metadata: contig_metadata: 21 rows where bioproject = "PRJNA683669" and tax

21 rows where bioproject = "PRJNA683669" 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
8318105	8318105	PRJNA683669_P_NODE_20127_length_287_cov_2.126168_g19895_i0	PRJNA683669	20127	287	2.126168	6.10210216	Acromegalomma interruptum	2023653	Annelida	Annelida	276	1.45e-69	NTclustered	gi\|1227250258\|gb\|MF145113.1\|	2023653	g19895	i0	87.19	80.9268292682927	242	31	84	0	46	287	483	242	Acromegalomma interruptum isolate Rcvrn_Contig127_ORF20 putative phototransduction mRNA, partial cds	blastn	23226	276	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Sabellidae	Acromegalomma	Acromegalomma interruptum
13419024	13419024	PRJNA683669_P_NODE_3971_length_653_cov_2.503448_g3749_i0	PRJNA683669	3971	653	2.503448	16.34751544	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	285	1.18e-92	NR	CAD5112291.1	2664684	g3749	i0	72.3	2.59111791730475	184	51	84.5	0	100	651	3	186	CAD5112291.1 DgyrCDS1520 [Dimorphilus gyrociliatus]	diamond	1692	285	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
17242935	17242935	PRJNA683669_P_NODE_2994_length_758_cov_3.077372_g2789_i0	PRJNA683669	2994	758	3.077372	23.32647976	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	56.5	0.006	NTclustered	gi\|2920003527\|emb\|OZ238867.1\|	1046305	g2789	i0	92.308	0.0514511873350923	39	3	5	0	88	126	25695889	25695851	Ailoscolex lacteospumosus genome assembly, chromosome: 8	blastn	39	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
17242974	17242974	PRJNA683669_P_NODE_4194_length_637_cov_2.294326_g3970_i0	PRJNA683669	4194	637	2.294326	14.61485662	Mesenchytraeus cf. pedatus SL-2017	2052678	Annelida	Annelida	305	4.4e-78	NTclustered	gi\|1275874787\|gb\|KU728824.2\|	2052678	g3970	i0	80.235	52.4960753532182	425	69	65	12	222	637	959	541	Mesenchytraeus cf. pedatus SL-2017 glyceraldehyde-3-phosphate dehydrogenase mRNA, complete cds	blastn	33440	305	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Enchytraeida	Enchytraeidae	Mesenchytraeus	Mesenchytraeus cf. pedatus SL-2017
21067327	21067327	PRJNA683669_P_NODE_11537_length_380_cov_1.071661_g11306_i0	PRJNA683669	11537	380	1.071661	4.0723118	Owenia fusiformis	6347	Annelida	Annelida	147	5.399999999999999e-38	NR	CAH1775312.1	6347	g11306	i0	59.4	2.02105263157895	128	49	99.5	2	378	1	905	1031	CAH1775312.1 unnamed protein product [Owenia fusiformis]	diamond	768	147	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
22342334	22342334	PRJNA683669_P_NODE_34378_length_229_cov_2.397436_g34146_i0	PRJNA683669	34378	229	2.397436	5.49012844	Hirudo verbana	311461	Annelida	Annelida	58.4	4.39e-4	NTclustered	gi\|2918369613\|emb\|OZ237779.1\|	311461	g34146	i0	100	0.135371179039301	31	0	14	0	35	65	203454	203484	Hirudo verbana genome assembly, chromosome: 1	blastn	31	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
24891138	24891138	PRJNA683669_P_NODE_30240_length_246_cov_0.890173_g30008_i0	PRJNA683669	30240	246	0.890173	2.18982558	Hirudo verbana	311461	Annelida	Annelida	62.1	3.69e-5	NTclustered	gi\|2918369614\|emb\|OZ237780.1\|	311461	g30008	i0	88.235	1.50813008130081	51	6	21	0	179	229	1141831	1141781	Hirudo verbana genome assembly, chromosome: 2	blastn	371	62.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
24891165	24891165	PRJNA683669_P_NODE_32680_length_243_cov_0.905882_g32448_i0	PRJNA683669	32680	243	0.905882	2.20129326	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	58.4	4.71e-4	NTclustered	gi\|2920003578\|emb\|OZ238870.1\|	1046305	g32448	i0	88.235	0.670781893004115	51	3	20	2	73	120	23545702	23545652	Ailoscolex lacteospumosus genome assembly, chromosome: 11	blastn	163	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
26607125	26607125	PRJNA683669_P_NODE_11701_length_377_cov_1.707237_g11470_i0	PRJNA683669	11701	377	1.707237	6.43628349	Lamellibrachia satsuma	104711	Annelida	Annelida	80.9	8e-15	NR	KAI0216320.1	104711	g11470	i0	65.2	0.525198938992042	66	19	52.5	1	177	374	63	124	KAI0216320.1 Pyruvate dehydrogenase [NADP(+)], mitochondrial [Lamellibrachia satsuma]	diamond	198	80.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
26797347	26797347	PRJNA683669_P_NODE_7861_length_456_cov_1.642298_g7630_i0	PRJNA683669	7861	456	1.642298	7.48887888	Capitella teleta	283909	Annelida	Annelida	96.7	2.8899999999999995e-23	NR	ELT97620.1	283909	g7630	i0	74.6	6.05921052631579	63	15	40.8	1	362	177	1	63	ELT97620.1 hypothetical protein CAPTEDRAFT_175858 [Capitella teleta]	diamond	2763	96.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
27555854	27555854	PRJNA683669_P_NODE_15924_length_325_cov_1.210317_g15693_i0	PRJNA683669	15924	325	1.210317	3.93353025	Lamellibrachia satsuma	104711	Annelida	Annelida	98.6	7.6600000000000005e-22	NR	KAI0212269.1	104711	g15693	i0	46.6	0.950769230769231	103	50	95.1	1	4	312	264	361	KAI0212269.1 Zinc phosphodiesterase ELAC protein 1 [Lamellibrachia satsuma]	diamond	309	98.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
27871775	27871775	PRJNA683669_P_NODE_19405_length_293_cov_1.040909_g19173_i0	PRJNA683669	19405	293	1.040909	3.04986337	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	103	8.64e-25	NR	CAD5124251.1	2664684	g19173	i0	64.7	1.55631399317406	68	24	69.6	0	293	90	170	237	CAD5124251.1 DgyrCDS12548 [Dimorphilus gyrociliatus]	diamond	456	103	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
28124454	28124454	PRJNA683669_P_NODE_18445_length_301_cov_1.350877_g18213_i0	PRJNA683669	18445	301	1.350877	4.06613977	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	96.7	6.820000000000001e-21	NR	CAD5118217.1	2664684	g18213	i0	53.5	1.32558139534884	71	33	70.8	0	301	89	402	472	CAD5118217.1 DgyrCDS6940 [Dimorphilus gyrociliatus]	diamond	399	96.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
28913555	28913555	PRJNA683669_P_NODE_9928_length_407_cov_0.922156_g9697_i0	PRJNA683669	9928	407	0.922156	3.75317492	Capitella teleta	283909	Annelida	Annelida	91.7	1.98e-18	NR	ELT93907.1	283909	g9697	i0	39.8	8.24815724815725	118	64	87	2	355	2	4353	4463	ELT93907.1 hypothetical protein CAPTEDRAFT_183261 [Capitella teleta]	diamond	3357	91.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
29766129	29766129	PRJNA683669_P_NODE_17411_length_310_cov_2.088608_g17179_i0	PRJNA683669	17411	310	2.088608	6.4746848	Paralvinella palmiformis	53620	Annelida	Annelida	119	1.06e-28	NR	KAK2156448.1	53620	g17179	i0	64.9	0.909677419354839	94	33	91	0	27	308	47	140	KAK2156448.1 hypothetical protein LSH36_213g04001 [Paralvinella palmiformis]	diamond	282	119	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30019161	30019161	PRJNA683669_P_NODE_7871_length_456_cov_1.185379_g7640_i0	PRJNA683669	7871	456	1.185379	5.40532824	Eisenia fetida	6396	Annelida	Annelida	95.9	2.44e-21	NR	ADV57678.1	6396	g7640	i0	38.8	2.00657894736842	139	77	88.8	3	437	33	1	135	ADV57678.1 glutathione S-transferase [Eisenia fetida]	diamond	915	95.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Eisenia	Eisenia fetida
30998483	30998483	PRJNA683669_P_NODE_22934_length_271_cov_0.782828_g22702_i0	PRJNA683669	22934	271	0.782828	2.12146388	Paralvinella palmiformis	53620	Annelida	Annelida	108	5.830000000000001e-26	NR	KAK2165373.1	53620	g22702	i0	55.1	0.985239852398524	89	40	98.5	0	270	4	204	292	KAK2165373.1 hypothetical protein LSH36_51g03067 [Paralvinella palmiformis]	diamond	267	108	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
31673934	31673934	PRJNA683669_P_NODE_597_length_1500_cov_2.717589_g519_i0	PRJNA683669	597	1500	2.717589	40.763835	Metazoa	33208	Annelida	Annelida	126	1.05e-27	NR	CAH1785778.1	6347	g519	i0	41.7	1.97	163	91	32.6	1	391	879	2	160	CAH1785778.1 unnamed protein product [Owenia fusiformis]	diamond	2955	127	0.992125984251969	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
31725613	31725613	PRJNA683669_P_NODE_5417_length_554_cov_1.920998_g5189_i0	PRJNA683669	5417	554	1.920998	10.64232892	Owenia fusiformis	6347	Annelida	Annelida	57	8.13e-6	NR	CAH1798153.1	6347	g5189	i0	27.8	1.37545126353791	126	80	63.9	5	548	195	157	279	CAH1798153.1 unnamed protein product [Owenia fusiformis]	diamond	762	57	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
32180379	32180379	PRJNA683669_P_NODE_29058_length_247_cov_1.327586_g28826_i0	PRJNA683669	29058	247	1.327586	3.27913742	Metazoa	33208	Annelida	Annelida	138	8.849999999999999e-37	NR	CAH1795717.1	6347	g28826	i0	78	51.7894736842105	82	18	99.6	0	247	2	258	339	CAH1795717.1 unnamed protein product [Owenia fusiformis]	diamond	12792	139	0.992805755395683	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
32674130	32674130	PRJNA683669_P_NODE_18020_length_305_cov_1.142241_g17788_i0	PRJNA683669	18020	305	1.142241	3.48383505	Lamellibrachia satsuma	104711	Annelida	Annelida	50.8	8.49e-5	NR	KAI0212934.1	104711	g17788	i0	32.6	0.875409836065574	89	60	87.5	0	303	37	162	250	KAI0212934.1 hypothetical protein LSAT2_002070 [Lamellibrachia satsuma]	diamond	267	50.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma

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