metadata: contig_metadata: 15 rows where bioproject = "PRJNA951412" and tax

15 rows where bioproject = "PRJNA951412" 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
3485443	3485443	PRJNA951412_P_NODE_1403_length_377_cov_2.029605_g1318_i0	PRJNA951412	1403	377	2.029605	7.65161085	root	1	Root_unresolved	Root_unresolved	142	2.11e-36	NR	KAJ9517333.1	44745	g1318	i0	66.1	18.7320954907162	124	42	98.7	0	1	372	1062	1185	KAJ9517333.1 hypothetical protein QJQ45_016698 [Haematococcus lacustris]	diamond	7062	143	0.993006993006993	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
4763130	4763130	PRJNA951412_P_NODE_1044_length_440_cov_2.790191_g959_i0	PRJNA951412	1044	440	2.790191	12.2768404	Monoraphidium neglectum	145388	Plants	Plants	65.8	5.46e-6	NTclustered	gi\|926786903\|ref\|XM_014046472.1\|	145388	g959	i0	93.182	0.1	44	3	10	0	395	438	470	427	Monoraphidium neglectum hypothetical protein mRNA	blastn	44	65.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
6037923	6037923	PRJNA951412_P_NODE_3245_length_273_cov_3.455000_g3160_i0	PRJNA951412	3245	273	3.455	9.43215	Chlamydomonas sp. ICE-L	309537	Plants	Plants	176	1.43e-39	NTclustered	gi\|1433048021\|gb\|MF780877.1\|	309537	g3160	i0	84.971	61.2857142857143	173	26	63	0	101	273	16	188	Chlamydomonas sp. ICE-L heat shock protein 70A (HSP70A) mRNA, partial cds	blastn	16731	176	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. ICE-L
8915544	8915544	PRJNA951412_P_NODE_3627_length_262_cov_2.962963_g3542_i0	PRJNA951412	3627	262	2.962963	7.76296306	Chlorophyta	3041	Plants	Plants	213	1.04e-50	NTclustered	gi\|760444702\|ref\|XM_011401118.1\|	3075	g3542	i0	85.644	57.8282442748092	202	29	77	0	61	262	124	325	Auxenochlorella protothecoides 40S ribosomal protein S23-2 partial mRNA	blastn	15151	213	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
14962636	14962636	PRJNA951412_P_NODE_272_length_949_cov_3.033105_g203_i0	PRJNA951412	272	949	3.033105	28.78416645	Chlorophyta	3041	Plants	Plants	361	7.209999999999997e-110	NR	KAL4858421.1	3077	g203	i0	65.9	11.2824025289779	258	88	81.6	0	12	785	81	338	KAL4858421.1 40S ribosomal protein S4 [Chlorella vulgaris]	diamond	10707	364	0.991758241758242	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
16237597	16237597	PRJNA951412_P_NODE_1873_length_335_cov_2.916031_g1788_i0	PRJNA951412	1873	335	2.916031	9.76870385	Chlorella variabilis	554065	Plants	Plants	327	4.69e-85	NTclustered	gi\|552830805\|ref\|XM_005847928.1\|	554065	g1788	i0	84.412	97.9731343283582	340	46	100	5	1	335	678	341	Chlorella variabilis hypothetical protein (RACK1) mRNA, complete cds	blastn	32821	327	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
22611802	22611802	PRJNA951412_P_NODE_2818_length_287_cov_4.658879_g2733_i0	PRJNA951412	2818	287	4.658879	13.37098273	Volvox carteri	3067	Plants	Plants	76.8	1.57e-9	NTclustered	gi\|302838673\|ref\|XM_002950849.1\|	3068	g2733	i0	97.727	0.327526132404181	44	1	15	0	222	265	770	727	Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl8), mRNA	blastn	94	76.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
25160905	25160905	PRJNA951412_P_NODE_1700_length_348_cov_1.872727_g1615_i0	PRJNA951412	1700	348	1.872727	6.51708996	Chlamydomonas incerta	51695	Plants	Plants	207	6.65e-49	NTclustered	gi\|74272614\|gb\|DQ122872.1\|	51695	g1615	i0	82.231	5.77011494252874	242	41	69	2	106	346	693	453	Chlamydomonas incerta mitochondrial ADP/ATP translocator (ANT) mRNA, complete cds; nuclear gene for mitochondrial product	blastn	2008	207	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
27569226	27569226	PRJNA951412_P_NODE_4364_length_252_cov_0.865922_g4279_i0	PRJNA951412	4364	252	0.865922	2.18212344	Chlamydomonadales	3042	Plants	Plants	121	4.86e-30	NR	XP_042926294.1	3055	g4279	i0	69.9	2.94047619047619	83	25	98.8	0	250	2	3	85	XP_042926294.1 uncharacterized protein CHLRE_03g189950v5 [Chlamydomonas reinhardtii]	diamond	741	122	0.991803278688525	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
27721070	27721070	PRJNA951412_P_NODE_1064_length_436_cov_1.283747_g979_i0	PRJNA951412	1064	436	1.283747	5.59713692	Bryopsis sp. KO-2	3115439	Plants	Plants	169	1.6999999999999998e-48	NR	GMH37549.1	3041901	g979	i0	52.4	0.997706422018349	145	69	99.8	0	435	1	75	219	GMH37549.1 hypothetical protein BSKO_05422 [Bryopsis sp. KO-2023]	diamond	435	169	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Bryopsidaceae	Bryopsis	Bryopsis sp. KO-2023
27752371	27752371	PRJNA951412_P_NODE_4544_length_251_cov_0.876404_g4459_i0	PRJNA951412	4544	251	0.876404	2.19977404	Scenedesmus sp. NREL 46B-D3	2650976	Plants	Plants	51.6	4.25e-6	NR	KAF6266637.1	2650976	g4459	i0	40	0.836653386454183	70	42	83.7	0	35	244	13	82	KAF6266637.1 transmembrane proteins 14C-domain-containing protein [Scenedesmus sp. NREL 46B-D3]	diamond	210	51.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. NREL 46B-D3
28067890	28067890	PRJNA951412_P_NODE_2585_length_297_cov_1.745536_g2500_i0	PRJNA951412	2585	297	1.745536	5.18424192	Pedinophyceae sp. YPF-7	765719	Plants	Plants	184	2.56e-53	NR	CAG9464639.1	765719	g2500	i0	93.9	31.6767676767677	98	6	99	0	2	295	372	469	CAG9464639.1 unnamed protein product [Pedinophyceae sp. YPF-701]	diamond	9408	184	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Pedinophyceae				Pedinophyceae sp. YPF-701
28793957	28793957	PRJNA951412_P_NODE_3987_length_253_cov_2.222222_g3902_i0	PRJNA951412	3987	253	2.222222	5.62222166	Prototheca wickerhamii	3111	Plants	Plants	81.6	6.09e-17	NR	KAK2076667.1	3111	g3902	i0	63.3	0.711462450592885	60	22	71.1	0	252	73	124	183	KAK2076667.1 hypothetical protein QBZ16_005427 [Prototheca wickerhamii]	diamond	180	81.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca wickerhamii
29463313	29463313	PRJNA951412_P_NODE_2330_length_309_cov_1.313559_g2245_i0	PRJNA951412	2330	309	1.313559	4.05889731	Eukaryota	2759	Plants	Plants	156	4.7e-45	NR	KAK9820033.1	41462	g2245	i0	73.7	26.7087378640777	99	26	96.1	0	11	307	1	99	KAK9820033.1 hypothetical protein WJX72_005304 [[Myrmecia] bisecta]	diamond	8253	156	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
31454355	31454355	PRJNA951412_P_NODE_2836_length_287_cov_1.439252_g2751_i0	PRJNA951412	2836	287	1.439252	4.13065324	Chlorellaceae	35461	Plants	Plants	124	7.09e-31	NR	XP_005845202.1	554065	g2751	i0	57.4	3.93031358885017	94	40	98.3	0	286	5	382	475	XP_005845202.1 hypothetical protein CHLNCDRAFT_137433 [Chlorella variabilis]	diamond	1128	124	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis

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