metadata: contig_metadata: 11 rows where bioproject = "PRJNA1197996" and tax

11 rows where bioproject = "PRJNA1197996" 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
1598761	1598761	PRJNA1197996_S_NODE_2482_length_520_cov_14.579418_g2431_i0	PRJNA1197996	2482	520	14.579418	75.8129736	Micromonas commoda	296587	Plants	Plants	309	2.7400000000000005e-79	NTclustered	gi\|255088120\|ref\|XM_002505937.1\|	296587	g2431	i0	82.768	66.4365384615385	354	54	68	6	163	514	1465	1117	Micromonas commoda adenosylhomocysteinase partial mRNA	blastn	34547	309	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
7977634	7977634	PRJNA1197996_S_NODE_4507_length_428_cov_3.678873_g4453_i0	PRJNA1197996	4507	428	3.678873	15.74557644	Micromonas commoda	296587	Plants	Plants	148	5.119999999999999e-31	NTclustered	gi\|255072432\|ref\|XM_002499845.1\|	296587	g4453	i0	79.902	13.7429906542056	204	39	47	2	226	428	1183	981	Micromonas commoda predicted protein partial mRNA	blastn	5882	148	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
8696565	8696565	PRJNA1197996_S_NODE_1367_length_638_cov_5.950442_g1321_i0	PRJNA1197996	1367	638	5.950442	37.96381996	root	1	Root_unresolved	Root_unresolved	134	2.2e-26	NTclustered	gi\|255077919\|ref\|XM_002502494.1\|	296587	g1321	i0	86.667	3.0282131661442	120	16	19	0	513	632	2193	2074	Micromonas commoda H+-translocating pyrophosphatase family partial mRNA	blastn	1932	134	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
10528048	10528048	PRJNA1197996_S_NODE_4389_length_432_cov_2.743733_g4335_i0	PRJNA1197996	4389	432	2.743733	11.85292656	Chlamydomonas reinhardtii	3055	Plants	Plants	126	2.4199999999999998e-24	NTclustered	gi\|2082241335\|ref\|XM_001695651.2\|	3055	g4335	i0	86.726	0.456018518518519	113	15	26	0	320	432	1890	1778	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g146527v5), mRNA	blastn	197	126	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
14352901	14352901	PRJNA1197996_S_NODE_15612_length_290_cov_1.433180_g15558_i0	PRJNA1197996	15612	290	1.43318	4.156222	Rhexinema sarcinoideum	43261	Plants	Plants	466	8.09e-127	NTclustered	gi\|1052423652\|gb\|KX306821.1\|	43261	g15558	i0	95.833	104.7	288	12	99	0	1	288	4365	4078	Rhexinema sarcinoideum chloroplast, complete genome	blastn	30363	466	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulotrichales	Helicodictyaceae	Rhexinema	Rhexinema sarcinoideum
26660728	26660728	PRJNA1197996_S_NODE_9321_length_341_cov_4.309701_g9267_i0	PRJNA1197996	9321	341	4.309701	14.69608041	Micromonas commoda	296587	Plants	Plants	110	8.959999999999999e-28	NR	XP_002500059.1	296587	g9267	i0	70.8	0.633431085043988	72	21	63.3	0	2	217	107	178	XP_002500059.1 predicted protein, partial [Micromonas commoda]	diamond	216	110	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
28240906	28240906	PRJNA1197996_S_NODE_21826_length_258_cov_1.572973_g21772_i0	PRJNA1197996	21826	258	1.572973	4.05827034	Chlorella variabilis	554065	Plants	Plants	65.9	3.18e-10	NR	XP_005851155.1	554065	g21772	i0	42.9	1.63953488372093	70	37	77.9	1	258	58	334	403	XP_005851155.1 hypothetical protein CHLNCDRAFT_137766 [Chlorella variabilis]	diamond	423	65.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
28335788	28335788	PRJNA1197996_S_NODE_14666_length_296_cov_1.381166_g14612_i0	PRJNA1197996	14666	296	1.381166	4.08825136	Trebouxia sp. C	2796353	Plants	Plants	72	3.35e-13	NR	KAL3133789.1	3373145	g14612	i0	30.9	1.64189189189189	97	66	97.3	1	291	4	66	162	KAL3133789.1 hypothetical protein ABBQ32_008268 [Trebouxia sp. C0010 RCD-2024]	diamond	486	72	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0010 RCD-2024
30767649	30767649	PRJNA1197996_S_NODE_2434_length_523_cov_67.344444_g2383_i0	PRJNA1197996	2434	523	67.344444	352.21144212	Tetrabaena socialis	47790	Plants	Plants	61.2	2.19e-7	NR	PNH06825.1	47790	g2383	i0	47.3	0.986615678776291	74	34	41.9	3	503	285	2	71	PNH06825.1 Serine protease inhibitor dipetalogastin [Tetrabaena socialis]	diamond	516	61.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Tetrabaenaceae	Tetrabaena	Tetrabaena socialis
31336337	31336337	PRJNA1197996_S_NODE_3996_length_445_cov_7.381720_g3942_i0	PRJNA1197996	3996	445	7.38172	32.848654	Auxenochlorella protothecoides	3075	Plants	Plants	51.6	8.21e-5	NR	AGB85042.1	3075	g3942	i0	37	0.546067415730337	81	48	54.6	2	28	270	51	128	AGB85042.1 hypothetical protein CHLPROCp014, partial [Auxenochlorella protothecoides]	diamond	243	51.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
31905795	31905795	PRJNA1197996_S_NODE_6017_length_391_cov_7.553459_g5963_i0	PRJNA1197996	6017	391	7.553459	29.53402469	Chloropicon primus	1764295	Plants	Plants	76.3	1.9e-13	NR	QDZ20675.1	1764295	g5963	i0	61.5	1.20460358056266	52	20	39.9	0	390	235	265	316	QDZ20675.1 receptor of activated protein kinase C [Chloropicon primus]	diamond	471	76.3	1	Eukaryota		Viridiplantae	Chlorophyta	Chloropicophyceae	Chloropicales	Chloropicaceae	Chloropicon	Chloropicon primus

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