metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA657343" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA657343" and tax_phylum = "Tubulinea"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6264140	6264140	PRJNA657343_P_NODE_10625_length_262_cov_2.300469_g10601_i0	PRJNA657343	10625	262	2.300469	6.02722878	Amoeba proteus	5775	Tubulinea	other_Eukaryota	80.5	2.5e-15	NR	AKN09691.1	5775	g10601	i0	47.1	0.973282442748092	85	23	97.3	1	255	1	753	815	AKN09691.1 Tom70 [Amoeba proteus]	diamond	255	80.5	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
24849392	24849392	PRJNA657343_P_NODE_3300_length_405_cov_3.682584_g3277_i0	PRJNA657343	3300	405	3.682584	14.9144652	Nolandella sp. LAK-2	1908693	Tubulinea	other_Eukaryota	217	1.69e-68	NR	AFX73095.1	1260117	g3277	i0	73.8	1.94814814814815	130	34	96.3	0	2	391	14	143	AFX73095.1 elongation factor 2 alpha, partial [Nolandella sp. LAK-2012]	diamond	789	217	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Nolandella	Nolandella sp. LAK-2012
27586972	27586972	PRJNA657343_P_NODE_4824_length_351_cov_2.380795_g4801_i0	PRJNA657343	4824	351	2.380795	8.35659045	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	180	1.9299999999999994e-54	NR	ABD46560.1	5778	g4801	i0	73.3	0.991452991452991	116	31	99.1	0	3	350	92	207	ABD46560.1 lactate dehydrogenase-like protein, partial [Vermamoeba vermiformis]	diamond	348	180	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
29240977	29240977	PRJNA657343_P_NODE_2509_length_447_cov_5.977387_g2486_i0	PRJNA657343	2509	447	5.977387	26.71891989	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	157	4.46e-45	NR	AAY21191.1	5778	g2486	i0	61.3	1.85234899328859	137	53	91.9	0	6	416	98	234	AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis]	diamond	828	158	0.993670886075949	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
29493527	29493527	PRJNA657343_P_NODE_13470_length_240_cov_2.068063_g13446_i0	PRJNA657343	13470	240	2.068063	4.9633512	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	129	2.53e-33	NR	BAN33737.1	931554	g13446	i0	79.7	4.7625	74	15	92.5	0	6	227	249	322	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	1143	129	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
32862412	32862412	PRJNA657343_P_NODE_20000_length_207_cov_3.462025_g19976_i0	PRJNA657343	20000	207	3.462025	7.16639175	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	105	6.93e-26	NR	ABD46560.1	5778	g19976	i0	72.7	0.956521739130435	66	18	95.7	0	7	204	2	67	ABD46560.1 lactate dehydrogenase-like protein, partial [Vermamoeba vermiformis]	diamond	198	105	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;