metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA508758" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA508758" 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
11963598	11963598	PRJNA508758_P_NODE_76070_length_250_cov_0.870056_g75022_i0	PRJNA508758	76070	250	0.870056	2.17514	root	1	Root_unresolved	Root_unresolved	175	2.3199999999999994e-54	NR	ABB29582.1	6359	g75022	i0	98.8	234.996	83	1	99.6	0	1	249	8	90	ABB29582.1 cell division control protein 42, partial [Platynereis dumerilii]	diamond	58749	176	0.994318181818182	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Platynereis	Platynereis dumerilii
23436773	23436773	PRJNA508758_P_NODE_12899_length_580_cov_2.605523_g11893_i0	PRJNA508758	12899	580	2.605523	15.1120334	Metazoa	33208	Annelida	Annelida	224	1.46e-64	NR	CAH1793612.1	6347	g11893	i0	74.6	81.9672413793104	142	36	73.4	0	580	155	163	304	CAH1793612.1 unnamed protein product [Owenia fusiformis]	diamond	47541	224	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27772309	27772309	PRJNA508758_P_NODE_53444_length_291_cov_2.477064_g52396_i0	PRJNA508758	53444	291	2.477064	7.20825624	Owenia fusiformis	6347	Annelida	Annelida	62.8	6.1e-9	NR	CAH1774556.1	6347	g52396	i0	39.5	1.75257731958763	86	50	86.6	1	288	37	176	261	CAH1774556.1 unnamed protein product [Owenia fusiformis]	diamond	510	62.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29366274	29366274	PRJNA508758_P_NODE_74409_length_251_cov_0.865169_g73361_i0	PRJNA508758	74409	251	0.865169	2.17157419	Metazoa	33208	Annelida	Annelida	94.7	4.34e-21	NR	KAK2183615.1	27915	g73361	i0	66.2	7.17131474103586	65	22	77.7	0	56	250	5	69	KAK2183615.1 hypothetical protein NP493_305g03029 [Ridgeia piscesae]	diamond	1800	95.1	0.995793901156677	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
29603043	29603043	PRJNA508758_P_NODE_3890_length_1270_cov_2.658312_g3400_i0	PRJNA508758	3890	1270	2.658312	33.7605624	Capitella teleta	283909	Annelida	Annelida	58.5	2.29e-5	NR	ELT89389.1	283909	g3400	i0	44.2	0.181889763779528	77	42	18.2	1	1188	958	77	152	ELT89389.1 hypothetical protein CAPTEDRAFT_219532 [Capitella teleta]	diamond	231	58.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
29666158	29666158	PRJNA508758_P_NODE_44850_length_314_cov_1.597510_g43802_i0	PRJNA508758	44850	314	1.59751	5.0161814	Ridgeia piscesae	27915	Annelida	Annelida	74.3	6.79e-13	NR	KAK2187338.1	27915	g43802	i0	36	4.55732484076433	125	56	96.5	2	311	9	337	461	KAK2187338.1 hypothetical protein NP493_169g04003 [Ridgeia piscesae]	diamond	1431	74.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
29729410	29729410	PRJNA508758_P_NODE_38310_length_335_cov_1.175573_g37262_i0	PRJNA508758	38310	335	1.175573	3.93816955	Helobdella robusta	6412	Annelida	Annelida	89	2.21e-19	NR	XP_009022231.1	6412	g37262	i0	40.6	0.949253731343284	106	63	94.9	0	333	16	51	156	XP_009022231.1 hypothetical protein HELRODRAFT_184769, partial [Helobdella robusta]	diamond	318	89	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
30330387	30330387	PRJNA508758_P_NODE_67412_length_263_cov_1.389474_g66364_i0	PRJNA508758	67412	263	1.389474	3.65431662	Ridgeia piscesae	27915	Annelida	Annelida	58.9	9.73e-8	NR	KAK2186905.1	27915	g66364	i0	57.1	0.479087452471483	42	18	47.9	0	4	129	1057	1098	KAK2186905.1 hypothetical protein NP493_185g06053 [Ridgeia piscesae]	diamond	126	58.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
31989081	31989081	PRJNA508758_P_NODE_7178_length_861_cov_1.408629_g6326_i0	PRJNA508758	7178	861	1.408629	12.12829569	Siboglinidae	41324	Annelida	Annelida	62.8	6.58e-7	NR	KAK2186802.1	27915	g6326	i0	23	2	287	201	96.9	7	854	21	791	1066	KAK2186802.1 hypothetical protein NP493_188g02044 [Ridgeia piscesae]	diamond	1722	62.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
32858186	32858186	PRJNA508758_P_NODE_35860_length_344_cov_1.158672_g34812_i0	PRJNA508758	35860	344	1.158672	3.98583168	Helobdella robusta	6412	Annelida	Annelida	55.8	1.4e-6	NR	XP_009012286.1	6412	g34812	i0	35.8	2.80813953488372	81	51	69.8	1	241	2	41	121	XP_009012286.1 hypothetical protein HELRODRAFT_184582, partial [Helobdella robusta]	diamond	966	55.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta

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