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

8 rows where bioproject = "PRJNA1253303" 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
9287564	9287564	PRJNA1253303_P_NODE_1188_length_452_cov_1.440633_g1166_i0	PRJNA1253303	1188	452	1.440633	6.51166116	Coccomyxa	41891	Plants	Plants	251	4.4799999999999996e-82	NR	CAL5221060.1	1274662	g1166	i0	80.8	15.4048672566372	146	28	96.9	0	14	451	1	146	CAL5221060.1 g3183 [Coccomyxa viridis]	diamond	6963	251	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis
23311655	23311655	PRJNA1253303_P_NODE_3999_length_277_cov_1.455882_g3977_i0	PRJNA1253303	3999	277	1.455882	4.03279314	Scherffelia dubia	3190	Plants	Plants	209	1.43e-49	NTclustered	gi\|13897311\|emb\|AJ312020.1\|	3190	g3977	i0	81.569	72.3068592057762	255	45	92	2	7	260	1442	1189	Scherffelia dubia partial mRNA for luminal binding protein (bip gene), strain SAG 40.89	blastn	20029	209	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorodendrophyceae	Chlorodendrales	Chlorodendraceae	Scherffelia	Scherffelia dubia
28070776	28070776	PRJNA1253303_P_NODE_8105_length_243_cov_0.917647_g8083_i0	PRJNA1253303	8105	243	0.917647	2.22988221	Chlamydomonadales	3042	Plants	Plants	75.9	1.12e-15	NR	KAG2437468.1	51695	g8083	i0	55	1.48148148148148	60	27	74.1	0	11	190	34	93	KAG2437468.1 hypothetical protein HXX76_006118 [Chlamydomonas incerta]	diamond	360	76.6	0.990861618798956	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
28558259	28558259	PRJNA1253303_P_NODE_4807_length_255_cov_1.285714_g4785_i0	PRJNA1253303	4807	255	1.285714	3.2785707	Haematococcus lacustris	44745	Plants	Plants	89	2.34e-18	NR	KAJ9515451.1	44745	g4785	i0	63.2	1.55294117647059	68	25	80	0	245	42	859	926	KAJ9515451.1 hypothetical protein QJQ45_016447 [Haematococcus lacustris]	diamond	396	89	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
28968649	28968649	PRJNA1253303_P_NODE_1408_length_421_cov_0.887931_g1386_i0	PRJNA1253303	1408	421	0.887931	3.73818951	Bryopsis sp. KO-2	3115439	Plants	Plants	48.5	0.00254	NR	GMH46045.1	3041901	g1386	i0	37.4	1.53919239904988	99	42	66.3	6	73	351	1378	1462	GMH46045.1 hypothetical protein BSKO_14009 [Bryopsis sp. KO-2023]	diamond	648	48.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Bryopsidaceae	Bryopsis	Bryopsis sp. KO-2023
29410523	29410523	PRJNA1253303_P_NODE_8429_length_242_cov_0.923077_g8407_i0	PRJNA1253303	8429	242	0.923077	2.23384634	Ostreobium quekettii	121088	Plants	Plants	102	1.49e-23	NR	CAD7701840.1	121088	g8407	i0	87.7	0.706611570247934	57	7	70.7	0	242	72	322	378	CAD7701840.1 unnamed protein product [Ostreobium quekettii]	diamond	171	102	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Ostreobiaceae	Ostreobium	Ostreobium quekettii
31274461	31274461	PRJNA1253303_P_NODE_5995_length_250_cov_0.881356_g5973_i0	PRJNA1253303	5995	250	0.881356	2.20339	Raphidocelis subcapitata	307507	Plants	Plants	117	3.0899999999999993e-31	NR	GBF93448.1	307507	g5973	i0	68.3	0.984	82	26	98.4	0	5	250	36	117	GBF93448.1 ribosomal protein S1 [Raphidocelis subcapitata]	diamond	246	117	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Raphidocelis	Raphidocelis subcapitata
31559370	31559370	PRJNA1253303_P_NODE_476_length_684_cov_1.333879_g454_i0	PRJNA1253303	476	684	1.333879	9.12373236	Trebouxia sp. A1-2	2608996	Plants	Plants	243	1.55e-70	NR	KAA6427849.1	2608996	g454	i0	62	1.75438596491228	200	76	87.7	0	683	84	869	1068	KAA6427849.1 MAG: elongation factor 3 [Trebouxia sp. A1-2]	diamond	1200	243	1	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);;