metadata: contig_metadata: 14 rows where bioproject = "PRJNA1095825", tax_clade = "Opisthokonta" and tax

14 rows where bioproject = "PRJNA1095825", tax_clade = "Opisthokonta" 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
200788	200788	PRJNA1095825_P_NODE_260941_length_247_cov_0.885057_g257878_i0	PRJNA1095825	260941	247	0.885057	2.18609079	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	62.1	3.71e-5	NTclustered	gi\|2920003418\|emb\|OZ238863.1\|	1046305	g257878	i0	100	0.133603238866397	33	0	13	0	16	48	1095596	1095564	Ailoscolex lacteospumosus genome assembly, chromosome: 4	blastn	33	62.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
200912	200912	PRJNA1095825_P_NODE_273521_length_245_cov_0.895349_g270458_i0	PRJNA1095825	273521	245	0.895349	2.19360505	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	58.4	4.75e-4	NTclustered	gi\|2920003623\|emb\|OZ238873.1\|	1046305	g270458	i0	92.683	0.436734693877551	41	1	16	2	145	183	20885764	20885804	Ailoscolex lacteospumosus genome assembly, chromosome: 14	blastn	107	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
2750282	2750282	PRJNA1095825_P_NODE_112063_length_361_cov_1.336806_g109000_i0	PRJNA1095825	112063	361	1.336806	4.82586966	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	62.1	5.69e-5	NTclustered	gi\|2920003527\|emb\|OZ238867.1\|	1046305	g109000	i0	97.222	0.0997229916897507	36	1	10	0	161	196	20490903	20490868	Ailoscolex lacteospumosus genome assembly, chromosome: 8	blastn	36	62.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
2752426	2752426	PRJNA1095825_P_NODE_78543_length_427_cov_1.596045_g75480_i0	PRJNA1095825	78543	427	1.596045	6.81511215	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	375	2.1499999999999995e-99	NTclustered	gi\|2920003593\|emb\|OZ238871.1\|	1046305	g75480	i0	90.169	2.91100702576112	295	19	69	4	4	296	15481532	15481246	Ailoscolex lacteospumosus genome assembly, chromosome: 12	blastn	1243	375	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
5303838	5303838	PRJNA1095825_P_NODE_268965_length_246_cov_0.861272_g265902_i0	PRJNA1095825	268965	246	0.861272	2.11872912	Hirudo verbana	311461	Annelida	Annelida	102	2.18e-17	NTclustered	gi\|2918369720\|emb\|OZ237792.1\|	311461	g265902	i0	80.42	0.58130081300813	143	21	56	3	16	153	4593025	4592885	Hirudo verbana genome assembly, chromosome: 14	blastn	143	102	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
6577622	6577622	PRJNA1095825_P_NODE_129726_length_338_cov_2.615094_g126663_i0	PRJNA1095825	129726	338	2.615094	8.83901772	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	63.9	1.47e-5	NTclustered	gi\|2920003371\|emb\|OZ238862.1\|	1046305	g126663	i0	95	0.674556213017751	40	2	12	0	83	122	6273276	6273315	Ailoscolex lacteospumosus genome assembly, chromosome: 3	blastn	228	63.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
9128731	9128731	PRJNA1095825_P_NODE_278408_length_244_cov_0.900585_g275345_i0	PRJNA1095825	278408	244	0.900585	2.1974274	Hirudo verbana	311461	Annelida	Annelida	58.4	4.73e-4	NTclustered	gi\|2918369620\|emb\|OZ237782.1\|	311461	g275345	i0	97.059	0.368852459016393	34	1	14	0	125	158	4592248	4592281	Hirudo verbana genome assembly, chromosome: 4	blastn	90	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
10404377	10404377	PRJNA1095825_P_NODE_280489_length_243_cov_2.641176_g277426_i0	PRJNA1095825	280489	243	2.641176	6.41805768	Hirudo verbana	311461	Annelida	Annelida	52.8	0.022	NTclustered	gi\|2918369714\|emb\|OZ237790.1\|	311461	g277426	i0	100	0.11522633744856	28	0	12	0	71	98	6948466	6948493	Hirudo verbana genome assembly, chromosome: 12	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
11678533	11678533	PRJNA1095825_P_NODE_153390_length_314_cov_2.464730_g150327_i0	PRJNA1095825	153390	314	2.46473	7.7392522	Theromyzon tessulatum	13286	Annelida	Annelida	120	3.7699999999999995e-30	NR	AAN28680.1	13286	g150327	i0	66.7	0.888535031847134	93	24	82.2	3	272	15	259	351	AAN28680.1 cathepsin L [Theromyzon tessulatum]	diamond	279	120	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Theromyzon	Theromyzon tessulatum
18052996	18052996	PRJNA1095825_P_NODE_36475_length_646_cov_1.343805_g33451_i0	PRJNA1095825	36475	646	1.343805	8.6809803	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	69.4	6.38e-7	NTclustered	gi\|2920003508\|emb\|OZ238866.1\|	1046305	g33451	i0	93.478	2.19814241486068	46	3	7	0	482	527	26052226	26052271	Ailoscolex lacteospumosus genome assembly, chromosome: 7	blastn	1420	69.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
20145809	20145809	PRJNA1095825_P_NODE_212756_length_267_cov_1.726804_g209693_i0	PRJNA1095825	212756	267	1.726804	4.61056668	Metazoa	33208	Annelida	Annelida	63.9	1.13e-5	NTclustered	gi\|675863665\|ref\|XM_009019145.1\|	6412	g209693	i0	97.297	0.415730337078652	37	1	14	0	95	131	132	96	Helobdella robusta hypothetical protein partial mRNA	blastn	111	63.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
22696552	22696552	PRJNA1095825_P_NODE_298398_length_238_cov_2.793939_g295335_i0	PRJNA1095825	298398	238	2.793939	6.64957482	Metazoa	33208	Annelida	Annelida	60.2	1.28e-4	NTclustered	gi\|2918369613\|emb\|OZ237779.1\|	311461	g295335	i0	100	0.542016806722689	32	0	13	0	43	74	4177129	4177160	Hirudo verbana genome assembly, chromosome: 1	blastn	129	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
28962637	28962637	PRJNA1095825_P_NODE_192328_length_282_cov_1.373206_g189265_i0	PRJNA1095825	192328	282	1.373206	3.87244092	Ridgeia piscesae	27915	Annelida	Annelida	101	1.67e-24	NR	KAK2185756.1	27915	g189265	i0	68.4	5.88297872340426	79	22	80.9	1	13	240	56	134	KAK2185756.1 hypothetical protein NP493_223g02027 [Ridgeia piscesae]	diamond	1659	101	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
30794220	30794220	PRJNA1095825_P_NODE_227234_length_257_cov_1.293478_g224171_i0	PRJNA1095825	227234	257	1.293478	3.32423846	Helobdella robusta	6412	Annelida	Annelida	57.4	1.95e-7	NR	XP_009020192.1	6412	g224171	i0	76.5	0.968871595330739	34	7	38.5	1	125	223	11	44	XP_009020192.1 hypothetical protein HELRODRAFT_174496 [Helobdella robusta]	diamond	249	57.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta

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