metadata: contig_metadata: 7 rows where bioproject = "PRJNA773247", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA773247", 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
1206922	1206922	PRJNA773247_P_NODE_13661_length_407_cov_6.188623_g13577_i0	PRJNA773247	13661	407	6.188623	25.18769561	Opisthokonta	33154	Mollusca	Mollusca	619	8.539999999999999e-173	NTclustered	gi\|325297131\|ref\|NM_001204646.1\|	6500	g13577	i0	95.373	225.385749385749	389	18	100	0	19	407	1	389	Aplysia californica polyubiquitin-C (LOC101860494), mRNA	blastn	91732	621	0.996779388083736	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
10952869	10952869	PRJNA773247_P_NODE_17309_length_350_cov_23.747292_g17225_i0	PRJNA773247	17309	350	23.747292	83.115522	Bradybaena similaris	145626	Mollusca	Mollusca	54.7	0.009	NTclustered	gi\|2912999222\|dbj\|AP039605.1\|	145626	g17225	i0	96.875	0.17142857142857101	32	1	9	0	128	159	12369320	12369351	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence	blastn	60	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
27464282	27464282	PRJNA773247_P_NODE_29203_length_256_cov_1.896175_g29119_i0	PRJNA773247	29203	256	1.896175	4.854208	Magallana angulata	2784310	Mollusca	Mollusca	44.3	0.0125	NR	XP_052719870.1	2784310	g29119	i0	42.3	0.609375	52	28	60.9	1	249	94	88	137	XP_052719870.1 mucin-3A-like [Magallana angulata]	diamond	156	44.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana angulata
28221756	28221756	PRJNA773247_P_NODE_9566_length_512_cov_26.334852_g9483_i0	PRJNA773247	9566	512	26.334852	134.83444224	Biomphalaria pfeifferi	112525	Mollusca	Mollusca	97.1	7.51e-20	NR	KAK0039444.1	112525	g9483	i0	37	0.966796875	165	98	94.9	3	502	17	415	576	KAK0039444.1 DNA helicase [Biomphalaria pfeifferi]	diamond	495	97.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria pfeifferi
28443074	28443074	PRJNA773247_P_NODE_18406_length_337_cov_20.515152_g18322_i0	PRJNA773247	18406	337	20.515152	69.13606224	Mya arenaria	6604	Mollusca	Mollusca	47.8	3.38e-4	NR	XP_052814943.1	6604	g18322	i0	67.6	0.302670623145401	34	10	30.3	1	234	335	65	97	XP_052814943.1 uncharacterized protein LOC128241871 [Mya arenaria]	diamond	102	47.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
29547818	29547818	PRJNA773247_P_NODE_23050_length_294_cov_2.443439_g22966_i0	PRJNA773247	23050	294	2.443439	7.18371066	Physella acuta	109671	Mollusca	Mollusca	45.1	0.0112	NR	XP_059150027.1	109671	g22966	i0	46.3	0.551020408163265	54	28	54.1	1	70	228	1003	1056	XP_059150027.1 protein scribble homolog isoform X11 [Physella acuta]	diamond	162	45.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
30369739	30369739	PRJNA773247_P_NODE_18792_length_333_cov_11.076923_g18708_i0	PRJNA773247	18792	333	11.076923	36.88615359	Haliotis rufescens	6454	Mollusca	Mollusca	50.8	1.41e-4	NR	XP_046357693.2	6454	g18708	i0	46.6	0.657657657657658	73	28	65.8	3	315	97	143	204	XP_046357693.2 glycogenin-1-like [Haliotis rufescens]	diamond	219	50.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens

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