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

8 rows where bioproject = "PRJNA950981", 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
4762237	4762237	PRJNA950981_P_NODE_1324_length_810_cov_1.609227_g1170_i0	PRJNA950981	1324	810	1.609227	13.0347387	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	54.7	0.023	NTclustered	gi\|2920003636\|emb\|OZ238874.1\|	1046305	g1170	i0	100	0.0358024691358025	29	0	4	0	349	377	18635826	18635798	Ailoscolex lacteospumosus genome assembly, chromosome: 15	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
4762281	4762281	PRJNA950981_P_NODE_9164_length_333_cov_1.500000_g8988_i0	PRJNA950981	9164	333	1.5	4.995	Metazoa	33208	Annelida	Annelida	157	5.89e-44	NR	KAK2152681.1	53620	g8988	i0	68.1	17.0720720720721	113	34	100	1	333	1	277	389	KAK2152681.1 hypothetical protein LSH36_321g00017 [Paralvinella palmiformis]	diamond	5685	158	0.993670886075949	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
18785616	18785616	PRJNA950981_P_NODE_18215_length_249_cov_0.886364_g18039_i0	PRJNA950981	18215	249	0.886364	2.20704636	Metazoa	33208	Annelida	Annelida	107	1.37e-25	NR	KAI0221347.1	104711	g18039	i0	63.3	12.3493975903614	79	28	94	1	1	234	192	270	KAI0221347.1 Minor histocompatibility antigen H13 [Lamellibrachia satsuma]	diamond	3075	107	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
21335948	21335948	PRJNA950981_P_NODE_19097_length_247_cov_1.793103_g18921_i0	PRJNA950981	19097	247	1.793103	4.42896441	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	106	3.4899999999999998e-25	NR	KAK2171033.1	27915	g18921	i0	62.2	2.98785425101215	82	30	99.6	1	2	247	167	247	KAK2171033.1 hypothetical protein NP493_1112g00036 [Ridgeia piscesae]	diamond	738	107	0.990654205607477	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
26645469	26645469	PRJNA950981_P_NODE_11521_length_302_cov_1.362445_g11345_i0	PRJNA950981	11521	302	1.362445	4.1145839	Lamellibrachia satsuma	104711	Annelida	Annelida	46.2	0.00368	NR	KAI0213179.1	104711	g11345	i0	36	0.745033112582781	75	46	72.5	2	52	270	7	81	KAI0213179.1 hypothetical protein LSAT2_001823 [Lamellibrachia satsuma]	diamond	225	46.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
26905637	26905637	PRJNA950981_P_NODE_10621_length_313_cov_1.300000_g10445_i0	PRJNA950981	10621	313	1.3	4.069	Metazoa	33208	Annelida	Annelida	71.6	4.86e-13	NR	XP_009028864.1	6412	g10445	i0	46.9	1.84025559105431	98	47	89.1	2	291	13	22	119	XP_009028864.1 hypothetical protein HELRODRAFT_69844, partial [Helobdella robusta]	diamond	576	71.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
27941675	27941675	PRJNA950981_P_NODE_18945_length_248_cov_0.891429_g18769_i0	PRJNA950981	18945	248	0.891429	2.21074392	Ridgeia piscesae	27915	Annelida	Annelida	67	8.68e-11	NR	KAK2192909.1	27915	g18769	i0	38.3	1.95967741935484	81	35	98	1	243	1	109	174	KAK2192909.1 hypothetical protein NP493_20g01010 [Ridgeia piscesae]	diamond	486	67	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
32270330	32270330	PRJNA950981_P_NODE_17418_length_251_cov_0.876404_g17242_i0	PRJNA950981	17418	251	0.876404	2.19977404	Paralvinella palmiformis	53620	Annelida	Annelida	72.4	1.34e-13	NR	KAK2168654.1	53620	g17242	i0	51.9	1.85258964143426	77	35	92	1	236	6	34	108	KAK2168654.1 hypothetical protein LSH36_15g12056 [Paralvinella palmiformis]	diamond	465	72.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis

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