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

30 rows where analysis = "blastn", bioproject = "PRJNA382558" and tax_kingdom = "Metazoa"

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
3626439	3626439	PRJNA382558_S_NODE_2263_length_261_cov_6.508929_g2259_i0	PRJNA382558	2263	261	6.508929	16.98830469	Mus	10088	Chordata	Chordata	477	3.3099999999999986e-130	NTclustered	gi\|846387786\|dbj\|LC061991.1\|	10090	g2259	i0	99.617	100	261	1	100	0	1	261	1008	748	Mus musculus mitochondrion DNA, including ATP6, COX3, tRNA-Gly, ND3, tRNA-Arg, ND4L, ND4 genes, complete sequence, sequence_id: (8070..10988)_18	blastn	26100	477	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
4903658	4903658	PRJNA382558_S_NODE_11844_length_164_cov_6.291339_g11840_i0	PRJNA382558	11844	164	6.291339	10.31779596	Mus	10088	Chordata	Chordata	303	3.42e-78	NTclustered	gi\|846387586\|dbj\|LC061956.1\|	10090	g11840	i0	100	100	164	0	100	0	1	164	1	164	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_5	blastn	16400	303	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
6178694	6178694	PRJNA382558_S_NODE_2205_length_262_cov_10.280000_g2201_i0	PRJNA382558	2205	262	10.28	26.9336	Mus	10088	Chordata	Chordata	484	1.99e-132	NTclustered	gi\|846387586\|dbj\|LC061956.1\|	10090	g2201	i0	100	100	262	0	100	0	1	262	2347	2608	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_5	blastn	26200	484	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
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
10003841	10003841	PRJNA382558_S_NODE_5428_length_206_cov_16.390533_g5424_i0	PRJNA382558	5428	206	16.390533	33.76449798	Metazoa	33208	Chordata	Chordata	381	2.0199999999999994e-101	NTclustered	gi\|846387586\|dbj\|LC061956.1\|	10090	g5424	i0	100	100	206	0	100	0	1	206	1531	1736	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_5	blastn	20600	381	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
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
12554343	12554343	PRJNA382558_S_NODE_6530_length_196_cov_5.880503_g6526_i0	PRJNA382558	6530	196	5.880503	11.52578588	Lampetra	13103	Chordata	Chordata	63.9	7.83e-6	NTclustered	gi\|2805736014\|emb\|OZ078436.1\|	7748	g6526	i0	97.297	5.79591836734694	37	1	19	0	3	39	3422681	3422717	Lampetra fluviatilis genome assembly, chromosome: 33	blastn	1136	63.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
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
13829170	13829170	PRJNA382558_S_NODE_12791_length_160_cov_7.658537_g12787_i0	PRJNA382558	12791	160	7.658537	12.2536592	Timema	61471	Arthropoda	Arthropoda	54.7	0.004	NTclustered	gi\|1962654685\|emb\|OE179204.1\|	61474	g12787	i0	96.875	0.8	32	1	20	0	48	79	343434	343465	2_Tcm_b3v08	blastn	128	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema californicum
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
16378216	16378216	PRJNA382558_S_NODE_5833_length_202_cov_10.884848_g5829_i0	PRJNA382558	5833	202	10.884848	21.98739296	root	1	Root_unresolved	Root_unresolved	278	2.67e-70	NTclustered	gi\|354799462\|gb\|JN963963.1\|	10090	g5829	i0	98.113	78.8217821782178	159	3	79	0	44	202	20732	20890	Mus musculus targeted non-conditional, lacZ-tagged mutant allele Lrrc23:tm1e(EUCOMM)Wtsi; transgenic	blastn	15922	279	0.996415770609319	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
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
16982407	16982407	PRJNA382558_S_NODE_9294_length_176_cov_9.978417_g9290_i0	PRJNA382558	9294	176	9.978417	17.56201392	Euproctis chrysorrhoea	987934	Arthropoda	Arthropoda	52.8	0.015	NTclustered	gi\|2918370019\|emb\|OZ237906.1\|	987934	g9290	i0	100	0.159090909090909	28	0	16	0	80	107	42169480	42169507	Euproctis chrysorrhoea genome assembly, chromosome: 2	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Erebidae	Euproctis	Euproctis chrysorrhoea
18256346	18256346	PRJNA382558_S_NODE_13795_length_157_cov_3.550000_g13791_i0	PRJNA382558	13795	157	3.55	5.5735	Fringilla coelebs	37598	Chordata	Chordata	52.8	0.013	NTclustered	gi\|2917610922\|emb\|OZ228690.1\|	37598	g13791	i0	100	0.178343949044586	28	0	18	0	21	48	254440	254467	Fringilla coelebs genome assembly, chromosome: Z	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Fringilla	Fringilla coelebs
18256480	18256480	PRJNA382558_S_NODE_6015_length_200_cov_15.846626_g6011_i0	PRJNA382558	6015	200	15.846626	31.693252	Cydia pomonella	82600	Arthropoda	Arthropoda	56.5	0.001	NTclustered	gi\|2639375780\|ref\|XM_061862610.1\|	82600	g6011	i0	96.97	0.165	33	1	17	0	136	168	55	87	PREDICTED: Cydia pomonella cytochrome b5 reductase 4 (LOC133526133), transcript variant X2, mRNA	blastn	33	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Tortricidae	Cydia	Cydia pomonella
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
21477356	21477356	PRJNA382558_S_NODE_1117_length_310_cov_10.725275_g1113_i0	PRJNA382558	1117	310	10.725275	33.2483525	Metazoa	33208	Chordata	Chordata	54.7	0.008	NTclustered	gi\|2805738660\|emb\|OZ078456.1\|	7748	g1113	i0	100	7.43548387096774	29	0	9	0	274	302	4206859	4206887	Lampetra fluviatilis genome assembly, chromosome: 53	blastn	2305	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
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
24027483	24027483	PRJNA382558_S_NODE_7099_length_191_cov_6.870130_g7095_i0	PRJNA382558	7099	191	6.87013	13.1219483	Mus	10088	Chordata	Chordata	353	4.02e-93	NTclustered	gi\|756142290\|gb\|KP260515.1\|	10090	g7095	i0	100	100	191	0	100	0	1	191	11360	11170	Mus musculus strain ME mitochondrion, complete genome	blastn	19100	353	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
25301864	25301864	PRJNA382558_S_NODE_11600_length_165_cov_6.968750_g11596_i0	PRJNA382558	11600	165	6.96875	11.4984375	Mus	10088	Chordata	Chordata	305	9.59e-79	NTclustered	gi\|846388176\|dbj\|LC062059.1\|	10090	g11596	i0	100	100	165	0	100	0	1	165	401	237	Mus musculus mitochondrion DNA, including Cytb, tRNA-Tyr, tRNA-Pro, tRNA-Phe, 12S rRNA genes and D-loop, complete sequence, sequence_id: (14446..634)_12	blastn	16500	305	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus

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