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

9 rows where analysis = "blastn", bioproject = "PRJNA924320" 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
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
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
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
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

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