metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA285816" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA285816" 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
1646761	1646761	PRJNA285816_S_NODE_18862_length_184_cov_1.540741_g18760_i0	PRJNA285816	18862	184	1.540741	2.83496344	Chlorella variabilis	554065	Plants	Plants	122	1.1799999999999999e-23	NTclustered	gi\|552840787\|ref\|XM_005850079.1\|	554065	g18760	i0	91.111	1	90	8	49	0	12	101	146	57	Chlorella variabilis hypothetical protein (CHLNCDRAFT_59606) mRNA, complete cds	blastn	184	122	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
1646879	1646879	PRJNA285816_S_NODE_28982_length_162_cov_5.362832_g28880_i0	PRJNA285816	28982	162	5.362832	8.68778784	Ostreococcus sp. 'lucimarinus'	242159	Plants	Plants	152	1.29e-32	NTclustered	gi\|145347520\|ref\|XM_001418175.1\|	436017	g28880	i0	84.076	0.969135802469136	157	25	97	0	2	158	985	829	Ostreococcus lucimarinus CCE9901 predicted protein partial mRNA	blastn	157	152	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Ostreococcus	Ostreococcus sp. 'lucimarinus'
9987257	9987257	PRJNA285816_S_NODE_19748_length_181_cov_1.575758_g19646_i0	PRJNA285816	19748	181	1.575758	2.85212198	Chlorophyta	3041	Plants	Plants	172	1.13e-38	NTclustered	gi\|255072308\|ref\|XM_002499783.1\|	296587	g19646	i0	84.795	39.8066298342541	171	26	94	0	9	179	319	149	Micromonas commoda predicted protein mRNA	blastn	7205	172	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
11262346	11262346	PRJNA285816_S_NODE_409_length_922_cov_23.387171_g359_i0	PRJNA285816	409	922	23.387171	215.62971662	Eukaryota	2759	Plants	Plants	351	8.2e-92	NTclustered	gi\|1861356367\|gb\|MT377411.1\|	51329	g359	i0	77.467	51.6041214750542	608	124	65	12	173	773	97	698	Polytomella parva clone 0016300147 40S ribosomal protein S2 (RPS2) mRNA, complete cds; plastid	blastn	47579	351	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Polytomella	Polytomella parva
11850802	11850802	PRJNA285816_S_NODE_7910_length_253_cov_2.014706_g7808_i0	PRJNA285816	7910	253	2.014706	5.09720618	Volvox carteri	3067	Plants	Plants	86.1	2.26e-12	NTclustered	gi\|302831072\|ref\|XM_002947056.1\|	3068	g7808	i0	90.625	0.25296442687747	64	6	25	0	2	65	87	150	Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl39), partial mRNA	blastn	64	86.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
14401140	14401140	PRJNA285816_S_NODE_7752_length_255_cov_2.257282_g7650_i0	PRJNA285816	7752	255	2.257282	5.7560691	Auxenochlorella protothecoides	3075	Plants	Plants	215	2.79e-51	NTclustered	gi\|1102971032\|gb\|FJ196315.2\|	3075	g7650	i0	81.89	82.0470588235294	254	46	99	0	1	254	612	359	Auxenochlorella protothecoides ribosomal protein S5 (RPS5) mRNA, partial cds	blastn	20922	215	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
19497808	19497808	PRJNA285816_S_NODE_10996_length_223_cov_1.494253_g10894_i0	PRJNA285816	10996	223	1.494253	3.33218419	Tetraselmis sp. CCMP 881	1812852	Plants	Plants	180	8.7e-41	NTclustered	gi\|1778428824\|gb\|MN642087.1\|	1812852	g10894	i0	81.333	70.8206278026906	225	38	100	3	1	223	41690	41912	Tetraselmis sp. CCMP 881 mitochondrion, complete genome	blastn	15793	180	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorodendrophyceae	Chlorodendrales	Chlorodendraceae	Tetraselmis	Tetraselmis sp. CCMP 881
20773347	20773347	PRJNA285816_S_NODE_10217_length_229_cov_1.372222_g10115_i0	PRJNA285816	10217	229	1.372222	3.14238838	Micromonas commoda	296587	Plants	Plants	126	1.19e-24	NTclustered	gi\|255076324\|ref\|XM_002501791.1\|	296587	g10115	i0	91.304	23.6331877729258	92	8	40	0	17	108	1046	1137	Micromonas commoda p-type ATPase superfamily partial mRNA	blastn	5412	126	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
21460916	21460916	PRJNA285816_S_NODE_5917_length_285_cov_7.762712_g5815_i0	PRJNA285816	5917	285	7.762712	22.1237292	Opisthokonta	33154	Plants	Plants	99	3.33e-16	NTclustered	gi\|612395756\|ref\|XM_007513336.1\|	41875	g5815	i0	80.303	1.92631578947368	132	24	46	2	102	232	171	41	Bathycoccus prasinos 40S ribosomal protein S29 (Bathy04g01450), partial mRNA	blastn	549	100	0.99	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Bathycoccus	Bathycoccus prasinos
22048337	22048337	PRJNA285816_S_NODE_10418_length_227_cov_1.938202_g10316_i0	PRJNA285816	10418	227	1.938202	4.39971854	Micromonas commoda	296587	Plants	Plants	128	3.27e-25	NTclustered	gi\|255080187\|ref\|XM_002503628.1\|	296587	g10316	i0	77.232	1.38766519823789	224	47	98	4	1	222	2004	1783	Micromonas commoda predicted protein partial mRNA	blastn	315	128	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
22048605	22048605	PRJNA285816_S_NODE_6638_length_272_cov_1.098655_g6536_i0	PRJNA285816	6638	272	1.098655	2.9883416	Haematococcus lacustris	44745	Plants	Plants	329	1.0299999999999998e-85	NTclustered	gi\|1279575454\|gb\|MF683078.1\|	44745	g6536	i0	89.961	396.055147058824	259	20	94	6	3	258	2928	2673	Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast	blastn	107727	329	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
22048610	22048610	PRJNA285816_S_NODE_7018_length_266_cov_1.350230_g6916_i0	PRJNA285816	7018	266	1.35023	3.5916118	Chlamydomonas incerta	51695	Plants	Plants	163	1.08e-35	NTclustered	gi\|74272608\|gb\|DQ122869.1\|	51695	g6916	i0	80	3.84210526315789	225	41	84	3	15	237	157	379	Chlamydomonas incerta 40S ribosomal protein S8 mRNA, complete cds	blastn	1022	163	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta

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