metadata: contig_metadata: 21 rows where bioproject = "PRJNA478247" and tax

21 rows where 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
1097152	1097152	PRJNA478247_P_NODE_3241_length_165_cov_2.536765_g3135_i0	PRJNA478247	3241	165	2.536765	4.18566225	Blastococcus	38501	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|507148190\|ref\|NR_102997.1\|	138336	g3135	i0	100	391.236363636364	165	0	100	0	1	165	2345	2509	Blastococcus saxobsidens strain DD2 23S ribosomal RNA gene, complete sequence	blastn	64554	305	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
3648284	3648284	PRJNA478247_P_NODE_1603_length_290_cov_2.900383_g1497_i0	PRJNA478247	1603	290	2.900383	8.4111107	Arthrobacter	1663	Bacteria	Bacteria	433	8.21e-117	NTclustered	gi\|2921126289\|gb\|CP102608.1\|	619291	g1497	i0	95.273	311.662068965517	275	10	94	3	1	274	459350	459078	Arthrobacter sp. N1 chromosome, complete genome	blastn	90382	433	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. N1
10025457	10025457	PRJNA478247_P_NODE_3508_length_154_cov_5.672000_g3402_i0	PRJNA478247	3508	154	5.672	8.73488	Bacillati	1783272	Bacteria	Bacteria	270	3.2099999999999992e-68	NTclustered	gi\|1883577788\|gb\|CP059343.1\|	1272	g3402	i0	100	124.038961038961	146	0	95	0	1	146	1048593	1048448	Kocuria varians strain 80 chromosome, complete genome	blastn	19102	272	0.992647058823529	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria varians
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
18299347	18299347	PRJNA478247_P_NODE_2955_length_180_cov_2.066225_g2849_i0	PRJNA478247	2955	180	2.066225	3.719205	Friedmanniella luteola	546871	Bacteria	Bacteria	300	4.94e-77	NTclustered	gi\|1085823321\|emb\|LT629749.1\|	546871	g2849	i0	96.667	350.127777777778	180	6	100	0	1	180	1464051	1463872	Friedmanniella luteola strain DSM 21741 genome assembly, chromosome: I	blastn	63023	300	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Friedmanniella	Friedmanniella luteola
18948640	18948640	PRJNA478247_P_NODE_1175_length_364_cov_3.570149_g1069_i0	PRJNA478247	1175	364	3.570149	12.99534236	Gordonia	2053	Bacteria	Bacteria	516	1.02e-141	NTclustered	gi\|2714293900\|gb\|CP136137.1\|	40516	g1069	i0	95.107	372.656593406593	327	16	91	0	38	364	3354	3028	Gordonia hydrophobica strain 1610/1b chromosome	blastn	135647	516	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia	Gordonia hydrophobica
20849381	20849381	PRJNA478247_P_NODE_3277_length_164_cov_1.503704_g3171_i0	PRJNA478247	3277	164	1.503704	2.46607456	Kocuria palustris	71999	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|923033569\|gb\|CP012507.1\|	71999	g3171	i0	98.78	321.609756097561	164	2	100	0	1	164	218430	218267	Kocuria palustris strain MU14/1, complete genome	blastn	52744	292	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria palustris
24673862	24673862	PRJNA478247_P_NODE_1800_length_265_cov_2.580508_g1694_i0	PRJNA478247	1800	265	2.580508	6.8383462	Kocuria sp. KD4	2719588	Bacteria	Bacteria	442	1.2299999999999995e-119	NTclustered	gi\|1826585035\|gb\|CP050449.1\|	2719588	g1694	i0	98.79	353.449056603774	248	3	94	0	1	248	1836634	1836387	Kocuria sp. KD4 chromosome, complete genome	blastn	93664	442	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria sp. KD4
24673869	24673869	PRJNA478247_P_NODE_500_length_640_cov_7.384615_g405_i0	PRJNA478247	500	640	7.384615	47.261536	Streptomyces sp. GQFP	2907545	Bacteria	Bacteria	63.9	2.94e-5	NTclustered	gi\|2181538142\|gb\|CP089312.1\|	2907545	g405	i0	95	0.2828125	40	2	6	0	25	64	7470618	7470579	Streptomyces sp. GQFP chromosome	blastn	181	63.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. GQFP
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);;