metadata: contig_metadata: 25 rows where bioproject = "PRJNA857143" and tax

25 rows where bioproject = "PRJNA857143" 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
2119626	2119626	PRJNA857143_S_NODE_57242_length_379_cov_2.039216_g56149_i0	PRJNA857143	57242	379	2.039216	7.72862864	Hirudo verbana	311461	Annelida	Annelida	54.7	0.01	NTclustered	gi\|2918369697\|emb\|OZ237786.1\|	311461	g56149	i0	100	0.0765171503957784	29	0	8	0	324	352	2254621	2254649	Hirudo verbana genome assembly, chromosome: 8	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
2119922	2119922	PRJNA857143_S_NODE_8702_length_714_cov_30.196568_g7770_i0	PRJNA857143	8702	714	30.196568	215.60349552	Annelida	6340	Annelida	Annelida	350	8.33e-120	NR	CCD27767.1	41797	g7770	i0	77.9	33.2394957983193	217	48	91.2	0	2	652	9	225	CCD27767.1 ribosomal protein l8, partial [Phascolosoma granulatum]	diamond	23733	350	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Sipuncula	Phascolosomatiformes	Phascolosomatidae	Phascolosoma	Phascolosoma granulatum
3394444	3394444	PRJNA857143_S_NODE_19183_length_538_cov_35.733333_g18105_i0	PRJNA857143	19183	538	35.733333	192.24533154	Opisthokonta	33154	Annelida	Annelida	234	1.68e-75	NR	XP_009022737.1	6412	g18105	i0	75.6	40.9795539033457	156	38	87	0	537	70	35	190	XP_009022737.1 hypothetical protein HELRODRAFT_155894 [Helobdella robusta]	diamond	22047	234	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
4672215	4672215	PRJNA857143_S_NODE_19384_length_536_cov_25.904968_g18305_i0	PRJNA857143	19384	536	25.904968	138.85062848	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	181	7.82e-52	NR	CAD5125094.1	2664684	g18305	i0	64.4	11.4850746268657	135	48	75.6	0	534	130	260	394	CAD5125094.1 DgyrCDS13335 [Dimorphilus gyrociliatus]	diamond	6156	181	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
4672568	4672568	PRJNA857143_S_NODE_49484_length_397_cov_3.391975_g48391_i0	PRJNA857143	49484	397	3.391975	13.46614075	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	62.1	6.32e-5	NTclustered	gi\|2920003418\|emb\|OZ238863.1\|	1046305	g48391	i0	86.667	0.246851385390428	60	3	15	5	323	380	33370838	33370782	Ailoscolex lacteospumosus genome assembly, chromosome: 4	blastn	98	62.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
11046751	11046751	PRJNA857143_S_NODE_128769_length_284_cov_1.848341_g127676_i0	PRJNA857143	128769	284	1.848341	5.24928844	Hirudo verbana	311461	Annelida	Annelida	54.7	0.007	NTclustered	gi\|2918369702\|emb\|OZ237787.1\|	311461	g127676	i0	96.97	0.51056338028169	33	0	12	1	188	220	601142	601173	Hirudo verbana genome assembly, chromosome: 9	blastn	145	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
11048065	11048065	PRJNA857143_S_NODE_79169_length_340_cov_1.168539_g78076_i0	PRJNA857143	79169	340	1.168539	3.9730326	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	54.7	0.009	NTclustered	gi\|2920003545\|emb\|OZ238868.1\|	1046305	g78076	i0	100	0.714705882352941	29	0	9	0	210	238	337527	337555	Ailoscolex lacteospumosus genome assembly, chromosome: 9	blastn	243	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
12323487	12323487	PRJNA857143_S_NODE_65550_length_362_cov_7.802768_g64457_i0	PRJNA857143	65550	362	7.802768	28.24602016	Hirudo verbana	311461	Annelida	Annelida	52.8	0.034	NTclustered	gi\|2918369620\|emb\|OZ237782.1\|	311461	g64457	i0	100	0.154696132596685	28	0	8	0	1	28	213050	213023	Hirudo verbana genome assembly, chromosome: 4	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
18694423	18694423	PRJNA857143_S_NODE_126715_length_286_cov_1.643192_g125622_i0	PRJNA857143	126715	286	1.643192	4.69952912	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	65.8	3.4e-6	NTclustered	gi\|2920003257\|emb\|OZ238860.1\|	1046305	g125622	i0	88.136	2.7972027972028	59	1	21	2	180	238	37246771	37246719	Ailoscolex lacteospumosus genome assembly, chromosome: 1	blastn	800	65.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
21246568	21246568	PRJNA857143_S_NODE_80757_length_337_cov_4.568182_g79664_i0	PRJNA857143	80757	337	4.568182	15.39477334	Hirudo verbana	311461	Annelida	Annelida	52.8	0.032	NTclustered	gi\|2918369620\|emb\|OZ237782.1\|	311461	g79664	i0	100	0.166172106824926	28	0	8	0	1	28	213050	213023	Hirudo verbana genome assembly, chromosome: 4	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
25068957	25068957	PRJNA857143_S_NODE_106840_length_305_cov_4.810345_g105747_i0	PRJNA857143	106840	305	4.810345	14.67155225	Hirudo verbana	311461	Annelida	Annelida	58.4	6.11e-4	NTclustered	gi\|2918369621\|emb\|OZ237783.1\|	311461	g105747	i0	100	0.101639344262295	31	0	10	0	237	267	10515784	10515754	Hirudo verbana genome assembly, chromosome: 5	blastn	31	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
26674917	26674917	PRJNA857143_S_NODE_187281_length_245_cov_1.325581_g186188_i0	PRJNA857143	187281	245	1.325581	3.24767345	Owenia fusiformis	6347	Annelida	Annelida	45.4	0.00279	NR	CAH1772743.1	6347	g186188	i0	39.6	0.648979591836735	53	32	64.9	0	235	77	138	190	CAH1772743.1 unnamed protein product, partial [Owenia fusiformis]	diamond	159	45.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27347914	27347914	PRJNA857143_S_NODE_75103_length_346_cov_1.886447_g74010_i0	PRJNA857143	75103	346	1.886447	6.52710662	Metazoa	33208	Annelida	Annelida	97.8	2.6200000000000003e-21	NR	CAH17649.1	6446	g74010	i0	52	7.82947976878613	75	36	65	0	1	225	322	396	CAH17649.1 strombine dehydrogenase [Sipunculus nudus]	diamond	2709	98.2	0.995926680244399	Eukaryota	Opisthokonta	Metazoa	Annelida	Sipuncula	Golfingiida	Sipunculidae	Sipunculus	Sipunculus nudus
27379546	27379546	PRJNA857143_S_NODE_48643_length_399_cov_4.920245_g47550_i0	PRJNA857143	48643	399	4.920245	19.63177755	Metazoa	33208	Annelida	Annelida	117	2.13e-29	NR	CAH1797348.1	6347	g47550	i0	70.5	13.1203007518797	78	23	58.6	0	6	239	180	257	CAH1797348.1 unnamed protein product, partial [Owenia fusiformis]	diamond	5235	117	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28034363	28034363	PRJNA857143_S_NODE_44125_length_411_cov_25.988166_g43032_i0	PRJNA857143	44125	411	25.988166	106.81136226	Helobdella robusta	6412	Annelida	Annelida	110	2.53e-28	NR	XP_009025143.1	6412	g43032	i0	58.9	0.693430656934307	95	39	69.3	0	83	367	7	101	XP_009025143.1 hypothetical protein HELRODRAFT_67827 [Helobdella robusta]	diamond	285	110	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
28042423	28042423	PRJNA857143_S_NODE_96085_length_317_cov_4.180328_g94992_i0	PRJNA857143	96085	317	4.180328	13.25163976	Metazoa	33208	Annelida	Annelida	56.2	3.75e-7	NR	KAK2174562.1	27915	g94992	i0	43.8	0.936908517350158	48	27	45.4	0	305	162	105	152	KAK2174562.1 hypothetical protein NP493_794g01015 [Ridgeia piscesae]	diamond	297	56.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
28191834	28191834	PRJNA857143_S_NODE_99746_length_313_cov_3.087500_g98653_i0	PRJNA857143	99746	313	3.0875	9.663875	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	66.2	5.02e-10	NR	CAD5112216.1	2664684	g98653	i0	37.5	3.29712460063898	88	53	84.3	1	2	265	2115	2200	CAD5112216.1 DgyrCDS1449 [Dimorphilus gyrociliatus]	diamond	1032	66.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
29052880	29052880	PRJNA857143_S_NODE_164028_length_256_cov_1.704918_g162935_i0	PRJNA857143	164028	256	1.704918	4.36459008	Metazoa	33208	Annelida	Annelida	119	5.14e-29	NR	CAH1789151.1	6347	g162935	i0	64.3	287.44921875	84	30	98.4	0	252	1	528	611	CAH1789151.1 unnamed protein product [Owenia fusiformis]	diamond	73587	119	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29076306	29076306	PRJNA857143_S_NODE_161368_length_258_cov_1.470270_g160275_i0	PRJNA857143	161368	258	1.47027	3.7932966	Paralvinella palmiformis	53620	Annelida	Annelida	103	2.4099999999999998e-24	NR	KAK2142481.1	53620	g160275	i0	53.6	1.94186046511628	84	37	97.7	1	2	253	204	285	KAK2142481.1 hypothetical protein LSH36_950g00055 [Paralvinella palmiformis]	diamond	501	103	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
29928880	29928880	PRJNA857143_S_NODE_41351_length_420_cov_2.697406_g40258_i0	PRJNA857143	41351	420	2.697406	11.3291052	Owenia fusiformis	6347	Annelida	Annelida	49.3	0.00111	NR	CAH1778662.1	6347	g40258	i0	30	0.785714285714286	110	66	74.3	2	330	19	149	253	CAH1778662.1 unnamed protein product [Owenia fusiformis]	diamond	330	49.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30497503	30497503	PRJNA857143_S_NODE_144513_length_271_cov_1.181818_g143420_i0	PRJNA857143	144513	271	1.181818	3.20272678	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	76.3	7.7e-14	NR	CAD5113759.1	2664684	g143420	i0	48.7	0.863468634686347	78	32	86.3	2	266	33	173	242	CAD5113759.1 DgyrCDS2925 [Dimorphilus gyrociliatus]	diamond	234	76.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
31128970	31128970	PRJNA857143_S_NODE_191415_length_243_cov_1.717647_g190322_i0	PRJNA857143	191415	243	1.717647	4.17388221	Capitella teleta	283909	Annelida	Annelida	74.7	1.71e-15	NR	ELU05554.1	283909	g190322	i0	50.8	1.65432098765432	65	30	77.8	1	9	197	15	79	ELU05554.1 hypothetical protein CAPTEDRAFT_140822 [Capitella teleta]	diamond	402	74.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
31318961	31318961	PRJNA857143_S_NODE_69995_length_354_cov_5.743772_g68902_i0	PRJNA857143	69995	354	5.743772	20.33295288	Paralvinella palmiformis	53620	Annelida	Annelida	43.9	0.041	NR	KAK2158093.1	53620	g68902	i0	31.9	0.584745762711864	69	47	58.5	0	53	259	115	183	KAK2158093.1 hypothetical protein LSH36_177g02001 [Paralvinella palmiformis]	diamond	207	43.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
31706727	31706727	PRJNA857143_S_NODE_104037_length_308_cov_5.310638_g102944_i0	PRJNA857143	104037	308	5.310638	16.35676504	Metazoa	33208	Annelida	Annelida	58.9	1.75e-7	NR	CAH1777009.1	6347	g102944	i0	57.4	1.83116883116883	47	14	45.8	2	307	167	4653	4693	CAH1777009.1 unnamed protein product [Owenia fusiformis]	diamond	564	59.3	0.993254637436762	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
32300053	32300053	PRJNA857143_S_NODE_55439_length_383_cov_1.958065_g54346_i0	PRJNA857143	55439	383	1.958065	7.49938895	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	75.1	8.89e-13	NR	CAD5123944.1	2664684	g54346	i0	48.7	0.610966057441253	78	39	61.1	1	3	236	768	844	CAD5123944.1 DgyrCDS12251 [Dimorphilus gyrociliatus]	diamond	234	75.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus

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