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

20 rows where bioproject = "PRJNA1095825" 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
200940	200940	PRJNA1095825_P_NODE_276641_length_244_cov_0.900585_g273578_i0	PRJNA1095825	276641	244	0.900585	2.1974274	Auxenochlorella protothecoides	3075	Plants	Plants	451	1.86e-122	NTclustered	gi\|760447182\|ref\|XM_011402358.1\|	3075	g273578	i0	100	1	244	0	100	0	1	244	386	143	Auxenochlorella protothecoides 1-aminocyclopropane-1-carboxylate synthase CMW33 partial mRNA	blastn	244	451	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
1475495	1475495	PRJNA1095825_P_NODE_262342_length_247_cov_0.885057_g259279_i0	PRJNA1095825	262342	247	0.885057	2.18609079	Auxenochlorella protothecoides	3075	Plants	Plants	235	2.07e-57	NTclustered	gi\|760442850\|ref\|XM_011400192.1\|	3075	g259279	i0	100	0.51417004048583	127	0	51	0	1	127	400	526	Auxenochlorella protothecoides hypothetical protein partial mRNA	blastn	127	235	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
2294972	2294972	PRJNA1095825_P_NODE_258202_length_247_cov_1.350575_g255139_i0	PRJNA1095825	258202	247	1.350575	3.33592025	Chlorophyta	3041	Plants	Plants	255	1.59e-63	NTclustered	gi\|371782093\|emb\|HE610125.1\|	37433	g255139	i0	85.425	100.457489878543	247	34	99	2	3	247	4681	4435	Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2	blastn	24813	255	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Stichococcaceae	Stichococcus	Stichococcus bacillaris
2751645	2751645	PRJNA1095825_P_NODE_267963_length_246_cov_0.890173_g264900_i0	PRJNA1095825	267963	246	0.890173	2.18982558	Tetradesmus bajacalifornicus	269609	Plants	Plants	141	4.61e-29	NTclustered	gi\|2692951786\|ref\|NC_086755.1\|	269609	g264900	i0	97.561	14.5040650406504	82	2	33	0	1	82	93232	93151	Tetradesmus bajacalifornicus strain SAG 3.99 chloroplast, complete genome	blastn	3568	141	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus bajacalifornicus
3570217	3570217	PRJNA1095825_P_NODE_71863_length_446_cov_18.053619_g68800_i0	PRJNA1095825	71863	446	18.053619	80.51914074	Eukaryota	2759	Plants	Plants	800	0	NTclustered	gi\|1201359271\|gb\|MF040793.1\|	3078	g68800	i0	99.544	95.0560538116592	439	2	98	0	1	439	1448	1886	Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence	blastn	42395	802	0.997506234413965	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella pyrenoidosa
4027002	4027002	PRJNA1095825_P_NODE_209704_length_270_cov_0.928934_g206641_i0	PRJNA1095825	209704	270	0.928934	2.5081218	Auxenochlorella protothecoides	3075	Plants	Plants	483	7.409999999999998e-132	NTclustered	gi\|760446390\|ref\|XM_011401962.1\|	3075	g206641	i0	98.889	37.6925925925926	270	3	100	0	1	270	1978	1709	Auxenochlorella protothecoides 60S ribosomal protein L10 partial mRNA	blastn	10177	483	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
4027121	4027121	PRJNA1095825_P_NODE_221184_length_261_cov_1.638298_g218121_i0	PRJNA1095825	221184	261	1.638298	4.27595778	Trebouxia sp. C	2796353	Plants	Plants	74.3	6.74e-15	NR	KAL0042167.1	2905653	g218121	i0	54	1.47126436781609	63	28	71.3	1	4	189	3	65	KAL0042167.1 hypothetical protein WJX77_005300 [Trebouxia sp. C0004]	diamond	384	74.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0004
5303673	5303673	PRJNA1095825_P_NODE_251605_length_249_cov_0.875000_g248542_i0	PRJNA1095825	251605	249	0.875	2.17875	Chlamydomonas incerta	51695	Plants	Plants	178	3.56e-40	NTclustered	gi\|74272704\|gb\|DQ122917.1\|	51695	g248542	i0	81.818	76.8714859437751	220	33	88	7	14	231	360	146	Chlamydomonas incerta S-adenosyl-L-homocystein hydrolase (SAHH) mRNA, partial cds	blastn	19141	178	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
6577654	6577654	PRJNA1095825_P_NODE_133066_length_335_cov_1.175573_g130003_i0	PRJNA1095825	133066	335	1.175573	3.93816955	Scenedesmus sp. NREL 46B-D3	2650976	Plants	Plants	135	4.529999999999999e-37	NR	KAF6263477.1	2650976	g130003	i0	69.5	3.40298507462687	95	29	85.1	0	328	44	143	237	KAF6263477.1 60S ribosomal protein L7 [Scenedesmus sp. NREL 46B-D3]	diamond	1140	135	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. NREL 46B-D3
9128079	9128079	PRJNA1095825_P_NODE_21368_length_919_cov_1.660757_g18615_i0	PRJNA1095825	21368	919	1.660757	15.26235683	Volvox carteri	3067	Plants	Plants	60.2	5.55e-4	NTclustered	gi\|302848485\|ref\|XM_002955729.1\|	3068	g18615	i0	91.111	2.74319912948857	45	3	5	1	339	382	5260	5216	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_119165), partial mRNA	blastn	2521	60.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
10404104	10404104	PRJNA1095825_P_NODE_252269_length_248_cov_1.668571_g249206_i0	PRJNA1095825	252269	248	1.668571	4.13805608	Marvania geminata	97105	Plants	Plants	139	1.67e-28	NTclustered	gi\|2724824493\|gb\|PP746561.1\|	97105	g249206	i0	78.189	42.25	243	35	96	17	1	237	27155	27385	Marvania geminata culture SAG:12.88 mitochondrion, complete genome	blastn	10478	139	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Marvania	Marvania geminata
12954332	12954332	PRJNA1095825_P_NODE_228571_length_256_cov_1.420765_g225508_i0	PRJNA1095825	228571	256	1.420765	3.6371584	Auxenochlorella protothecoides	3075	Plants	Plants	468	1.95e-127	NTclustered	gi\|760442996\|ref\|XM_011400265.1\|	3075	g225508	i0	99.609	37.98046875	256	1	100	0	1	256	434	689	Auxenochlorella protothecoides Triosephosphate isomerase, cytosolic partial mRNA	blastn	9723	468	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
15503555	15503555	PRJNA1095825_P_NODE_261233_length_247_cov_0.885057_g258170_i0	PRJNA1095825	261233	247	0.885057	2.18609079	Stichococcus bacillaris	37433	Plants	Plants	331	2.5600000000000002e-86	NTclustered	gi\|371782093\|emb\|HE610125.1\|	37433	g258170	i0	89.96	9.7165991902834	249	23	100	2	1	247	7296	7048	Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2	blastn	2400	331	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Stichococcaceae	Stichococcus	Stichococcus bacillaris
16777973	16777973	PRJNA1095825_P_NODE_261694_length_247_cov_0.885057_g258631_i0	PRJNA1095825	261694	247	0.885057	2.18609079	Auxenochlorella protothecoides	3075	Plants	Plants	457	4.05e-124	NTclustered	gi\|760448308\|ref\|XM_011402921.1\|	3075	g258631	i0	100	1.28744939271255	247	0	100	0	1	247	532	286	Auxenochlorella protothecoides Heme-binding-like protein, chloroplastic partial mRNA	blastn	318	457	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
19327040	19327040	PRJNA1095825_P_NODE_299916_length_227_cov_2.564935_g296853_i0	PRJNA1095825	299916	227	2.564935	5.82240245	Volvox carteri	3067	Plants	Plants	52.8	0.02	NTclustered	gi\|302848168\|ref\|XM_002955571.1\|	3068	g296853	i0	100	0.123348017621145	28	0	12	0	20	47	1017	990	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_106890), mRNA	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
24427050	24427050	PRJNA1095825_P_NODE_288740_length_242_cov_0.911243_g285677_i0	PRJNA1095825	288740	242	0.911243	2.20520806	Auxenochlorella protothecoides	3075	Plants	Plants	448	2.3799999999999995e-121	NTclustered	gi\|760445518\|ref\|XM_011401526.1\|	3075	g285677	i0	100	5.60743801652893	242	0	100	0	1	242	676	917	Auxenochlorella protothecoides Minor histocompatibility antigen H13 partial mRNA	blastn	1357	448	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
27794333	27794333	PRJNA1095825_P_NODE_294104_length_241_cov_0.916667_g291041_i0	PRJNA1095825	294104	241	0.916667	2.20916747	Monoraphidium neglectum	145388	Plants	Plants	68.2	3.18e-11	NR	XP_013901161.1	145388	g291041	i0	60.7	0.697095435684647	56	21	68.5	1	240	76	275	330	XP_013901161.1 hypothetical protein MNEG_5819 [Monoraphidium neglectum]	diamond	168	68.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
29088782	29088782	PRJNA1095825_P_NODE_219988_length_262_cov_1.629630_g216925_i0	PRJNA1095825	219988	262	1.62963	4.2696306	Edaphochlamys debaryana	47281	Plants	Plants	90.5	3.21e-19	NR	KAG2485171.1	47281	g216925	i0	64.6	0.744274809160305	65	23	74.4	0	260	66	299	363	KAG2485171.1 hypothetical protein HYH03_016061 [Edaphochlamys debaryana]	diamond	195	90.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales		Edaphochlamys	Edaphochlamys debaryana
29688303	29688303	PRJNA1095825_P_NODE_237630_length_251_cov_0.865169_g234567_i0	PRJNA1095825	237630	251	0.865169	2.17157419	Chlorella variabilis	554065	Plants	Plants	72.4	1.48e-12	NR	XP_005845855.1	554065	g234567	i0	56.7	1.74501992031873	60	21	71.7	1	186	7	330	384	XP_005845855.1 hypothetical protein CHLNCDRAFT_136360 [Chlorella variabilis]	diamond	438	72.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
31141512	31141512	PRJNA1095825_P_NODE_295575_length_241_cov_0.916667_g292512_i0	PRJNA1095825	295575	241	0.916667	2.20916747	Haematococcus lacustris	44745	Plants	Plants	100	4.12e-23	NR	KAJ9515751.1	44745	g292512	i0	56.6	2.90041493775934	76	33	94.6	0	229	2	227	302	KAJ9515751.1 hypothetical protein QJQ45_008633 [Haematococcus lacustris]	diamond	699	100	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris

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