metadata: contig_metadata: 11 rows where bioproject = "PRJNA1044115" and tax

11 rows where bioproject = "PRJNA1044115" 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
5273998	5273998	PRJNA1044115_P_NODE_12085_length_428_cov_16.461972_g11901_i0	PRJNA1044115	12085	428	16.461972	70.45724016	Mollusca	6447	Mollusca	Mollusca	211	1.21e-66	NR	XP_005109406.2	6500	g11901	i0	94.6	4.50700934579439	130	7	91.1	0	3	392	98	227	XP_005109406.2 ubiquitin-40S ribosomal protein S27a [Aplysia californica]	diamond	1929	211	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
6111963	6111963	PRJNA1044115_P_NODE_40085_length_244_cov_1.415205_g39901_i0	PRJNA1044115	40085	244	1.415205	3.4531002	Metazoa	33208	Mollusca	Mollusca	451	1.86e-122	NTclustered	gi\|1928112764\|gb\|MT947788.1\|	6523	g39901	i0	100	99.8852459016394	244	0	100	0	1	244	878	1121	Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds	blastn	24372	451	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
7386597	7386597	PRJNA1044115_P_NODE_42486_length_238_cov_2.072727_g42302_i0	PRJNA1044115	42486	238	2.072727	4.93309026	Metazoa	33208	Mollusca	Mollusca	440	3.899999999999999e-119	NTclustered	gi\|1928112764\|gb\|MT947788.1\|	6523	g42302	i0	100	99.9495798319328	238	0	100	0	1	238	1156	1393	Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds	blastn	23788	440	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
11650176	11650176	PRJNA1044115_P_NODE_44150_length_202_cov_4.116279_g43966_i0	PRJNA1044115	44150	202	4.116279	8.31488358	Galeommatoidea sp. MN19374	1873786	Mollusca	Mollusca	159	1.01e-34	NTclustered	gi\|1050775354\|gb\|KX375938.1\|	1873786	g43966	i0	81.675	87.4158415841584	191	35	95	0	2	192	35	225	Galeommatoidea sp. MN19374 histone H3 (H3) gene, partial cds	blastn	17658	159	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Galeommatida			Galeommatoidea sp. MN19374
15474390	15474390	PRJNA1044115_P_NODE_35613_length_251_cov_0.876404_g35429_i0	PRJNA1044115	35613	251	0.876404	2.19977404	Bradybaena similaris	145626	Mollusca	Mollusca	58.4	4.89e-4	NTclustered	gi\|2913001816\|dbj\|AP039609.1\|	145626	g35429	i0	89.13	0.183266932270916	46	5	18	0	141	186	47058311	47058356	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence	blastn	46	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
23123608	23123608	PRJNA1044115_P_NODE_23159_length_302_cov_1.838428_g22975_i0	PRJNA1044115	23159	302	1.838428	5.55205256	Patella vulgata	6465	Mollusca	Mollusca	239	2.01e-58	NTclustered	gi\|2506342283\|ref\|XM_050559823.2\|	6465	g22975	i0	81.145	11.4205298013245	297	56	98	0	1	297	686	982	PREDICTED: Patella vulgata rRNA 2'-O-methyltransferase fibrillarin (LOC126829721), mRNA	blastn	3449	239	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
27153157	27153157	PRJNA1044115_P_NODE_24942_length_291_cov_2.522936_g24758_i0	PRJNA1044115	24942	291	2.522936	7.34174376	Metazoa	33208	Mollusca	Mollusca	124	8.88e-31	NR	KAK3106661.1	66713	g24758	i0	54.2	5.93814432989691	96	44	99	0	3	290	285	380	KAK3106661.1 hypothetical protein FSP39_024761 [Pinctada imbricata]	diamond	1728	125	0.992	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pteriidae	Pinctada	Pinctada imbricata
29277174	29277174	PRJNA1044115_P_NODE_33569_length_254_cov_1.701657_g33385_i0	PRJNA1044115	33569	254	1.701657	4.32220878	Crassostrea virginica	6565	Mollusca	Mollusca	131	3.2100000000000004e-33	NR	XP_022342755.1	6565	g33385	i0	71.4	0.992125984251969	84	24	99.2	0	2	253	64	147	XP_022342755.1 major vault protein-like [Crassostrea virginica]	diamond	252	131	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
30375197	30375197	PRJNA1044115_P_NODE_22412_length_307_cov_1.632479_g22228_i0	PRJNA1044115	22412	307	1.632479	5.01171053	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	78.2	1.18e-14	NR	XP_059142437.1	109671	g22228	i0	57.8	5.1498371335504904	64	27	62.5	0	51	242	1	64	XP_059142437.1 craniofacial development protein 2-like [Physella acuta]	diamond	1581	78.6	0.994910941475827	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
31765486	31765486	PRJNA1044115_P_NODE_43197_length_231_cov_2.417722_g43013_i0	PRJNA1044115	43197	231	2.417722	5.58493782	Mollusca	6447	Mollusca	Mollusca	93.6	3.27e-21	NR	XP_046371700.1	6454	g43013	i0	57.1	13.6883116883117	77	30	98.7	2	2	229	123	197	XP_046371700.1 transcriptional activator protein Pur-alpha-like isoform X4 [Haliotis rufescens]	diamond	3162	93.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
31836654	31836654	PRJNA1044115_P_NODE_16477_length_361_cov_1.128472_g16293_i0	PRJNA1044115	16477	361	1.128472	4.07378392	Mytilus edulis	6550	Mollusca	Mollusca	45.8	0.00593	NR	CAG2248249.1	6550	g16293	i0	62.5	0.265927977839335	32	12	26.6	0	319	224	139	170	CAG2248249.1 E3.1.3.1 [Mytilus edulis]	diamond	96	45.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis

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