metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA312615" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA312615" 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
378696	378696	PRJNA312615_P_NODE_57561_length_162_cov_0.920354_g57410_i0	PRJNA312615	57561	162	0.920354	1.49097348	Coccomyxa subellipsoidea	248742	Plants	Plants	100	4.75e-17	NTclustered	gi\|545376489\|ref\|XM_005652272.1\|	574566	g57410	i0	89.024	0.506172839506173	82	7	51	2	67	148	969	890	Coccomyxa subellipsoidea C-169 CSD-domain-containing protein partial mRNA	blastn	82	100	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
1652756	1652756	PRJNA312615_P_NODE_21662_length_262_cov_1.197183_g21511_i0	PRJNA312615	21662	262	1.197183	3.13661946	Coccomyxa subellipsoidea	248742	Plants	Plants	169	2.27e-37	NTclustered	gi\|545370858\|ref\|XM_005649977.1\|	574566	g21511	i0	80.822	32.7748091603053	219	38	83	3	26	242	971	1187	Coccomyxa subellipsoidea C-169 26S proteasome subunit P45 mRNA	blastn	8587	169	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
1653534	1653534	PRJNA312615_P_NODE_6142_length_491_cov_2.755656_g5994_i0	PRJNA312615	6142	491	2.755656	13.53027096	Monoraphidium neglectum	145388	Plants	Plants	333	1.53e-86	NTclustered	gi\|926773763\|ref\|XM_014039902.1\|	145388	g5994	i0	81.308	60.4012219959267	428	64	86	14	52	471	420	1	Monoraphidium neglectum 60S ribosomal protein L19-2 mRNA	blastn	29657	333	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
5481916	5481916	PRJNA312615_P_NODE_44845_length_182_cov_1.225564_g44694_i0	PRJNA312615	44845	182	1.225564	2.23052648	Chlamydomonas reinhardtii	3055	Plants	Plants	106	1.17e-18	NTclustered	gi\|2082260798\|ref\|XM_001697008.2\|	3055	g44694	i0	92	1.54945054945055	75	6	41	0	46	120	957	1031	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g520500v5), mRNA	blastn	282	106	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
6755853	6755853	PRJNA312615_P_NODE_31966_length_216_cov_2.113772_g31815_i0	PRJNA312615	31966	216	2.113772	4.56574752	Chlamydomonas reinhardtii	3055	Plants	Plants	235	1.7599999999999998e-57	NTclustered	gi\|2082248650\|ref\|XM_043063418.1\|	3055	g31815	i0	87.019	98.2777777777778	208	27	96	0	9	216	617	824	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA	blastn	21228	235	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
8716796	8716796	PRJNA312615_P_NODE_53067_length_166_cov_0.871795_g52916_i0	PRJNA312615	53067	166	0.871795	1.4471797	Chlorellales	35460	Plants	Plants	191	2.82e-44	NTclustered	gi\|13486625\|dbj\|AB058647.1\|	3077	g52916	i0	90.476	12.7469879518072	147	11	87	1	13	156	488	342	Chlorella vulgaris rbcS mRNA for ribulose-1,5-bisphosphate carboxylase small subunit, complete cds	blastn	2116	191	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
10581846	10581846	PRJNA312615_P_NODE_18429_length_284_cov_1.672340_g18278_i0	PRJNA312615	18429	284	1.67234	4.7494456	Chlamydomonas reinhardtii	3055	Plants	Plants	58.4	5.64e-4	NTclustered	gi\|2082238366\|ref\|XM_043059241.1\|	3055	g18278	i0	89.13	0.161971830985915	46	5	16	0	93	138	1511	1556	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g081250v5), mRNA	blastn	46	58.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
10582761	10582761	PRJNA312615_P_NODE_8269_length_428_cov_3.303430_g8119_i0	PRJNA312615	8269	428	3.30343	14.1386804	Chlorella variabilis	554065	Plants	Plants	479	1.5999999999999996e-130	NTclustered	gi\|552844675\|ref\|XM_005851082.1\|	554065	g8119	i0	92.988	76.4345794392523	328	23	77	0	1	328	416	89	Chlorella variabilis alpha-tubulin (CHLNCDRAFT_33793) mRNA, complete cds	blastn	32714	479	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
13132332	13132332	PRJNA312615_P_NODE_50891_length_167_cov_1.762712_g50740_i0	PRJNA312615	50891	167	1.762712	2.94372904	Coccomyxa subellipsoidea	248742	Plants	Plants	169	1.33e-37	NTclustered	gi\|545362831\|ref\|XM_005646559.1\|	574566	g50740	i0	85.03	1.34730538922156	167	23	99	2	2	167	316	151	Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA	blastn	225	169	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
15680911	15680911	PRJNA312615_P_NODE_2933_length_668_cov_6.148627_g2801_i0	PRJNA312615	2933	668	6.148627	41.07282836	Chlamydomonas reinhardtii	3055	Plants	Plants	335	5.9e-87	NTclustered	gi\|2082248650\|ref\|XM_043063418.1\|	3055	g2801	i0	77.526	72.8622754491018	574	117	85	11	81	648	857	290	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA	blastn	48672	335	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
18230539	18230539	PRJNA312615_P_NODE_9135_length_408_cov_6.052925_g8985_i0	PRJNA312615	9135	408	6.052925	24.695934	Chlamydomonas incerta	51695	Plants	Plants	300	1.27e-76	NTclustered	gi\|74272606\|gb\|DQ122868.1\|	51695	g8985	i0	84.026	76.2377450980392	313	48	76	2	31	342	345	34	Chlamydomonas incerta 40S ribosomal protein S3 mRNA, complete cds	blastn	31105	300	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
19503881	19503881	PRJNA312615_P_NODE_19076_length_279_cov_1.552174_g18925_i0	PRJNA312615	19076	279	1.552174	4.33056546	Auxenochlorella protothecoides	3075	Plants	Plants	134	8.920000000000001e-27	NTclustered	gi\|760437580\|ref\|XM_011397557.1\|	3075	g18925	i0	78.571	1.11827956989247	210	39	74	5	1	207	270	64	Auxenochlorella protothecoides Transcription factor BTF3 partial mRNA	blastn	312	134	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
19504237	19504237	PRJNA312615_P_NODE_3456_length_625_cov_3.989583_g3318_i0	PRJNA312615	3456	625	3.989583	24.93489375	Monoraphidium neglectum	145388	Plants	Plants	255	4.4e-63	NTclustered	gi\|926778303\|ref\|XM_014042172.1\|	145388	g3318	i0	78.019	49.1296	414	85	66	5	57	467	25	435	Monoraphidium neglectum 40S ribosomal protein S18 mRNA	blastn	30706	255	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
19504301	19504301	PRJNA312615_P_NODE_37796_length_200_cov_0.913907_g37645_i0	PRJNA312615	37796	200	0.913907	1.827814	Chlamydomonas reinhardtii	3055	Plants	Plants	135	1.68e-27	NTclustered	gi\|2082260551\|ref\|XM_001702928.2\|	3055	g37645	i0	82.278	3.61	158	26	79	2	17	173	200	356	Chlamydomonas reinhardtii ribosomal protein S11 (CHLRE_12g514500v5), mRNA	blastn	722	135	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
20779491	20779491	PRJNA312615_P_NODE_21537_length_263_cov_0.906542_g21386_i0	PRJNA312615	21537	263	0.906542	2.38420546	Auxenochlorella protothecoides	3075	Plants	Plants	135	2.32e-27	NTclustered	gi\|760446452\|ref\|XM_011401993.1\|	3075	g21386	i0	79.891	9.15969581749049	184	37	70	0	8	191	315	132	Auxenochlorella protothecoides Isocitrate dehydrogenase [NADP], chloroplastic partial mRNA	blastn	2409	135	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
22054488	22054488	PRJNA312615_P_NODE_20338_length_270_cov_1.710407_g20187_i0	PRJNA312615	20338	270	1.710407	4.6180989	Chlamydomonas reinhardtii	3055	Plants	Plants	250	8.18e-62	NTclustered	gi\|18122\|emb\|X61624.1\|	3055	g20187	i0	83.712	48.837037037037	264	43	98	0	1	264	1349	1612	Chlamydomonas reinhardtii atp2 (atpB) mRNA	blastn	13186	250	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
23329982	23329982	PRJNA312615_P_NODE_1919_length_788_cov_4.132612_g1800_i0	PRJNA312615	1919	788	4.132612	32.56498256	Auxenochlorella protothecoides	3075	Plants	Plants	313	3.28e-80	NTclustered	gi\|760437194\|ref\|XM_011397364.1\|	3075	g1800	i0	81.443	32.2652284263959	388	66	49	5	384	768	627	243	Auxenochlorella protothecoides 40S ribosomal protein S3a partial mRNA	blastn	25425	313	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
24604327	24604327	PRJNA312615_P_NODE_3700_length_609_cov_3.455357_g3561_i0	PRJNA312615	3700	609	3.455357	21.04312413	Chlamydomonas reinhardtii	3055	Plants	Plants	353	1.48e-92	NTclustered	gi\|2082261495\|ref\|XM_001692933.2\|	3055	g3561	i0	79.198	63.0509031198686	524	97	85	10	48	565	929	412	Chlamydomonas reinhardtii ribosomal protein L8 (CHLRE_12g535851v5), mRNA	blastn	38398	353	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);;