metadata: contig_metadata: 8 rows where bioproject = "PRJNA576995", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA576995", 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
1836200	1836200	PRJNA576995_P_NODE_33342_length_259_cov_1.241935_g32750_i0	PRJNA576995	33342	259	1.241935	3.21661165	Owenia fusiformis	6347	Annelida	Annelida	89.4	1.07e-20	NR	CAH1787134.1	6347	g32750	i0	69	2.46718146718147	71	22	82.2	0	214	2	1	71	CAH1787134.1 unnamed protein product [Owenia fusiformis]	diamond	639	89.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
6240550	6240550	PRJNA576995_P_NODE_32165_length_266_cov_1.595855_g31573_i0	PRJNA576995	32165	266	1.595855	4.2449743	Metazoa	33208	Annelida	Annelida	130	9.26e-37	NR	UCK81569.1	6344	g31573	i0	77.4	41.8646616541353	84	19	94.7	0	254	3	1	84	UCK81569.1 histone H2A [Arenicola marina]	diamond	11136	131	0.99236641221374	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
10765084	10765084	PRJNA576995_P_NODE_36669_length_249_cov_0.875000_g36077_i0	PRJNA576995	36669	249	0.875	2.17875	Enchytraeus buchholzi	34589	Annelida	Annelida	449	6.840000000000001e-122	NTclustered	gi\|2868818994\|dbj\|LC855137.1\|	34589	g36077	i0	99.197	20.8192771084337	249	2	100	0	1	249	103	351	Enchytraeus buchholzi IDEA_Annelid009 gene for 28S rRNA, partial sequence	blastn	5184	449	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Enchytraeida	Enchytraeidae	Enchytraeus	Enchytraeus buchholzi
15863671	15863671	PRJNA576995_P_NODE_7053_length_600_cov_1.077799_g6469_i0	PRJNA576995	7053	600	1.077799	6.466794	Hirudo verbana	311461	Annelida	Annelida	58.4	0.001	NTclustered	gi\|2918369620\|emb\|OZ237782.1\|	311461	g6469	i0	94.737	1.125	38	1	6	1	99	136	11765341	11765377	Hirudo verbana genome assembly, chromosome: 4	blastn	675	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
30946360	30946360	PRJNA576995_P_NODE_31734_length_269_cov_1.178571_g31142_i0	PRJNA576995	31734	269	1.178571	3.17035599	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	104	1.1e-23	NR	KAI0209478.1	104711	g31142	i0	55.6	2.98884758364312	90	39	99.3	1	269	3	170	259	KAI0209478.1 Tubulin polyglutamylase TTLL11 [Lamellibrachia satsuma]	diamond	804	105	0.990476190476191	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
31452143	31452143	PRJNA576995_P_NODE_34996_length_251_cov_0.865169_g34404_i0	PRJNA576995	34996	251	0.865169	2.17157419	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	67.8	6.07e-11	NR	CAH1779152.1	6347	g34404	i0	38.6	3.02390438247012	83	46	99.2	2	251	3	151	228	CAH1779152.1 unnamed protein product [Owenia fusiformis]	diamond	759	68.2	0.994134897360704	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
32545927	32545927	PRJNA576995_P_NODE_37959_length_248_cov_0.880000_g37367_i0	PRJNA576995	37959	248	0.88	2.1824	Capitella teleta	283909	Annelida	Annelida	78.6	9.72e-15	NR	ELT94199.1	283909	g37367	i0	44.9	3.75	78	39	94.4	1	239	6	116	189	ELT94199.1 hypothetical protein CAPTEDRAFT_155802 [Capitella teleta]	diamond	930	78.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
32577456	32577456	PRJNA576995_P_NODE_20539_length_333_cov_1.669231_g19947_i0	PRJNA576995	20539	333	1.669231	5.55853923	Capitella teleta	283909	Annelida	Annelida	102	2.26e-23	NR	ELU13384.1	283909	g19947	i0	50	2.92792792792793	110	37	99.1	3	3	332	153	244	ELU13384.1 hypothetical protein CAPTEDRAFT_155317 [Capitella teleta]	diamond	975	102	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);;