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

9 rows where analysis = "blastn", bioproject = "PRJEB3181" 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
6434363	6434363	PRJEB3181_S_NODE_7066_length_234_cov_5134.909548_g6773_i0	PRJEB3181	7066	234	5134.909548	12015.68834232	Aplysia californica	6500	Mollusca	Mollusca	97.1	9.55e-16	NTclustered	gi\|1897927524\|ref\|XM_005100004.3\|	6500	g6773	i0	86.364	5.19230769230769	88	12	38	0	147	234	1072	985	PREDICTED: Aplysia californica cathepsin B-like cysteine proteinase 3 (LOC101847348), transcript variant X2, mRNA	blastn	1215	97.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
7366403	7366403	PRJEB3181_P_NODE_18246_length_194_cov_1.073620_g17982_i0	PRJEB3181	18246	194	1.07362	2.0828228	Opisthokonta	33154	Mollusca	Mollusca	99	2.12e-16	NTclustered	gi\|1207979968\|ref\|XM_021483826.1\|	6573	g17982	i0	80.8	17.6030927835052	125	24	64	0	65	189	449	325	PREDICTED: Mizuhopecten yessoensis 40S ribosomal protein S18-like (LOC110440666), partial mRNA	blastn	3415	99	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
12809496	12809496	PRJEB3181_P_NODE_24211_length_164_cov_2.233083_g23946_i0	PRJEB3181	24211	164	2.233083	3.66225612	Physella acuta	109671	Mollusca	Mollusca	220	3.55e-53	NTclustered	gi\|2572452079\|ref\|XR_009385380.1\|	109671	g23946	i0	99.18	2.14024390243902	122	1	74	0	43	164	3769	3648	PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA	blastn	351	220	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
17907626	17907626	PRJEB3181_P_NODE_6575_length_324_cov_3.197952_g6316_i0	PRJEB3181	6575	324	3.197952	10.36136448	Lottia gigantea	225164	Mollusca	Mollusca	195	4.78e-45	NTclustered	gi\|676456588\|ref\|XM_009056125.1\|	225164	g6316	i0	83.099	3.01851851851852	213	36	66	0	107	319	386	174	Lottia gigantea hypothetical protein mRNA	blastn	978	195	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
17907785	17907785	PRJEB3181_S_NODE_7135_length_233_cov_123.898990_g6842_i0	PRJEB3181	7135	233	123.89899	288.6846467	Argopecten irradians	31199	Mollusca	Mollusca	134	7.240000000000001e-27	NTclustered	gi\|2835350600\|ref\|XM_069247595.1\|	31199	g6842	i0	93.333	39.6609442060086	90	6	39	0	1	90	1353	1442	PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA	blastn	9241	134	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
17907790	17907790	PRJEB3181_S_NODE_7695_length_226_cov_2.272251_g7402_i0	PRJEB3181	7695	226	2.272251	5.13528726	Aplysia californica	6500	Mollusca	Mollusca	91.6	4.26e-14	NTclustered	gi\|1897914721\|ref\|XM_013091444.2\|	6500	g7402	i0	86.905	6.9646017699115	84	8	37	1	143	226	1487	1407	PREDICTED: Aplysia californica tubulin alpha-1A chain (LOC101845985), mRNA	blastn	1574	91.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
20456942	20456942	PRJEB3181_S_NODE_6517_length_243_cov_3.961538_g6224_i0	PRJEB3181	6517	243	3.961538	9.62653734	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.022	NTclustered	gi\|2913000417\|dbj\|AP039607.1\|	145626	g6224	i0	100	0.11522633744856	28	0	12	0	128	155	8953149	8953122	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
21390954	21390954	PRJEB3181_P_NODE_27357_length_153_cov_1.360656_g27092_i0	PRJEB3181	27357	153	1.360656	2.08180368	Metazoa	33208	Mollusca	Mollusca	52.8	0.013	NTclustered	gi\|2912987826\|dbj\|AP039592.1\|	145626	g27092	i0	96.774	1.11764705882353	31	1	20	0	4	34	47599792	47599822	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence	blastn	171	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
23007923	23007923	PRJEB3181_P_NODE_10939_length_257_cov_2.977876_g10675_i0	PRJEB3181	10939	257	2.977876	7.65314132	Littorina saxatilis	31220	Mollusca	Mollusca	291	4.55e-74	NTclustered	gi\|2868609750\|ref\|XM_070343994.1\|	31220	g10675	i0	91.469	87.7548638132296	211	18	82	0	46	256	1417	1207	PREDICTED: Littorina saxatilis tubulin beta-4B chain-like (LOC138971279), mRNA	blastn	22553	291	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis

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