metadata: contig_metadata: 7 rows where bioproject = "PRJNA312615", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA312615", 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
4205249	4205249	PRJNA312615_P_NODE_24504_length_247_cov_1.030303_g24353_i0	PRJNA312615	24504	247	1.030303	2.54484841	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	124	1.24e-32	NR	XP_009025699.1	6412	g24353	i0	73.2	20.914979757085	82	22	99.6	0	246	1	57	138	XP_009025699.1 hypothetical protein HELRODRAFT_107583 [Helobdella robusta]	diamond	5166	124	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
16956211	16956211	PRJNA312615_P_NODE_774_length_1085_cov_5.687259_g690_i0	PRJNA312615	774	1085	5.687259	61.70676015	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	276	4.739999999999999e-87	NR	AAN28680.1	13286	g690	i0	48.6	3.54193548387097	348	144	88.2	13	66	1022	10	351	AAN28680.1 cathepsin L [Theromyzon tessulatum]	diamond	3843	278	0.992805755395683	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Theromyzon	Theromyzon tessulatum
19504707	19504707	PRJNA312615_P_NODE_58536_length_159_cov_4.254545_g58385_i0	PRJNA312615	58536	159	4.254545	6.76472655	Hirudo verbana	311461	Annelida	Annelida	52.8	0.013	NTclustered	gi\|2918369693\|emb\|OZ237785.1\|	311461	g58385	i0	100	0.176100628930818	28	0	18	0	132	159	2652876	2652849	Hirudo verbana genome assembly, chromosome: 7	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
24603803	24603803	PRJNA312615_P_NODE_12580_length_348_cov_2.936455_g12430_i0	PRJNA312615	12580	348	2.936455	10.2188634	Hirudo verbana	311461	Annelida	Annelida	54.7	0.009	NTclustered	gi\|2918369621\|emb\|OZ237783.1\|	311461	g12430	i0	96.875	0.0919540229885057	32	1	9	0	268	299	4545125	4545094	Hirudo verbana genome assembly, chromosome: 5	blastn	32	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
28463996	28463996	PRJNA312615_P_NODE_42366_length_188_cov_1.359712_g42215_i0	PRJNA312615	42366	188	1.359712	2.55625856	Paralvinella palmiformis	53620	Annelida	Annelida	67	6.6e-12	NR	KAK2140823.1	53620	g42215	i0	72.2	0.574468085106383	36	10	57.4	0	2	109	78	113	KAK2140823.1 hypothetical protein LSH36_1235g00010 [Paralvinella palmiformis]	diamond	108	67	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
29018485	29018485	PRJNA312615_P_NODE_38888_length_197_cov_1.033784_g38737_i0	PRJNA312615	38888	197	1.033784	2.03655448	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	67.4	4.01e-11	NR	ELU07510.1	283909	g38737	i0	47.6	6.7005076142132	63	32	95.9	1	5	193	44	105	ELU07510.1 hypothetical protein CAPTEDRAFT_122289, partial [Capitella teleta]	diamond	1320	67.8	0.994100294985251	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
29523377	29523377	PRJNA312615_P_NODE_41990_length_189_cov_1.178571_g41839_i0	PRJNA312615	41990	189	1.178571	2.22749919	Opisthokonta	33154	Annelida	Annelida	52	9.52e-6	NR	KAI0211303.1	104711	g41839	i0	40.3	5.82539682539683	62	36	96.8	1	5	187	117	178	KAI0211303.1 hypothetical protein LSAT2_003880 [Lamellibrachia satsuma]	diamond	1101	52	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma

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