metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA1087264" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA1087264" 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
194012	194012	PRJNA1087264_P_NODE_13421_length_172_cov_1.040650_g13339_i0	PRJNA1087264	13421	172	1.04065	1.789918	Mantoniella tinhauana	3097027	Plants	Plants	122	1.0799999999999999e-23	NTclustered	gi\|2735153278\|gb\|CP140063.1\|	3097027	g13339	i0	81.013	17.4360465116279	158	26	91	4	1	156	631735	631890	Mantoniella tinhauana isolate LFS chromosome 2	blastn	2999	122	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Mantoniella	Mantoniella tinhauana
1468650	1468650	PRJNA1087264_P_NODE_16622_length_165_cov_0.913793_g16540_i0	PRJNA1087264	16622	165	0.913793	1.50775845	Chlamydomonas sp. TK-1983	3056	Plants	Plants	58.4	2.97e-4	NTclustered	gi\|174203\|gb\|K02345.1\|CRERRA	3056	g16540	i0	100	0.187878787878788	31	0	19	0	1	31	88	118	Chlamydomonas sp. TK-1983 5S ribosomal RNA gene, complete sequence	blastn	31	58.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. TK-1983
1468677	1468677	PRJNA1087264_P_NODE_2842_length_393_cov_1.095930_g2761_i0	PRJNA1087264	2842	393	1.09593	4.3070049	Chlorella variabilis	554065	Plants	Plants	165	4.63e-36	NTclustered	gi\|552825916\|ref\|XM_005846855.1\|	554065	g2761	i0	85.535	18.1221374045802	159	21	40	2	159	316	234	77	Chlorella variabilis hypothetical protein (CHLNCDRAFT_134811) mRNA, complete cds	blastn	7122	165	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
1468687	1468687	PRJNA1087264_P_NODE_4362_length_311_cov_1.553435_g4280_i0	PRJNA1087264	4362	311	1.553435	4.83118285	Mantoniella tinhauana	3097027	Plants	Plants	211	4.53e-50	NTclustered	gi\|2735153287\|gb\|CP140072.1\|	3097027	g4280	i0	84.507	79.5369774919614	213	33	68	0	47	259	851991	851779	Mantoniella tinhauana isolate LFS chromosome 11	blastn	24736	211	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Mantoniella	Mantoniella tinhauana
2744814	2744814	PRJNA1087264_P_NODE_8403_length_218_cov_0.857988_g8321_i0	PRJNA1087264	8403	218	0.857988	1.87041384	Micromonas commoda	296587	Plants	Plants	113	8.720000000000001e-21	NTclustered	gi\|255078913\|ref\|XM_002502991.1\|	296587	g8321	i0	83.898	31.4357798165138	118	19	54	0	85	202	183	66	Micromonas commoda predicted protein mRNA	blastn	6853	113	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
4020618	4020618	PRJNA1087264_P_NODE_15004_length_167_cov_0.864407_g14922_i0	PRJNA1087264	15004	167	0.864407	1.44355969	Auxenochlorella protothecoides	3075	Plants	Plants	100	4.93e-17	NTclustered	gi\|760444206\|ref\|XM_011400870.1\|	3075	g14922	i0	80	4.08383233532934	135	27	81	0	1	135	774	908	Auxenochlorella protothecoides Lysine-tRNA ligase partial mRNA	blastn	682	100	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
4020650	4020650	PRJNA1087264_P_NODE_20764_length_162_cov_0.902655_g20682_i0	PRJNA1087264	20764	162	0.902655	1.4623011	Ulva intestinalis	3116	Plants	Plants	111	2.19e-20	NTclustered	gi\|148524158\|gb\|EF551324.1\|	3116	g20682	i0	81.818	2.47530864197531	132	24	81	0	27	158	1155	1024	Ulva intestinalis elongation factor-1 alpha-like protein mRNA, partial cds	blastn	401	111	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulvales	Ulvaceae	Ulva	Ulva intestinalis
4845522	4845522	PRJNA1087264_P_NODE_13264_length_173_cov_1.233871_g13182_i0	PRJNA1087264	13264	173	1.233871	2.13459683	Eukaryota	2759	Plants	Plants	154	3.87e-33	NTclustered	gi\|926791444\|ref\|XM_014048742.1\|	145388	g13182	i0	87.5	11.4450867052023	136	14	78	3	39	173	2308	2441	Monoraphidium neglectum adenosylhomocysteinase mRNA	blastn	1980	154	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
5296855	5296855	PRJNA1087264_P_NODE_4205_length_317_cov_2.085821_g4123_i0	PRJNA1087264	4205	317	2.085821	6.61205257	Chlamydomonas reinhardtii	3055	Plants	Plants	117	1.04e-21	NTclustered	gi\|2082253493\|ref\|XM_043066154.1\|	3055	g4123	i0	86.667	1.40378548895899	105	14	33	0	29	133	652	756	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g405106v5), mRNA	blastn	445	117	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
5296900	5296900	PRJNA1087264_P_NODE_7745_length_226_cov_1.248588_g7663_i0	PRJNA1087264	7745	226	1.248588	2.82180888	Monoraphidium neglectum	145388	Plants	Plants	111	3.27e-20	NTclustered	gi\|926770371\|ref\|XM_014038206.1\|	145388	g7663	i0	86.275	4.80530973451327	102	14	45	0	1	102	147	46	Monoraphidium neglectum solute carrier family 25 partial mRNA	blastn	1086	111	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
9121658	9121658	PRJNA1087264_P_NODE_18488_length_164_cov_0.886957_g18406_i0	PRJNA1087264	18488	164	0.886957	1.45460948	Micromonas pusilla	38833	Plants	Plants	178	2.17e-40	NTclustered	gi\|148524162\|gb\|EF551326.1\|	38833	g18406	i0	90.977	41.3475609756098	133	10	80	2	2	133	209	340	Micromonas pusilla clone 3RACE-1 elongation factor-1 alpha-like protein mRNA, partial cds	blastn	6781	178	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla
10397322	10397322	PRJNA1087264_P_NODE_11909_length_183_cov_1.074627_g11827_i0	PRJNA1087264	11909	183	1.074627	1.96656741	Chlamydomonas reinhardtii	3055	Plants	Plants	150	5.37e-32	NTclustered	gi\|2082260397\|ref\|XM_043068042.1\|	3055	g11827	i0	90.351	21.568306010929	114	11	62	0	65	178	525	412	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g498600v5), mRNA	blastn	3947	150	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
14222824	14222824	PRJNA1087264_P_NODE_8132_length_221_cov_1.313953_g8050_i0	PRJNA1087264	8132	221	1.313953	2.90383613	Chlamydomonas reinhardtii	3055	Plants	Plants	254	5e-63	NTclustered	gi\|167449\|gb\|M11448.1\|CRETBA2A	3055	g8050	i0	87.33	97.3665158371041	221	28	100	0	1	221	1159	1379	Chlamydomonas reinhardtii alpha-2 tubulin gene, complete cds	blastn	21518	254	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
15496680	15496680	PRJNA1087264_P_NODE_15913_length_166_cov_0.871795_g15831_i0	PRJNA1087264	15913	166	0.871795	1.4471797	Monoraphidium neglectum	145388	Plants	Plants	130	6.240000000000001e-26	NTclustered	gi\|926789746\|ref\|XM_014047893.1\|	145388	g15831	i0	80.838	78.1265060240964	167	30	100	2	1	166	1011	846	Monoraphidium neglectum lysyl-tRNA synthetase, class II partial mRNA	blastn	12969	130	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
18045834	18045834	PRJNA1087264_P_NODE_955_length_681_cov_1.574367_g885_i0	PRJNA1087264	955	681	1.574367	10.72143927	Micromonas commoda	296587	Plants	Plants	429	2.6899999999999993e-115	NTclustered	gi\|255078509\|ref\|XM_002502789.1\|	296587	g885	i0	81.923	55.6064610866373	520	83	75	8	169	681	864	349	Micromonas commoda predicted protein mRNA	blastn	37868	429	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
20595131	20595131	PRJNA1087264_P_NODE_2437_length_429_cov_1.855263_g2356_i0	PRJNA1087264	2437	429	1.855263	7.95907827	Volvox carteri	3067	Plants	Plants	331	4.750000000000001e-86	NTclustered	gi\|302849325\|ref\|XM_002956147.1\|	3068	g2356	i0	81.01	57.3659673659674	416	79	97	0	12	427	1404	989	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_110003), mRNA	blastn	24610	331	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
21419461	21419461	PRJNA1087264_P_NODE_1597_length_531_cov_2.331950_g1518_i0	PRJNA1087264	1597	531	2.33195	12.3826545	Eukaryota	2759	Plants	Plants	350	1.65e-91	NTclustered	gi\|2082260161\|ref\|XM_001690941.2\|	3055	g1518	i0	82.353	58.3389830508475	408	66	76	6	14	418	145	549	Chlamydomonas reinhardtii ribosomal protein S23 (CHLRE_12g504200v5), mRNA	blastn	30978	350	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
21870829	21870829	PRJNA1087264_P_NODE_15038_length_167_cov_0.864407_g14956_i0	PRJNA1087264	15038	167	0.864407	1.44355969	Micromonas commoda	296587	Plants	Plants	182	1.71e-41	NTclustered	gi\|255078525\|ref\|XM_002502797.1\|	296587	g14956	i0	88.667	66.1317365269461	150	15	89	2	18	166	349	201	Micromonas commoda translation elongation factor EF-1alpha/Tu (TEF1.1), mRNA	blastn	11044	182	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
22694324	22694324	PRJNA1087264_P_NODE_15378_length_166_cov_0.871795_g15296_i0	PRJNA1087264	15378	166	0.871795	1.4471797	Mantoniella	13607	Plants	Plants	230	5.98e-56	NTclustered	gi\|76257848\|gb\|DQ113474.1\|	13608	g15296	i0	91.566	98.6084337349398	166	14	100	0	1	166	604	439	Mantoniella squamata mstua1 alpha-tubulin gene, partial cds	blastn	16369	230	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Mantoniella	Mantoniella squamata
24419941	24419941	PRJNA1087264_P_NODE_8500_length_216_cov_1.670659_g8418_i0	PRJNA1087264	8500	216	1.670659	3.60862344	Chloropicon roscoffensis	1461544	Plants	Plants	296	7.98e-76	NTclustered	gi\|2863419500\|gb\|CP145464.1\|	1461544	g8418	i0	91.628	98.1851851851852	215	16	99	2	1	214	929248	929461	Chloropicon roscoffensis strain RCC2335 chromosome 5	blastn	21208	296	1	Eukaryota		Viridiplantae	Chlorophyta	Chloropicophyceae	Chloropicales	Chloropicaceae	Chloropicon	Chloropicon roscoffensis

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