metadata: contig_metadata: 9 rows where bioproject = "PRJNA278119", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJNA278119", tax_kingdom = "Metazoa" 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
15674296	15674296	PRJNA278119_P_NODE_8133_length_416_cov_1.340599_g7886_i0	PRJNA278119	8133	416	1.340599	5.57689184	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	134	8.28e-38	NR	KAI0216282.1	104711	g7886	i0	74.4	36.09375	82	21	59.1	0	108	353	23	104	KAI0216282.1 U6 snRNA-associated Sm-like protein LSm6 [Lamellibrachia satsuma]	diamond	15015	134	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
17636488	17636488	PRJNA278119_P_NODE_39514_length_166_cov_1.333333_g39265_i0	PRJNA278119	39514	166	1.333333	2.21333278	Metazoa	33208	Annelida	Annelida	54.7	0.004	NTclustered	gi\|2918369620\|emb\|OZ237782.1\|	311461	g39265	i0	100	0.686746987951807	29	0	17	0	136	164	2124497	2124469	Hirudo verbana genome assembly, chromosome: 4	blastn	114	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
18223250	18223250	PRJNA278119_P_NODE_6935_length_452_cov_2.307692_g6688_i0	PRJNA278119	6935	452	2.307692	10.43076784	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	181	9.739999999999997e-55	NR	CAH1780222.1	6347	g6688	i0	92.8	65.6615044247788	97	7	64.4	0	292	2	50	146	CAH1780222.1 unnamed protein product [Owenia fusiformis]	diamond	29679	182	0.994505494505495	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
19497294	19497294	PRJNA278119_P_NODE_34176_length_170_cov_1.247934_g33927_i0	PRJNA278119	34176	170	1.247934	2.1214878	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	54.7	0.004	NTclustered	gi\|2920003371\|emb\|OZ238862.1\|	1046305	g33927	i0	100	0.170588235294118	29	0	17	0	89	117	28761016	28761044	Ailoscolex lacteospumosus genome assembly, chromosome: 3	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
28937387	28937387	PRJNA278119_P_NODE_37308_length_168_cov_0.873950_g37059_i0	PRJNA278119	37308	168	0.87395	1.468236	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	68.2	2.87e-12	NR	CAD5110758.1	2664684	g37059	i0	56.4	4.83928571428571	55	24	98.2	0	167	3	83	137	CAD5110758.1 DgyrCDS126 [Dimorphilus gyrociliatus]	diamond	813	68.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
28986822	28986822	PRJNA278119_P_NODE_44408_length_163_cov_1.824561_g44159_i0	PRJNA278119	44408	163	1.824561	2.97403443	Metazoa	33208	Annelida	Annelida	52	6.9e-6	NR	CAH1799035.1	6347	g44159	i0	52	4.32515337423313	50	19	88.3	3	4	147	17	63	CAH1799035.1 unnamed protein product [Owenia fusiformis]	diamond	705	52	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29821105	29821105	PRJNA278119_P_NODE_21851_length_212_cov_1.134969_g21602_i0	PRJNA278119	21851	212	1.134969	2.40613428	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	103	3.87e-24	NR	CAD5119267.1	2664684	g21602	i0	69.6	2.91509433962264	69	21	97.6	0	3	209	124	192	CAD5119267.1 DgyrCDS7896 [Dimorphilus gyrociliatus]	diamond	618	103	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
31685798	31685798	PRJNA278119_P_NODE_10157_length_366_cov_3.353312_g9910_i0	PRJNA278119	10157	366	3.353312	12.27312192	Owenia fusiformis	6347	Annelida	Annelida	55.5	4.98e-6	NR	CAH1794709.1	6347	g9910	i0	48.9	0.680327868852459	47	24	38.5	0	200	60	261	307	CAH1794709.1 unnamed protein product [Owenia fusiformis]	diamond	249	55.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
31875603	31875603	PRJNA278119_P_NODE_34537_length_169_cov_1.300000_g34288_i0	PRJNA278119	34537	169	1.3	2.197	Capitella teleta	283909	Annelida	Annelida	64.7	2.46e-10	NR	ELU17350.1	283909	g34288	i0	47.3	3.92307692307692	55	28	97.6	1	4	168	175	228	ELU17350.1 hypothetical protein CAPTEDRAFT_154594 [Capitella teleta]	diamond	663	64.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta

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