metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA382558" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA382558" 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
1679815	1679815	PRJNA382558_S_NODE_6922_length_193_cov_3.250000_g6918_i0	PRJNA382558	6922	193	3.25	6.2725	Conus geographus	6491	Mollusca	Mollusca	344	2.45e-90	NTclustered	gi\|610518277\|dbj\|AB910766.1\|	6491	g6918	i0	98.958	2.32124352331606	192	2	99	0	2	193	298	107	Conus geographus mRNA for G001_VD_Con-ikot-ikot_precursor_conopeptide, complete cds	blastn	448	344	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus geographus
2955525	2955525	PRJNA382558_S_NODE_163_length_482_cov_13.973034_g159_i0	PRJNA382558	163	482	13.973034	67.35002388	Conus consors	101297	Mollusca	Mollusca	588	2.89e-163	NTclustered	gi\|528524678\|emb\|HE856376.1\|	101297	g159	i0	88.798	39.6763485477178	491	40	99	13	3	482	503	17	Conus consors mRNA for M superfamily CnIIIC precursor, biomaterial CH070619AA-AC	blastn	19124	588	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus consors
6782475	6782475	PRJNA382558_S_NODE_11286_length_167_cov_2.661538_g11282_i0	PRJNA382558	11286	167	2.661538	4.44476846	Conus striatus	6493	Mollusca	Mollusca	230	6.029999999999999e-56	NTclustered	gi\|28864634\|gb\|AY207469.1\|	6493	g11282	i0	91.566	7.68263473053892	166	14	99	0	2	167	795	630	Conus striatus mu conotoxin SIIIA precursor, mRNA, complete cds	blastn	1283	230	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus striatus
8058180	8058180	PRJNA382558_S_NODE_2987_length_243_cov_6.004854_g2983_i0	PRJNA382558	2987	243	6.004854	14.59179522	Conus geographus	6491	Mollusca	Mollusca	84.2	7.77e-12	NTclustered	gi\|610518165\|dbj\|AB910790.1\|	6491	g2983	i0	97.917	0.580246913580247	48	1	20	0	196	243	399	352	Conus geographus mRNA for G025_VD_Conantokin_precursor_conopeptide, complete cds	blastn	141	84.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus geographus
10608621	10608621	PRJNA382558_S_NODE_129_length_512_cov_12.993684_g8_i1	PRJNA382558	129	512	12.993684	66.52766208	Conus consors	101297	Mollusca	Mollusca	623	8.469999999999998e-174	NTclustered	gi\|528524662\|emb\|HE856368.1\|	101297	g8	i1	92.117	41.814453125	444	32	86	3	1	442	30	472	Conus consors mRNA for A superfamily CnID precursor, biomaterial CH070619AA-AC	blastn	21409	623	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus consors
10608862	10608862	PRJNA382558_S_NODE_9_length_1102_cov_17.381221_g8_i0	PRJNA382558	9	1102	17.381221	191.54105542	Conus consors	101297	Mollusca	Mollusca	1210	0	NTclustered	gi\|528524662\|emb\|HE856368.1\|	101297	g8	i0	88.538	28.1950998185118	1012	99	91	12	100	1102	1033	30	Conus consors mRNA for A superfamily CnID precursor, biomaterial CH070619AA-AC	blastn	31071	1210	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus consors
13158509	13158509	PRJNA382558_S_NODE_111_length_531_cov_4.163968_g108_i0	PRJNA382558	111	531	4.163968	22.11067008	Conus geographus	6491	Mollusca	Mollusca	809	0	NTclustered	gi\|610520096\|dbj\|AB910829.1\|	6491	g108	i0	99.111	26.5574387947269	450	4	85	0	76	525	450	1	Conus geographus mRNA for G064_VD_Superfamily_B_precursor_conopepti de, complete cds	blastn	14102	809	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus geographus
14433539	14433539	PRJNA382558_S_NODE_112_length_530_cov_13.277890_g109_i0	PRJNA382558	112	530	13.27789	70.372817	Conus geographus	6491	Mollusca	Mollusca	726	0	NTclustered	gi\|610518216\|dbj\|AB910781.1\|	6491	g109	i0	99.748	51.4547169811321	397	0	75	1	134	530	1	396	Conus geographus mRNA for G016_VD_Conantokin_precursor_conopeptide, complete cds	blastn	27271	726	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus geographus
15103522	15103522	PRJNA382558_S_NODE_2052_length_268_cov_2.012987_g2048_i0	PRJNA382558	2052	268	2.012987	5.39480516	Conus	6490	Mollusca	Mollusca	339	1.6799999999999998e-88	NTclustered	gi\|326422321\|gb\|JF322921.1\|	42752	g2048	i0	89.85	6.5	266	24	98	1	1	263	385	650	Conus marmoreus conotoxin Mr1.7 mRNA, complete cds	blastn	1742	342	0.991228070175439	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus marmoreus
16982229	16982229	PRJNA382558_S_NODE_15114_length_153_cov_1.215517_g15110_i0	PRJNA382558	15114	153	1.215517	1.85974101	Conus consors	101297	Mollusca	Mollusca	222	9.029999999999999e-54	NTclustered	gi\|528524702\|emb\|HE856388.1\|	101297	g15110	i0	92.81	1	153	11	100	0	1	153	1140	1292	Conus consors mRNA for conoporin superfamily Cn1 precursor, biomaterial CH070619AA-AC	blastn	153	222	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus consors
16982254	16982254	PRJNA382558_S_NODE_214_length_453_cov_11.057692_g210_i0	PRJNA382558	214	453	11.057692	50.09134476	Conus geographus	6491	Mollusca	Mollusca	536	9.939999999999996e-148	NTclustered	gi\|156520\|gb\|M84612.1\|CGECONOTOX	6491	g210	i0	93.369	45.6710816777042	377	2	83	6	7	382	355	1	Conus geographus omega-conotoxin precursor GVIA mRNA, complete cds	blastn	20689	536	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus geographus
18927163	18927163	PRJNA382558_S_NODE_10035_length_173_cov_3.102941_g10031_i0	PRJNA382558	10035	173	3.102941	5.36808793	Conus	6490	Mollusca	Mollusca	171	3.85e-38	NTclustered	gi\|452891155\|gb\|JX000432.1\|	89427	g10031	i0	92	8.46820809248555	125	4	69	3	1	119	378	254	Conus virgo conotoxin Vi6.9 mRNA, complete cds	blastn	1465	171	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus virgo
19530841	19530841	PRJNA382558_S_NODE_736_length_342_cov_2.131148_g732_i0	PRJNA382558	736	342	2.131148	7.28852616	Conus geographus	6491	Mollusca	Mollusca	294	4.87e-75	NTclustered	gi\|610520023\|dbj\|AB910813.1\|	6491	g732	i0	99.383	32.6929824561403	162	1	47	0	1	162	162	1	Conus geographus mRNA for G048_VD_Superfamily_A_precursor_conopepti de, complete cds	blastn	11181	294	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus geographus
20806472	20806472	PRJNA382558_S_NODE_2137_length_265_cov_4.986842_g2133_i0	PRJNA382558	2137	265	4.986842	13.2151313	Conus geographus	6491	Mollusca	Mollusca	326	1.29e-84	NTclustered	gi\|610520402\|dbj\|AB910891.1\|	6491	g2133	i0	98.901	1.37358490566038	182	2	69	0	84	265	309	128	Conus geographus mRNA for G126_VD_New_Superfamily-3_precursor_conopeptide, complete cds	blastn	364	326	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus geographus
22081490	22081490	PRJNA382558_S_NODE_9098_length_178_cov_1.865248_g9094_i0	PRJNA382558	9098	178	1.865248	3.32014144	Conus geographus	6491	Mollusca	Mollusca	152	1.4399999999999999e-32	NTclustered	gi\|610518277\|dbj\|AB910766.1\|	6491	g9094	i0	98.824	0.955056179775281	85	1	48	0	3	87	261	345	Conus geographus mRNA for G001_VD_Con-ikot-ikot_precursor_conopeptide, complete cds	blastn	170	152	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus geographus
23357000	23357000	PRJNA382558_S_NODE_39_length_683_cov_3.976780_g37_i0	PRJNA382558	39	683	3.97678	27.1614074	Conus geographus	6491	Mollusca	Mollusca	411	9.76e-110	NTclustered	gi\|610520369\|dbj\|AB910884.1\|	6491	g37	i0	97.5	4.10688140556369	240	6	35	0	304	543	240	1	Conus geographus mRNA for G119_VD_New_Superfamily-1_precursor_conopeptide, complete cds	blastn	2805	411	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus geographus
23357101	23357101	PRJNA382558_S_NODE_8619_length_181_cov_1.375000_g8615_i0	PRJNA382558	8619	181	1.375	2.48875	Conus arenatus	89451	Mollusca	Mollusca	219	1.4299999999999996e-52	NTclustered	gi\|12619676\|gb\|AF215072.1\|AF215072	89451	g8615	i0	94.366	11.6629834254144	142	8	78	0	1	142	458	317	Conus arenatus clone ArMSGL-011 conotoxin scaffold VI/VII precursor, mRNA, complete cds	blastn	2111	219	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Conidae	Conus	Conus arenatus

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