metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA379145" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA379145" and tax_phylum = "Annelida"

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
2951496	2951496	PRJNA379145_P_NODE_38603_length_315_cov_2.585106_g36452_i0	PRJNA379145	38603	315	2.585106	8.1430839	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	58.4	6.34e-4	NTclustered	gi\|2920003371\|emb\|OZ238862.1\|	1046305	g36452	i0	100	1.47619047619048	31	0	10	0	7	37	24920007	24920037	Ailoscolex lacteospumosus genome assembly, chromosome: 3	blastn	465	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
6778372	6778372	PRJNA379145_P_NODE_21446_length_563_cov_2.883019_g19528_i0	PRJNA379145	21446	563	2.883019	16.23139697	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	56.5	0.004	NTclustered	gi\|2920003257\|emb\|OZ238860.1\|	1046305	g19528	i0	100	0.104795737122558	30	0	5	0	146	175	50100248	50100219	Ailoscolex lacteospumosus genome assembly, chromosome: 1	blastn	59	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
8054408	8054408	PRJNA379145_P_NODE_71927_length_155_cov_1.467213_g69772_i0	PRJNA379145	71927	155	1.467213	2.27418015	Hirudo verbana	311461	Annelida	Annelida	60.2	7.62e-5	NTclustered	gi\|2918369702\|emb\|OZ237787.1\|	311461	g69772	i0	97.143	0.658064516129032	35	1	23	0	20	54	597706	597740	Hirudo verbana genome assembly, chromosome: 9	blastn	102	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
10002166	10002166	PRJNA379145_P_NODE_56228_length_203_cov_2.647059_g54074_i0	PRJNA379145	56228	203	2.647059	5.37352977	Pristina	150439	Annelida	Annelida	370	4.3e-98	NTclustered	gi\|285029397\|gb\|GQ355415.1\|	212339	g54074	i0	99.507	99.7832512315271	203	1	100	0	1	203	55	257	Pristina aequiseta 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	20256	370	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Pristina	Pristina aequiseta
10604476	10604476	PRJNA379145_P_NODE_24749_length_500_cov_2.426124_g22727_i0	PRJNA379145	24749	500	2.426124	12.13062	Hirudo verbana	311461	Annelida	Annelida	58.4	0.001	NTclustered	gi\|2918369714\|emb\|OZ237790.1\|	311461	g22727	i0	92.5	0.266	40	3	8	0	42	81	8969117	8969078	Hirudo verbana genome assembly, chromosome: 12	blastn	133	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
10604812	10604812	PRJNA379145_P_NODE_57869_length_197_cov_1.725610_g55715_i0	PRJNA379145	57869	197	1.72561	3.3994517	Platynereis dumerilii	6359	Annelida	Annelida	93.5	1.01e-14	NTclustered	gi\|83306927\|emb\|CT032901.1\|	6359	g55715	i0	94.915	1.18781725888325	59	3	30	0	98	156	447	505	Platynereis dumerilii EST IB0AAA29CH12EM1	blastn	234	93.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Platynereis	Platynereis dumerilii
10604827	10604827	PRJNA379145_P_NODE_59929_length_189_cov_1.634615_g57775_i0	PRJNA379145	59929	189	1.634615	3.08942235	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	54.7	0.005	NTclustered	gi\|2920003371\|emb\|OZ238862.1\|	1046305	g57775	i0	94.444	0.19047619047619	36	1	19	1	1	36	29176468	29176502	Ailoscolex lacteospumosus genome assembly, chromosome: 3	blastn	36	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
11879894	11879894	PRJNA379145_P_NODE_68770_length_162_cov_3.240310_g66616_i0	PRJNA379145	68770	162	3.24031	5.2493022	Lumbricus rubellus	35632	Annelida	Annelida	102	1.32e-17	NTclustered	gi\|11121259\|emb\|AJ291613.1\|	35632	g66616	i0	81.6	0.771604938271605	125	21	77	2	32	155	1	124	Lumbricus rubellus mRNA for 40S ribosomal protein S23 (rpS23 gene)	blastn	125	102	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Lumbricus	Lumbricus rubellus
14429902	14429902	PRJNA379145_P_NODE_71032_length_157_cov_1.596774_g68877_i0	PRJNA379145	71032	157	1.596774	2.50693518	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	63.9	5.98e-6	NTclustered	gi\|2920003623\|emb\|OZ238873.1\|	1046305	g68877	i0	97.297	7.77070063694268	37	1	24	0	40	76	21245568	21245604	Ailoscolex lacteospumosus genome assembly, chromosome: 14	blastn	1220	63.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
15703611	15703611	PRJNA379145_P_NODE_41933_length_287_cov_2.023622_g39781_i0	PRJNA379145	41933	287	2.023622	5.80779514	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.027	NTclustered	gi\|2920003418\|emb\|OZ238863.1\|	1046305	g39781	i0	100	0.0975609756097561	28	0	10	0	5	32	24230199	24230172	Ailoscolex lacteospumosus genome assembly, chromosome: 4	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
15703861	15703861	PRJNA379145_P_NODE_6933_length_1156_cov_2.898486_g6108_i0	PRJNA379145	6933	1156	2.898486	33.50649816	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	60.2	7.04e-4	NTclustered	gi\|2920003644\|emb\|OZ238875.1\|	1046305	g6108	i0	100	0.572664359861592	32	0	3	0	1091	1122	3144828	3144797	Ailoscolex lacteospumosus genome assembly, chromosome: 16	blastn	662	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
16978153	16978153	PRJNA379145_P_NODE_31694_length_393_cov_2.030556_g29563_i0	PRJNA379145	31694	393	2.030556	7.98008508	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	58.4	8.08e-4	NTclustered	gi\|2920003545\|emb\|OZ238868.1\|	1046305	g29563	i0	97.059	0.0865139949109415	34	1	9	0	29	62	5052323	5052356	Ailoscolex lacteospumosus genome assembly, chromosome: 9	blastn	34	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
16978403	16978403	PRJNA379145_P_NODE_58094_length_196_cov_1.785276_g55940_i0	PRJNA379145	58094	196	1.785276	3.49914096	Hirudo verbana	311461	Annelida	Annelida	56.5	0.001	NTclustered	gi\|2918369718\|emb\|OZ237791.1\|	311461	g55940	i0	100	8.44897959183673	30	0	15	0	167	196	8841465	8841494	Hirudo verbana genome assembly, chromosome: 13	blastn	1656	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
19526528	19526528	PRJNA379145_P_NODE_23136_length_530_cov_1.607646_g21159_i0	PRJNA379145	23136	530	1.607646	8.5205238	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	54.7	0.014	NTclustered	gi\|2920003527\|emb\|OZ238867.1\|	1046305	g21159	i0	100	0.0547169811320755	29	0	5	0	74	102	10910126	10910154	Ailoscolex lacteospumosus genome assembly, chromosome: 8	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
19526662	19526662	PRJNA379145_P_NODE_34236_length_361_cov_2.033537_g32091_i0	PRJNA379145	34236	361	2.033537	7.34106857	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	69.4	3.4e-7	NTclustered	gi\|2920003651\|emb\|OZ238876.1\|	1046305	g32091	i0	100	60.994459833795	37	0	10	0	59	95	2289971	2290007	Ailoscolex lacteospumosus genome assembly, chromosome: 17	blastn	22019	69.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
19527000	19527000	PRJNA379145_P_NODE_68756_length_162_cov_4.728682_g66602_i0	PRJNA379145	68756	162	4.728682	7.66046484	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	198	1.64e-46	NTclustered	gi\|2920003418\|emb\|OZ238863.1\|	1046305	g66602	i0	89.677	97.5185185185185	155	16	96	0	7	161	34179564	34179410	Ailoscolex lacteospumosus genome assembly, chromosome: 4	blastn	15798	198	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
22077230	22077230	PRJNA379145_P_NODE_24858_length_498_cov_3.978495_g22834_i0	PRJNA379145	24858	498	3.978495	19.8129051	Macellicephalinae sp. ASH-2021	2813884	Annelida	Annelida	296	2.04e-75	NTclustered	gi\|2483664316\|gb\|OL960153.1\|	2813884	g22834	i0	79.661	79.5843373493976	413	80	83	4	36	446	411	1	Macellicephalinae sp. ASH-2021 histone H3 (H3) gene, partial cds	blastn	39633	296	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Polynoidae		Macellicephalinae sp. ASH-2021
22077268	22077268	PRJNA379145_P_NODE_27798_length_449_cov_1.704327_g25713_i0	PRJNA379145	27798	449	1.704327	7.65242823	Hirudo verbana	311461	Annelida	Annelida	60.2	2.6e-4	NTclustered	gi\|2918369613\|emb\|OZ237779.1\|	311461	g25713	i0	91.111	5.49220489977728	45	3	10	1	316	360	5854836	5854879	Hirudo verbana genome assembly, chromosome: 1	blastn	2466	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
23352552	23352552	PRJNA379145_P_NODE_15099_length_732_cov_3.160229_g13482_i0	PRJNA379145	15099	732	3.160229	23.13287628	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	65.8	9.41e-6	NTclustered	gi\|2920003608\|emb\|OZ238872.1\|	1046305	g13482	i0	83.333	0.579234972677596	72	10	10	2	56	126	19159048	19159118	Ailoscolex lacteospumosus genome assembly, chromosome: 13	blastn	424	65.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
23352890	23352890	PRJNA379145_P_NODE_40939_length_295_cov_2.041985_g38788_i0	PRJNA379145	40939	295	2.041985	6.02385575	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	60.2	1.64e-4	NTclustered	gi\|2920003563\|emb\|OZ238869.1\|	1046305	g38788	i0	97.143	3.32542372881356	35	1	12	0	233	267	16583750	16583716	Ailoscolex lacteospumosus genome assembly, chromosome: 10	blastn	981	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
24627378	24627378	PRJNA379145_P_NODE_6340_length_1207_cov_6.416525_g5570_i0	PRJNA379145	6340	1207	6.416525	77.44745675	Hirudo verbana	311461	Annelida	Annelida	63.9	5.69e-5	NTclustered	gi\|2918369714\|emb\|OZ237790.1\|	311461	g5570	i0	91.489	0.454846727423364	47	3	4	1	1162	1207	803755	803801	Hirudo verbana genome assembly, chromosome: 12	blastn	549	63.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
24627437	24627437	PRJNA379145_P_NODE_69600_length_160_cov_2.755906_g67446_i0	PRJNA379145	69600	160	2.755906	4.4094496	Sparganophilus sp. HI-2019	2567987	Annelida	Annelida	158	2.73e-34	NTclustered	gi\|1931074695\|dbj\|LC475835.1\|	2567987	g67446	i0	85.35	81.7125	157	18	95	5	2	153	563	407	Sparganophilus sp. HI-2019 s199 mitochondrial gene for 16S rRNA, partial sequence	blastn	13074	158	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Lumbriculida	Sparganophilidae	Sparganophilus	Sparganophilus sp. HI-2019

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