metadata: contig_metadata: 4 rows where bioproject = "PRJNA1137393", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJNA1137393", tax_clade = "Opisthokonta" 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
15587535	15587535	PRJNA1137393_P_NODE_11413_length_246_cov_2.507614_g10897_i0	PRJNA1137393	11413	246	2.507614	6.16873044	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.022	NTclustered	gi\|2913000417\|dbj\|AP039607.1\|	145626	g10897	i0	100	0.113821138211382	28	0	11	0	28	55	8953122	8953149	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
27659852	27659852	PRJNA1137393_P_NODE_9664_length_267_cov_0.798165_g9148_i0	PRJNA1137393	9664	267	0.798165	2.13110055	Mytilus	6548	Mollusca	Mollusca	43.1	0.0347	NR	XP_071177450.1	6550	g9148	i0	47.1	8.40449438202247	68	36	76.4	0	4	207	205	272	XP_071177450.1 uncharacterized protein [Mytilus edulis]	diamond	2244	43.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
28018066	28018066	PRJNA1137393_P_NODE_65485_length_163_cov_1.096491_g64969_i0	PRJNA1137393	65485	163	1.096491	1.78728033	Bulinus truncatus	55810	Mollusca	Mollusca	42	0.0234	NR	KAH9494694.1	55810	g64969	i0	54.8	0.570552147239264	31	14	57.1	0	25	117	127	157	KAH9494694.1 hypothetical protein Btru_020264 [Bulinus truncatus]	diamond	93	42	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Bulinus	Bulinus truncatus
31429165	31429165	PRJNA1137393_P_NODE_50496_length_167_cov_0.881356_g49980_i0	PRJNA1137393	50496	167	0.881356	1.47186452	Bradybaena similaris	145626	Mollusca	Mollusca	42.4	0.0182	NR	BFZ17186.1	145626	g49980	i0	43.6	0.988023952095808	55	30	98.8	1	165	1	253	306	BFZ17186.1 hypothetical protein BsWGS_20225 [Bradybaena similaris]	diamond	165	42.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris

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