metadata: contig_metadata: 20 rows where bioproject = "PRJNA637219" and tax

20 rows where bioproject = "PRJNA637219" 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
1885006	1885006	PRJNA637219_S_NODE_18142_length_151_cov_2.843137_g18097_i0	PRJNA637219	18142	151	2.843137	4.29313687	Chloroidium ellipsoideum	63676	Plants	Plants	268	1.12e-67	NTclustered	gi\|535783\|dbj\|D17810.1\|CHLLSURRNA	63676	g18097	i0	98.675	100	151	2	100	0	1	151	2109	1959	Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron	blastn	15100	268	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Chloroidium	Chloroidium ellipsoideum
6987365	6987365	PRJNA637219_S_NODE_46_length_1315_cov_16.098736_g34_i0	PRJNA637219	46	1315	16.098736	211.6983784	Trentepohlia sp. BN17	3063876	Plants	Plants	76.8	7.98e-9	NTclustered	gi\|2192923729\|ref\|NC_060532.1\|	3063876	g34	i0	92.453	0.27148288973384	53	4	4	0	637	689	223485	223433	Trentepohlia sp. BN17 chloroplast, complete genome	blastn	357	76.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Trentepohliales	Trentepohliaceae	Trentepohlia	Trentepohlia sp. BN17
7532891	7532891	PRJNA637219_S_NODE_11386_length_166_cov_1.735043_g11341_i0	PRJNA637219	11386	166	1.735043	2.88017138	Pseudochlorella	63681	Plants	Plants	307	2.69e-79	NTclustered	gi\|694226641\|gb\|KM116465.1\|	173497	g11341	i0	100	94.078313253012	166	0	100	0	1	166	2931	3096	Pabia signiensis strain SAG 2110 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence	blastn	15617	307	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Pseudochlorella	Pseudochlorella signiensis
8262047	8262047	PRJNA637219_S_NODE_3567_length_251_cov_3.064356_g3522_i0	PRJNA637219	3567	251	3.064356	7.69153356	Chlamydomonas reinhardtii	3055	Plants	Plants	63.9	1.05e-5	NTclustered	gi\|2082238366\|ref\|XM_043059241.1\|	3055	g3522	i0	91.304	0.183266932270916	46	4	18	0	117	162	1511	1556	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g081250v5), mRNA	blastn	46	63.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
13362899	13362899	PRJNA637219_S_NODE_13351_length_164_cov_1.365217_g13306_i0	PRJNA637219	13351	164	1.365217	2.23895588	Micromonas commoda	296587	Plants	Plants	178	2.17e-40	NTclustered	gi\|255088120\|ref\|XM_002505937.1\|	296587	g13306	i0	86.42	48.8414634146341	162	22	99	0	3	164	1189	1350	Micromonas commoda adenosylhomocysteinase partial mRNA	blastn	8010	178	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
17186672	17186672	PRJNA637219_S_NODE_12414_length_165_cov_1.163793_g12369_i0	PRJNA637219	12414	165	1.163793	1.92025845	Pseudochlorella signiensis	173497	Plants	Plants	294	2.08e-75	NTclustered	gi\|725650714\|ref\|NC_025529.1\|	173497	g12369	i0	98.788	131.187878787879	165	2	100	0	1	165	151173	151009	Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome	blastn	21646	294	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Pseudochlorella	Pseudochlorella signiensis
17186792	17186792	PRJNA637219_S_NODE_4994_length_220_cov_1.333333_g4949_i0	PRJNA637219	4994	220	1.333333	2.9333326	Pseudochlorella signiensis	173497	Plants	Plants	368	1.6999999999999997e-97	NTclustered	gi\|725650714\|ref\|NC_025529.1\|	173497	g4949	i0	96.818	113.281818181818	220	7	100	0	1	220	151480	151261	Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome	blastn	24922	368	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Pseudochlorella	Pseudochlorella signiensis
17732938	17732938	PRJNA637219_S_NODE_1994_length_319_cov_2.151852_g1949_i0	PRJNA637219	1994	319	2.151852	6.86440788	Pseudochlorella	63681	Plants	Plants	507	5.31e-139	NTclustered	gi\|1139689052\|emb\|LT560356.1\|	3072	g1949	i0	95.327	100.529780564263	321	12	100	3	1	319	607	926	Pseudochlorella pringsheimii partial 18S rRNA gene, strain SAG 211-1a	blastn	32069	512	0.990234375	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Pseudochlorella	Pseudochlorella pringsheimii
18460977	18460977	PRJNA637219_S_NODE_8915_length_178_cov_1.131783_g8870_i0	PRJNA637219	8915	178	1.131783	2.01457374	Chlorella variabilis	554065	Plants	Plants	167	5.149999999999999e-37	NTclustered	gi\|552812580\|ref\|XM_005843676.1\|	554065	g8870	i0	84.211	0.960674157303371	171	27	96	0	5	175	205	375	Chlorella variabilis hypothetical protein (CHLNCDRAFT_140078) mRNA, complete cds	blastn	171	167	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
23561409	23561409	PRJNA637219_S_NODE_16859_length_161_cov_0.910714_g16814_i0	PRJNA637219	16859	161	0.910714	1.46624954	Auxenochlorella protothecoides	3075	Plants	Plants	279	5.64e-71	NTclustered	gi\|760448684\|ref\|XM_011403109.1\|	3075	g16814	i0	98.125	0.993788819875776	160	3	99	0	2	161	300	141	Auxenochlorella protothecoides hypothetical protein partial mRNA	blastn	160	279	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
26637767	26637767	PRJNA637219_S_NODE_11001_length_167_cov_0.864407_g10956_i0	PRJNA637219	11001	167	0.864407	1.44355969	Monoraphidium neglectum	145388	Plants	Plants	43.5	0.00134	NR	XP_013891194.1	145388	g10956	i0	42.9	1.50898203592814	42	24	75.4	0	167	42	21	62	XP_013891194.1 hypothetical protein MNEG_15788 [Monoraphidium neglectum]	diamond	252	43.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
28533920	28533920	PRJNA637219_S_NODE_10507_length_167_cov_1.296610_g10462_i0	PRJNA637219	10507	167	1.29661	2.1653387	Ulva partita	1605170	Plants	Plants	97.4	1.28e-24	NR	BAV58192.1	1605170	g10462	i0	80	0.988023952095808	55	11	98.8	0	2	166	51	105	BAV58192.1 H/ACA ribonucleoprotein complex subunit 3 [Ulva partita]	diamond	165	97.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulvales	Ulvaceae	Ulva	Ulva partita
28533923	28533923	PRJNA637219_S_NODE_16567_length_161_cov_0.910714_g16522_i0	PRJNA637219	16567	161	0.910714	1.46624954	Micromonas pusilla CCMP1545	564608	Plants	Plants	42.7	0.0123	NR	XP_003063910.1	564608	g16522	i0	42.6	1.67701863354037	47	27	87.6	0	142	2	301	347	XP_003063910.1 protein kinase [Micromonas pusilla CCMP1545]	diamond	270	42.7	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla
28893359	28893359	PRJNA637219_S_NODE_15908_length_162_cov_0.902655_g15863_i0	PRJNA637219	15908	162	0.902655	1.4623011	Chlorophyta	3041	Plants	Plants	63.2	7.56e-10	NR	XP_007510048.1	41875	g15863	i0	52	2.85185185185185	50	24	92.6	0	8	157	492	541	XP_007510048.1 predicted protein [Bathycoccus prasinos]	diamond	462	63.5	0.995275590551181	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Bathycoccus	Bathycoccus prasinos
30270832	30270832	PRJNA637219_S_NODE_712_length_490_cov_7.390023_g667_i0	PRJNA637219	712	490	7.390023	36.2111127	Picochlorum sp. BPE23	2696299	Plants	Plants	142	2.1e-40	NR	KAI8104783.1	2696299	g667	i0	65.6	3.03673469387755	122	42	74.7	0	27	392	1	122	KAI8104783.1 hypothetical protein M9434_003335 [Picochlorum sp. BPE23]	diamond	1488	142	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Picochlorum	Picochlorum sp. BPE23
30270833	30270833	PRJNA637219_S_NODE_7452_length_190_cov_1.085106_g7407_i0	PRJNA637219	7452	190	1.085106	2.0617014	Gonium pectorale	33097	Plants	Plants	52.4	6.96e-6	NR	KXZ42091.1	33097	g7407	i0	77.8	2.13157894736842	27	6	42.6	0	190	110	285	311	KXZ42091.1 hypothetical protein GPECTOR_208g403 [Gonium pectorale]	diamond	405	52.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Gonium	Gonium pectorale
31104368	31104368	PRJNA637219_S_NODE_7315_length_191_cov_2.042254_g7270_i0	PRJNA637219	7315	191	2.042254	3.90070514	root	1	Root_unresolved	Root_unresolved	50.4	3.59e-5	NR	XP_003058476.1	564608	g7270	i0	66.7	1.02094240837696	30	10	47.1	0	91	2	509	538	XP_003058476.1 SNF2 super family [Micromonas pusilla CCMP1545]	diamond	195	50.4	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla
31325765	31325765	PRJNA637219_S_NODE_15935_length_162_cov_0.902655_g15890_i0	PRJNA637219	15935	162	0.902655	1.4623011	Opisthokonta	33154	Plants	Plants	76.6	1.56e-16	NR	KAK3276844.1	36881	g15890	i0	72	3.87037037037037	50	14	92.6	0	11	160	9	58	KAK3276844.1 40S ribosomal protein S25 [Cymbomonas tetramitiformis]	diamond	627	76.6	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
31439766	31439766	PRJNA637219_S_NODE_12036_length_166_cov_0.871795_g11991_i0	PRJNA637219	12036	166	0.871795	1.4471797	Cymbomonas tetramitiformis	36881	Plants	Plants	59.7	1.3e-8	NR	KAK3245194.1	36881	g11991	i0	67.4	0.77710843373494	43	14	77.7	0	1	129	291	333	KAK3245194.1 proteasome regulatory particle subunit RPN11 [Cymbomonas tetramitiformis]	diamond	129	59.7	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
31692840	31692840	PRJNA637219_S_NODE_16477_length_161_cov_1.366071_g16432_i0	PRJNA637219	16477	161	1.366071	2.19937431	Tetraselmis sp. RG-15	65602	Plants	Plants	46.2	6.67e-4	NR	AAB70556.1	65602	g16432	i0	87	0.428571428571429	23	3	42.9	0	161	93	229	251	AAB70556.1 chlorophyll a/b binding protein [Tetraselmis sp. RG-15]	diamond	69	46.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorodendrophyceae	Chlorodendrales	Chlorodendraceae	Tetraselmis	Tetraselmis sp. RG-15

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