metadata: contig_metadata: 13 rows where bioproject = "PRJNA1180292", tax_kingdom = "Viridiplantae" and tax

13 rows where bioproject = "PRJNA1180292", 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
6695725	6695725	PRJNA1180292_P_NODE_1486_length_565_cov_3.546748_g1354_i0	PRJNA1180292	1486	565	3.546748	20.0391262	Trebouxiophyceae	75966	Plants	Plants	272	1.8000000000000002e-81	NR	PRW58729.1	3076	g1354	i0	80.2	8.2353982300885	172	34	91.3	0	516	1	1	172	PRW58729.1 fidgetin 1 [Chlorella sorokiniana]	diamond	4653	274	0.992700729927007	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
7971198	7971198	PRJNA1180292_P_NODE_9887_length_249_cov_0.886364_g9755_i0	PRJNA1180292	9887	249	0.886364	2.20704636	Tetradesmus obliquus	3088	Plants	Plants	387	5.439999999999998e-103	NTclustered	gi\|87313204\|gb\|DQ370087.1\|	3088	g9755	i0	100	13.5301204819277	209	0	84	0	1	209	209	1	Scenedesmus obliquus light-harvesting chlorophyll-a/b binding protein LhcbM2 mRNA, complete cds	blastn	3369	387	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
10521485	10521485	PRJNA1180292_P_NODE_1749_length_519_cov_1.654709_g1617_i0	PRJNA1180292	1749	519	1.654709	8.58793971	Coccomyxa sp. Obi	2315456	Plants	Plants	271	7.7999999999999995e-84	NR	BDA48176.1	2315456	g1617	i0	81.4	5.9364161849711	167	31	96.5	0	519	19	507	673	BDA48176.1 Heat shock protein 81-1 [Coccomyxa sp. Obi]	diamond	3081	271	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa sp. Obi
10521529	10521529	PRJNA1180292_P_NODE_5629_length_294_cov_1.411765_g5497_i0	PRJNA1180292	5629	294	1.411765	4.1505891	Eukaryota	2759	Plants	Plants	205	9.07e-64	NR	PRW60266.1	3076	g5497	i0	91.8	38.6020408163265	97	8	99	0	293	3	167	263	PRW60266.1 Serine threonine- phosphatase 2A catalytic subunit beta isoform [Chlorella sorokiniana]	diamond	11349	207	0.990338164251208	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
10521581	10521581	PRJNA1180292_P_NODE_9829_length_249_cov_0.886364_g9697_i0	PRJNA1180292	9829	249	0.886364	2.20704636	Chlorophyta	3041	Plants	Plants	123	2.07e-30	NR	KAL4856580.1	3077	g9697	i0	70.4	5.85542168674699	81	23	97.6	1	247	5	355	434	KAL4856580.1 DNA-directed RNA polymerase II subunit 2 [Chlorella vulgaris]	diamond	1458	124	0.991935483870968	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
21994466	21994466	PRJNA1180292_P_NODE_10018_length_248_cov_1.651429_g9886_i0	PRJNA1180292	10018	248	1.651429	4.09554392	Micromonas pusilla CCMP1545	564608	Plants	Plants	134	3.989999999999999e-37	NR	XP_003056478.1	564608	g9886	i0	72	4.95967741935484	82	23	99.2	0	1	246	107	188	XP_003056478.1 uncharacterized protein MICPUCDRAFT_31664 [Micromonas pusilla CCMP1545]	diamond	1230	134	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla
23270065	23270065	PRJNA1180292_P_NODE_7619_length_255_cov_1.714286_g7487_i0	PRJNA1180292	7619	255	1.714286	4.3714293	Trebouxia	13786	Plants	Plants	144	3.1e-38	NR	KAA6420074.1	2608996	g7487	i0	86.7	3.90588235294118	83	11	97.6	0	250	2	209	291	KAA6420074.1 MAG: elongation factor [Trebouxia sp. A1-2]	diamond	996	144	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2
24543790	24543790	PRJNA1180292_P_NODE_10220_length_248_cov_0.891429_g10088_i0	PRJNA1180292	10220	248	0.891429	2.21074392	Eukaryota	2759	Plants	Plants	145	5.5499999999999996e-40	NR	KXZ54790.1	33097	g10088	i0	85.4	109.112903225806	82	12	99.2	0	247	2	98	179	KXZ54790.1 hypothetical protein GPECTOR_4g861 [Gonium pectorale]	diamond	27060	145	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Gonium	Gonium pectorale
27988237	27988237	PRJNA1180292_P_NODE_8685_length_251_cov_1.314607_g8553_i0	PRJNA1180292	8685	251	1.314607	3.29966357	Micromonas pusilla CCMP1545	564608	Plants	Plants	72.4	2.5e-14	NR	XP_003058547.1	564608	g8553	i0	54.4	0.812749003984064	68	30	80.1	1	1	201	30	97	XP_003058547.1 uncharacterized protein MICPUCDRAFT_37472 [Micromonas pusilla CCMP1545]	diamond	204	72.4	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla
28418012	28418012	PRJNA1180292_P_NODE_9926_length_249_cov_0.886364_g9794_i0	PRJNA1180292	9926	249	0.886364	2.20704636	Chlorophyta	3041	Plants	Plants	70.1	5.01e-12	NR	PNH05868.1	47790	g9794	i0	59.2	10.855421686747	49	20	59	0	26	172	98	146	PNH05868.1 DNA polymerase epsilon catalytic subunit A, partial [Tetrabaena socialis]	diamond	2703	70.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Tetrabaenaceae	Tetrabaena	Tetrabaena socialis
30893871	30893871	PRJNA1180292_P_NODE_2654_length_417_cov_1.026163_g2522_i0	PRJNA1180292	2654	417	1.026163	4.27909971	Coccomyxa viridis	1274662	Plants	Plants	115	1.47e-29	NR	CAK0774332.1	1274662	g2522	i0	51.3	0.856115107913669	119	56	84.9	2	61	414	29	146	CAK0774332.1 hypothetical protein CVIRNUC_004158 [Coccomyxa viridis]	diamond	357	115	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis
31304487	31304487	PRJNA1180292_P_NODE_12915_length_242_cov_0.923077_g12783_i0	PRJNA1180292	12915	242	0.923077	2.23384634	Ostreococcus lucimarinus CCE99	242159	Plants	Plants	91.3	8.94e-20	NR	XP_001417370.1	436017	g12783	i0	51.9	7.30165289256198	77	36	95.5	1	9	239	122	197	XP_001417370.1 predicted protein [Ostreococcus lucimarinus CCE9901]	diamond	1767	91.3	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Ostreococcus	Ostreococcus sp. 'lucimarinus'
32000440	32000440	PRJNA1180292_P_NODE_7538_length_257_cov_1.402174_g7406_i0	PRJNA1180292	7538	257	1.402174	3.60358718	Coccomyxa sp. Obi	2315456	Plants	Plants	85.1	5.05e-17	NR	BDA42516.1	2315456	g7406	i0	59.7	1.57587548638132	67	27	78.2	0	203	3	59	125	BDA42516.1 betaine aldehyde dehydrogenase 2 [Coccomyxa sp. Obi]	diamond	405	85.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa sp. Obi

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