metadata: contig_metadata: 7 rows where bioproject = "PRJNA999747" and tax

7 rows where bioproject = "PRJNA999747" 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
2549869	2549869	PRJNA999747_S_NODE_242_length_484_cov_3.269316_g215_i0	PRJNA999747	242	484	3.269316	15.82348944	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	69.4	4.68e-7	NTclustered	gi\|2506304296\|ref\|XR_008789413.1\|	6465	g215	i0	81.609	3.08677685950413	87	12	18	2	63	147	1715	1799	PREDICTED: Patella vulgata large subunit ribosomal RNA (LOC130014397), rRNA	blastn	1494	69.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
5102392	5102392	PRJNA999747_S_NODE_844_length_312_cov_7.288256_g812_i0	PRJNA999747	844	312	7.288256	22.73935872	Metazoa	33208	Mollusca	Mollusca	237	7.5e-58	NTclustered	gi\|18565103\|dbj\|AB071191.1\|	29159	g812	i0	82.955	66.4487179487179	264	43	84	2	50	312	34	296	Crassostrea gigas actin 2 mRNA for Actin 2, complete cds	blastn	20732	237	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
6083775	6083775	PRJNA999747_S_NODE_2725_length_188_cov_3.159236_g2693_i0	PRJNA999747	2725	188	3.159236	5.93936368	Patella vulgata	6465	Mollusca	Mollusca	174	3.3e-39	NTclustered	gi\|2506322169\|ref\|XM_050547105.2\|	6465	g2693	i0	83.871	27.2127659574468	186	26	98	4	5	188	787	970	PREDICTED: Patella vulgata transitional endoplasmic reticulum ATPase (LOC126819200), mRNA	blastn	5116	174	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
16576815	16576815	PRJNA999747_S_NODE_3113_length_177_cov_3.041096_g3081_i0	PRJNA999747	3113	177	3.041096	5.38273992	Metazoa	33208	Mollusca	Mollusca	100	3.8299999999999997e-23	NR	KAK3088013.1	66713	g3081	i0	82.5	25.1525423728814	57	10	96.6	0	2	172	193	249	KAK3088013.1 hypothetical protein FSP39_013455 [Pinctada imbricata]	diamond	4452	101	0.99009900990099	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pteriidae	Pinctada	Pinctada imbricata
29016398	29016398	PRJNA999747_S_NODE_3968_length_159_cov_1.671875_g3936_i0	PRJNA999747	3968	159	1.671875	2.65828125	Liolophura japonica	13599	Mollusca	Mollusca	89.7	2.23e-19	NR	XP_064595148.1	13599	g3936	i0	78.8	3.77358490566038	52	11	98.1	0	4	159	181	232	XP_064595148.1 S-adenosylmethionine synthase-like [Liolophura japonica]	diamond	600	89.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Chitonida	Chitonidae	Liolophura	Liolophura japonica
29426333	29426333	PRJNA999747_S_NODE_1049_length_287_cov_144.437500_g1017_i0	PRJNA999747	1049	287	144.4375	414.535625	Potamilus streckersoni	2493646	Mollusca	Mollusca	43.5	0.00772	NR	KAK3580123.1	2493646	g1017	i0	45.5	0.888501742160279	44	24	46	0	248	117	4	47	KAK3580123.1 hypothetical protein CHS0354_034063 [Potamilus streckersoni]	diamond	255	43.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Unionida	Unionidae	Potamilus	Potamilus streckersoni
30000944	30000944	PRJNA999747_S_NODE_3591_length_166_cov_2.185185_g3559_i0	PRJNA999747	3591	166	2.185185	3.6274071	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	81.6	2.55e-16	NR	KAK3762911.1	231223	g3559	i0	75.9	15.6686746987952	54	13	97.6	0	162	1	241	294	KAK3762911.1 hypothetical protein RRG08_008129 [Elysia crispata]	diamond	2601	82.4	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia crispata

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