metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA532380" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA532380" 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
27092654	27092654	PRJNA532380_P_NODE_27262_length_169_cov_1.275000_g26937_i0	PRJNA532380	27262	169	1.275	2.15475	Parabacteroides	375288	Bacteria	Bacteria	41.6	0.0144	NR	WP_347145407.1	823	g26937	i0	66.7	1.06508875739645	30	10	53.3	0	141	52	42	71	WP_347145407.1 hypothetical protein [Parabacteroides distasonis]	diamond	180	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
27583025	27583025	PRJNA532380_P_NODE_27564_length_169_cov_0.866667_g27239_i0	PRJNA532380	27564	169	0.866667	1.46466723	Cytophagaceae bacterium	2026729	Bacteria	Bacteria	74.7	5.52e-14	NR	MFN6944692.1	2026729	g27239	i0	58.9	0.994082840236686	56	23	99.4	0	2	169	92	147	MFN6944692.1 branched-chain amino acid aminotransferase [Cytophagaceae bacterium]	diamond	168	74.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		Cytophagaceae bacterium
29587042	29587042	PRJNA532380_P_NODE_33350_length_162_cov_0.920354_g33025_i0	PRJNA532380	33350	162	0.920354	1.49097348	Bacteroidota	976	Bacteria	Bacteria	47	3.54e-4	NR	MDE0916928.1	2021391	g33025	i0	50	4.16666666666667	38	19	70.4	0	48	161	14	51	MDE0916928.1 BPTI/Kunitz domain-containing protein [Flavobacteriales bacterium]	diamond	675	47.4	0.991561181434599	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
30172291	30172291	PRJNA532380_P_NODE_30192_length_166_cov_0.888889_g29867_i0	PRJNA532380	30192	166	0.888889	1.47555574	Haliscomenobacter hydrossis	2350	Bacteria	Bacteria	127	3.45e-33	NR	WP_013768666.1	2350	g29867	i0	98.2	0.993975903614458	55	1	99.4	0	165	1	167	221	WP_013768666.1 saccharopine dehydrogenase C-terminal domain-containing protein [Haliscomenobacter hydrossis]	diamond	165	127	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis
31278173	31278173	PRJNA532380_P_NODE_14975_length_233_cov_2.260870_g14650_i0	PRJNA532380	14975	233	2.26087	5.2678271	Prolixibacteraceae bacterium	2053594	Bacteria	Bacteria	114	1.18e-27	NR	MBP6968496.1	2053594	g14650	i0	78.4	11.5107296137339	74	16	95.3	0	10	231	4	77	MBP6968496.1 adenosylhomocysteinase [Prolixibacteraceae bacterium]	diamond	2682	114	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae		Prolixibacteraceae bacterium
32637991	32637991	PRJNA532380_P_NODE_33240_length_162_cov_0.920354_g32915_i0	PRJNA532380	33240	162	0.920354	1.49097348	Bacteroidales bacterium	2030927	Bacteria	Bacteria	42.4	0.0174	NR	NOQ25841.1	2030927	g32915	i0	45	0.740740740740741	40	22	74.1	0	16	135	8	47	NOQ25841.1 quinone-dependent dihydroorotate dehydrogenase [Bacteroidales bacterium]	diamond	120	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
32701134	32701134	PRJNA532380_P_NODE_33520_length_162_cov_0.920354_g33195_i0	PRJNA532380	33520	162	0.920354	1.49097348	Hymenobacter	89966	Bacteria	Bacteria	41.2	0.0434	NR	WP_183403953.1	89966	g33195	i0	52.8	0.666666666666667	36	14	66.7	1	142	35	387	419	WP_183403953.1 MULTISPECIES: ArnT family glycosyltransferase [Hymenobacter]	diamond	108	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter

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