metadata: contig_metadata: 13 rows where bioproject = "PRJNA738523" and tax

13 rows where bioproject = "PRJNA738523" 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
9647965	9647965	PRJNA738523_P_NODE_15468_length_242_cov_0.911243_g15397_i0	PRJNA738523	15468	242	0.911243	2.20520806	Hirudo verbana	311461	Annelida	Annelida	62.1	3.62e-5	NTclustered	gi\|2918369718\|emb\|OZ237791.1\|	311461	g15397	i0	89.796	1.74380165289256	49	4	20	1	25	73	8828144	8828191	Hirudo verbana genome assembly, chromosome: 13	blastn	422	62.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
12198941	12198941	PRJNA738523_P_NODE_5350_length_311_cov_0.966387_g5279_i0	PRJNA738523	5350	311	0.966387	3.00546357	Hirudo verbana	311461	Annelida	Annelida	69.4	2.89e-7	NTclustered	gi\|2918369714\|emb\|OZ237790.1\|	311461	g5279	i0	87.302	12.8810289389068	63	4	19	3	6	64	426261	426199	Hirudo verbana genome assembly, chromosome: 12	blastn	4006	69.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
13473366	13473366	PRJNA738523_P_NODE_14211_length_244_cov_1.801170_g14140_i0	PRJNA738523	14211	244	1.80117	4.3948548	Hirudo verbana	311461	Annelida	Annelida	167	7.529999999999998e-37	NTclustered	gi\|2918369702\|emb\|OZ237787.1\|	311461	g14140	i0	91.129	20.3401639344262	124	10	52	1	3	126	5167086	5167208	Hirudo verbana genome assembly, chromosome: 9	blastn	4963	167	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
13473386	13473386	PRJNA738523_P_NODE_2531_length_412_cov_2.253687_g2460_i0	PRJNA738523	2531	412	2.253687	9.28519044	Helobdella robusta	6412	Annelida	Annelida	313	1.64e-80	NTclustered	gi\|675872871\|ref\|XM_009023748.1\|	6412	g2460	i0	80.693	43.2936893203884	404	76	98	2	5	407	427	25	Helobdella robusta hypothetical protein partial mRNA	blastn	17837	313	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
14748467	14748467	PRJNA738523_P_NODE_15732_length_242_cov_0.911243_g15661_i0	PRJNA738523	15732	242	0.911243	2.20520806	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.022	NTclustered	gi\|2920003323\|emb\|OZ238861.1\|	1046305	g15661	i0	100	0.115702479338843	28	0	12	0	94	121	33627857	33627830	Ailoscolex lacteospumosus genome assembly, chromosome: 2	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
21599930	21599930	PRJNA738523_P_NODE_7517_length_279_cov_1.121359_g7446_i0	PRJNA738523	7517	279	1.121359	3.12859161	Clitellata	42113	Annelida	Annelida	146	1.07e-40	NR	WVD50229.1	6386	g7446	i0	75.3	7	93	23	100	0	1	279	121	213	WVD50229.1 glyceraldehyde-3-phosphate dehydrogenase [Tubifex tubifex]	diamond	1953	146	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Tubifex	Tubifex tubifex
24945978	24945978	PRJNA738523_P_NODE_14260_length_244_cov_1.444444_g14189_i0	PRJNA738523	14260	244	1.444444	3.52444336	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	69.4	2.19e-7	NTclustered	gi\|2920003323\|emb\|OZ238861.1\|	1046305	g14189	i0	95.349	14.2622950819672	43	2	18	0	1	43	3194798	3194840	Ailoscolex lacteospumosus genome assembly, chromosome: 2	blastn	3480	69.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
26704075	26704075	PRJNA738523_P_NODE_5801_length_301_cov_1.688596_g5730_i0	PRJNA738523	5801	301	1.688596	5.08267396	Arenicola marina	6344	Annelida	Annelida	73.2	2.08e-13	NR	ABW23137.1	6344	g5730	i0	64.2	2.08305647840532	53	19	52.8	0	2	160	147	199	ABW23137.1 ribosomal protein rps3a, partial [Arenicola marina]	diamond	627	73.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
26936001	26936001	PRJNA738523_P_NODE_5842_length_300_cov_1.850220_g5771_i0	PRJNA738523	5842	300	1.85022	5.55066	root	1	Root_unresolved	Root_unresolved	102	8.98e-25	NR	XP_009020778.1	6412	g5771	i0	70.5	15.79	61	18	61	0	117	299	1	61	XP_009020778.1 hypothetical protein HELRODRAFT_185729 [Helobdella robusta]	diamond	4737	103	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
28483889	28483889	PRJNA738523_P_NODE_16306_length_241_cov_0.916667_g16235_i0	PRJNA738523	16306	241	0.916667	2.20916747	Metazoa	33208	Annelida	Annelida	43.5	0.0184	NR	CAH1776380.1	6347	g16235	i0	48.3	2.36514522821577	29	15	36.1	0	227	141	385	413	CAH1776380.1 unnamed protein product [Owenia fusiformis]	diamond	570	43.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
31284693	31284693	PRJNA738523_P_NODE_6755_length_286_cov_1.906103_g6684_i0	PRJNA738523	6755	286	1.906103	5.45145458	Ridgeia piscesae	27915	Annelida	Annelida	69.7	1.57e-11	NR	KAK2163497.1	27915	g6684	i0	38.8	1.82517482517483	85	52	89.2	0	281	27	233	317	KAK2163497.1 hypothetical protein NP493_1459g00022 [Ridgeia piscesae]	diamond	522	69.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
31822323	31822323	PRJNA738523_P_NODE_11877_length_249_cov_0.875000_g11806_i0	PRJNA738523	11877	249	0.875	2.17875	Helobdella robusta	6412	Annelida	Annelida	89	9.67e-19	NR	XP_009031044.1	6412	g11806	i0	56.5	4.96385542168675	85	34	98.8	1	246	1	76	160	XP_009031044.1 hypothetical protein HELRODRAFT_186207 [Helobdella robusta]	diamond	1236	89	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
32812258	32812258	PRJNA738523_P_NODE_15800_length_241_cov_2.244048_g15729_i0	PRJNA738523	15800	241	2.244048	5.40815568	Metazoa	33208	Annelida	Annelida	52.4	6.74e-6	NR	CAH1783075.1	6347	g15729	i0	57.5	6.13692946058091	40	17	49.8	0	2	121	144	183	CAH1783075.1 unnamed protein product, partial [Owenia fusiformis]	diamond	1479	52.4	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);;