metadata: contig_metadata: 16 rows where bioproject = "PRJNA1035005" and tax

16 rows where bioproject = "PRJNA1035005" 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
1443454	1443454	PRJNA1035005_P_NODE_2462_length_726_cov_5.583461_g2083_i0	PRJNA1035005	2462	726	5.583461	40.535926859999996	Aeolosoma sp. GG-2011	1071604	Annelida	Annelida	359	3.82e-94	NTclustered	gi\|342220097\|gb\|HQ691208.1\|	1071604	g2083	i0	81.21	26.1225895316804	463	72	62	10	125	576	472	14	Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	18965	359	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Aeolosomatidae	Aeolosoma	Aeolosoma sp. GG-2011
4836004	4836004	PRJNA1035005_P_NODE_7604_length_398_cov_1.467692_g7202_i0	PRJNA1035005	7604	398	1.467692	5.84141416	Opisthokonta	33154	Annelida	Annelida	56.5	0.003	NTclustered	gi\|2918369697\|emb\|OZ237786.1\|	311461	g7202	i0	100	0.296482412060302	30	0	8	0	239	268	11023387	11023416	Hirudo verbana genome assembly, chromosome: 8	blastn	118	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
15471501	15471501	PRJNA1035005_P_NODE_1513_length_1025_cov_4.545168_g1199_i0	PRJNA1035005	1513	1025	4.545168	46.587972	Metazoa	33208	Annelida	Annelida	281	8.75e-90	NR	XP_009025699.1	6412	g1199	i0	63.4	10.510243902439	246	81	69.4	2	32	742	1	246	XP_009025699.1 hypothetical protein HELRODRAFT_107583 [Helobdella robusta]	diamond	10773	281	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
15471854	15471854	PRJNA1035005_P_NODE_6173_length_431_cov_1.743017_g5771_i0	PRJNA1035005	6173	431	1.743017	7.51240327	Dendrobaena pentheri	1302597	Annelida	Annelida	75	8.88e-9	NTclustered	gi\|674656596\|gb\|KJ912407.1\|	1302597	g5771	i0	72.492	2.20417633410673	309	58	69	26	63	358	703	409	Dendrobaena pentheri isolate MPL406 12S ribosomal RNA gene, partial sequence; tRNA-Val gene, complete sequence; and 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	950	75	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Dendrobaena	Dendrobaena pentheri
20569811	20569811	PRJNA1035005_P_NODE_13617_length_332_cov_1.660232_g13211_i0	PRJNA1035005	13617	332	1.660232	5.51197024	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	56.5	0.002	NTclustered	gi\|2920003484\|emb\|OZ238865.1\|	1046305	g13211	i0	100	0.0903614457831325	30	0	9	0	170	199	20004805	20004834	Ailoscolex lacteospumosus genome assembly, chromosome: 6	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
20569964	20569964	PRJNA1035005_P_NODE_3557_length_574_cov_1.554890_g3164_i0	PRJNA1035005	3557	574	1.55489	8.9250686	Pristina longiseta	188231	Annelida	Annelida	891	0	NTclustered	gi\|2169792353\|gb\|OM001222.1\|	188231	g3164	i0	97.154	82.4756097560976	527	15	92	0	7	533	1	527	Pristina longiseta voucher CW649 large subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	47341	891	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Pristina	Pristina longiseta
20570144	20570144	PRJNA1035005_P_NODE_5857_length_441_cov_1.271739_g5457_i0	PRJNA1035005	5857	441	1.271739	5.60836899	Metazoa	33208	Annelida	Annelida	215	2.11e-62	NR	KAK2164859.1	53620	g5457	i0	75.3	6.97278911564626	146	33	99.3	2	441	4	460	602	KAK2164859.1 hypothetical protein LSH36_58g18051 [Paralvinella palmiformis]	diamond	3075	215	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
21845560	21845560	PRJNA1035005_P_NODE_14898_length_324_cov_1.243028_g14492_i0	PRJNA1035005	14898	324	1.243028	4.02741072	Hirudo verbana	311461	Annelida	Annelida	58.4	6.54e-4	NTclustered	gi\|2918369706\|emb\|OZ237788.1\|	311461	g14492	i0	97.143	1.3179012345679	35	0	10	1	122	155	5029325	5029359	Hirudo verbana genome assembly, chromosome: 10	blastn	427	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
24394762	24394762	PRJNA1035005_P_NODE_19020_length_304_cov_1.965368_g18614_i0	PRJNA1035005	19020	304	1.965368	5.97471872	Hirudo verbana	311461	Annelida	Annelida	75	6.05e-9	NTclustered	gi\|2918369693\|emb\|OZ237785.1\|	311461	g18614	i0	89.655	137.644736842105	58	6	19	0	92	149	3955963	3955906	Hirudo verbana genome assembly, chromosome: 7	blastn	41844	75	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
27058800	27058800	PRJNA1035005_P_NODE_46362_length_261_cov_1.925532_g45956_i0	PRJNA1035005	46362	261	1.925532	5.02563852	Metazoa	33208	Annelida	Annelida	73.2	9.26e-13	NR	CAH1786227.1	6347	g45956	i0	44.7	7.11494252873563	94	37	100	3	261	1	203	288	CAH1786227.1 unnamed protein product [Owenia fusiformis]	diamond	1857	73.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27288002	27288002	PRJNA1035005_P_NODE_11183_length_352_cov_1.118280_g10778_i0	PRJNA1035005	11183	352	1.11828	3.9363456	Lamellibrachia satsuma	104711	Annelida	Annelida	117	2.37e-28	NR	KAI0235029.1	104711	g10778	i0	55.8	2.88920454545455	113	46	96.3	3	8	346	97	205	KAI0235029.1 hypothetical protein LSAT2_014572 [Lamellibrachia satsuma]	diamond	1017	117	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
27375203	27375203	PRJNA1035005_P_NODE_28103_length_285_cov_1.457547_g27697_i0	PRJNA1035005	28103	285	1.457547	4.15400895	Metazoa	33208	Annelida	Annelida	56.6	8.24e-7	NR	KAK2181249.1	27915	g27697	i0	42.1	3.56842105263158	76	42	77.9	1	9	230	748	823	KAK2181249.1 hypothetical protein NP493_405g05002 [Ridgeia piscesae]	diamond	1017	56.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
29174757	29174757	PRJNA1035005_P_NODE_5509_length_453_cov_1.228947_g5109_i0	PRJNA1035005	5509	453	1.228947	5.56712991	Metazoa	33208	Annelida	Annelida	158	2.38e-44	NR	ELU13384.1	283909	g5109	i0	55.1	19.0596026490066	147	48	97.4	3	452	12	116	244	ELU13384.1 hypothetical protein CAPTEDRAFT_155317 [Capitella teleta]	diamond	8634	158	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
30975155	30975155	PRJNA1035005_P_NODE_2254_length_777_cov_5.867898_g1882_i0	PRJNA1035005	2254	777	5.867898	45.59356746	Sabellida	6362	Annelida	Annelida	199	1.96e-60	NR	CAH1784699.1	6347	g1882	i0	54.5	11.8648648648649	191	81	73.7	2	44	616	1	185	CAH1784699.1 unnamed protein product [Owenia fusiformis]	diamond	9219	199	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
31299038	31299038	PRJNA1035005_P_NODE_14195_length_328_cov_1.992157_g13789_i0	PRJNA1035005	14195	328	1.992157	6.53427496	Owenia fusiformis	6347	Annelida	Annelida	113	1.29e-26	NR	CAH1802338.1	6347	g13789	i0	52.3	0.996951219512195	109	48	99.7	3	2	328	395	499	CAH1802338.1 unnamed protein product [Owenia fusiformis]	diamond	327	113	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
32153239	32153239	PRJNA1035005_P_NODE_20678_length_298_cov_0.937778_g20272_i0	PRJNA1035005	20678	298	0.937778	2.79457844	Owenia fusiformis	6347	Annelida	Annelida	68.9	4.55e-11	NR	CAH1795822.1	6347	g20272	i0	36.4	0.996644295302013	99	46	99.7	1	297	1	713	794	CAH1795822.1 unnamed protein product, partial [Owenia fusiformis]	diamond	297	68.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis

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