metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA763718" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA763718" and tax_phylum = "Streptophyta"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27116202	27116202	PRJNA763718_S_NODE_7142_length_164_cov_1.795276_g6934_i0	PRJNA763718	7142	164	1.795276	2.94425264	Closterium sp. Yama58-4	2996821	Plants	Plants	67	3.46e-11	NR	CAI5460280.1	2996821	g6934	i0	63.5	2.85365853658537	52	19	95.1	0	156	1	428	479	CAI5460280.1 unnamed protein product [Closterium sp. Yama58-4]	diamond	468	67	1	Eukaryota		Viridiplantae	Streptophyta	Zygnematophyceae	Desmidiales	Closteriaceae	Closterium	Closterium sp. Yama58-4
28348059	28348059	PRJNA763718_S_NODE_3886_length_224_cov_1.652406_g3678_i0	PRJNA763718	3886	224	1.652406	3.70138944	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	90.1	6.14e-19	NR	BAK02651.1	112509	g3678	i0	59.5	0.991071428571429	74	26	97.8	2	221	3	1158	1228	BAK02651.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	222	90.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
28569025	28569025	PRJNA763718_S_NODE_3047_length_257_cov_2.613636_g2839_i0	PRJNA763718	3047	257	2.613636	6.71704452	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	66.6	1.75e-10	NR	BAK02651.1	112509	g2839	i0	67.9	0.618677042801556	53	15	61.9	1	97	255	1348	1398	BAK02651.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	159	66.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
29778443	29778443	PRJNA763718_S_NODE_5891_length_180_cov_1.517483_g5683_i0	PRJNA763718	5891	180	1.517483	2.7314694	Eukaryota	2759	Plants	Plants	120	1.8e-30	NR	KAI7730095.1	4212	g5683	i0	93	83.6333333333333	57	4	95	0	175	5	397	453	KAI7730095.1 hypothetical protein M8C21_033301 [Ambrosia artemisiifolia]	diamond	15054	120	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Ambrosia	Ambrosia artemisiifolia
30021743	30021743	PRJNA763718_S_NODE_3311_length_246_cov_1.669856_g3103_i0	PRJNA763718	3311	246	1.669856	4.10784576	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	122	2.4599999999999995e-32	NR	BAJ96378.1	112509	g3103	i0	86.3	0.890243902439024	73	6	85.4	2	245	36	195	266	BAJ96378.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	219	122	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
30252576	30252576	PRJNA763718_S_NODE_5312_length_190_cov_1.333333_g5104_i0	PRJNA763718	5312	190	1.333333	2.5333327	Eukaryota	2759	Plants	Plants	79.7	1.46e-16	NR	KAH7517731.1	714518	g5104	i0	61.9	341.352631578947	63	24	99.5	0	1	189	31	93	KAH7517731.1 hypothetical protein FEM48_Zijuj09G0095400 [Ziziphus jujuba var. spinosa]	diamond	64857	80.5	0.990062111801242	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rhamnaceae	Ziziphus	Ziziphus jujuba
31199839	31199839	PRJNA763718_S_NODE_2355_length_298_cov_3.574713_g2147_i0	PRJNA763718	2355	298	3.574713	10.65264474	Eukaryota	2759	Plants	Plants	45.8	0.00568	NR	KAK7289439.1	3830	g2147	i0	59.6	11.4765100671141	47	19	47.3	0	258	118	272	318	KAK7289439.1 hypothetical protein RIF29_03121 [Crotalaria pallida]	diamond	3420	45.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Crotalaria	Crotalaria pallida
31759907	31759907	PRJNA763718_S_NODE_7777_length_158_cov_1.280992_g7569_i0	PRJNA763718	7777	158	1.280992	2.02396736	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	67.8	1.71e-11	NR	BAK03555.1	112509	g7569	i0	57.7	0.987341772151899	52	20	98.7	1	157	2	488	537	BAK03555.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	156	67.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare

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);;