metadata: contig_metadata: 26 rows where bioproject = "PRJNA489308" and tax

26 rows where bioproject = "PRJNA489308" 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
4277153	4277153	PRJNA489308_P_NODE_14924_length_314_cov_1.278008_g14848_i0	PRJNA489308	14924	314	1.278008	4.01294512	Hirudo verbana	311461	Annelida	Annelida	54.7	0.008	NTclustered	gi\|2918369621\|emb\|OZ237783.1\|	311461	g14848	i0	92.308	0.780254777070064	39	1	12	2	246	282	12374749	12374711	Hirudo verbana genome assembly, chromosome: 5	blastn	245	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
6827660	6827660	PRJNA489308_P_NODE_15226_length_312_cov_1.456067_g15150_i0	PRJNA489308	15226	312	1.456067	4.54292904	Helobdella robusta	6412	Annelida	Annelida	52.8	0.029	NTclustered	gi\|675860169\|ref\|XM_009017397.1\|	6412	g15150	i0	100	0.0897435897435897	28	0	9	0	101	128	5881	5854	Helobdella robusta hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
6827664	6827664	PRJNA489308_P_NODE_15486_length_310_cov_1.890295_g15410_i0	PRJNA489308	15486	310	1.890295	5.8599145	Helobdella robusta	6412	Annelida	Annelida	163	4.2999999999999994e-49	NR	XP_009017924.1	6412	g15410	i0	88.9	2.39032258064516	81	9	78.4	0	244	2	11	91	XP_009017924.1 hypothetical protein HELRODRAFT_79470 [Helobdella robusta]	diamond	741	163	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
8103175	8103175	PRJNA489308_P_NODE_1067_length_870_cov_4.806775_g1008_i0	PRJNA489308	1067	870	4.806775	41.8189425	Metazoa	33208	Annelida	Annelida	304	2.2e-99	NR	KAK2146210.1	53620	g1008	i0	69.2	14.8724137931034	208	64	71.7	0	832	209	6	213	KAK2146210.1 hypothetical protein LSH36_624g01057 [Paralvinella palmiformis]	diamond	12939	305	0.99672131147541	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
8103198	8103198	PRJNA489308_P_NODE_1247_length_818_cov_3.269799_g1183_i0	PRJNA489308	1247	818	3.269799	26.74695582	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	306	2.49e-100	NR	ELU05060.1	283909	g1183	i0	60.7	14.1931540342298	257	98	93.5	3	52	816	7	262	ELU05060.1 hypothetical protein CAPTEDRAFT_166194 [Capitella teleta]	diamond	11610	309	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
10653842	10653842	PRJNA489308_P_NODE_2409_length_628_cov_2.756757_g2334_i0	PRJNA489308	2409	628	2.756757	17.31243396	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	56.5	0.005	NTclustered	gi\|2920003636\|emb\|OZ238874.1\|	1046305	g2334	i0	100	0.0477707006369427	30	0	5	0	133	162	8349453	8349424	Ailoscolex lacteospumosus genome assembly, chromosome: 15	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
10654051	10654051	PRJNA489308_P_NODE_909_length_928_cov_2.452632_g851_i0	PRJNA489308	909	928	2.452632	22.76042496	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	271	1.02e-85	NR	AAN28680.1	13286	g851	i0	52	3.81465517241379	306	124	93.4	11	925	59	52	351	AAN28680.1 cathepsin L [Theromyzon tessulatum]	diamond	3540	271	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Theromyzon	Theromyzon tessulatum
14478801	14478801	PRJNA489308_P_NODE_30732_length_251_cov_0.865169_g30656_i0	PRJNA489308	30732	251	0.865169	2.17157419	Hirudo verbana	311461	Annelida	Annelida	56.5	0.002	NTclustered	gi\|2918369697\|emb\|OZ237786.1\|	311461	g30656	i0	96.97	0.386454183266932	33	1	13	0	124	156	8373533	8373565	Hirudo verbana genome assembly, chromosome: 8	blastn	97	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
17027403	17027403	PRJNA489308_P_NODE_17354_length_299_cov_2.008850_g17278_i0	PRJNA489308	17354	299	2.00885	6.0064615	Hirudo verbana	311461	Annelida	Annelida	63.9	1.28e-5	NTclustered	gi\|2918369720\|emb\|OZ237792.1\|	311461	g17278	i0	100	10.9063545150502	34	0	11	0	91	124	602171	602138	Hirudo verbana genome assembly, chromosome: 14	blastn	3261	63.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
17027657	17027657	PRJNA489308_P_NODE_8894_length_371_cov_1.932886_g8818_i0	PRJNA489308	8894	371	1.932886	7.17100706	Hirudo verbana	311461	Annelida	Annelida	54.7	0.01	NTclustered	gi\|2918369613\|emb\|OZ237779.1\|	311461	g8818	i0	96.97	0.0889487870619946	33	0	9	1	235	266	5983643	5983675	Hirudo verbana genome assembly, chromosome: 1	blastn	33	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
19575863	19575863	PRJNA489308_P_NODE_1376_length_785_cov_5.595506_g1306_i0	PRJNA489308	1376	785	5.595506	43.9247221	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	404	3.2e-140	NR	CAH1782245.1	6347	g1306	i0	74.4	43.7503184713376	258	66	98.6	0	7	780	1	258	CAH1782245.1 unnamed protein product [Owenia fusiformis]	diamond	34344	405	0.997530864197531	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
19575901	19575901	PRJNA489308_P_NODE_17576_length_298_cov_1.706667_g17500_i0	PRJNA489308	17576	298	1.706667	5.08586766	Hirudo verbana	311461	Annelida	Annelida	65.8	3.56e-6	NTclustered	gi\|2918369693\|emb\|OZ237785.1\|	311461	g17500	i0	95.122	12.7919463087248	41	2	14	0	131	171	11699002	11698962	Hirudo verbana genome assembly, chromosome: 7	blastn	3812	65.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
21499968	21499968	PRJNA489308_P_NODE_20057_length_287_cov_1.074766_g19981_i0	PRJNA489308	20057	287	1.074766	3.08457842	Clitellata	42113	Annelida	Annelida	60.2	1.59e-4	NTclustered	gi\|2918369702\|emb\|OZ237787.1\|	311461	g19981	i0	94.872	0.473867595818815	39	1	13	1	69	106	1288731	1288769	Hirudo verbana genome assembly, chromosome: 9	blastn	136	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
26712292	26712292	PRJNA489308_P_NODE_37281_length_243_cov_0.905882_g37205_i0	PRJNA489308	37281	243	0.905882	2.20129326	Metazoa	33208	Annelida	Annelida	110	9.07e-27	NR	ELU01936.1	283909	g37205	i0	66.2	2.82716049382716	77	26	95.1	0	3	233	143	219	ELU01936.1 hypothetical protein CAPTEDRAFT_176844 [Capitella teleta]	diamond	687	110	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
27424224	27424224	PRJNA489308_P_NODE_12943_length_328_cov_1.792157_g12867_i0	PRJNA489308	12943	328	1.792157	5.87827496	Helobdella robusta	6412	Annelida	Annelida	43.9	0.0377	NR	XP_009025366.1	6412	g12867	i0	38.9	0.49390243902439	54	24	49.4	1	303	142	391	435	XP_009025366.1 hypothetical protein HELRODRAFT_155987 [Helobdella robusta]	diamond	162	43.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
27487141	27487141	PRJNA489308_P_NODE_10543_length_350_cov_1.819495_g10467_i0	PRJNA489308	10543	350	1.819495	6.3682325	Owenia fusiformis	6347	Annelida	Annelida	60.1	6.85e-9	NR	CAH1778093.1	6347	g10467	i0	40.3	1.18285714285714	72	38	61.7	1	329	114	35	101	CAH1778093.1 unnamed protein product [Owenia fusiformis]	diamond	414	60.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28718616	28718616	PRJNA489308_P_NODE_7767_length_391_cov_4.194969_g7691_i0	PRJNA489308	7767	391	4.194969	16.40232879	Arenicola marina	6344	Annelida	Annelida	71.6	6.3e-12	NR	UCK81497.1	6344	g7691	i0	34.7	0.951406649616368	124	77	92.8	3	27	389	146	268	UCK81497.1 ricin lectin domain-containing protein 6 [Arenicola marina]	diamond	372	71.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
29318384	29318384	PRJNA489308_P_NODE_5649_length_445_cov_3.956989_g5573_i0	PRJNA489308	5649	445	3.956989	17.60860105	Capitella teleta	283909	Annelida	Annelida	134	3.09e-36	NR	ELU11053.1	283909	g5573	i0	55.3	1.87415730337079	141	63	95.1	0	3	425	64	204	ELU11053.1 hypothetical protein CAPTEDRAFT_183211 [Capitella teleta]	diamond	834	134	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
29950023	29950023	PRJNA489308_P_NODE_32551_length_249_cov_0.875000_g32475_i0	PRJNA489308	32551	249	0.875	2.17875	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	76.6	3.51e-14	NR	CAD5110796.1	2664684	g32475	i0	45.7	2.78313253012048	81	38	97.6	2	6	248	252	326	CAD5110796.1 DgyrCDS161 [Dimorphilus gyrociliatus]	diamond	693	76.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
30455879	30455879	PRJNA489308_P_NODE_31773_length_250_cov_0.870056_g31697_i0	PRJNA489308	31773	250	0.870056	2.17514	Helobdella robusta	6412	Annelida	Annelida	48.9	2.73e-4	NR	XP_009012875.1	6412	g31697	i0	41.8	0.66	55	22	66	1	56	220	336	380	XP_009012875.1 hypothetical protein HELRODRAFT_185380 [Helobdella robusta]	diamond	165	48.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
30487193	30487193	PRJNA489308_P_NODE_30933_length_251_cov_0.865169_g30857_i0	PRJNA489308	30933	251	0.865169	2.17157419	Paralvinella palmiformis	53620	Annelida	Annelida	52.8	1.13e-5	NR	KAK2145403.1	53620	g30857	i0	58.1	2.42629482071713	43	18	51.4	0	83	211	15	57	KAK2145403.1 hypothetical protein LSH36_685g02020 [Paralvinella palmiformis]	diamond	609	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30613370	30613370	PRJNA489308_P_NODE_8953_length_370_cov_2.074074_g8877_i0	PRJNA489308	8953	370	2.074074	7.6740738	Owenia fusiformis	6347	Annelida	Annelida	68.9	5.55e-11	NR	CAH1780818.1	6347	g8877	i0	31	1.79189189189189	100	60	81.1	1	71	370	7	97	CAH1780818.1 unnamed protein product [Owenia fusiformis]	diamond	663	68.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30739859	30739859	PRJNA489308_P_NODE_7834_length_390_cov_2.570978_g7758_i0	PRJNA489308	7834	390	2.570978	10.0268142	Owenia fusiformis	6347	Annelida	Annelida	52.8	4.57e-5	NR	CAH1773776.1	6347	g7758	i0	54	0.630769230769231	50	17	38.5	1	214	363	115	158	CAH1773776.1 unnamed protein product [Owenia fusiformis]	diamond	246	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30897970	30897970	PRJNA489308_P_NODE_38894_length_241_cov_0.916667_g38818_i0	PRJNA489308	38894	241	0.916667	2.20916747	Lamellibrachia satsuma	104711	Annelida	Annelida	73.9	3.74e-13	NR	KAI0216049.1	104711	g38818	i0	50.8	0.734439834024896	59	28	73.4	1	226	50	549	606	KAI0216049.1 Zinc finger CCCH domain-containing protein 14 [Lamellibrachia satsuma]	diamond	177	73.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
32036220	32036220	PRJNA489308_P_NODE_32898_length_248_cov_1.537143_g32822_i0	PRJNA489308	32898	248	1.537143	3.81211464	Owenia fusiformis	6347	Annelida	Annelida	55.5	1.33e-6	NR	CAH1784738.1	6347	g32822	i0	34.2	1.65725806451613	73	41	81	3	46	246	747	818	CAH1784738.1 unnamed protein product, partial [Owenia fusiformis]	diamond	411	55.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
32904839	32904839	PRJNA489308_P_NODE_22920_length_275_cov_1.990099_g22844_i0	PRJNA489308	22920	275	1.990099	5.47277225	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	47.4	0.00126	NR	CAD5117251.1	2664684	g22844	i0	42.4	1.70181818181818	59	34	64.4	0	7	183	131	189	CAD5117251.1 DgyrCDS6046 [Dimorphilus gyrociliatus]	diamond	468	47.8	0.99163179916318	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);;