metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA609258" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA609258" and tax_phylum = "Bacteroidota"

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
588022	588022	PRJNA609258_P_NODE_59241_length_243_cov_0.917647_g58856_i0	PRJNA609258	59241	243	0.917647	2.22988221	Kaistella pullorum	2763074	Bacteria	Bacteria	93.6	4.22e-21	NR	WP_251832140.1	2763074	g58856	i0	78.2	5.66666666666667	55	12	67.9	0	76	240	5	59	WP_251832140.1 glycosyltransferase family 2 protein [Kaistella pullorum]	diamond	1377	93.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella pullorum
17165149	17165149	PRJNA609258_P_NODE_38794_length_295_cov_1.405405_g38409_i0	PRJNA609258	38794	295	1.405405	4.14594475	Bacteroidota	976	Bacteria	Bacteria	171	2.77e-49	NR	WP_111294315.1	1004304	g38409	i0	84	33.7423728813559	94	15	95.6	0	285	4	4	97	WP_111294315.1 NADP-dependent isocitrate dehydrogenase [Hydrotalea sandarakina]	diamond	9954	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Hydrotalea	Hydrotalea sandarakina
27048581	27048581	PRJNA609258_P_NODE_50922_length_252_cov_0.871508_g50537_i0	PRJNA609258	50922	252	0.871508	2.19620016	Chryseobacterium sp.	1871047	Bacteria	Bacteria	72.8	8.14e-13	NR	TXI86969.1	1871047	g50537	i0	50.7	0.821428571428571	69	33	81	1	214	11	280	348	TXI86969.1 MAG: hypothetical protein E6Q36_08295 [Chryseobacterium sp.]	diamond	207	72.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp.
27333178	27333178	PRJNA609258_P_NODE_56483_length_246_cov_0.901734_g56098_i0	PRJNA609258	56483	246	0.901734	2.21826564	Pedobacter ureilyticus	1393051	Bacteria	Bacteria	166	7.29e-48	NR	WP_138724024.1	1393051	g56098	i0	100	1	82	0	100	0	1	246	17	98	WP_138724024.1 prolyl oligopeptidase family serine peptidase [Pedobacter ureilyticus]	diamond	246	166	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter ureilyticus
27756905	27756905	PRJNA609258_P_NODE_52604_length_250_cov_0.881356_g52219_i0	PRJNA609258	52604	250	0.881356	2.20339	Porphyromonadaceae	171551	Bacteria	Bacteria	117	3.07e-28	NR	WP_007365865.1	281920	g52219	i0	69.9	8.964	83	25	99.6	0	249	1	13	95	WP_007365865.1 calcium-translocating P-type ATPase, PMCA-type [Porphyromonas uenonis]	diamond	2241	117	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas uenonis
28198494	28198494	PRJNA609258_P_NODE_55426_length_247_cov_0.896552_g55041_i0	PRJNA609258	55426	247	0.896552	2.21448344	Chryseobacterium	59732	Bacteria	Bacteria	145	5.9e-40	NR	WP_072953088.1	1416778	g55041	i0	85.4	21.9109311740891	82	12	99.6	0	1	246	265	346	WP_072953088.1 HlyD family secretion protein [Chryseobacterium arachidis]	diamond	5412	145	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium arachidis
28672427	28672427	PRJNA609258_P_NODE_51607_length_251_cov_0.876404_g51222_i0	PRJNA609258	51607	251	0.876404	2.19977404	Bacteroidota	976	Bacteria	Bacteria	118	1.2e-28	NR	WP_088467854.1	2010998	g51222	i0	61.4	9.9203187250996	83	32	99.2	0	251	3	310	392	WP_088467854.1 cation-translocating P-type ATPase [Chryseobacterium sp. VAUSW3]	diamond	2490	119	0.991596638655462	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. VAUSW3
28722427	28722427	PRJNA609258_P_NODE_45087_length_269_cov_1.591837_g44702_i0	PRJNA609258	45087	269	1.591837	4.28204153	Pedobacter ureilyticus	1393051	Bacteria	Bacteria	173	7.33e-48	NR	WP_138721359.1	1393051	g44702	i0	100	0.992565055762082	89	0	99.3	0	2	268	250	338	WP_138721359.1 DEAD/DEAH box helicase [Pedobacter ureilyticus]	diamond	267	173	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter ureilyticus
29209204	29209204	PRJNA609258_P_NODE_55789_length_246_cov_1.578035_g55404_i0	PRJNA609258	55789	246	1.578035	3.8819661	Mucilaginibacter	423349	Bacteria	Bacteria	113	5.490000000000001e-27	NR	WP_147032620.1	398053	g55404	i0	59.8	2	82	33	100	0	246	1	51	132	WP_147032620.1 NRDE family protein [Mucilaginibacter ginsenosidivorans]	diamond	492	114	0.991228070175439	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter ginsenosidivorans
29385487	29385487	PRJNA609258_P_NODE_59229_length_243_cov_0.917647_g58844_i0	PRJNA609258	59229	243	0.917647	2.22988221	Kaistella anthropi	520603	Bacteria	Bacteria	74.3	1.37e-15	NR	MCB4235523.1	520603	g58844	i0	86.5	0.45679012345679	37	5	45.7	0	109	219	23	59	MCB4235523.1 hypothetical protein [Kaistella anthropi]	diamond	111	74.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella anthropi
30428122	30428122	PRJNA609258_P_NODE_58033_length_244_cov_0.912281_g57648_i0	PRJNA609258	58033	244	0.912281	2.22596564	uncultured Porphyromonas sp.	159274	Bacteria	Bacteria	170	6.44e-48	NR	WP_295020799.1	159274	g57648	i0	100	1.99180327868852	81	0	99.6	0	244	2	268	348	WP_295020799.1 right-handed parallel beta-helix repeat-containing protein [uncultured Porphyromonas sp.]	diamond	486	170	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	uncultured Porphyromonas sp.
30756782	30756782	PRJNA609258_P_NODE_49574_length_253_cov_0.866667_g49189_i0	PRJNA609258	49574	253	0.866667	2.19266751	Alloprevotella	1283313	Bacteria	Bacteria	173	2.4499999999999994e-52	NR	WP_009348600.1	671218	g49189	i0	98.8	7.96837944664032	84	1	99.6	0	252	1	159	242	WP_009348600.1 IS982 family transposase, partial [Alloprevotella rava]	diamond	2016	173	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Alloprevotella	Alloprevotella rava
30869990	30869990	PRJNA609258_P_NODE_54394_length_248_cov_0.891429_g54009_i0	PRJNA609258	54394	248	0.891429	2.21074392	Bacteroidia bacterium	2044936	Bacteria	Bacteria	55.5	1.29e-6	NR	GHT23346.1	2044936	g54009	i0	42.1	0.919354838709677	76	37	83.5	2	3	209	46	121	GHT23346.1 hypothetical protein AGMMS4957_14770 [Bacteroidia bacterium]	diamond	228	55.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
30978088	30978088	PRJNA609258_P_NODE_57494_length_245_cov_0.906977_g57109_i0	PRJNA609258	57494	245	0.906977	2.22209365	Bacteroidota	976	Bacteria	Bacteria	168	1.9699999999999998e-47	NR	WP_348335225.1	1872435	g57109	i0	97.5	4.95918367346939	81	2	99.2	0	3	245	285	365	WP_348335225.1 ATP-dependent helicase, partial [Algoriphagus sp.]	diamond	1215	168	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Algoriphagus	Algoriphagus sp.
31122423	31122423	PRJNA609258_P_NODE_59275_length_243_cov_0.917647_g58890_i0	PRJNA609258	59275	243	0.917647	2.22988221	Pedobacter sp. Leaf176	1736286	Bacteria	Bacteria	157	2.61e-42	NR	WP_056094292.1	1736286	g58890	i0	93.8	1	81	5	100	0	243	1	312	392	WP_056094292.1 SusC/RagA family TonB-linked outer membrane protein [Pedobacter sp. Leaf176]	diamond	243	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. Leaf176
32103260	32103260	PRJNA609258_P_NODE_54438_length_248_cov_0.891429_g54053_i0	PRJNA609258	54438	248	0.891429	2.21074392	Weeksellaceae bacterium A-14	3143028	Bacteria	Bacteria	151	1.4999999999999999e-40	NR	MEN2433933.1	3143028	g54053	i0	85.4	0.991935483870968	82	12	99.2	0	2	247	501	582	MEN2433933.1 S9 family peptidase [Weeksellaceae bacterium A-14]	diamond	246	151	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae		Weeksellaceae bacterium A-14
32653601	32653601	PRJNA609258_P_NODE_50920_length_252_cov_0.871508_g50535_i0	PRJNA609258	50920	252	0.871508	2.19620016	Weeksellaceae	2762318	Bacteria	Bacteria	56.2	7.19e-7	NR	WP_336686720.1	1241978	g50535	i0	72.7	3.5	33	9	39.3	0	152	250	221	253	WP_336686720.1 transcription termination factor Rho [Chryseobacterium bernardetii]	diamond	882	56.6	0.992932862190813	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium bernardetii
32653602	32653602	PRJNA609258_P_NODE_51400_length_251_cov_0.876404_g51015_i0	PRJNA609258	51400	251	0.876404	2.19977404	Pedobacter	84567	Bacteria	Bacteria	112	7.47e-29	NR	WP_131539730.1	2488994	g51015	i0	96.3	1.29083665338645	54	2	64.5	0	249	88	169	222	WP_131539730.1 cytochrome b/b6 domain-containing protein [Pedobacter nototheniae]	diamond	324	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter nototheniae

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