metadata: contig_metadata: 8 rows where bioproject = "PRJNA1145997" and tax

8 rows where bioproject = "PRJNA1145997" 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
289748	289748	PRJNA1145997_P_NODE_6121_length_1604_cov_8.496408_g5248_i0	PRJNA1145997	6121	1604	8.496408	136.28238432	Eukaryota	2759	Plants	Plants	341	2.5799999999999993e-104	NR	PRW50796.1	3076	g5248	i0	51.3	274.269950124688	427	162	79.7	8	158	1435	408	789	PRW50796.1 polyubiquitin 3 isoform A [Chlorella sorokiniana]	diamond	439929	342	0.997076023391813	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
2308769	2308769	PRJNA1145997_P_NODE_33822_length_323_cov_2.432000_g31203_i0	PRJNA1145997	33822	323	2.432	7.85536	Eukaryota	2759	Plants	Plants	56.5	0.002	NTclustered	gi\|2082245855\|ref\|XM_043062443.1\|	3055	g31203	i0	87.755	0.619195046439629	49	5	15	1	157	204	4828	4780	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_05g243150v5), mRNA	blastn	200	56.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
7942389	7942389	PRJNA1145997_P_NODE_26507_length_470_cov_17.450882_g23891_i0	PRJNA1145997	26507	470	17.450882	82.0191454	Trebouxia sp. SL0000003	3350044	Plants	Plants	507	8.11e-139	NTclustered	gi\|2917929628\|emb\|OZ234916.1\|	3350044	g23891	i0	90.979	0.959574468085106	388	17	96	9	83	470	2153359	2152990	Trebouxia sp. SL0000003 genome assembly, chromosome: 11	blastn	451	507	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. SL0000003
28997234	28997234	PRJNA1145997_P_NODE_31308_length_360_cov_8.167247_g28689_i0	PRJNA1145997	31308	360	8.167247	29.4020892	Trebouxia sp. C	2796353	Plants	Plants	119	2.13e-28	NR	KAL3157822.1	3373145	g28689	i0	77.8	0.6	72	16	60	0	338	123	536	607	KAL3157822.1 hypothetical protein ABBQ32_012244 [Trebouxia sp. C0010 RCD-2024]	diamond	216	119	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0010 RCD-2024
30217364	30217364	PRJNA1145997_P_NODE_17452_length_807_cov_6.990463_g15085_i0	PRJNA1145997	17452	807	6.990463	56.41303641	Trebouxia	13786	Plants	Plants	252	6.289999999999999e-82	NR	KAA6427716.1	2608996	g15085	i0	86	1.01115241635688	136	19	50.6	0	114	521	6	141	KAA6427716.1 MAG: ubiquitin-conjugating enzyme family [Trebouxia sp. A1-2]	diamond	816	252	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2
31682212	31682212	PRJNA1145997_P_NODE_27777_length_434_cov_15.468144_g25160_i0	PRJNA1145997	27777	434	15.468144	67.13174496	Symbiochloris irregularis	706552	Plants	Plants	166	2.43e-50	NR	KAK9798119.1	706552	g25160	i0	72	1.61059907834101	118	31	80.2	1	371	24	1	118	KAK9798119.1 hypothetical protein WJX73_000908 [Symbiochloris irregularis]	diamond	699	166	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis
32335960	32335960	PRJNA1145997_P_NODE_39799_length_268_cov_1.969231_g37180_i0	PRJNA1145997	39799	268	1.969231	5.27753908	Trebouxia	13786	Plants	Plants	124	7.939999999999999e-32	NR	KAL3139652.1	3373144	g37180	i0	92.2	2.86567164179104	64	5	71.6	0	76	267	238	301	KAL3139652.1 hypothetical protein ABBQ38_003969 [Trebouxia sp. C0009 RCD-2024]	diamond	768	125	0.992	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0009 RCD-2024
32430726	32430726	PRJNA1145997_P_NODE_11539_length_1150_cov_13.583101_g9868_i0	PRJNA1145997	11539	1150	13.583101	156.2056615	Trebouxia	13786	Plants	Plants	64.3	7.98e-8	NR	KAA6428380.1	2608996	g9868	i0	66.7	0.349565217391304	45	15	11.7	0	349	215	116	160	KAA6428380.1 MAG: hypothetical protein FRX49_01256 [Trebouxia sp. A1-2]	diamond	402	64.7	0.993817619783617	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2

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