metadata: contig_metadata: 22 rows where bioproject = "PRJNA681822" and tax

22 rows where bioproject = "PRJNA681822" 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
12131023	12131023	PRJNA681822_P_NODE_124850_length_363_cov_1.593103_g123363_i0	PRJNA681822	124850	363	1.593103	5.78296389	Arenicola marina	6344	Annelida	Annelida	139	2.57e-28	NTclustered	gi\|158187735\|gb\|EU124952.1\|	6344	g123363	i0	84.397	3.95592286501377	141	22	39	0	187	327	231	371	Arenicola marina ribosomal protein rps30 mRNA, complete cds	blastn	1436	139	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
12131136	12131136	PRJNA681822_P_NODE_132210_length_356_cov_2.031802_g130723_i0	PRJNA681822	132210	356	2.031802	7.23321512	Siboglinidae	41324	Annelida	Annelida	184	7.079999999999999e-57	NR	KAK2174984.1	27915	g130723	i0	84.1	1.80337078651685	107	17	90.2	0	34	354	3	109	KAK2174984.1 hypothetical protein NP493_762g00031 [Ridgeia piscesae]	diamond	642	185	0.994594594594595	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
14683790	14683790	PRJNA681822_P_NODE_355452_length_259_cov_1.279570_g353963_i0	PRJNA681822	355452	259	1.27957	3.3140863	Hirudo verbana	311461	Annelida	Annelida	52.8	0.024	NTclustered	gi\|2918369616\|emb\|OZ237781.1\|	311461	g353963	i0	100	0.108108108108108	28	0	11	0	115	142	14158422	14158449	Hirudo verbana genome assembly, chromosome: 3	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
15959678	15959678	PRJNA681822_P_NODE_67433_length_457_cov_2.406250_g65959_i0	PRJNA681822	67433	457	2.40625	10.9965625	Lamellibrachia satsuma	104711	Annelida	Annelida	125	1.89e-33	NR	KAI0212180.1	104711	g65959	i0	61.8	21.8927789934354	110	42	72.2	0	334	5	18	127	KAI0212180.1 60S ribosomal protein L23a [Lamellibrachia satsuma]	diamond	10005	125	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
18506526	18506526	PRJNA681822_P_NODE_324355_length_267_cov_3.603093_g322866_i0	PRJNA681822	324355	267	3.603093	9.62025831	Nephasoma pellucidum	360536	Annelida	Annelida	85.1	2.77e-18	NR	CCD27765.1	360536	g322866	i0	66.2	2.19101123595506	65	22	73	0	267	73	112	176	CCD27765.1 ribosomal protein l13, partial [Nephasoma pellucidum]	diamond	585	85.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Sipuncula	Golfingiida	Golfingiidae	Nephasoma	Nephasoma pellucidum
21059838	21059838	PRJNA681822_P_NODE_87157_length_412_cov_1.259587_g85676_i0	PRJNA681822	87157	412	1.259587	5.18949844	Pristina aequiseta	212339	Annelida	Annelida	571	2.4599999999999998e-158	NTclustered	gi\|285029437\|gb\|GQ355455.1\|	212339	g85676	i0	91.768	97.7839805825243	413	30	100	4	1	412	681	272	Pristina aequiseta 28S ribosomal RNA gene, partial sequence	blastn	40287	571	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Pristina	Pristina aequiseta
22330510	22330510	PRJNA681822_P_NODE_218778_length_297_cov_2.419643_g217289_i0	PRJNA681822	218778	297	2.419643	7.18633971	Metazoa	33208	Annelida	Annelida	125	7.5e-34	NR	CAH1797529.1	6347	g217289	i0	68	12.7575757575758	97	29	98	1	296	6	67	161	CAH1797529.1 unnamed protein product [Owenia fusiformis]	diamond	3789	125	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28388550	28388550	PRJNA681822_P_NODE_138926_length_350_cov_2.223827_g137438_i0	PRJNA681822	138926	350	2.223827	7.7833945	Sabellida	6362	Annelida	Annelida	147	4.02e-43	NR	KAK2179910.1	27915	g137438	i0	63.2	4.43142857142857	106	39	90.9	0	33	350	1	106	KAK2179910.1 hypothetical protein NP493_466g00017 [Ridgeia piscesae]	diamond	1551	147	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
29020371	29020371	PRJNA681822_P_NODE_215988_length_299_cov_1.362832_g214500_i0	PRJNA681822	215988	299	1.362832	4.07486768	Metazoa	33208	Annelida	Annelida	163	9.12e-49	NR	KAI0221472.1	104711	g214500	i0	72.4	70.866220735786	98	27	98.3	0	3	296	6	103	KAI0221472.1 60S ribosomal protein L4 [Lamellibrachia satsuma]	diamond	21189	164	0.99390243902439	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
29355750	29355750	PRJNA681822_P_NODE_18889_length_877_cov_5.909204_g17719_i0	PRJNA681822	18889	877	5.909204	51.82371908	Paralvinella palmiformis	53620	Annelida	Annelida	214	1.1800000000000001e-59	NR	KAK2152459.1	53620	g17719	i0	42.2	0.851767388825542	249	138	84.2	2	801	64	252	497	KAK2152459.1 hypothetical protein LSH36_328g03019 [Paralvinella palmiformis]	diamond	747	214	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30208087	30208087	PRJNA681822_P_NODE_381472_length_251_cov_1.606742_g379983_i0	PRJNA681822	381472	251	1.606742	4.03292242	Owenia fusiformis	6347	Annelida	Annelida	65.5	4.14e-10	NR	CAH1799227.1	6347	g379983	i0	40.6	3.15537848605578	96	39	93.2	1	1	234	1510	1605	CAH1799227.1 unnamed protein product [Owenia fusiformis]	diamond	792	65.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30303632	30303632	PRJNA681822_P_NODE_289232_length_277_cov_1.264706_g287743_i0	PRJNA681822	289232	277	1.264706	3.50323562	Lamellibrachia satsuma	104711	Annelida	Annelida	92	4.85e-22	NR	KAI0240148.1	104711	g287743	i0	51.2	1.86281588447653	86	42	93.1	0	259	2	1	86	KAI0240148.1 Ragulator complex protein LAMTOR5 [Lamellibrachia satsuma]	diamond	516	92	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
30335183	30335183	PRJNA681822_P_NODE_181032_length_320_cov_1.068826_g179544_i0	PRJNA681822	181032	320	1.068826	3.4202432	Paralvinella palmiformis	53620	Annelida	Annelida	42	0.0172	NR	KAK2143076.1	53620	g179544	i0	46	0.46875	50	23	43.1	1	3	140	7	56	KAK2143076.1 hypothetical protein LSH36_880g00047 [Paralvinella palmiformis]	diamond	150	42	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
31073298	31073298	PRJNA681822_P_NODE_435075_length_246_cov_0.890173_g433586_i0	PRJNA681822	435075	246	0.890173	2.18982558	Metazoa	33208	Annelida	Annelida	137	7.82e-36	NR	CAH1797385.1	6347	g433586	i0	70.4	3.95121951219512	81	24	98.8	0	3	245	104	184	CAH1797385.1 unnamed protein product [Owenia fusiformis]	diamond	972	137	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
31093065	31093065	PRJNA681822_P_NODE_367915_length_255_cov_1.692308_g366426_i0	PRJNA681822	367915	255	1.692308	4.3153854	Capitella teleta	283909	Annelida	Annelida	140	2.9e-40	NR	ELT98735.1	283909	g366426	i0	78.3	0.976470588235294	83	18	97.6	0	2	250	18	100	ELT98735.1 hypothetical protein CAPTEDRAFT_173854 [Capitella teleta]	diamond	249	140	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
31187523	31187523	PRJNA681822_P_NODE_299755_length_274_cov_1.532338_g298266_i0	PRJNA681822	299755	274	1.532338	4.19860612	Arenicola marina	6344	Annelida	Annelida	108	7.88e-27	NR	CAA64472.1	6344	g298266	i0	57.8	0.985401459854015	90	38	98.5	0	272	3	135	224	CAA64472.1 chymotrypsinogen [Arenicola marina]	diamond	270	108	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
31187550	31187550	PRJNA681822_P_NODE_462735_length_243_cov_0.905882_g461245_i0	PRJNA681822	462735	243	0.905882	2.20129326	Aspidosiphon albus	360530	Annelida	Annelida	55.1	7.93e-7	NR	CCD27761.1	360530	g461245	i0	43.3	0.827160493827161	67	37	82.7	1	2	202	114	179	CCD27761.1 ribosomal protein l13, partial [Aspidosiphon albus]	diamond	201	55.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Sipuncula	Aspidosiphonidormes	Aspidosiphonidae	Aspidosiphon	Aspidosiphon albus
31326037	31326037	PRJNA681822_P_NODE_180775_length_320_cov_1.246964_g179287_i0	PRJNA681822	180775	320	1.246964	3.9902848	root	1	Root_unresolved	Root_unresolved	110	5.21e-29	NR	ABW90378.1	6446	g179287	i0	66.7	4.959375	84	19	78.8	1	68	319	1	75	ABW90378.1 putative ribosomal protein S12, partial [Sipunculus nudus]	diamond	1587	110	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Sipuncula	Golfingiida	Sipunculidae	Sipunculus	Sipunculus nudus
32136890	32136890	PRJNA681822_P_NODE_168618_length_328_cov_1.415686_g167130_i0	PRJNA681822	168618	328	1.415686	4.64345008	Capitella teleta	283909	Annelida	Annelida	113	1.37e-26	NR	ELU18393.1	283909	g167130	i0	47.2	0.98780487804878	108	56	98.8	1	326	3	655	761	ELU18393.1 hypothetical protein CAPTEDRAFT_227631 [Capitella teleta]	diamond	324	113	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
32370232	32370232	PRJNA681822_P_NODE_342839_length_262_cov_2.190476_g341350_i0	PRJNA681822	342839	262	2.190476	5.73904712	Metazoa	33208	Annelida	Annelida	68.9	2.75e-11	NR	CAH1791039.1	6347	g341350	i0	42.9	3.92748091603053	84	43	92.7	2	18	260	619	700	CAH1791039.1 unnamed protein product [Owenia fusiformis]	diamond	1029	69.3	0.994227994227994	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
32485019	32485019	PRJNA681822_P_NODE_323259_length_268_cov_1.348718_g321770_i0	PRJNA681822	323259	268	1.348718	3.61456424	Capitella teleta	283909	Annelida	Annelida	114	2.53e-27	NR	ELU07764.1	283909	g321770	i0	68.4	1.82462686567164	79	25	88.4	0	264	28	760	838	ELU07764.1 hypothetical protein CAPTEDRAFT_152289 [Capitella teleta]	diamond	489	114	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
32717401	32717401	PRJNA681822_P_NODE_171080_length_326_cov_1.924901_g169592_i0	PRJNA681822	171080	326	1.924901	6.27517726	Metazoa	33208	Annelida	Annelida	145	5.159999999999998e-42	NR	XP_009012840.1	6412	g169592	i0	65.6	8.9079754601227	96	33	88.3	0	289	2	3	98	XP_009012840.1 hypothetical protein HELRODRAFT_185375 [Helobdella robusta]	diamond	2904	145	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);;