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

21 rows where bioproject = "PRJNA529924" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2392728	2392728	PRJNA529924_P_NODE_862_length_645_cov_6.220779_g52_i2	PRJNA529924	862	645	6.220779	40.12402455	Cutibacterium	1912216	Bacteria	Bacteria	959	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g52	i2	93.548	311.06511627907	651	30	100	10	1	645	608211	608855	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	200637	959	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3054247	3054247	PRJNA529924_P_NODE_4363_length_180_cov_1.403974_g4189_i0	PRJNA529924	4363	180	1.403974	2.5271532	Dermacoccus nishinomiyaensis	1274	Bacteria	Bacteria	333	4.87e-87	NTclustered	gi\|1966870119\|gb\|CP068484.1\|	1274	g4189	i0	100	110.972222222222	180	0	100	0	1	180	128444	128623	Dermacoccus nishinomiyaensis strain FDAARGOS_1119 chromosome	blastn	19975	333	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus nishinomiyaensis
4945406	4945406	PRJNA529924_P_NODE_1384_length_480_cov_4.394678_g1212_i0	PRJNA529924	1384	480	4.394678	21.0944544	Corynebacterium	1716	Bacteria	Bacteria	832	0	NTclustered	gi\|1948598483\|gb\|CP066007.1\|	39791	g1212	i0	97.921	414	481	9	100	1	1	480	2168734	2168254	Corynebacterium glucuronolyticum strain FDAARGOS_1053 chromosome, complete genome	blastn	198720	832	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium glucuronolyticum
4945411	4945411	PRJNA529924_P_NODE_3584_length_212_cov_2.207650_g3410_i0	PRJNA529924	3584	212	2.20765	4.680218	Rothia	32207	Bacteria	Bacteria	392	9.67e-105	NTclustered	gi\|470475611\|ref\|NR_076290.1\|	43675	g3410	i0	100	210.080188679245	212	0	100	0	1	212	1722	1511	Rothia mucilaginosa strain DY-18 23S ribosomal RNA gene, complete sequence	blastn	44537	392	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
5607024	5607024	PRJNA529924_P_NODE_3425_length_220_cov_1.602094_g3251_i0	PRJNA529924	3425	220	1.602094	3.5246068	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2621704807\|emb\|OY763072.1\|	2026734	g3251	i0	100	0.127272727272727	28	0	13	0	116	143	3446192	3446219	MAG: Dehalococcoidia bacterium isolate 40e540cc-5106-4b3b-ab2b-631d7f64572a genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
8156132	8156132	PRJNA529924_P_NODE_3367_length_224_cov_1.774359_g3193_i0	PRJNA529924	3367	224	1.774359	3.97456416	Rothia aeria	172042	Bacteria	Bacteria	67.6	7.11e-7	NTclustered	gi\|1958291603\|gb\|CP068102.1\|	172042	g3193	i0	97.436	0.696428571428571	39	1	17	0	77	115	1176187	1176225	Rothia aeria strain FDAARGOS_1137 chromosome, complete genome	blastn	156	67.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia aeria
8770274	8770274	PRJNA529924_P_NODE_2927_length_257_cov_2.688596_g2753_i0	PRJNA529924	2927	257	2.688596	6.90969172	Rothia	32207	Bacteria	Bacteria	473	4.2099999999999996e-129	NTclustered	gi\|470475611\|ref\|NR_076290.1\|	43675	g2753	i0	100	198.95719844358	256	0	99	0	1	256	526	271	Rothia mucilaginosa strain DY-18 23S ribosomal RNA gene, complete sequence	blastn	51132	473	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
8770276	8770276	PRJNA529924_P_NODE_3167_length_238_cov_2.516746_g2993_i0	PRJNA529924	3167	238	2.516746	5.98985548	Rothia	32207	Bacteria	Bacteria	350	6.77e-92	NTclustered	gi\|470475611\|ref\|NR_076290.1\|	43675	g2993	i0	92.578	173.773109243697	256	0	99	1	2	238	271	526	Rothia mucilaginosa strain DY-18 23S ribosomal RNA gene, complete sequence	blastn	41358	350	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
10045761	10045761	PRJNA529924_P_NODE_68_length_1902_cov_7.139349_g52_i0	PRJNA529924	68	1902	7.139349	135.79041798	Cutibacterium	1912216	Bacteria	Bacteria	3393	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g52	i0	99.308	283.016298633018	1879	7	99	5	25	1902	606982	608855	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	538297	3393	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13871091	13871091	PRJNA529924_P_NODE_991_length_597_cov_7.404930_g841_i0	PRJNA529924	991	597	7.40493	44.2074321	Corynebacterium	1716	Bacteria	Bacteria	1037	0	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g841	i0	97.99	371.539363484087	597	12	100	0	1	597	760544	759948	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	221809	1037	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
16420025	16420025	PRJNA529924_P_NODE_3973_length_195_cov_1.692771_g3799_i0	PRJNA529924	3973	195	1.692771	3.30090345	Limosilactobacillus	2742598	Bacteria	Bacteria	346	6.9e-91	NTclustered	gi\|2459461436\|gb\|CP119425.1\|	1613	g3799	i0	98.485	99.7692307692308	198	0	100	1	1	195	1035119	1034922	Limosilactobacillus fermentum strain KUFM408 chromosome, complete genome	blastn	19455	346	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus fermentum
18968788	18968788	PRJNA529924_P_NODE_1075_length_567_cov_6.355019_g918_i0	PRJNA529924	1075	567	6.355019	36.03295773	Corynebacterium	1716	Bacteria	Bacteria	1038	0	NTclustered	gi\|2869797333\|gb\|CP175765.1\|	38304	g918	i0	100	364.712522045855	562	0	99	0	6	567	2379	2940	Corynebacterium tuberculostearicum strain YSMAA5_1_F11 chromosome, complete genome	blastn	206792	1038	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
18968789	18968789	PRJNA529924_P_NODE_1655_length_418_cov_3.709512_g1481_i0	PRJNA529924	1655	418	3.709512	15.50576016	Corynebacterium	1716	Bacteria	Bacteria	750	0	NTclustered	gi\|2869819920\|gb\|CP175795.1\|	1979527	g1481	i0	99.043	371.464114832536	418	4	100	0	1	418	789534	789117	Corynebacterium kefirresidentii strain YSMAA1_1_C6 chromosome, complete genome	blastn	155272	756	0.992063492063492	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
20243714	20243714	PRJNA529924_P_NODE_296_length_1146_cov_12.971352_g229_i0	PRJNA529924	296	1146	12.971352	148.65169392	Bacillales	1385	Bacteria	Bacteria	1585	0	NTclustered	gi\|2692800537\|gb\|CP146065.1\|	1283	g229	i0	91.732	502.177137870855	1149	84	99	10	2	1146	772955	771814	Staphylococcus haemolyticus strain SPS12 chromosome, complete genome	blastn	575495	1585	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
20243715	20243715	PRJNA529924_P_NODE_4596_length_169_cov_5.150000_g4422_i0	PRJNA529924	4596	169	5.15	8.7035	Rothia	32207	Bacteria	Bacteria	281	1.65e-71	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g4422	i0	97.006	260.568047337278	167	5	99	0	1	167	653197	653031	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	44036	281	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
21519277	21519277	PRJNA529924_P_NODE_3837_length_200_cov_3.719298_g3663_i0	PRJNA529924	3837	200	3.719298	7.438596	root	1	Root_unresolved	Root_unresolved	348	1.98e-91	NTclustered	gi\|425707021\|gb\|JX860320.1\|	2702	g3663	i0	98	114	200	4	100	0	1	200	1117	1316	Gardnerella vaginalis strain JCP8481A 16S ribosomal RNA gene, partial sequence	blastn	22800	348	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Gardnerella	Gardnerella vaginalis
22179943	22179943	PRJNA529924_P_NODE_5018_length_151_cov_1.426230_g4844_i0	PRJNA529924	5018	151	1.42623	2.1536073	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	263	5.23e-66	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g4844	i0	98.013	373.350993377483	151	3	100	0	1	151	551979	552129	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	56376	263	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
25343610	25343610	PRJNA529924_P_NODE_3200_length_236_cov_1.492754_g3026_i0	PRJNA529924	3200	236	1.492754	3.52289944	Clostridium	1485	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2331091137\|gb\|CP110856.1\|	1534	g3026	i0	100	0.491525423728814	29	0	12	0	142	170	2245442	2245414	Clostridium kluyveri strain BJN0002 chromosome, complete genome	blastn	116	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium kluyveri
26665777	26665777	PRJNA529924_P_NODE_4961_length_153_cov_1.556452_g4787_i0	PRJNA529924	4961	153	1.556452	2.38137156	Propionibacteriales bacterium	2015801	Bacteria	Bacteria	59.7	3.34e-10	NR	MBA2717461.1	2015801	g4787	i0	57.8	0.882352941176471	45	15	86.3	2	2	133	25	66	MBA2717461.1 hypothetical protein [Propionibacteriales bacterium]	diamond	135	59.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales			Propionibacteriales bacterium
29256301	29256301	PRJNA529924_P_NODE_4409_length_178_cov_1.275168_g4235_i0	PRJNA529924	4409	178	1.275168	2.26979904	Bacillota bacterium	1879010	Bacteria	Bacteria	43.5	0.00778	NR	HBG15780.1	1879010	g4235	i0	54.8	4.95505617977528	42	19	70.8	0	178	53	196	237	HBG15780.1 peptidoglycan-binding protein LysM [Bacillota bacterium]	diamond	882	43.5	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31025541	31025541	PRJNA529924_P_NODE_2555_length_291_cov_1.839695_g2381_i0	PRJNA529924	2555	291	1.839695	5.35351245	Bacillota bacterium	1879010	Bacteria	Bacteria	42	0.014	NR	NLL58111.1	1879010	g2381	i0	38.9	0.556701030927835	54	26	55.7	2	213	52	3	49	NLL58111.1 50S ribosomal protein L28 [Bacillota bacterium]	diamond	162	42	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium

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