metadata: contig_metadata: 9 rows where bioproject = "PRJNA316313" and tax

9 rows where bioproject = "PRJNA316313" 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
1662116	1662116	PRJNA316313_P_NODE_358322_length_173_cov_4.088235_g356936_i0	PRJNA316313	358322	173	4.088235	7.07264655	Platydorina caudata	51709	Plants	Plants	54.7	0.004	NTclustered	gi\|2089720213\|gb\|MZ444776.1\|	51709	g356936	i0	100	0.167630057803468	29	0	17	0	137	165	1517	1545	Platydorina caudata strain NIES-728 hypothetical protein mRNA, partial cds	blastn	29	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Platydorina	Platydorina caudata
2937181	2937181	PRJNA316313_P_NODE_212643_length_187_cov_3.253333_g211257_i0	PRJNA316313	212643	187	3.253333	6.08373271	Chloroidium sp. KL-2023a	3031248	Plants	Plants	113	7.240000000000001e-21	NTclustered	gi\|2450595352\|gb\|ON986219.1\|	3031248	g211257	i0	93.421	1.56149732620321	76	5	41	0	112	187	48186	48261	Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome	blastn	292	113	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Chloroidium	Chloroidium sp. KL-2023a
5491658	5491658	PRJNA316313_P_NODE_473065_length_151_cov_2.956140_g471679_i0	PRJNA316313	473065	151	2.95614	4.4637714	Jenufa minuta	993092	Plants	Plants	126	7.16e-25	NTclustered	gi\|1829768154\|ref\|NC_046780.1\|	993092	g471679	i0	98.611	0.980132450331126	72	0	96	1	7	78	40102	40172	Jenufa minuta culture CAUP:H8102 mitochondrion, complete genome	blastn	148	126	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae			Jenufa	Jenufa minuta
9314121	9314121	PRJNA316313_P_NODE_127208_length_188_cov_3.384106_g125822_i0	PRJNA316313	127208	188	3.384106	6.36211928	Monoraphidium neglectum	145388	Plants	Plants	60.2	9.63e-5	NTclustered	gi\|926779541\|ref\|XM_014042791.1\|	145388	g125822	i0	97.143	0.186170212765957	35	1	19	0	154	188	138	172	Monoraphidium neglectum hypothetical protein partial mRNA	blastn	35	60.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
16371411	16371411	PRJNA316313_P_NODE_92133_length_211_cov_6.580460_g90747_i0	PRJNA316313	92133	211	6.58046	13.8847706	Eukaryota	2759	Plants	Plants	350	5.869999999999999e-92	NTclustered	gi\|452119374\|gb\|KC661411.1\|	3116	g90747	i0	99.482	95.1516587677725	193	0	91	1	4	195	377	185	Ulva intestinalis isolate I RNA polymerase subunit C (rpoC) gene, partial cds; chloroplast	blastn	20077	351	0.997150997150997	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulvales	Ulvaceae	Ulva	Ulva intestinalis
18238470	18238470	PRJNA316313_P_NODE_258235_length_187_cov_2.753333_g256849_i0	PRJNA316313	258235	187	2.753333	5.14873271	Codium simulans	589376	Plants	Plants	54.7	0.004	NTclustered	gi\|1111669385\|ref\|NC_032043.1\|	589376	g256849	i0	94.286	0.18716577540107	35	2	19	0	54	88	11612	11578	Codium simulans chloroplast, complete genome	blastn	35	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Codiaceae	Codium	Codium simulans
28513016	28513016	PRJNA316313_P_NODE_147167_length_187_cov_4.826667_g145781_i0	PRJNA316313	147167	187	4.826667	9.02586729	Eukaryota	2759	Plants	Plants	51.2	1.77e-5	NR	CAD7696102.1	121088	g145781	i0	95.8	47.3582887700535	24	1	38.5	0	114	185	882	905	CAD7696102.1 unnamed protein product [Ostreobium quekettii]	diamond	8856	51.6	0.992248062015504	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Ostreobiaceae	Ostreobium	Ostreobium quekettii
28685329	28685329	PRJNA316313_P_NODE_335407_length_186_cov_2.449664_g334021_i0	PRJNA316313	335407	186	2.449664	4.55637504	Apatococcus lobatus	904363	Plants	Plants	45.1	0.00274	NR	KAK9816287.1	904363	g334021	i0	80	0.403225806451613	25	5	40.3	0	75	1	254	278	KAK9816287.1 hypothetical protein WJX74_006374 [Apatococcus lobatus]	diamond	75	45.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Apatococcus	Apatococcus lobatus
28765559	28765559	PRJNA316313_S_NODE_1407_length_188_cov_2.033113_g1404_i0	PRJNA316313	1407	188	2.033113	3.82225244	Eukaryota	2759	Plants	Plants	99	2.72e-22	NR	KAG2497954.1	47281	g1404	i0	73.3	5.77659574468085	60	16	95.7	0	180	1	418	477	KAG2497954.1 hypothetical protein HYH03_004216 [Edaphochlamys debaryana]	diamond	1086	99.4	0.995975855130785	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales		Edaphochlamys	Edaphochlamys debaryana

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