metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJEB12982" and tax

6 rows where analysis = "diamond", bioproject = "PRJEB12982" and tax_phylum = "Mollusca"

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
27563546	27563546	PRJEB12982_P_NODE_11664_length_206_cov_1.299363_g11501_i0	PRJEB12982	11664	206	1.299363	2.67668778	Bivalvia	6544	Mollusca	Mollusca	60.8	1.53e-9	NR	XP_021339433.1	6573	g11501	i0	43.3	3.87378640776699	67	38	97.6	0	206	6	83	149	XP_021339433.1 calmodulin-beta-like [Mizuhopecten yessoensis]	diamond	798	60.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
29338388	29338388	PRJEB12982_P_NODE_6229_length_295_cov_0.829268_g6066_i0	PRJEB12982	6229	295	0.829268	2.4463406	Saccostrea echinata	191078	Mollusca	Mollusca	118	3.35e-29	NR	XP_061163244.1	191078	g6066	i0	58.5	0.955932203389831	94	38	95.6	1	294	13	332	424	XP_061163244.1 elongation factor 1-gamma-like [Saccostrea echinata]	diamond	282	118	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea echinata
30374692	30374692	PRJEB12982_P_NODE_20852_length_161_cov_0.910714_g20689_i0	PRJEB12982	20852	161	0.910714	1.46624954	Metazoa	33208	Mollusca	Mollusca	54.3	1.01e-6	NR	XP_033738496.1	6579	g20689	i0	49	10.583850931677	51	26	95	0	4	156	7	57	XP_033738496.1 ergothioneine biosynthesis protein 1-like [Pecten maximus]	diamond	1704	54.7	0.992687385740402	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
30791323	30791323	PRJEB12982_P_NODE_13174_length_193_cov_1.062500_g13011_i0	PRJEB12982	13174	193	1.0625	2.050625	Crassostrea virginica	6565	Mollusca	Mollusca	42	0.0267	NR	XP_022314845.1	6565	g13011	i0	47.9	0.746113989637306	48	24	74.6	1	48	191	121	167	XP_022314845.1 hippocalcin-like protein 1 [Crassostrea virginica]	diamond	144	42	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
31012494	31012494	PRJEB12982_P_NODE_18975_length_164_cov_0.886957_g18812_i0	PRJEB12982	18975	164	0.886957	1.45460948	Candidula unifasciata	100452	Mollusca	Mollusca	44.3	0.00369	NR	CAG5134914.1	100452	g18812	i0	54.8	5.63414634146341	42	19	76.8	0	134	9	38	79	CAG5134914.1 unnamed protein product, partial [Candidula unifasciata]	diamond	924	44.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Geomitridae	Candidula	Candidula unifasciata
31385665	31385665	PRJEB12982_P_NODE_18576_length_165_cov_0.879310_g18413_i0	PRJEB12982	18576	165	0.87931	1.4508615	root	1	Root_unresolved	Root_unresolved	44.7	0.00281	NR	CAL1537303.1	6523	g18413	i0	42	1.69090909090909	50	29	90.9	0	1	150	178	227	CAL1537303.1 unnamed protein product [Lymnaea stagnalis]	diamond	279	44.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis

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