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

6 rows where bioproject = "PRJNA1197996" and tax_clade = "core chlorophytes"

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

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