metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA478247" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA478247" and tax_kingdom = "Bacillati"

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
10651459	10651459	PRJNA478247_P_NODE_1429_length_316_cov_1.731707_g1323_i0	PRJNA478247	1429	316	1.731707	5.47219412	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	135	2.5899999999999996e-37	NR	MEN9568196.1	2847862	g1323	i0	82.9	0.778481012658228	82	14	77.8	0	28	273	158	239	MEN9568196.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	246	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
26633092	26633092	PRJNA478247_P_NODE_3301_length_163_cov_1.365672_g3195_i0	PRJNA478247	3301	163	1.365672	2.22604536	Clostridiales bacterium	1898207	Bacteria	Bacteria	45.4	0.00141	NR	MCI7029261.1	1898207	g3195	i0	45.5	0.809815950920245	44	24	81	0	31	162	29	72	MCI7029261.1 Gfo/Idh/MocA family oxidoreductase [Clostridiales bacterium]	diamond	132	45.4	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
26727661	26727661	PRJNA478247_P_NODE_1361_length_329_cov_1.596667_g1255_i0	PRJNA478247	1361	329	1.596667	5.25303443	Chloroflexota bacterium	2026724	Bacteria	Bacteria	60.8	5.48e-9	NR	MCX6065193.1	2026724	g1255	i0	37.1	0.638297872340426	70	44	63.8	0	214	5	52	121	MCX6065193.1 protease inhibitor I42 family protein [Chloroflexota bacterium]	diamond	210	60.8	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
27107683	27107683	PRJNA478247_P_NODE_1122_length_377_cov_2.126437_g1016_i0	PRJNA478247	1122	377	2.126437	8.01666749	Bacillota bacterium	1879010	Bacteria	Bacteria	53.5	2.61e-5	NR	MFO7263334.1	1879010	g1016	i0	52.2	0.36604774535809	46	22	36.6	0	138	1	4	49	MFO7263334.1 F0F1 ATP synthase subunit beta [Bacillota bacterium]	diamond	138	53.5	1	Bacteria		Bacillati	Bacillota					Bacillota bacterium
27265986	27265986	PRJNA478247_P_NODE_3523_length_154_cov_1.944000_g3417_i0	PRJNA478247	3523	154	1.944	2.99376	Ruminococcus sp.	41978	Bacteria	Bacteria	45.8	7.05e-4	NR	MBQ3855877.1	41978	g3417	i0	40.4	0.915584415584416	47	28	91.6	0	146	6	6	52	MBQ3855877.1 ribonuclease P subunit p25 family protein [Ruminococcus sp.]	diamond	141	45.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
28339573	28339573	PRJNA478247_P_NODE_2326_length_219_cov_4.931579_g2220_i0	PRJNA478247	2326	219	4.931579	10.80015801	Armatimonadia bacterium	2663015	Bacteria	Bacteria	42	0.0133	NR	MEN6306005.1	2663015	g2220	i0	35.6	0.808219178082192	59	36	80.8	1	196	20	5	61	MEN6306005.1 hypothetical protein [Armatimonadia bacterium]	diamond	177	42	1	Bacteria		Bacillati	Armatimonadota	Armatimonadia				Armatimonadia bacterium
29034429	29034429	PRJNA478247_P_NODE_2668_length_198_cov_1.840237_g2562_i0	PRJNA478247	2668	198	1.840237	3.64366926	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	78.6	4.9e-15	NR	WP_356920268.1	3155599	g2562	i0	60.6	4.93939393939394	66	25	98.5	1	195	1	3	68	WP_356920268.1 flavin-containing monooxygenase [Streptomyces sp. NPDC006372]	diamond	978	78.6	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC006372
29318278	29318278	PRJNA478247_P_NODE_2969_length_179_cov_3.346667_g2863_i0	PRJNA478247	2969	179	3.346667	5.99053393	Goekera deserti	2497753	Bacteria	Bacteria	40	0.0477	NR	WP_152730834.1	2497753	g2863	i0	46.3	0.687150837988827	41	22	68.7	0	150	28	43	83	WP_152730834.1 putative quinol monooxygenase [Goekera deserti]	diamond	123	40	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Goekera	Goekera deserti
29760251	29760251	PRJNA478247_P_NODE_591_length_573_cov_3.397059_g488_i0	PRJNA478247	591	573	3.397059	19.46514807	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	48.5	0.00134	NR	HEU0073941.1	2026734	g488	i0	47.9	0.25130890052356	48	24	25.1	1	182	325	56	102	HEU0073941.1 RlpA-like double-psi beta-barrel domain-containing protein [Dehalococcoidia bacterium]	diamond	144	48.5	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
30107780	30107780	PRJNA478247_P_NODE_2132_length_234_cov_2.839024_g2026_i0	PRJNA478247	2132	234	2.839024	6.64331616	Nocardiopsis trehalosi	109329	Bacteria	Bacteria	45.1	0.00486	NR	WP_067971345.1	109329	g2026	i0	39.3	2.94871794871795	56	34	71.8	0	63	230	37	92	WP_067971345.1 S8 family peptidase [Nocardiopsis trehalosi]	diamond	690	45.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis trehalosi
30297913	30297913	PRJNA478247_P_NODE_2612_length_202_cov_1.826590_g2506_i0	PRJNA478247	2612	202	1.82659	3.6897118	Chloroflexales bacterium	2725990	Bacteria	Bacteria	135	3.92e-35	NR	MCG8347618.1	2725990	g2506	i0	88.1	5.94059405940594	67	8	99.5	0	1	201	47	113	MCG8347618.1 phosphoenolpyruvate carboxykinase (GTP) [Chloroflexales bacterium]	diamond	1200	135	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales			Chloroflexales bacterium
31498541	31498541	PRJNA478247_P_NODE_1856_length_259_cov_1.186957_g1750_i0	PRJNA478247	1856	259	1.186957	3.07421863	Clostridia bacterium	2044939	Bacteria	Bacteria	48.9	3.1e-4	NR	MBR3696712.1	2044939	g1750	i0	47.3	1.21621621621622	55	28	62.5	1	26	187	263	317	MBR3696712.1 hypothetical protein [Clostridia bacterium]	diamond	315	48.9	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium
32731525	32731525	PRJNA478247_P_NODE_800_length_469_cov_2.181818_g695_i0	PRJNA478247	800	469	2.181818	10.23272642	Pleurocapsa sp. CRU_1_2	2720401	Bacteria	Bacteria	63.2	1.35e-8	NR	NJO98385.1	2720401	g695	i0	27.7	1.75266524520256	137	97	87.6	1	41	451	61	195	NJO98385.1 hypothetical protein [Pleurocapsa sp. CRU_1_2]	diamond	822	63.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. CRU_1_2

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