metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA438572" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA438572" 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
6812656	6812656	PRJNA438572_P_NODE_12826_length_289_cov_0.722222_g12707_i0	PRJNA438572	12826	289	0.722222	2.08722158	Littorina saxatilis	31220	Mollusca	Mollusca	163	1.18e-35	NTclustered	gi\|2868614015\|ref\|XM_070321681.1\|	31220	g12707	i0	85	15.4325259515571	160	24	55	0	30	189	583	424	PREDICTED: Littorina saxatilis eukaryotic translation elongation factor 2-like (LOC138949893), mRNA	blastn	4460	163	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
9363020	9363020	PRJNA438572_P_NODE_20128_length_248_cov_0.891429_g20009_i0	PRJNA438572	20128	248	0.891429	2.21074392	Ruditapes philippinarum	129788	Mollusca	Mollusca	104	6.11e-18	NTclustered	gi\|2616472270\|ref\|XM_060700849.1\|	129788	g20009	i0	81.6	0.504032258064516	125	23	50	0	4	128	574	698	PREDICTED: Ruditapes philippinarum zinc finger C4H2 domain-containing protein-like (LOC132717390), mRNA	blastn	125	104	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
14463917	14463917	PRJNA438572_P_NODE_9872_length_326_cov_1.233202_g9753_i0	PRJNA438572	9872	326	1.233202	4.02023852	Bradybaena similaris	145626	Mollusca	Mollusca	58.4	6.59e-4	NTclustered	gi\|2913001038\|dbj\|AP039608.1\|	145626	g9753	i0	97.059	2	34	1	10	0	53	86	46500196	46500163	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence	blastn	652	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
15737534	15737534	PRJNA438572_P_NODE_12713_length_290_cov_0.953917_g12594_i0	PRJNA438572	12713	290	0.953917	2.7663593	Physella acuta	109671	Mollusca	Mollusca	296	1.12e-75	NTclustered	gi\|2572364099\|ref\|XR_009387799.1\|	109671	g12594	i0	86.617	42.3620689655172	269	34	92	2	18	285	459	192	PREDICTED: Physella acuta uncharacterized LOC131946826 (LOC131946826), ncRNA	blastn	12285	296	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
19560952	19560952	PRJNA438572_P_NODE_20876_length_247_cov_0.896552_g20757_i0	PRJNA438572	20876	247	0.896552	2.21448344	Mytilus edulis	6550	Mollusca	Mollusca	54.7	0.006	NTclustered	gi\|2912429871\|ref\|XM_071265749.1\|	6550	g20757	i0	96.97	0.267206477732794	33	0	13	1	179	210	784	816	PREDICTED: Mytilus edulis U5 small nuclear ribonucleoprotein TSSC4-like (LOC139482091), transcript variant X1, mRNA	blastn	66	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
20217193	20217193	PRJNA438572_P_NODE_15636_length_263_cov_1.410526_g15517_i0	PRJNA438572	15636	263	1.410526	3.70968338	Opisthokonta	33154	Mollusca	Mollusca	54.7	0.007	NTclustered	gi\|2912981848\|dbj\|AP039587.1\|	145626	g15517	i0	100	1.08745247148289	29	0	11	0	61	89	46041731	46041703	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence	blastn	286	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
20836486	20836486	PRJNA438572_P_NODE_12697_length_290_cov_1.078341_g12578_i0	PRJNA438572	12697	290	1.078341	3.1271889	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.027	NTclustered	gi\|2912985489\|dbj\|AP039590.1\|	145626	g12578	i0	100	0.096551724137931	28	0	10	0	159	186	52186000	52185973	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
23387265	23387265	PRJNA438572_P_NODE_23339_length_243_cov_1.294118_g23220_i0	PRJNA438572	23339	243	1.294118	3.14470674	Austrofusus glans	619957	Mollusca	Mollusca	97.1	9.98e-16	NTclustered	gi\|1577001636\|gb\|MK543277.1\|	619957	g23220	i0	87.059	0.349794238683128	85	11	35	0	1	85	2755	2839	Austrofusus glans voucher SFKH-TMP014 large subunit ribosomal RNA gene, partial sequence	blastn	85	97.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Buccinidae	Austrofusus	Austrofusus glans
25317316	25317316	PRJNA438572_P_NODE_9160_length_337_cov_1.106061_g9041_i0	PRJNA438572	9160	337	1.106061	3.72742557	Mytilus	6548	Mollusca	Mollusca	100	1.12e-16	NTclustered	gi\|2912398368\|ref\|XM_071311913.1\|	6550	g9041	i0	86.667	0.534124629080119	90	12	27	0	19	108	447	536	PREDICTED: Mytilus edulis small ribosomal subunit protein eS6-like (LOC139519695), mRNA	blastn	180	100	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);;