metadata: contig_metadata: 9 rows where bioproject = "PRJEB75227" and tax

9 rows where bioproject = "PRJEB75227" 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
9062927	9062927	PRJEB75227_P_NODE_3348_length_397_cov_0.962963_g3177_i0	PRJEB75227	3348	397	0.962963	3.82296311	Metazoa	33208	Mollusca	Mollusca	266	6.979999999999999e-87	NR	XP_013070859.1	6526	g3177	i0	98.5	30.6952141057935	131	2	99	0	3	395	160	290	XP_013070859.1 casein kinase I isoform X2 [Biomphalaria glabrata]	diamond	12186	268	0.992537313432836	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
10338654	10338654	PRJEB75227_P_NODE_10069_length_247_cov_0.896552_g9898_i0	PRJEB75227	10069	247	0.896552	2.21448344	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.022	NTclustered	gi\|2912981848\|dbj\|AP039587.1\|	145626	g9898	i0	96.774	0.125506072874494	31	1	13	0	182	212	52161435	52161405	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
10338696	10338696	PRJEB75227_P_NODE_5409_length_300_cov_1.581498_g5238_i0	PRJEB75227	5409	300	1.581498	4.744494	Solemya velum	13268	Mollusca	Mollusca	112	1.86e-28	NR	KAL5007910.1	13268	g5238	i0	58.2	0.98	98	40	98	1	5	298	61	157	KAL5007910.1 hypothetical protein ScPMuIL_016716 [Solemya velum]	diamond	294	112	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Solemyida	Solemyidae	Solemya	Solemya velum
11614136	11614136	PRJEB75227_P_NODE_3430_length_391_cov_0.981132_g3259_i0	PRJEB75227	3430	391	0.981132	3.83622612	Lottia gigantea	225164	Mollusca	Mollusca	294	5.63e-75	NTclustered	gi\|676430959\|ref\|XM_009047849.1\|	225164	g3259	i0	81.564	2.54987212276215	358	65	92	1	34	391	3513	3157	Lottia gigantea hypothetical protein mRNA	blastn	997	294	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
15438092	15438092	PRJEB75227_P_NODE_1653_length_611_cov_1.301115_g1482_i0	PRJEB75227	1653	611	1.301115	7.94981265	Mytilus edulis	6550	Mollusca	Mollusca	313	2.52e-80	NTclustered	gi\|2912324166\|ref\|XM_071283382.1\|	6550	g1482	i0	77.117	23.9590834697218	555	117	90	9	1	550	579	1128	PREDICTED: Mytilus edulis calreticulin-like (LOC139495180), mRNA	blastn	14639	313	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
23087458	23087458	PRJEB75227_P_NODE_5439_length_299_cov_1.690265_g5268_i0	PRJEB75227	5439	299	1.690265	5.05389235	Bradybaena similaris	145626	Mollusca	Mollusca	56.5	0.002	NTclustered	gi\|2912983111\|dbj\|AP039588.1\|	145626	g5268	i0	94.595	0.79933110367893	37	0	12	2	176	211	8646731	8646696	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence	blastn	239	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
27571286	27571286	PRJEB75227_P_NODE_3084_length_418_cov_1.055072_g2913_i0	PRJEB75227	3084	418	1.055072	4.41020096	Pomacea canaliculata	400727	Mollusca	Mollusca	154	2.71e-41	NR	XP_025106922.1	400727	g2913	i0	53.2	3	139	65	99.8	0	417	1	159	297	XP_025106922.1 autocrine proliferation repressor protein A-like isoform X1 [Pomacea canaliculata]	diamond	1254	154	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
27792454	27792454	PRJEB75227_P_NODE_8904_length_251_cov_0.876404_g8733_i0	PRJEB75227	8904	251	0.876404	2.19977404	Mytilus coruscus	42192	Mollusca	Mollusca	65.5	4.12e-10	NR	CAC5360435.1	42192	g8733	i0	50	1.86454183266932	78	36	92	2	231	1	7	82	CAC5360435.1 E7.6.2.1 [Mytilus coruscus]	diamond	468	65.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus coruscus
32595158	32595158	PRJEB75227_P_NODE_8780_length_251_cov_0.876404_g8609_i0	PRJEB75227	8780	251	0.876404	2.19977404	Patella vulgata	6465	Mollusca	Mollusca	83.2	2.48e-16	NR	XP_055956246.1	6465	g8609	i0	46.3	3.9800796812749	82	42	98	2	5	250	4454	4533	XP_055956246.1 uncharacterized protein LOC126819809 [Patella vulgata]	diamond	999	83.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata

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