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

18 rows where analysis = "blastn", bioproject = "PRJNA924320" 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
899141	899141	PRJNA924320_S_NODE_28641_length_202_cov_2.163399_g28499_i0	PRJNA924320	28641	202	2.163399	4.37006598	Chlorella variabilis	554065	Plants	Plants	119	1.71e-22	NTclustered	gi\|552822108\|ref\|XM_005845964.1\|	554065	g28499	i0	81.379	11.4108910891089	145	27	72	0	5	149	283	427	Chlorella variabilis hypothetical protein (CHLNCDRAFT_53431) mRNA, complete cds	blastn	2305	119	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
6002399	6002399	PRJNA924320_S_NODE_38385_length_180_cov_1.625954_g38243_i0	PRJNA924320	38385	180	1.625954	2.9267172	Polytomella parva	51329	Plants	Plants	67.6	5.45e-7	NTclustered	gi\|1861356351\|gb\|MT377403.1\|	51329	g38243	i0	91.667	0.433333333333333	48	4	27	0	13	60	1087	1134	Polytomella parva clone 0016314495 nucleolin rDNA chromatin transcription factor (NUCL) mRNA, complete cds; plastid	blastn	78	67.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Polytomella	Polytomella parva
9826906	9826906	PRJNA924320_S_NODE_23568_length_218_cov_0.964497_g23426_i0	PRJNA924320	23568	218	0.964497	2.10260346	Micromonas commoda	296587	Plants	Plants	71.3	5.32e-8	NTclustered	gi\|255072042\|ref\|XM_002499650.1\|	296587	g23426	i0	95.455	0.201834862385321	44	2	20	0	133	176	2412	2369	Micromonas commoda kinesin motor domain partial mRNA	blastn	44	71.3	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
9826925	9826925	PRJNA924320_S_NODE_25728_length_211_cov_1.018519_g25586_i0	PRJNA924320	25728	211	1.018519	2.14907509	Bathycoccus prasinos	41875	Plants	Plants	60.2	1.11e-4	NTclustered	gi\|612386744\|ref\|XM_007508832.1\|	41875	g25586	i0	97.143	1.99526066350711	35	1	17	0	122	156	1083	1117	Bathycoccus prasinos predicted protein (Bathy15g00230), partial mRNA	blastn	421	60.2	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Bathycoccus	Bathycoccus prasinos
13652745	13652745	PRJNA924320_S_NODE_19091_length_236_cov_1.363636_g18949_i0	PRJNA924320	19091	236	1.363636	3.21818096	Chloropicon roscoffensis	1461544	Plants	Plants	235	1.96e-57	NTclustered	gi\|2863415340\|gb\|CP145459.1\|	1461544	g18949	i0	85.153	95.021186440678	229	34	97	0	8	236	169289	169517	Chloropicon roscoffensis strain CCMP1998 chromosome 19	blastn	22425	235	1	Eukaryota		Viridiplantae	Chlorophyta	Chloropicophyceae	Chloropicales	Chloropicaceae	Chloropicon	Chloropicon roscoffensis
14927023	14927023	PRJNA924320_S_NODE_17072_length_247_cov_1.212121_g16930_i0	PRJNA924320	17072	247	1.212121	2.99393887	Mantoniella tinhauana	3097027	Plants	Plants	209	1.25e-49	NTclustered	gi\|2735153281\|gb\|CP140066.1\|	3097027	g16930	i0	83.55	5.18623481781376	231	31	91	7	1	226	82112	81884	Mantoniella tinhauana isolate LFS chromosome 5	blastn	1281	209	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Mantoniella	Mantoniella tinhauana
14927231	14927231	PRJNA924320_S_NODE_43432_length_171_cov_1.254098_g43290_i0	PRJNA924320	43432	171	1.254098	2.14450758	Ostreococcus sp. 'lucimarinus'	242159	Plants	Plants	152	1.37e-32	NTclustered	gi\|145351700\|ref\|XM_001420169.1\|	436017	g43290	i0	83.436	36.6783625730994	163	27	95	0	3	165	2053	2215	Ostreococcus lucimarinus CCE9901 predicted protein partial mRNA	blastn	6272	152	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Ostreococcus	Ostreococcus sp. 'lucimarinus'
16202025	16202025	PRJNA924320_S_NODE_16373_length_251_cov_1.316832_g16231_i0	PRJNA924320	16373	251	1.316832	3.30524832	Chlamydomonas reinhardtii	3055	Plants	Plants	165	2.8e-36	NTclustered	gi\|169219362\|dbj\|AB426139.1\|	3055	g16231	i0	82.564	8.62948207171315	195	26	76	6	58	248	433	623	Chlamydomonas reinhardtii PACRG mRNA for Parkin-co-regulated gene product, complete cds	blastn	2166	165	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
16202051	16202051	PRJNA924320_S_NODE_19013_length_236_cov_2.700535_g18871_i0	PRJNA924320	19013	236	2.700535	6.3732626	Mantoniella tinhauana	3097027	Plants	Plants	93.5	1.25e-14	NTclustered	gi\|2735153289\|gb\|CP140074.1\|	3097027	g18871	i0	84	0.919491525423729	100	13	42	3	112	210	917656	917753	Mantoniella tinhauana isolate LFS chromosome 13	blastn	217	93.5	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Mantoniella	Mantoniella tinhauana
16202175	16202175	PRJNA924320_S_NODE_33313_length_191_cov_1.119718_g33171_i0	PRJNA924320	33313	191	1.119718	2.13866138	Bathycoccus prasinos	41875	Plants	Plants	52.8	0.016	NTclustered	gi\|612398260\|ref\|XM_007514588.1\|	41875	g33171	i0	100	0.146596858638743	28	0	15	0	62	89	34	7	Bathycoccus prasinos PREDICTED: similar to formin binding protein 11-related protein (Bathy02g02320), partial mRNA	blastn	28	52.8	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Bathycoccus	Bathycoccus prasinos
17477328	17477328	PRJNA924320_S_NODE_27734_length_205_cov_1.179487_g27592_i0	PRJNA924320	27734	205	1.179487	2.41794835	Monoraphidium neglectum	145388	Plants	Plants	154	4.77e-33	NTclustered	gi\|926773841\|ref\|XM_014039941.1\|	145388	g27592	i0	85.714	50.6341463414634	147	19	71	2	1	146	203	58	Monoraphidium neglectum 40S ribosomal protein S23 mRNA	blastn	10380	154	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
18750668	18750668	PRJNA924320_S_NODE_15255_length_258_cov_1.952153_g15113_i0	PRJNA924320	15255	258	1.952153	5.03655474	Micromonas commoda	296587	Plants	Plants	219	2.19e-52	NTclustered	gi\|255075346\|ref\|XM_002501302.1\|	296587	g15113	i0	82.031	14.4341085271318	256	46	99	0	1	256	429	684	Micromonas commoda proteasomal ATPase partial mRNA	blastn	3724	219	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
20025937	20025937	PRJNA924320_S_NODE_40956_length_175_cov_2.420635_g40814_i0	PRJNA924320	40956	175	2.420635	4.23611125	Pleodorina californica	47285	Plants	Plants	86.1	1.45e-12	NTclustered	gi\|821690952\|dbj\|AB973442.1\|	47285	g40814	i0	83.333	0.548571428571429	96	12	54	4	82	175	1649	1556	Pleodorina californica act1 gene for actin, partial cds, culture_collection: NIES:576	blastn	96	86.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Pleodorina	Pleodorina californica
23851600	23851600	PRJNA924320_S_NODE_50279_length_165_cov_0.879310_g50137_i0	PRJNA924320	50279	165	0.87931	1.4508615	Volvox carteri	3067	Plants	Plants	106	1.04e-18	NTclustered	gi\|302850906\|ref\|XM_002956933.1\|	3068	g50137	i0	78.571	1.01818181818182	168	30	100	6	1	165	751	915	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_107492), mRNA	blastn	168	106	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
23851663	23851663	PRJNA924320_S_NODE_56819_length_161_cov_0.910714_g56677_i0	PRJNA924320	56819	161	0.910714	1.46624954	Chlamydomonas reinhardtii	3055	Plants	Plants	54.7	0.004	NTclustered	gi\|2082247570\|ref\|XM_043062999.1\|	3055	g56677	i0	100	1.39751552795031	29	0	18	0	129	157	394	422	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g275100v5), mRNA	blastn	225	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
25125207	25125207	PRJNA924320_S_NODE_28380_length_203_cov_1.324675_g28238_i0	PRJNA924320	28380	203	1.324675	2.68909025	Chlamydomonas reinhardtii	3055	Plants	Plants	82.4	2.26e-11	NTclustered	gi\|2082248611\|ref\|XM_043063404.1\|	3055	g28238	i0	91.525	2.50738916256158	59	5	29	0	66	124	1993	1935	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g289850v5), mRNA	blastn	509	82.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
25125324	25125324	PRJNA924320_S_NODE_4180_length_460_cov_3.861314_g4039_i0	PRJNA924320	4180	460	3.861314	17.7620444	Trebouxia sp. SL0000003	3350044	Plants	Plants	58.4	0.001	NTclustered	gi\|2917929625\|emb\|OZ234913.1\|	3350044	g4039	i0	100	0.134782608695652	31	0	7	0	6	36	2994134	2994164	Trebouxia sp. SL0000003 genome assembly, chromosome: 8	blastn	62	58.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. SL0000003
25125420	25125420	PRJNA924320_S_NODE_49960_length_165_cov_0.879310_g49818_i0	PRJNA924320	49960	165	0.87931	1.4508615	Micromonas pusilla	38833	Plants	Plants	71.3	3.81e-8	NTclustered	gi\|303288801\|ref\|XM_003063643.1\|	564608	g49818	i0	84.416	0.466666666666667	77	7	45	5	13	86	539	465	Micromonas pusilla CCMP1545 uncharacterized protein (MICPUCDRAFT_22753), partial mRNA	blastn	77	71.3	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla

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