metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA438572" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA438572" 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
6812960	6812960	PRJNA438572_P_NODE_7226_length_376_cov_0.986799_g7107_i0	PRJNA438572	7226	376	0.986799	3.71036424	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	189	5.61e-57	NR	XP_009028567.1	6412	g7107	i0	76	24.8218085106383	125	30	99.7	0	2	376	71	195	XP_009028567.1 hypothetical protein HELRODRAFT_186113, partial [Helobdella robusta]	diamond	9333	190	0.994736842105263	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
27771165	27771165	PRJNA438572_P_NODE_17724_length_252_cov_0.871508_g17605_i0	PRJNA438572	17724	252	0.871508	2.19620016	Helobdella robusta	6412	Annelida	Annelida	41.6	0.0252	NR	XP_009016464.1	6412	g17605	i0	50	0.595238095238095	50	21	56	2	70	210	36	84	XP_009016464.1 hypothetical protein HELRODRAFT_92454, partial [Helobdella robusta]	diamond	150	41.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
28592004	28592004	PRJNA438572_P_NODE_20107_length_248_cov_0.891429_g19988_i0	PRJNA438572	20107	248	0.891429	2.21074392	Owenia fusiformis	6347	Annelida	Annelida	55.8	7.82e-7	NR	CAH1780818.1	6347	g19988	i0	35	0.967741935483871	80	43	96.8	1	247	8	24	94	CAH1780818.1 unnamed protein product [Owenia fusiformis]	diamond	240	55.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29302788	29302788	PRJNA438572_P_NODE_18169_length_251_cov_0.876404_g18050_i0	PRJNA438572	18169	251	0.876404	2.19977404	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	77.4	2.47e-14	NR	CAH1773466.1	6347	g18050	i0	64.7	9.28685258964143	51	18	61	0	197	45	210	260	CAH1773466.1 unnamed protein product [Owenia fusiformis]	diamond	2331	77.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29586640	29586640	PRJNA438572_P_NODE_2930_length_573_cov_1.144000_g2813_i0	PRJNA438572	2930	573	1.144	6.55512	Metazoa	33208	Annelida	Annelida	228	1.95e-67	NR	CAH1789021.1	6347	g2813	i0	57.6	1.99476439790576	191	79	99.5	2	571	2	458	647	CAH1789021.1 unnamed protein product [Owenia fusiformis]	diamond	1143	228	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30897640	30897640	PRJNA438572_P_NODE_18474_length_251_cov_0.876404_g18355_i0	PRJNA438572	18474	251	0.876404	2.19977404	Paralvinella palmiformis	53620	Annelida	Annelida	106	1.29e-24	NR	KAK2154102.1	53620	g18355	i0	53.6	3.07171314741036	84	37	98	1	2	247	200	283	KAK2154102.1 hypothetical protein LSH36_276g00012 [Paralvinella palmiformis]	diamond	771	106	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
32510783	32510783	PRJNA438572_P_NODE_22979_length_244_cov_0.912281_g22860_i0	PRJNA438572	22979	244	0.912281	2.22596564	Capitella teleta	283909	Annelida	Annelida	47.4	8.81e-4	NR	ELT93314.1	283909	g22860	i0	43.8	0.590163934426229	48	24	57.8	2	1	141	421	466	ELT93314.1 hypothetical protein CAPTEDRAFT_225336 [Capitella teleta]	diamond	144	47.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
32605242	32605242	PRJNA438572_P_NODE_19880_length_249_cov_0.886364_g19761_i0	PRJNA438572	19880	249	0.886364	2.20704636	Paralvinella palmiformis	53620	Annelida	Annelida	59.7	4.08e-8	NR	KAK2161159.1	53620	g19761	i0	53.5	1.02409638554217	43	19	51.8	1	120	248	203	244	KAK2161159.1 hypothetical protein LSH36_120g02000 [Paralvinella palmiformis]	diamond	255	59.7	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);;