metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA1101946" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA1101946" 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
16788394	16788394	PRJNA1101946_S_NODE_17574_length_192_cov_3.566434_g17475_i0	PRJNA1101946	17574	192	3.566434	6.84755328	Sphingobacteriaceae	84566	Bacteria	Bacteria	123	2.15e-31	NR	WP_172661121.1	363849	g17475	i0	98.4	8.859375	63	1	98.4	0	3	191	146	208	WP_172661121.1 ammonium transporter [Pedobacter panaciterrae]	diamond	1701	123	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter panaciterrae
26624431	26624431	PRJNA1101946_S_NODE_23421_length_166_cov_4.709402_g23322_i0	PRJNA1101946	23421	166	4.709402	7.81760732	Labilibaculum sp. K2S	3056386	Bacteria	Bacteria	78.2	7.39e-17	NR	WP_289532364.1	3056386	g23322	i0	61.8	1.95180722891566	55	21	99.4	0	165	1	58	112	WP_289532364.1 hypothetical protein, partial [Labilibaculum sp. K2S]	diamond	324	78.6	0.994910941475827	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinifilaceae	Labilibaculum	Labilibaculum sp. K2S
26655910	26655910	PRJNA1101946_S_NODE_5341_length_305_cov_3.347656_g5242_i0	PRJNA1101946	5341	305	3.347656	10.2103508	Leyella stercorea	363265	Bacteria	Bacteria	185	2.739999999999999e-55	NR	WP_278862324.1	363265	g5242	i0	88.1	1.98688524590164	101	12	99.3	0	1	303	240	340	WP_278862324.1 LacI family DNA-binding transcriptional regulator [Leyella stercorea]	diamond	606	185	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Leyella	Leyella stercorea
26846404	26846404	PRJNA1101946_S_NODE_11401_length_235_cov_1.645161_g11302_i0	PRJNA1101946	11401	235	1.645161	3.86612835	Pedobacter sp. ASV12	2795120	Bacteria	Bacteria	75.1	3.06e-15	NR	WP_199138737.1	2795120	g11302	i0	86.4	0.561702127659575	44	6	56.2	0	103	234	1	44	WP_199138737.1 hypothetical protein [Pedobacter sp. ASV12]	diamond	132	75.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. ASV12
27288889	27288889	PRJNA1101946_S_NODE_3643_length_338_cov_3.269896_g3544_i0	PRJNA1101946	3643	338	3.269896	11.05224848	Bacteroidota bacterium	1898104	Bacteria	Bacteria	45.4	0.0107	NR	MDA0728227.1	1898104	g3544	i0	39.6	0.470414201183432	53	28	43.5	2	155	301	192	244	MDA0728227.1 hypothetical protein [Bacteroidota bacterium]	diamond	159	45.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27541677	27541677	PRJNA1101946_S_NODE_13744_length_217_cov_0.910714_g13645_i0	PRJNA1101946	13744	217	0.910714	1.97624938	Asinibacterium sp. OR53	925409	Bacteria	Bacteria	130	1.29e-33	NR	WP_026768228.1	925409	g13645	i0	100	0.898617511520737	65	0	89.9	0	195	1	324	388	WP_026768228.1 RNA polymerase factor sigma-54 [Asinibacterium sp. OR53]	diamond	195	130	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Asinibacterium	Asinibacterium sp. OR53
28552126	28552126	PRJNA1101946_S_NODE_10887_length_239_cov_1.873684_g10788_i0	PRJNA1101946	10887	239	1.873684	4.47810476	Bacteroidales bacterium	2030927	Bacteria	Bacteria	159	2.12e-45	NR	MCI7615044.1	2030927	g10788	i0	98.7	0.99163179916318	79	1	99.2	0	2	238	301	379	MCI7615044.1 DNA recombination protein RmuC [Bacteroidales bacterium]	diamond	237	159	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28678437	28678437	PRJNA1101946_S_NODE_6327_length_290_cov_2.199170_g6228_i0	PRJNA1101946	6327	290	2.19917	6.377593	Asinibacterium sp. OR53	925409	Bacteria	Bacteria	82.8	4.86e-16	NR	WP_037361201.1	925409	g6228	i0	74	0.993103448275862	96	25	99.3	0	2	289	361	456	WP_037361201.1 c-type cytochrome domain-containing protein [Asinibacterium sp. OR53]	diamond	288	82.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Asinibacterium	Asinibacterium sp. OR53
30067594	30067594	PRJNA1101946_S_NODE_9632_length_251_cov_5.158416_g9533_i0	PRJNA1101946	9632	251	5.158416	12.94762416	Pedobacter albus	3113905	Bacteria	Bacteria	156	9.999999999999999e-43	NR	WP_330107385.1	3113905	g9533	i0	92.8	0.99203187250996006	83	6	99.2	0	3	251	172	254	WP_330107385.1 histidine kinase N-terminal 7TM domain-containing protein [Pedobacter albus]	diamond	249	156	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter albus
31354625	31354625	PRJNA1101946_S_NODE_11736_length_232_cov_3.344262_g11637_i0	PRJNA1101946	11736	232	3.344262	7.75868784	Proteiniphilum	294702	Bacteria	Bacteria	53.1	5.09e-7	NR	KUL19953.1	1641377	g11637	i0	96.2	1.17672413793103	26	1	33.6	0	80	3	1	26	KUL19953.1 MAG: tRNA-specific 2-thiouridylase MnmA, partial [Proteiniphilum sp. 51_7]	diamond	273	53.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Proteiniphilum	Proteiniphilum sp. 51_7
31742672	31742672	PRJNA1101946_S_NODE_8677_length_261_cov_3.872642_g8578_i0	PRJNA1101946	8677	261	3.872642	10.10759562	Hydrobacter penzbergensis	1235997	Bacteria	Bacteria	138	9.45e-37	NR	WP_257574734.1	1235997	g8578	i0	84.7	0.977011494252874	85	13	97.7	0	5	259	51	135	WP_257574734.1 undecaprenyl-phosphate glucose phosphotransferase [Hydrobacter penzbergensis]	diamond	255	138	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Hydrobacter	Hydrobacter penzbergensis
32817299	32817299	PRJNA1101946_S_NODE_11400_length_235_cov_1.645161_g11301_i0	PRJNA1101946	11400	235	1.645161	3.86612835	uncultured Chryseobacterium sp.	259322	Bacteria	Bacteria	152	5.79e-41	NR	WP_308005465.1	259322	g11301	i0	98.7	0.982978723404255	77	1	98.3	0	233	3	735	811	WP_308005465.1 delta-60 repeat domain-containing protein [uncultured Chryseobacterium sp.]	diamond	231	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	uncultured Chryseobacterium sp.

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