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

20 rows where analysis = "blastn", bioproject = "PRJNA876641" 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
1238489	1238489	PRJNA876641_P_NODE_5021_length_351_cov_2.215827_g4947_i0	PRJNA876641	5021	351	2.215827	7.77755277	Eukaryota	2759	Plants	Plants	250	1.1e-61	NTclustered	gi\|2082260161\|ref\|XM_001690941.2\|	3055	g4947	i0	82.414	68.997150997151	290	47	82	4	58	345	192	479	Chlamydomonas reinhardtii ribosomal protein S23 (CHLRE_12g504200v5), mRNA	blastn	24218	250	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
3403817	3403817	PRJNA876641_P_NODE_12443_length_268_cov_1.425641_g12369_i0	PRJNA876641	12443	268	1.425641	3.82071788	Chlamydomonas reinhardtii	3055	Plants	Plants	71.3	6.77e-8	NTclustered	gi\|2082261585\|ref\|XM_043068686.1\|	3055	g12369	i0	100	0.141791044776119	38	0	14	0	44	81	295	258	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g537800v5), mRNA	blastn	38	71.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
4681465	4681465	PRJNA876641_P_NODE_12444_length_268_cov_1.415385_g12370_i0	PRJNA876641	12444	268	1.415385	3.7932318	Chlamydomonas reinhardtii	3055	Plants	Plants	89.8	1.87e-13	NTclustered	gi\|2082253493\|ref\|XM_043066154.1\|	3055	g12370	i0	91.045	367.347014925373	67	5	25	1	1	67	706	771	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g405106v5), mRNA	blastn	98449	89.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
7231504	7231504	PRJNA876641_P_NODE_5546_length_339_cov_1.492481_g5472_i0	PRJNA876641	5546	339	1.492481	5.05951059	Monoraphidium neglectum	145388	Plants	Plants	187	8.409999999999998e-43	NTclustered	gi\|926783943\|ref\|XM_014044992.1\|	145388	g5472	i0	92.969	130.194690265487	128	9	38	0	212	339	688	561	Monoraphidium neglectum ubiquitin C mRNA	blastn	44136	187	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
8506027	8506027	PRJNA876641_P_NODE_14847_length_255_cov_1.434066_g14773_i0	PRJNA876641	14847	255	1.434066	3.6568683	Chlamydomonas reinhardtii	3055	Plants	Plants	235	2.1399999999999997e-57	NTclustered	gi\|2082243702\|ref\|XM_043061450.1\|	3055	g14773	i0	84.146	83.3686274509804	246	36	96	3	4	249	185	427	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g204250v5), mRNA	blastn	21259	235	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
8506079	8506079	PRJNA876641_P_NODE_17527_length_249_cov_0.875000_g17453_i0	PRJNA876641	17527	249	0.875	2.17875	Acetabularia acetabulum	35845	Plants	Plants	180	9.91e-41	NTclustered	gi\|1303672\|dbj\|D50528.1\|	35845	g17453	i0	80.159	10.8192771084337	252	40	99	7	4	249	1372	1125	Acetabularia acetabulum mRNA for adenosine triphosphatase A subunit, complete cds	blastn	2694	180	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Dasycladales	Polyphysaceae	Acetabularia	Acetabularia acetabulum
8506124	8506124	PRJNA876641_P_NODE_20127_length_245_cov_0.895349_g20053_i0	PRJNA876641	20127	245	0.895349	2.19360505	Auxenochlorella protothecoides	3075	Plants	Plants	154	5.89e-33	NTclustered	gi\|760447428\|ref\|XM_011402481.1\|	3075	g20053	i0	98.837	0.351020408163265	86	1	35	0	160	245	1350	1265	Auxenochlorella protothecoides putative dual-specificity RNA methyltransferase RlmN partial mRNA	blastn	86	154	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
9780984	9780984	PRJNA876641_P_NODE_13728_length_261_cov_1.494681_g13654_i0	PRJNA876641	13728	261	1.494681	3.90111741	Chlorella variabilis	554065	Plants	Plants	198	2.89e-46	NTclustered	gi\|552833560\|ref\|XM_005848496.1\|	554065	g13654	i0	83.182	46.9195402298851	220	34	84	3	42	260	155	372	Chlorella variabilis hypothetical protein (CHLNCDRAFT_59661) mRNA, complete cds	blastn	12246	198	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
9781178	9781178	PRJNA876641_P_NODE_5968_length_330_cov_2.210117_g5894_i0	PRJNA876641	5968	330	2.210117	7.2933861	Chlorella variabilis	554065	Plants	Plants	298	3.61e-76	NTclustered	gi\|552844675\|ref\|XM_005851082.1\|	554065	g5894	i0	85.172	85.4060606060606	290	43	88	0	3	292	375	86	Chlorella variabilis alpha-tubulin (CHLNCDRAFT_33793) mRNA, complete cds	blastn	28184	298	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
11056995	11056995	PRJNA876641_P_NODE_4329_length_369_cov_1.114865_g4255_i0	PRJNA876641	4329	369	1.114865	4.11385185	Monoraphidium neglectum	145388	Plants	Plants	198	4.26e-46	NTclustered	gi\|926782011\|ref\|XM_014044026.1\|	145388	g4255	i0	88.024	44.420054200542	167	20	45	0	201	367	707	541	Monoraphidium neglectum 14-3-3-like protein mRNA	blastn	16391	198	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
16155991	16155991	PRJNA876641_P_NODE_4713_length_358_cov_2.017544_g4639_i0	PRJNA876641	4713	358	2.017544	7.22280752	Chlamydomonas reinhardtii	3055	Plants	Plants	217	1.14e-51	NTclustered	gi\|2082263148\|ref\|XM_001693658.2\|	3055	g4639	i0	82.787	20.2374301675978	244	41	68	1	58	301	493	735	Chlamydomonas reinhardtii ribosomal protein S3a (CHLRE_13g568650v5), mRNA	blastn	7245	217	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
16156018	16156018	PRJNA876641_P_NODE_6453_length_322_cov_1.835341_g6379_i0	PRJNA876641	6453	322	1.835341	5.90979802	Chlamydomonas reinhardtii	3055	Plants	Plants	163	1.34e-35	NTclustered	gi\|2082238114\|ref\|XM_001701583.2\|	3055	g6379	i0	79.825	1.29192546583851	228	42	70	4	93	318	621	396	Chlamydomonas reinhardtii ribosomal protein L19 (CHLRE_02g075700v5), mRNA	blastn	416	163	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
17431283	17431283	PRJNA876641_P_NODE_14094_length_259_cov_1.424731_g14020_i0	PRJNA876641	14094	259	1.424731	3.69005329	Chlamydomonas reinhardtii	3055	Plants	Plants	182	2.88e-41	NTclustered	gi\|2082244743\|ref\|XM_001698671.2\|	3055	g14020	i0	93.443	48.7220077220077	122	8	47	0	130	251	750	629	Chlamydomonas reinhardtii ribosomal protein L23 (CHLRE_04g211800v5), mRNA	blastn	12619	182	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
18704494	18704494	PRJNA876641_P_NODE_12915_length_265_cov_2.406250_g12841_i0	PRJNA876641	12915	265	2.40625	6.3765625	Chlamydomonas reinhardtii	3055	Plants	Plants	145	3.88e-30	NTclustered	gi\|2082256028\|ref\|XM_001702556.2\|	3055	g12841	i0	80	1.97735849056604	195	39	74	0	26	220	218	412	Chlamydomonas reinhardtii ribosomal protein L30 (CHLRE_10g420750v5), mRNA	blastn	524	145	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
21640565	21640565	PRJNA876641_P_NODE_2077_length_483_cov_1.060976_g2003_i0	PRJNA876641	2077	483	1.060976	5.12451408	Eukaryota	2759	Plants	Plants	372	3.18e-98	NTclustered	gi\|2082253475\|ref\|XM_001695212.2\|	3055	g2003	i0	80.894	87.7577639751553	492	76	100	14	1	483	2205	1723	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g386750v5), mRNA	blastn	42387	374	0.994652406417112	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
22916143	22916143	PRJNA876641_P_NODE_1978_length_494_cov_1.415677_g1904_i0	PRJNA876641	1978	494	1.415677	6.99344438	Eukaryota	2759	Plants	Plants	56.5	0.004	NTclustered	gi\|926763293\|ref\|XM_014035245.1\|	145388	g1904	i0	90.909	0.477732793522267	44	1	8	1	393	433	1244	1201	Monoraphidium neglectum E3 ubiquitin-protein ligase mRNA	blastn	236	56.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
23805285	23805285	PRJNA876641_P_NODE_13579_length_262_cov_1.402116_g13505_i0	PRJNA876641	13579	262	1.402116	3.67354392	Auxenochlorella protothecoides	3075	Plants	Plants	193	1.35e-44	NTclustered	gi\|760442850\|ref\|XM_011400192.1\|	3075	g13505	i0	95.798	0.454198473282443	119	5	45	0	1	119	408	526	Auxenochlorella protothecoides hypothetical protein partial mRNA	blastn	119	193	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
23805507	23805507	PRJNA876641_P_NODE_6139_length_327_cov_1.669291_g6065_i0	PRJNA876641	6139	327	1.669291	5.45858157	Monoraphidium neglectum	145388	Plants	Plants	298	3.58e-76	NTclustered	gi\|926779051\|ref\|XM_014042546.1\|	145388	g6065	i0	84.899	88.2599388379205	298	41	91	3	16	311	1280	985	Monoraphidium neglectum heat shock 70kDa protein 1/8 mRNA	blastn	28861	298	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
25079239	25079239	PRJNA876641_P_NODE_18760_length_247_cov_0.885057_g18686_i0	PRJNA876641	18760	247	0.885057	2.18609079	Coccomyxa subellipsoidea	248742	Plants	Plants	246	9.54e-61	NTclustered	gi\|545355299\|ref\|XM_005643394.1\|	574566	g18686	i0	84.677	1.00404858299595	248	36	100	2	1	247	374	620	Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA	blastn	248	246	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
25079252	25079252	PRJNA876641_P_NODE_19600_length_246_cov_0.890173_g19526_i0	PRJNA876641	19600	246	0.890173	2.18982558	Auxenochlorella protothecoides	3075	Plants	Plants	455	1.4500000000000002e-123	NTclustered	gi\|760443184\|ref\|XM_011400359.1\|	3075	g19526	i0	100	1	246	0	100	0	1	246	653	408	Auxenochlorella protothecoides Translation initiation factor eIF-2B subunit beta partial mRNA	blastn	246	455	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides

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