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

9 rows where analysis = "diamond", bioproject = "PRJNA352850" 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
15698846	15698846	PRJNA352850_P_NODE_58993_length_304_cov_1.019608_g56160_i0	PRJNA352850	58993	304	1.019608	3.09960832	Clitellata	42113	Annelida	Annelida	139	2.23e-38	NR	QUJ10057.1	6386	g56160	i0	75.9	5.97039473684211	87	21	85.9	0	263	3	145	231	QUJ10057.1 cytochrome c oxidase subunit III [Tubifex tubifex]	diamond	1815	140	0.992857142857143	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Tubifex	Tubifex tubifex
19522384	19522384	PRJNA352850_P_NODE_71236_length_266_cov_1.230415_g68403_i0	PRJNA352850	71236	266	1.230415	3.2729039	Clitellata	42113	Annelida	Annelida	111	2.84e-28	NR	XBQ63458.1	188233	g68403	i0	69.7	5.0187969924812	89	26	99.2	1	265	2	5	93	XBQ63458.1 cytochrome c oxidase subunit 2 [Slavina appendiculata]	diamond	1335	111	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Slavina	Slavina appendiculata
22071368	22071368	PRJNA352850_P_NODE_16898_length_734_cov_3.074453_g14226_i0	PRJNA352850	16898	734	3.074453	22.56648502	Metazoa	33208	Annelida	Annelida	318	6.419999999999997e-106	NR	KAK2169243.1	27915	g14226	i0	77.6	4.63896457765668	201	45	82.2	0	3	605	78	278	KAK2169243.1 hypothetical protein NP493_1199g02001 [Ridgeia piscesae]	diamond	3405	318	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
23347594	23347594	PRJNA352850_P_NODE_42719_length_381_cov_2.819277_g39886_i0	PRJNA352850	42719	381	2.819277	10.74144537	Metazoa	33208	Annelida	Annelida	213	1.01e-67	NR	ADY18390.1	104710	g39886	i0	81.1	7.96850393700787	127	24	100	0	381	1	43	169	ADY18390.1 ribosomal protein rpl6, partial [Glycera tridactyla]	diamond	3036	215	0.990697674418605	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Glyceridae	Glycera	Glycera tridactyla
30422764	30422764	PRJNA352850_P_NODE_83853_length_243_cov_1.051546_g81020_i0	PRJNA352850	83853	243	1.051546	2.55525678	Lamellibrachia satsuma	104711	Annelida	Annelida	61.2	1.02e-8	NR	KAI0213502.1	104711	g81020	i0	42.4	0.814814814814815	66	36	79	1	216	25	79	144	KAI0213502.1 hypothetical protein LSAT2_001469 [Lamellibrachia satsuma]	diamond	198	61.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
31370648	31370648	PRJNA352850_P_NODE_41256_length_391_cov_2.207602_g38424_i0	PRJNA352850	41256	391	2.207602	8.63172382	Glossoscolex paulistus	1046353	Annelida	Annelida	72.8	3.06e-13	NR	4U8U_C	1046353	g38424	i0	71.1	0.705882352941177	45	13	34.5	0	4	138	105	149	4U8U_C Chain C, Globin c Chain [Glossoscolex paulistus]	diamond	276	72.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Glossoscolecidae	Glossoscolex	Glossoscolex paulistus
31971362	31971362	PRJNA352850_P_NODE_61218_length_295_cov_3.865854_g58385_i0	PRJNA352850	61218	295	3.865854	11.4042693	Dendrobaena mrazeki	2839887	Annelida	Annelida	74.3	2.65e-13	NR	UWX39416.1	2839887	g58385	i0	51.1	2.5728813559322	90	42	89.5	1	295	32	206	295	UWX39416.1 NADH-ubiquinone oxidoreductase chain 1, partial [Dendrobaena mrazeki]	diamond	759	74.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Dendrobaena	Dendrobaena mrazeki
32083469	32083469	PRJNA352850_P_NODE_50798_length_337_cov_2.708333_g47965_i0	PRJNA352850	50798	337	2.708333	9.12708221	Siboglinidae	41324	Annelida	Annelida	140	1.38e-39	NR	AAG16892.1	6426	g47965	i0	82.5	2.13649851632047	80	14	71.2	0	3	242	113	192	AAG16892.1 myosin regulatory light chain [Riftia pachyptila]	diamond	720	140	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Riftia	Riftia pachyptila
32792693	32792693	PRJNA352850_P_NODE_14400_length_826_cov_3.576577_g11814_i0	PRJNA352850	14400	826	3.576577	29.54252602	Helobdella robusta	6412	Annelida	Annelida	73.9	2.31e-11	NR	XP_009023098.1	6412	g11814	i0	64.9	0.207021791767554	57	20	20.7	0	822	652	180	236	XP_009023098.1 hypothetical protein HELRODRAFT_155963 [Helobdella robusta]	diamond	171	73.9	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);;