metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1035005" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1035005" 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
15471501	15471501	PRJNA1035005_P_NODE_1513_length_1025_cov_4.545168_g1199_i0	PRJNA1035005	1513	1025	4.545168	46.587972	Metazoa	33208	Annelida	Annelida	281	8.75e-90	NR	XP_009025699.1	6412	g1199	i0	63.4	10.510243902439	246	81	69.4	2	32	742	1	246	XP_009025699.1 hypothetical protein HELRODRAFT_107583 [Helobdella robusta]	diamond	10773	281	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
20570144	20570144	PRJNA1035005_P_NODE_5857_length_441_cov_1.271739_g5457_i0	PRJNA1035005	5857	441	1.271739	5.60836899	Metazoa	33208	Annelida	Annelida	215	2.11e-62	NR	KAK2164859.1	53620	g5457	i0	75.3	6.97278911564626	146	33	99.3	2	441	4	460	602	KAK2164859.1 hypothetical protein LSH36_58g18051 [Paralvinella palmiformis]	diamond	3075	215	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
27058800	27058800	PRJNA1035005_P_NODE_46362_length_261_cov_1.925532_g45956_i0	PRJNA1035005	46362	261	1.925532	5.02563852	Metazoa	33208	Annelida	Annelida	73.2	9.26e-13	NR	CAH1786227.1	6347	g45956	i0	44.7	7.11494252873563	94	37	100	3	261	1	203	288	CAH1786227.1 unnamed protein product [Owenia fusiformis]	diamond	1857	73.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27288002	27288002	PRJNA1035005_P_NODE_11183_length_352_cov_1.118280_g10778_i0	PRJNA1035005	11183	352	1.11828	3.9363456	Lamellibrachia satsuma	104711	Annelida	Annelida	117	2.37e-28	NR	KAI0235029.1	104711	g10778	i0	55.8	2.88920454545455	113	46	96.3	3	8	346	97	205	KAI0235029.1 hypothetical protein LSAT2_014572 [Lamellibrachia satsuma]	diamond	1017	117	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
27375203	27375203	PRJNA1035005_P_NODE_28103_length_285_cov_1.457547_g27697_i0	PRJNA1035005	28103	285	1.457547	4.15400895	Metazoa	33208	Annelida	Annelida	56.6	8.24e-7	NR	KAK2181249.1	27915	g27697	i0	42.1	3.56842105263158	76	42	77.9	1	9	230	748	823	KAK2181249.1 hypothetical protein NP493_405g05002 [Ridgeia piscesae]	diamond	1017	56.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
29174757	29174757	PRJNA1035005_P_NODE_5509_length_453_cov_1.228947_g5109_i0	PRJNA1035005	5509	453	1.228947	5.56712991	Metazoa	33208	Annelida	Annelida	158	2.38e-44	NR	ELU13384.1	283909	g5109	i0	55.1	19.0596026490066	147	48	97.4	3	452	12	116	244	ELU13384.1 hypothetical protein CAPTEDRAFT_155317 [Capitella teleta]	diamond	8634	158	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
30975155	30975155	PRJNA1035005_P_NODE_2254_length_777_cov_5.867898_g1882_i0	PRJNA1035005	2254	777	5.867898	45.59356746	Sabellida	6362	Annelida	Annelida	199	1.96e-60	NR	CAH1784699.1	6347	g1882	i0	54.5	11.8648648648649	191	81	73.7	2	44	616	1	185	CAH1784699.1 unnamed protein product [Owenia fusiformis]	diamond	9219	199	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
31299038	31299038	PRJNA1035005_P_NODE_14195_length_328_cov_1.992157_g13789_i0	PRJNA1035005	14195	328	1.992157	6.53427496	Owenia fusiformis	6347	Annelida	Annelida	113	1.29e-26	NR	CAH1802338.1	6347	g13789	i0	52.3	0.996951219512195	109	48	99.7	3	2	328	395	499	CAH1802338.1 unnamed protein product [Owenia fusiformis]	diamond	327	113	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
32153239	32153239	PRJNA1035005_P_NODE_20678_length_298_cov_0.937778_g20272_i0	PRJNA1035005	20678	298	0.937778	2.79457844	Owenia fusiformis	6347	Annelida	Annelida	68.9	4.55e-11	NR	CAH1795822.1	6347	g20272	i0	36.4	0.996644295302013	99	46	99.7	1	297	1	713	794	CAH1795822.1 unnamed protein product, partial [Owenia fusiformis]	diamond	297	68.9	1	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);;