metadata: contig_metadata: 10 rows where bioproject = "PRJNA1087264", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA1087264", tax_clade = "Opisthokonta" 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
20595166	20595166	PRJNA1087264_P_NODE_6777_length_243_cov_1.314433_g6695_i0	PRJNA1087264	6777	243	1.314433	3.19407219	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.022	NTclustered	gi\|2920003371\|emb\|OZ238862.1\|	1046305	g6695	i0	100	0.11522633744856	28	0	12	0	77	104	39084712	39084685	Ailoscolex lacteospumosus genome assembly, chromosome: 3	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
24419849	24419849	PRJNA1087264_P_NODE_14960_length_167_cov_0.864407_g14878_i0	PRJNA1087264	14960	167	0.864407	1.44355969	Hirudo verbana	311461	Annelida	Annelida	54.7	0.004	NTclustered	gi\|2918369718\|emb\|OZ237791.1\|	311461	g14878	i0	100	1.03592814371257	29	0	17	0	59	87	2186329	2186357	Hirudo verbana genome assembly, chromosome: 13	blastn	173	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
26624296	26624296	PRJNA1087264_P_NODE_8641_length_214_cov_2.303030_g8559_i0	PRJNA1087264	8641	214	2.30303	4.9284842	Owenia fusiformis	6347	Annelida	Annelida	65.1	3.39e-10	NR	CAH1788364.1	6347	g8559	i0	48.4	2.66355140186916	62	29	86.9	1	198	13	571	629	CAH1788364.1 unnamed protein product [Owenia fusiformis]	diamond	570	65.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
26814454	26814454	PRJNA1087264_P_NODE_15821_length_166_cov_0.871795_g15739_i0	PRJNA1087264	15821	166	0.871795	1.4471797	Owenia fusiformis	6347	Annelida	Annelida	69.3	5.34e-12	NR	CAH1777627.1	6347	g15739	i0	62.3	26.6566265060241	53	20	95.8	0	161	3	669	721	CAH1777627.1 unnamed protein product [Owenia fusiformis]	diamond	4425	69.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
26940861	26940861	PRJNA1087264_P_NODE_7262_length_234_cov_1.102703_g7180_i0	PRJNA1087264	7262	234	1.102703	2.58032502	Helobdella robusta	6412	Annelida	Annelida	58.9	5.3e-8	NR	XP_009020629.1	6412	g7180	i0	47.1	0.871794871794872	68	33	87.2	1	6	209	229	293	XP_009020629.1 hypothetical protein HELRODRAFT_185715 [Helobdella robusta]	diamond	204	58.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
28235815	28235815	PRJNA1087264_P_NODE_11086_length_190_cov_0.936170_g11004_i0	PRJNA1087264	11086	190	0.93617	1.778723	Owenia fusiformis	6347	Annelida	Annelida	77.4	1.76e-15	NR	CAH1776593.1	6347	g11004	i0	46.7	3.85263157894737	60	32	94.7	0	186	7	161	220	CAH1776593.1 unnamed protein product [Owenia fusiformis]	diamond	732	77.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29404386	29404386	PRJNA1087264_P_NODE_6909_length_241_cov_0.791667_g6827_i0	PRJNA1087264	6909	241	0.791667	1.90791747	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	69.3	1.51e-11	NR	CAD5123542.1	2664684	g6827	i0	50.6	1.05809128630705	85	33	95.9	3	236	6	151	234	CAD5123542.1 DgyrCDS11882 [Dimorphilus gyrociliatus]	diamond	255	69.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
30312208	30312208	PRJNA1087264_P_NODE_3112_length_374_cov_2.036923_g3031_i0	PRJNA1087264	3112	374	2.036923	7.61809202	Opisthokonta	33154	Annelida	Annelida	169	1.88e-50	NR	XP_009018646.1	6412	g3031	i0	66.7	22.9090909090909	111	37	89	0	335	3	12	122	XP_009018646.1 hypothetical protein HELRODRAFT_185659 [Helobdella robusta]	diamond	8568	170	0.994117647058824	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
31101458	31101458	PRJNA1087264_P_NODE_16175_length_166_cov_0.871795_g16093_i0	PRJNA1087264	16175	166	0.871795	1.4471797	Metazoa	33208	Annelida	Annelida	96.7	1.36e-21	NR	CAH1772586.1	6347	g16093	i0	75.9	19.5903614457831	54	13	97.6	0	166	5	223	276	CAH1772586.1 unnamed protein product [Owenia fusiformis]	diamond	3252	96.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
32565569	32565569	PRJNA1087264_P_NODE_11979_length_182_cov_1.533835_g11897_i0	PRJNA1087264	11979	182	1.533835	2.7915797	Helobdella robusta	6412	Annelida	Annelida	74.7	4.83e-16	NR	XP_009015833.1	6412	g11897	i0	76.9	7.73076923076923	52	12	85.7	0	162	7	1	52	XP_009015833.1 hypothetical protein HELRODRAFT_64261 [Helobdella robusta]	diamond	1407	74.7	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);;