metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA193544" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA193544" and tax_superkingdom = "Bacteria"

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
26662127	26662127	PRJNA193544_S_NODE_921_length_259_cov_3.156522_g906_i0	PRJNA193544	921	259	3.156522	8.17539198	Planctomycetales bacterium	2053591	Bacteria	Bacteria	92	1.55e-22	NR	MCX7410675.1	2053591	g906	i0	83.9	0.648648648648649	56	9	64.9	0	34	201	1	56	MCX7410675.1 Flp family type IVb pilin [Planctomycetales bacterium]	diamond	168	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
27231961	27231961	PRJNA193544_S_NODE_3043_length_159_cov_8.092308_g3028_i0	PRJNA193544	3043	159	8.092308	12.86676972	[Clostridium] cellulosi	29343	Bacteria	Bacteria	42.4	0.00997	NR	CDZ23242.1	29343	g3028	i0	69.7	0.622641509433962	33	5	62.3	1	2	100	34	61	CDZ23242.1 hypothetical protein CCDG5_0096 [[Clostridium] cellulosi]	diamond	99	42.4	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		[Clostridium] cellulosi
27295206	27295206	PRJNA193544_S_NODE_1003_length_250_cov_736.443439_g988_i0	PRJNA193544	1003	250	736.443439	1841.1085975	Sphingobacterium chuzhouense	1742264	Bacteria	Bacteria	46.2	8.71e-4	NR	MBD1423946.1	1742264	g988	i0	65.4	0.312	26	9	31.2	0	52	129	82	107	MBD1423946.1 hypothetical protein [Sphingobacterium chuzhouense]	diamond	78	46.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium chuzhouense
27849681	27849681	PRJNA193544_S_NODE_2884_length_163_cov_2.880597_g2869_i0	PRJNA193544	2884	163	2.880597	4.69537311	Pseudomonadati	3379134	Bacteria	Bacteria	39.3	0.0394	NR	ALA57788.1	42253	g2869	i0	43.6	1.52760736196319	39	22	71.8	0	19	135	18	56	ALA57788.1 hypothetical protein NITMOv2_1360 [Nitrospira moscoviensis]	diamond	249	39.3	1	Bacteria		Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
27990021	27990021	PRJNA193544_S_NODE_1625_length_207_cov_1.848315_g1610_i0	PRJNA193544	1625	207	1.848315	3.82601205	Mucilaginibacter sp.	1882438	Bacteria	Bacteria	72.4	1.16e-14	NR	MDN5289622.1	1882438	g1610	i0	62.1	0.840579710144927	58	22	84.1	0	9	182	35	92	MDN5289622.1 hypothetical protein [Mucilaginibacter sp.]	diamond	174	72.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp.
28589980	28589980	PRJNA193544_S_NODE_1847_length_198_cov_10.739645_g1832_i0	PRJNA193544	1847	198	10.739645	21.2644971	uncultured bacterium	77133	Bacteria	Bacteria	54.3	1.24e-7	NR	AOE14047.1	77133	g1832	i0	50	0.939393939393939	62	28	90.9	2	181	2	1	61	AOE14047.1 hypothetical protein [uncultured bacterium]	diamond	186	54.3	1	Bacteria								uncultured bacterium
28842274	28842274	PRJNA193544_S_NODE_2928_length_162_cov_2.827068_g2913_i0	PRJNA193544	2928	162	2.827068	4.57985016	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	58.2	1.1e-9	NR	MBI3423676.1	1978231	g2913	i0	83.9	0.574074074074074	31	5	57.4	0	98	6	3	33	MBI3423676.1 Flp family type IVb pilin [Acidobacteriota bacterium]	diamond	93	58.2	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29473621	29473621	PRJNA193544_S_NODE_2090_length_188_cov_7.773585_g2075_i0	PRJNA193544	2090	188	7.773585	14.6143398	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	75.9	5.77e-16	NR	HRN86953.1	2099670	g2075	i0	77.4	0.845744680851064	53	12	84.6	0	161	3	51	103	HRN86953.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	159	75.9	1	Bacteria	Bacteria candidate phyla							Candidatus Dojkabacteria bacterium
29537020	29537020	PRJNA193544_S_NODE_1230_length_231_cov_16.599010_g1215_i0	PRJNA193544	1230	231	16.59901	38.3437131	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	42.7	0.0318	NR	MCA9060089.1	2026779	g1215	i0	36.4	1	77	49	100	0	231	1	58	134	MCA9060089.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	231	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29537022	29537022	PRJNA193544_S_NODE_3230_length_155_cov_7.992063_g3215_i0	PRJNA193544	3230	155	7.992063	12.38769765	Candidatus Peribacteria bacterium RIFCSPLOWO2_	2053688	Bacteria	Bacteria	55.5	2.09e-8	NR	OGJ69802.1	1801929	g3215	i0	66.7	0.812903225806452	42	14	81.3	0	28	153	26	67	OGJ69802.1 MAG: hypothetical protein A3H90_02195 [Candidatus Peribacteria bacterium RIFCSPLOWO2_02_FULL_55_36]	diamond	126	55.5	1	Bacteria	Bacteria candidate phyla		Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium RIFCSPLOWO2_02_FULL_55_36
30421858	30421858	PRJNA193544_S_NODE_1973_length_192_cov_23975.503067_g1958_i0	PRJNA193544	1973	192	23975.503067	46032.96588864	Microbacterium helvum	2773713	Bacteria	Bacteria	42	0.0238	NR	WP_191173023.1	2773713	g1958	i0	45.5	0.6875	44	23	67.2	1	153	25	49	92	WP_191173023.1 Mov34/MPN/PAD-1 family protein [Microbacterium helvum]	diamond	132	42	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium helvum
30705731	30705731	PRJNA193544_S_NODE_2194_length_184_cov_4.645161_g2179_i0	PRJNA193544	2194	184	4.645161	8.54709624	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	58.2	3.4e-9	NR	HRN86952.1	2099670	g2179	i0	87.1	0.505434782608696	31	4	50.5	0	95	3	1	31	HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	93	58.2	1	Bacteria	Bacteria candidate phyla							Candidatus Dojkabacteria bacterium
30990359	30990359	PRJNA193544_S_NODE_1494_length_214_cov_3.410811_g1479_i0	PRJNA193544	1494	214	3.410811	7.29913554	Planctomycetales bacterium	2053591	Bacteria	Bacteria	95.9	2.5299999999999998e-24	NR	MCX7410675.1	2053591	g1479	i0	86	0.799065420560748	57	8	79.9	0	184	14	1	57	MCX7410675.1 Flp family type IVb pilin [Planctomycetales bacterium]	diamond	171	95.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
31970473	31970473	PRJNA193544_S_NODE_2838_length_164_cov_13.851852_g2823_i0	PRJNA193544	2838	164	13.851852	22.71703728	Corynebacterium hadale	2026255	Bacteria	Bacteria	41.6	0.0329	NR	WP_095535840.1	2026255	g2823	i0	58.8	0.621951219512195	34	13	60.4	1	52	150	280	313	WP_095535840.1 multicopper oxidase domain-containing protein [Corynebacterium hadale]	diamond	102	41.6	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hadale

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