metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJEB36940" and tax

17 rows where analysis = "blastn", bioproject = "PRJEB36940" 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
988965	988965	PRJEB36940_P_NODE_1181_length_764_cov_3.794501_g1064_i0	PRJEB36940	1181	764	3.794501	28.98998764	Chlamydomonas	3052	Plants	Plants	363	3.12e-95	NTclustered	gi\|2082247947\|ref\|XM_001698013.2\|	3055	g1064	i0	80.705	29.6727748691099	482	80	62	10	226	699	198	674	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g278222v5), mRNA	blastn	22670	363	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
1331130	1331130	PRJEB36940_P_NODE_6722_length_332_cov_3.459459_g6593_i0	PRJEB36940	6722	332	3.459459	11.48540388	Auxenochlorella protothecoides	3075	Plants	Plants	250	1.03e-61	NTclustered	gi\|760448344\|ref\|XM_011402939.1\|	3075	g6593	i0	83.039	40.4819277108434	283	40	84	7	26	304	1	279	Auxenochlorella protothecoides 60S ribosomal protein L15 partial mRNA	blastn	13440	250	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
2606697	2606697	PRJEB36940_P_NODE_1743_length_635_cov_4.209964_g1623_i0	PRJEB36940	1743	635	4.209964	26.7332714	Chlamydomonas reinhardtii	3055	Plants	Plants	303	1.5800000000000001e-77	NTclustered	gi\|2082248650\|ref\|XM_043063418.1\|	3055	g1623	i0	76.632	56.0472440944882	582	116	90	18	48	619	285	856	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA	blastn	35590	303	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
3882965	3882965	PRJEB36940_P_NODE_7784_length_310_cov_1.324895_g7655_i0	PRJEB36940	7784	310	1.324895	4.1071745	uncultured Trebouxia photobiont	285713	Plants	Plants	510	3.98e-140	NTclustered	gi\|1273623725\|gb\|KY033354.1\|	285713	g7655	i0	96.452	21.6064516129032	310	9	100	2	1	310	8794	8487	Uncultured Trebouxia photobiont voucher Lendemer 46119 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	6698	510	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	uncultured Trebouxia photobiont
4816871	4816871	PRJEB36940_P_NODE_4924_length_384_cov_10.662379_g4795_i0	PRJEB36940	4924	384	10.662379	40.94353536	Eukaryota	2759	Plants	Plants	315	4.23e-81	NTclustered	gi\|685431495\|gb\|KM033846.1\|	1545437	g4795	i0	85.811	74.1432291666667	296	42	77	0	1	296	371	76	Dunaliella sp. KU22 alpha-tubulin protein (ATUB) mRNA, partial cds	blastn	28471	318	0.990566037735849	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella sp. KU22
6434949	6434949	PRJEB36940_P_NODE_15666_length_243_cov_0.894118_g15537_i0	PRJEB36940	15666	243	0.894118	2.17270674	Binuclearia lauterbornii	3087189	Plants	Plants	363	8.909999999999999e-96	NTclustered	gi\|725651149\|ref\|NC_025541.1\|	3087189	g15537	i0	93.776	125.399176954733	241	15	99	0	3	243	91503	91263	Planctonema lauterbornii culture-collection SAG:68.94 chloroplast, complete genome	blastn	30472	363	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Oocystaceae	Binuclearia	Binuclearia lauterbornii
7709162	7709162	PRJEB36940_P_NODE_3427_length_459_cov_0.979275_g3299_i0	PRJEB36940	3427	459	0.979275	4.49487225	Polytomella sp. Pringsheim 198.80	37502	Plants	Plants	289	3.12e-73	NTclustered	gi\|635557420\|emb\|FN984965.1\|	37502	g3299	i0	79.803	36.7080610021787	406	74	88	8	4	405	1420	1019	Polytomella sp. Pringsheim 198.80 mRNA for S-Adenosyl homocysteine hydrolase (sah1 gene)	blastn	16849	289	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Polytomella	Polytomella sp. Pringsheim 198.80
10259594	10259594	PRJEB36940_P_NODE_6089_length_348_cov_1.694545_g5960_i0	PRJEB36940	6089	348	1.694545	5.8970166	uncultured Trebouxia photobiont	285713	Plants	Plants	638	1.99e-178	NTclustered	gi\|1273623725\|gb\|KY033354.1\|	285713	g5960	i0	99.713	100.508620689655	348	1	100	0	1	348	6567	6220	Uncultured Trebouxia photobiont voucher Lendemer 46119 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	34977	638	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	uncultured Trebouxia photobiont
11192332	11192332	PRJEB36940_P_NODE_12629_length_251_cov_1.382022_g12500_i0	PRJEB36940	12629	251	1.382022	3.46887522	Chlorophyta	3041	Plants	Plants	257	4.49e-64	NTclustered	gi\|725676030\|ref\|NC_025530.1\|	160064	g12500	i0	85.772	122.115537848606	246	31	97	3	1	244	94552	94795	Pedinomonas tuberculata culture-collection SAG:42.84 chloroplast, complete genome	blastn	30651	257	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Pedinophyceae	Pedinomonadales	Pedinomonadaceae	Pedinomonas	Pedinomonas tuberculata
14085173	14085173	PRJEB36940_P_NODE_9852_length_278_cov_4.219512_g9723_i0	PRJEB36940	9852	278	4.219512	11.73024336	Auxenochlorella protothecoides	3075	Plants	Plants	202	2.4e-47	NTclustered	gi\|760448344\|ref\|XM_011402939.1\|	3075	g9723	i0	81.25	20.8812949640288	256	42	91	5	16	268	1	253	Auxenochlorella protothecoides 60S ribosomal protein L15 partial mRNA	blastn	5805	202	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
14085175	14085175	PRJEB36940_P_NODE_9892_length_278_cov_1.512195_g9763_i0	PRJEB36940	9892	278	1.512195	4.2039021	Chlorella variabilis	554065	Plants	Plants	113	1.16e-20	NTclustered	gi\|552832460\|ref\|XM_005848290.1\|	554065	g9763	i0	83.471	11.0935251798561	121	20	44	0	132	252	107	227	Chlorella variabilis hypothetical protein (CHLNCDRAFT_51922) mRNA, complete cds	blastn	3084	113	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
15358937	15358937	PRJEB36940_P_NODE_4153_length_419_cov_2.595376_g4024_i0	PRJEB36940	4153	419	2.595376	10.87462544	Chlamydomonas incerta	51695	Plants	Plants	303	1.01e-77	NTclustered	gi\|74272704\|gb\|DQ122917.1\|	51695	g4024	i0	84.74	71.9021479713604	308	42	73	5	1	307	342	39	Chlamydomonas incerta S-adenosyl-L-homocystein hydrolase (SAHH) mRNA, partial cds	blastn	30127	303	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
16633556	16633556	PRJEB36940_P_NODE_11634_length_258_cov_5.167568_g11505_i0	PRJEB36940	11634	258	5.167568	13.33232544	Chlorella variabilis	554065	Plants	Plants	130	1.05e-25	NTclustered	gi\|552842500\|ref\|XM_005850520.1\|	554065	g11505	i0	86.957	72.7170542635659	115	15	45	0	1	115	343	229	Chlorella variabilis hypothetical protein (CHLNCDRAFT_48528) mRNA, complete cds	blastn	18761	130	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
16633652	16633652	PRJEB36940_P_NODE_4294_length_412_cov_4.191740_g4165_i0	PRJEB36940	4294	412	4.19174	17.2699688	Monoraphidium neglectum	145388	Plants	Plants	231	4.7399999999999995e-56	NTclustered	gi\|926795717\|ref\|XM_014050538.1\|	145388	g4165	i0	80.192	38.3932038834951	313	58	75	4	20	330	365	55	Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA	blastn	15818	231	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
19182317	19182317	PRJEB36940_P_NODE_5836_length_355_cov_1.641844_g5707_i0	PRJEB36940	5836	355	1.641844	5.8285462	Monoraphidium neglectum	145388	Plants	Plants	200	1.13e-46	NTclustered	gi\|926769681\|ref\|XM_014037861.1\|	145388	g5707	i0	80.769	7.52957746478873	260	46	73	4	98	355	438	181	Monoraphidium neglectum H/ACA ribonucleoprotein complex subunit 4 mRNA	blastn	2673	200	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
20457637	20457637	PRJEB36940_P_NODE_4977_length_382_cov_4.938511_g4848_i0	PRJEB36940	4977	382	4.938511	18.86511202	Chlorella variabilis	554065	Plants	Plants	89.8	2.78e-13	NTclustered	gi\|552839615\|ref\|XM_005849780.1\|	554065	g4848	i0	78.322	2.11780104712042	143	27	37	4	165	305	261	121	Chlorella variabilis hypothetical protein (CHLNCDRAFT_143002) mRNA, complete cds	blastn	809	89.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
24282637	24282637	PRJEB36940_P_NODE_6260_length_344_cov_1.723247_g6131_i0	PRJEB36940	6260	344	1.723247	5.92796968	Chlamydomonas reinhardtii	3055	Plants	Plants	193	1.84e-44	NTclustered	gi\|2082243183\|ref\|XM_001691826.2\|	3055	g6131	i0	82.222	42.7994186046512	225	38	65	2	1	224	706	929	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g191050v5), mRNA	blastn	14723	193	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii

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