metadata: contig_metadata: 8 rows where bioproject = "PRJNA801875", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA801875", tax_kingdom = "Metazoa" 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
4629501	4629501	PRJNA801875_P_NODE_2864_length_198_cov_1.871166_g2761_i0	PRJNA801875	2864	198	1.871166	3.70490868	Lottia gigantea	225164	Mollusca	Mollusca	176	9.76e-40	NTclustered	gi\|676441926\|ref\|XM_009051394.1\|	225164	g2761	i0	83.871	6.18181818181818	186	28	93	2	14	198	147	331	Lottia gigantea hypothetical protein mRNA	blastn	1224	176	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
22478141	22478141	PRJNA801875_P_NODE_58_length_1685_cov_3.041212_g33_i0	PRJNA801875	58	1685	3.041212	51.2444222	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	750	1.17e-265	NR	AQQ10869.1	69564	g33	i0	73.2	143.056379821958	541	132	96.3	3	1681	59	121	648	AQQ10869.1 78Kda glucose regulated protein, partial [Conus miles]	diamond	241050	756	0.992063492063492	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus miles
27220812	27220812	PRJNA801875_P_NODE_3322_length_181_cov_1.301370_g3219_i0	PRJNA801875	3322	181	1.30137	2.3554797	Mytilus	6548	Mollusca	Mollusca	51.2	1.54e-5	NR	XP_071137211.1	6550	g3219	i0	46.5	2.40331491712707	43	23	71.3	0	10	138	175	217	XP_071137211.1 IgGFc-binding protein-like [Mytilus edulis]	diamond	435	51.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
27780822	27780822	PRJNA801875_P_NODE_2784_length_202_cov_1.544910_g2681_i0	PRJNA801875	2784	202	1.54491	3.1207182	Acanthosepion pharaonis	158019	Mollusca	Mollusca	99	2.47e-22	NR	CAE1170747.1	158019	g2681	i0	65.2	2.94059405940594	66	23	98	0	199	2	185	250	CAE1170747.1 EIF4A [Acanthosepion pharaonis]	diamond	594	99	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Sepiida	Sepiidae	Acanthosepion	Acanthosepion pharaonis
28799721	28799721	PRJNA801875_P_NODE_3967_length_164_cov_2.945736_g3864_i0	PRJNA801875	3967	164	2.945736	4.83100704	Metazoa	33208	Mollusca	Mollusca	66.6	4.73e-11	NR	XP_071161064.1	6550	g3864	i0	100	19.0243902439024	32	0	58.5	0	98	3	345	376	XP_071161064.1 uncharacterized protein [Mytilus edulis]	diamond	3120	67	0.994029850746269	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
29170106	29170106	PRJNA801875_P_NODE_2109_length_245_cov_3.509524_g2006_i0	PRJNA801875	2109	245	3.509524	8.5983338	Littorina saxatilis	31220	Mollusca	Mollusca	77.4	7.32e-16	NR	XP_070189923.1	31220	g2006	i0	63.8	0.844897959183673	69	16	73.5	1	245	66	76	144	XP_070189923.1 eukaryotic translation initiation factor 1A, X-chromosomal-like [Littorina saxatilis]	diamond	207	77.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
29746885	29746885	PRJNA801875_P_NODE_1870_length_272_cov_1.497890_g1767_i0	PRJNA801875	1870	272	1.49789	4.0742608	Mytilus	6548	Mollusca	Mollusca	60.1	4.24e-8	NR	CAG2245161.1	6550	g1767	i0	60	2.20588235294118	50	19	54	1	149	3	149	198	CAG2245161.1 TXNRD [Mytilus edulis]	diamond	600	60.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
32425375	32425375	PRJNA801875_P_NODE_3479_length_176_cov_1.127660_g3376_i0	PRJNA801875	3479	176	1.12766	1.9846816	Mytilus coruscus	42192	Mollusca	Mollusca	51.6	7.76e-6	NR	CAC5416802.1	42192	g3376	i0	41.8	2.38636363636364	67	28	95.5	1	1	168	15	81	CAC5416802.1 RSPH1 [Mytilus coruscus]	diamond	420	51.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus coruscus

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