metadata: contig_metadata: 6 rows where bioproject = "PRJNA290839", tax_kingdom = "Viridiplantae" and tax

6 rows where bioproject = "PRJNA290839", tax_kingdom = "Viridiplantae" and tax_phylum = "Chlorophyta"

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
14401865	14401865	PRJNA290839_P_NODE_1472_length_245_cov_0.901163_g1451_i0	PRJNA290839	1472	245	0.901163	2.20784935	Auxenochlorella protothecoides	3075	Plants	Plants	122	5e-30	NR	RMZ53593.1	3075	g1451	i0	86.4	10.5551020408163	66	9	80.8	0	205	8	179	244	RMZ53593.1 hypothetical protein APUTEX25_003415, partial [Auxenochlorella protothecoides]	diamond	2586	122	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
27010807	27010807	PRJNA290839_P_NODE_1382_length_246_cov_0.901734_g1361_i0	PRJNA290839	1382	246	0.901734	2.21826564	Trebouxia sp. C	2796353	Plants	Plants	55.1	1.75e-6	NR	KAL0028557.1	2905654	g1361	i0	42.2	0.780487804878049	64	37	78	0	203	12	10	73	KAL0028557.1 hypothetical protein WJX79_001690 [Trebouxia sp. C0005]	diamond	192	55.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0005
29410891	29410891	PRJNA290839_P_NODE_649_length_318_cov_1.346939_g628_i0	PRJNA290839	649	318	1.346939	4.28326602	Cymbomonas tetramitiformis	36881	Plants	Plants	97.4	4.9300000000000006e-21	NR	KAK3243787.1	36881	g628	i0	56	0.792452830188679	84	35	77.4	1	25	270	339	422	KAK3243787.1 hypothetical protein CYMTET_46577 [Cymbomonas tetramitiformis]	diamond	252	97.4	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
29586179	29586179	PRJNA290839_P_NODE_790_length_289_cov_1.064815_g769_i0	PRJNA290839	790	289	1.064815	3.07731535	Viridiplantae	33090	Plants	Plants	69.7	2.15e-11	NR	KAK3236683.1	36881	g769	i0	39.4	2.04498269896194	99	56	98.6	2	2	286	392	490	KAK3236683.1 hypothetical protein CYMTET_53189 [Cymbomonas tetramitiformis]	diamond	591	69.7	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
30091610	30091610	PRJNA290839_P_NODE_412_length_403_cov_1.118182_g391_i0	PRJNA290839	412	403	1.118182	4.50627346	Eukaryota	2759	Plants	Plants	113	5.44e-29	NR	GFR49314.1	47775	g391	i0	63.5	3.76674937965261	96	35	71.5	0	373	86	49	144	GFR49314.1 hypothetical protein Agub_g11337, partial [Astrephomene gubernaculifera]	diamond	1518	114	0.991228070175439	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Astrephomenaceae	Astrephomene	Astrephomene gubernaculifera
30723652	30723652	PRJNA290839_P_NODE_794_length_288_cov_1.330233_g773_i0	PRJNA290839	794	288	1.330233	3.83107104	Coccomyxa	41891	Plants	Plants	151	1.25e-44	NR	CAK0734215.1	1274662	g773	i0	77.9	7.91666666666667	95	21	99	0	3	287	27	121	CAK0734215.1 60S ribosomal protein L23A [Coccomyxa viridis]	diamond	2280	152	0.993421052631579	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis

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