metadata: contig_metadata: 15 rows where bioproject = "PRJNA657343", tax_kingdom = "Metazoa" and tax

15 rows where bioproject = "PRJNA657343", 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
7001543	7001543	PRJNA657343_P_NODE_2286_length_460_cov_10.021898_g2263_i0	PRJNA657343	2286	460	10.021898	46.1007308	Metazoa	33208	Annelida	Annelida	200	8.68e-63	NR	KAI0216520.1	104711	g2263	i0	72	50.1195652173913	132	37	86.1	0	19	414	33	164	KAI0216520.1 40S ribosomal protein S15a [Lamellibrachia satsuma]	diamond	23055	202	0.99009900990099	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
12102461	12102461	PRJNA657343_P_NODE_31090_length_176_cov_3.559055_g31066_i0	PRJNA657343	31090	176	3.559055	6.2639368	Hirudo verbana	311461	Annelida	Annelida	54.7	0.004	NTclustered	gi\|2918369613\|emb\|OZ237779.1\|	311461	g31066	i0	100	0.323863636363636	29	0	16	0	80	108	2010425	2010397	Hirudo verbana genome assembly, chromosome: 1	blastn	57	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
14652084	14652084	PRJNA657343_P_NODE_3892_length_380_cov_3.302115_g3869_i0	PRJNA657343	3892	380	3.302115	12.548037	Helobdella robusta	6412	Annelida	Annelida	170	3.58e-51	NR	XP_009022737.1	6412	g3869	i0	76.1	10.3973684210526	113	25	89.2	1	41	379	1	111	XP_009022737.1 hypothetical protein HELRODRAFT_155894 [Helobdella robusta]	diamond	3951	170	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
15188941	15188941	PRJNA657343_P_NODE_44192_length_162_cov_0.920354_g44168_i0	PRJNA657343	44192	162	0.920354	1.49097348	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	96.7	2.85e-24	NR	ABW23184.1	6344	g44168	i0	88.2	15.1851851851852	51	6	94.4	0	156	4	55	105	ABW23184.1 ribosomal protein rpl30 [Arenicola marina]	diamond	2460	96.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
18475256	18475256	PRJNA657343_P_NODE_26015_length_188_cov_2.841727_g25991_i0	PRJNA657343	26015	188	2.841727	5.34244676	Hirudo verbana	311461	Annelida	Annelida	54.7	0.004	NTclustered	gi\|2918369613\|emb\|OZ237779.1\|	311461	g25991	i0	96.875	0.335106382978723	32	1	17	0	119	150	12958753	12958784	Hirudo verbana genome assembly, chromosome: 1	blastn	63	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
22300185	22300185	PRJNA657343_P_NODE_21518_length_202_cov_1.000000_g21494_i0	PRJNA657343	21518	202	1	2.02	Opisthokonta	33154	Annelida	Annelida	95.5	3.56e-21	NR	ELU14716.1	283909	g21494	i0	69.4	12.0594059405941	62	19	92.1	0	198	13	44	105	ELU14716.1 hypothetical protein CAPTEDRAFT_158431 [Capitella teleta]	diamond	2436	95.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
27144126	27144126	PRJNA657343_P_NODE_19282_length_210_cov_1.875776_g19258_i0	PRJNA657343	19282	210	1.875776	3.9391296	Owenia fusiformis	6347	Annelida	Annelida	80.9	4.23e-16	NR	CAH1791660.1	6347	g19258	i0	53.6	0.985714285714286	69	32	98.6	0	209	3	166	234	CAH1791660.1 unnamed protein product [Owenia fusiformis]	diamond	207	80.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27599268	27599268	PRJNA657343_P_NODE_47824_length_150_cov_4.118812_g47800_i0	PRJNA657343	47824	150	4.118812	6.178218	Metazoa	33208	Annelida	Annelida	52.4	2.2e-6	NR	CAH1794262.1	6347	g47800	i0	54	6.94	50	21	98	2	148	2	69	117	CAH1794262.1 unnamed protein product, partial [Owenia fusiformis]	diamond	1041	52.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28534274	28534274	PRJNA657343_P_NODE_2027_length_481_cov_1.423611_g2004_i0	PRJNA657343	2027	481	1.423611	6.84756891	Capitella teleta	283909	Annelida	Annelida	183	1.71e-56	NR	ELT92933.1	283909	g2004	i0	68.3	8.77546777546778	126	40	78.6	0	65	442	13	138	ELT92933.1 hypothetical protein CAPTEDRAFT_183334 [Capitella teleta]	diamond	4221	183	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
28597363	28597363	PRJNA657343_P_NODE_25267_length_190_cov_1.773050_g25243_i0	PRJNA657343	25267	190	1.77305	3.368795	Owenia fusiformis	6347	Annelida	Annelida	60.1	1.41e-8	NR	CAH1790760.1	6347	g25243	i0	40.3	0.978947368421053	62	34	93.2	1	184	8	183	244	CAH1790760.1 unnamed protein product, partial [Owenia fusiformis]	diamond	186	60.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29701960	29701960	PRJNA657343_P_NODE_34150_length_170_cov_2.181818_g34126_i0	PRJNA657343	34150	170	2.181818	3.7090906	Platynereis dumerilii	6359	Annelida	Annelida	86.7	1.08e-18	NR	CAJ38798.1	6359	g34126	i0	71.4	2.96470588235294	56	16	98.8	0	169	2	197	252	CAJ38798.1 4-hydroxyphenylpyruvate dioxygenase protein, partial [Platynereis dumerilii]	diamond	504	86.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Platynereis	Platynereis dumerilii
29777576	29777576	PRJNA657343_P_NODE_39711_length_165_cov_2.560345_g39687_i0	PRJNA657343	39711	165	2.560345	4.22456925	Opisthokonta	33154	Annelida	Annelida	47.4	1.18e-4	NR	KAK2162878.1	53620	g39687	i0	48.9	3.27272727272727	45	23	81.8	0	151	17	56	100	KAK2162878.1 hypothetical protein LSH36_90g06003 [Paralvinella palmiformis]	diamond	540	47.8	0.99163179916318	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30144173	30144173	PRJNA657343_P_NODE_15852_length_226_cov_2.497175_g15828_i0	PRJNA657343	15852	226	2.497175	5.6436155	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	98.2	1.0300000000000001e-22	NR	CAD5124475.1	2664684	g15828	i0	71.4	0.836283185840708	63	18	83.6	0	3	191	154	216	CAD5124475.1 unnamed protein product [Dimorphilus gyrociliatus]	diamond	189	98.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
30334532	30334532	PRJNA657343_P_NODE_14272_length_235_cov_2.086022_g14248_i0	PRJNA657343	14272	235	2.086022	4.9021517	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	88.2	1.49e-19	NR	CAD5125058.1	2664684	g14248	i0	55.1	1.81276595744681	69	31	88.1	0	24	230	82	150	CAD5125058.1 unnamed protein product [Dimorphilus gyrociliatus]	diamond	426	88.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
30378324	30378324	PRJNA657343_P_NODE_28272_length_183_cov_1.477612_g28248_i0	PRJNA657343	28272	183	1.477612	2.70402996	Metazoa	33208	Annelida	Annelida	82.8	1.23e-16	NR	CAH1786802.1	6347	g28248	i0	59.3	5.80327868852459	59	24	96.7	0	5	181	448	506	CAH1786802.1 unnamed protein product [Owenia fusiformis]	diamond	1062	83.2	0.995192307692308	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis

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