metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA613025" 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
3142478	3142478	PRJNA613025_S_NODE_16163_length_261_cov_1.679245_g16009_i0	PRJNA613025	16163	261	1.679245	4.38282945	Eukaryota	2759	Plants	Plants	100	7.85e-24	NR	KAK2080821.1	3111	g16009	i0	66.7	5.83908045977012	84	28	96.6	0	8	259	36	119	KAK2080821.1 60S ribosomal protein L7B [Prototheca wickerhamii]	diamond	1524	101	0.99009900990099	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca wickerhamii
4419480	4419480	PRJNA613025_S_NODE_28944_length_171_cov_1.245902_g28790_i0	PRJNA613025	28944	171	1.245902	2.13049242	[Myrmecia] bisecta	41462	Plants	Plants	89.4	5.13e-19	NR	KAK9814170.1	41462	g28790	i0	76.8	1.96491228070175	56	13	98.2	0	3	170	38	93	KAK9814170.1 hypothetical protein WJX72_001591 [[Myrmecia] bisecta]	diamond	336	89.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
6970300	6970300	PRJNA613025_S_NODE_29426_length_169_cov_1.291667_g29272_i0	PRJNA613025	29426	169	1.291667	2.18291723	Botryococcus braunii	38881	Plants	Plants	89	1.13e-21	NR	BAM44860.1	38881	g29272	i0	69.1	0.976331360946746	55	17	97.6	0	167	3	19	73	BAM44860.1 ribulose bisphosphate carboxylase small subunit, partial [Botryococcus braunii]	diamond	165	89	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Botryococcus	Botryococcus braunii
6970369	6970369	PRJNA613025_S_NODE_32146_length_164_cov_0.886957_g31992_i0	PRJNA613025	32146	164	0.886957	1.45460948	Polytomella parva	51329	Plants	Plants	94	1.14e-20	NR	QKY14934.1	51329	g31992	i0	83.3	4.92073170731707	54	9	98.8	0	1	162	484	537	QKY14934.1 heat shock protein 70c (HS70), partial [Polytomella parva]	diamond	807	94	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Polytomella	Polytomella parva
27964618	27964618	PRJNA613025_S_NODE_34005_length_161_cov_0.866071_g33851_i0	PRJNA613025	34005	161	0.866071	1.39437431	Micromonas commoda	296587	Plants	Plants	45.1	4.25e-4	NR	XP_002507140.1	296587	g33851	i0	59	0.726708074534162	39	16	72.7	0	45	161	4	42	XP_002507140.1 60S ribosomal protein L36 [Micromonas commoda]	diamond	117	45.1	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
30124693	30124693	PRJNA613025_S_NODE_21172_length_211_cov_1.259259_g21018_i0	PRJNA613025	21172	211	1.259259	2.65703649	Eukaryota	2759	Plants	Plants	114	5.41e-29	NR	GIL46450.1	51714	g21018	i0	76.5	5.80094786729858	68	16	96.7	0	209	6	106	173	GIL46450.1 hypothetical protein Vafri_3453 [Volvox africanus]	diamond	1224	115	0.991304347826087	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox africanus
30965102	30965102	PRJNA613025_S_NODE_33974_length_161_cov_0.901786_g33820_i0	PRJNA613025	33974	161	0.901786	1.45187546	Cymbomonas tetramitiformis	36881	Plants	Plants	74.7	3.96e-14	NR	KAK3270400.1	36881	g33820	i0	62.5	1.7888198757764	48	18	89.4	0	151	8	164	211	KAK3270400.1 hypothetical protein CYMTET_21203 [Cymbomonas tetramitiformis]	diamond	288	74.7	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
31217311	31217311	PRJNA613025_S_NODE_33795_length_161_cov_0.910714_g33641_i0	PRJNA613025	33795	161	0.910714	1.46624954	Helicosporidium sp. ATCC 5	1907511	Plants	Plants	79	9.32e-17	NR	KDD75220.1	1291522	g33641	i0	73.6	1.95652173913043	53	14	98.8	0	160	2	97	149	KDD75220.1 ribosomal protein L32 [Helicosporidium sp. ATCC 50920]	diamond	315	79	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Helicosporidium	Helicosporidium sp. ATCC 50920
31723727	31723727	PRJNA613025_S_NODE_23437_length_197_cov_1.033784_g23283_i0	PRJNA613025	23437	197	1.033784	2.03655448	Trebouxia sp. C	2796353	Plants	Plants	56.2	3.64e-8	NR	KAL0042167.1	2905653	g23283	i0	54.2	0.730964467005076	48	21	71.6	1	195	55	18	65	KAL0042167.1 hypothetical protein WJX77_005300 [Trebouxia sp. C0004]	diamond	144	56.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0004

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