metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB58983" and tax

5 rows where analysis = "blastn", bioproject = "PRJEB58983" 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
2674934	2674934	PRJEB58983_P_NODE_22943_length_274_cov_7.189055_g22528_i0	PRJEB58983	22943	274	7.189055	19.6980107	Bradybaena similaris	145626	Mollusca	Mollusca	54.7	0.007	NTclustered	gi\|2913000417\|dbj\|AP039607.1\|	145626	g22528	i0	96.875	0.233576642335766	32	1	12	0	16	47	8068736	8068705	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence	blastn	64	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
2675202	2675202	PRJEB58983_P_NODE_5183_length_539_cov_2.221030_g4770_i0	PRJEB58983	5183	539	2.22103	11.9713517	Patella vulgata	6465	Mollusca	Mollusca	121	1.43e-22	NTclustered	gi\|2506343378\|ref\|XR_007684797.2\|	6465	g4770	i0	92.771	0.619666048237477	83	6	21	0	436	518	162	244	PREDICTED: Patella vulgata uncharacterized LOC126832675 (LOC126832675), ncRNA	blastn	334	121	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
10328095	10328095	PRJEB58983_P_NODE_31149_length_245_cov_0.906977_g30734_i0	PRJEB58983	31149	245	0.906977	2.22209365	Bradybaena similaris	145626	Mollusca	Mollusca	381	2.4799999999999995e-101	NTclustered	gi\|2913002568\|dbj\|AP039611.1\|	145626	g30734	i0	94.694	1	245	13	100	0	1	245	545639	545395	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence	blastn	245	381	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
15427449	15427449	PRJEB58983_P_NODE_31173_length_245_cov_0.906977_g30758_i0	PRJEB58983	31173	245	0.906977	2.22209365	Bradybaena similaris	145626	Mollusca	Mollusca	202	2.08e-47	NTclustered	gi\|2913002568\|dbj\|AP039611.1\|	145626	g30758	i0	85.938	0.783673469387755	192	24	78	1	54	245	541630	541818	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence	blastn	192	202	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
19250503	19250503	PRJEB58983_P_NODE_25976_length_260_cov_3.834225_g25561_i0	PRJEB58983	25976	260	3.834225	9.968985	Physella acuta	109671	Mollusca	Mollusca	481	2.55e-131	NTclustered	gi\|2572452079\|ref\|XR_009385380.1\|	109671	g25561	i0	100	3.19615384615385	260	0	100	0	1	260	3489	3748	PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA	blastn	831	481	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta

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