metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA675331" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA675331" 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
1168559	1168559	PRJNA675331_P_NODE_4981_length_427_cov_3.491525_g4809_i0	PRJNA675331	4981	427	3.491525	14.90881175	Cutibacterium	1912216	Bacteria	Bacteria	789	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g4809	i0	100	274.700234192037	427	0	100	0	1	427	608341	608767	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	117297	789	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
1923886	1923886	PRJNA675331_P_NODE_23502_length_242_cov_0.911243_g23330_i0	PRJNA675331	23502	242	0.911243	2.20520806	Rhodococcoides fascians	1828	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2637134465\|gb\|CP140264.1\|	1828	g23330	i0	100	10.7438016528926	242	0	100	0	1	242	3708891	3708650	Rhodococcoides fascians strain GS01 chromosome, complete genome	blastn	2600	448	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
1923913	1923913	PRJNA675331_P_NODE_6502_length_379_cov_1.006536_g6330_i0	PRJNA675331	6502	379	1.006536	3.81477144	Phormidium nigroviride	482564	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g6330	i0	100	0.0738786279683377	28	0	7	0	17	44	4959106	4959133	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
3198596	3198596	PRJNA675331_P_NODE_10963_length_303_cov_75.169565_g10791_i0	PRJNA675331	10963	303	75.169565	227.76378195	uncultured Streptococcus sp.	83427	Bacteria	Bacteria	405	1.88e-108	NTclustered	gi\|2695360723\|gb\|PP455427.1\|	83427	g10791	i0	92	120.792079207921	300	6	94	11	9	293	503	799	Uncultured Streptococcus sp. clone def16 16S ribosomal RNA gene, partial sequence	blastn	36600	405	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	uncultured Streptococcus sp.
3198597	3198597	PRJNA675331_P_NODE_11143_length_302_cov_0.790393_g10971_i0	PRJNA675331	11143	302	0.790393	2.38698686	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	431	3.09e-116	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g10971	i0	92.409	116.940397350993	303	21	100	2	1	302	2192	1891	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	35316	431	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3198667	3198667	PRJNA675331_P_NODE_20943_length_246_cov_0.890173_g20771_i0	PRJNA675331	20943	246	0.890173	2.18982558	Aeromicrobium chenweiae	2079793	Bacteria	Bacteria	58.4	4.78e-4	NTclustered	gi\|1380481754\|gb\|CP026952.1\|	2079793	g20771	i0	90.909	0.178861788617886	44	3	18	1	52	95	2854818	2854776	Aeromicrobium chenweiae strain 592 chromosome, complete genome	blastn	44	58.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Aeromicrobium	Aeromicrobium chenweiae
4475818	4475818	PRJNA675331_P_NODE_9544_length_320_cov_13.870445_g9372_i0	PRJNA675331	9544	320	13.870445	44.385424	Bifidobacterium sp. group II-3	152172	Bacteria	Bacteria	488	1.93e-133	NTclustered	gi\|12958602\|gb\|AF321296.1\|	152172	g9372	i0	95.987	75.1625	299	6	93	1	12	310	481	773	Bifidobacterium sp. group II-3 16S ribosomal RNA gene, partial sequence	blastn	24052	488	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium sp. group II-3
4996866	4996866	PRJNA675331_P_NODE_20004_length_248_cov_0.880000_g19832_i0	PRJNA675331	20004	248	0.88	2.1824	Streptomyces	1883	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1992354418\|gb\|CP070326.1\|	1971	g19832	i0	100	0.225806451612903	28	0	11	0	105	132	1174518	1174491	Streptomyces noursei strain A-2-1 chromosome, complete genome	blastn	56	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces noursei
4996873	4996873	PRJNA675331_P_NODE_3464_length_503_cov_2.093023_g3293_i0	PRJNA675331	3464	503	2.093023	10.52790569	Actinomycetes	1760	Bacteria	Bacteria	62.1	8.17e-5	NTclustered	gi\|2655716716\|gb\|CP108864.1\|	1961	g3293	i0	97.222	1.09145129224652	36	1	7	0	339	374	6725921	6725956	Streptomyces virginiae strain NBC_00831 chromosome, complete genome	blastn	549	62.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces virginiae
5751267	5751267	PRJNA675331_P_NODE_12945_length_284_cov_1.094787_g12773_i0	PRJNA675331	12945	284	1.094787	3.10919508	Neobacillus sp. DY30	3047871	Bacteria	Bacteria	147	1.17e-30	NTclustered	gi\|2511398412\|gb\|CP126093.1\|	3047871	g12773	i0	82.286	16.306338028169	175	25	60	5	105	275	164379	164551	Neobacillus sp. DY30 chromosome, complete genome	blastn	4631	147	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus sp. DY30
5751328	5751328	PRJNA675331_P_NODE_22805_length_243_cov_0.905882_g22633_i0	PRJNA675331	22805	243	0.905882	2.20129326	Streptococcus mitis	28037	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2886512733\|emb\|OZ217346.1\|	28037	g22633	i0	99.177	99.0740740740741	243	2	100	0	1	243	173848	174090	Streptococcus mitis isolate S. mitis D22 genome assembly, chromosome: 1	blastn	24075	438	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
5751360	5751360	PRJNA675331_P_NODE_6925_length_368_cov_1.044068_g6753_i0	PRJNA675331	6925	368	1.044068	3.84217024	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	274	6.85e-69	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g6753	i0	91.919	75.9809782608696	198	12	53	4	4	199	597517	597322	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	27961	274	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
6272464	6272464	PRJNA675331_P_NODE_15185_length_270_cov_1.436548_g15013_i0	PRJNA675331	15185	270	1.436548	3.8786796	Clostridium	1485	Bacteria	Bacteria	418	2.1199999999999993e-112	NTclustered	gi\|2425298477\|gb\|CP114763.1\|	1492	g15013	i0	95.131	863.562962962963	267	10	99	3	3	268	11376	11640	Clostridium butyricum strain LV1 chromosome 1, complete sequence	blastn	233162	418	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium butyricum
7026400	7026400	PRJNA675331_P_NODE_19406_length_249_cov_0.875000_g19234_i0	PRJNA675331	19406	249	0.875	2.17875	Pseudanabaena sp. JOINES	2307005	Bacteria	Bacteria	459	1.1399999999999998e-124	NTclustered	gi\|1467029694\|gb\|MH818549.1\|	2307005	g19234	i0	100	168.911646586345	248	0	99	0	2	249	898	651	Pseudanabaena sp. JOINES 23S ribosomal RNA gene, partial sequence	blastn	42059	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. JOINES
8821557	8821557	PRJNA675331_P_NODE_23427_length_242_cov_0.911243_g23255_i0	PRJNA675331	23427	242	0.911243	2.20520806	Kocuria	57493	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2654448039\|gb\|CP108528.1\|	72000	g23255	i0	100	108	242	0	100	0	1	242	1091961	1091720	Kocuria rhizophila strain NBC_01227 chromosome, complete genome	blastn	26136	448	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rhizophila
8821558	8821558	PRJNA675331_P_NODE_2367_length_601_cov_1.795455_g2201_i0	PRJNA675331	2367	601	1.795455	10.79068455	Cutibacterium	1912216	Bacteria	Bacteria	1110	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2201	i0	100	289.404326123128	601	0	100	0	1	601	55518	56118	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	173932	1110	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9576340	9576340	PRJNA675331_P_NODE_22348_length_244_cov_0.900585_g22176_i0	PRJNA675331	22348	244	0.900585	2.1974274	Janibacter indicus	857417	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|1110981648\|gb\|CP013290.1\|	857417	g22176	i0	99.59	4.20081967213115	244	1	100	0	1	244	745155	744912	Janibacter indicus strain YFY001 chromosome, complete genome	blastn	1025	446	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter indicus
9576341	9576341	PRJNA675331_P_NODE_22628_length_243_cov_0.905882_g22456_i0	PRJNA675331	22628	243	0.905882	2.20129326	uncultured Actinomycetes bacterium	152507	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2874254008\|emb\|OY970333.1\|	152507	g22456	i0	100	0.11522633744856	28	0	12	0	11	38	714861	714888	MAG: uncultured Actinomycetes bacterium isolate MFD05747.bin.c.3 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes				uncultured Actinomycetes bacterium
9576343	9576343	PRJNA675331_P_NODE_23008_length_243_cov_0.905882_g22836_i0	PRJNA675331	23008	243	0.905882	2.20129326	Corynebacterium haemomassiliense	2754726	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2831275068\|gb\|CP170998.1\|	2754726	g22836	i0	100	1	243	0	100	0	1	243	2234104	2233862	Corynebacterium haemomassiliense strain WGS1525 chromosome, complete genome	blastn	243	449	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium haemomassiliense
10097218	10097218	PRJNA675331_P_NODE_9628_length_319_cov_10.231707_g9456_i0	PRJNA675331	9628	319	10.231707	32.63914533	root	1	Root_unresolved	Root_unresolved	488	1.9199999999999997e-133	NTclustered	gi\|572927228\|gb\|KF733677.1\|	1660	g9456	i0	95.973	94.717868338558	298	7	93	1	12	309	488	780	Schaalia odontolytica strain ChDC B351 16S ribosomal RNA gene, partial sequence	blastn	30215	488	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia odontolytica
10851776	10851776	PRJNA675331_P_NODE_18689_length_250_cov_0.870056_g18517_i0	PRJNA675331	18689	250	0.870056	2.17514	Streptococcus sp. oral taxon 061	712623	Bacteria	Bacteria	440	4.1399999999999976e-119	NTclustered	gi\|1866752300\|gb\|CP058258.1\|	712623	g18517	i0	98.4	5.996	250	4	100	0	1	250	284137	284386	Streptococcus sp. oral taxon 061 strain F0704 chromosome, complete genome	blastn	1499	440	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. oral taxon 061
10851786	10851786	PRJNA675331_P_NODE_20569_length_247_cov_0.885057_g20397_i0	PRJNA675331	20569	247	0.885057	2.18609079	Lactobacillus crispatus	47770	Bacteria	Bacteria	420	5.31e-113	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g20397	i0	100	27.5708502024291	227	0	92	0	1	227	250579	250353	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	6810	420	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
11372095	11372095	PRJNA675331_P_NODE_8669_length_334_cov_0.969349_g8497_i0	PRJNA675331	8669	334	0.969349	3.23762566	root	1	Root_unresolved	Root_unresolved	612	1.15e-170	NTclustered	gi\|184190882\|gb\|EU642360.1\|	1211	g8497	i0	99.701	101.002994011976	334	1	100	0	1	334	224	557	Uncultured cyanobacterium clone LW18m-2-91 16S ribosomal RNA gene, partial sequence	blastn	33735	612	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
12647843	12647843	PRJNA675331_P_NODE_18410_length_251_cov_0.865169_g18238_i0	PRJNA675331	18410	251	0.865169	2.17157419	Streptococcus	1301	Bacteria	Bacteria	398	2.5399999999999994e-106	NTclustered	gi\|1403472623\|emb\|LS483417.1\|	1313	g18238	i0	95.219	99.9760956175299	251	12	100	0	1	251	1155700	1155950	Streptococcus pneumoniae strain NCTC11902 genome assembly, chromosome: 1	blastn	25094	398	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
13401863	13401863	PRJNA675331_P_NODE_3451_length_504_cov_1.245940_g3281_i0	PRJNA675331	3451	504	1.24594	6.2795376	Mycobacterium sp. AMU20-3851	3122055	Bacteria	Bacteria	97.1	2.24e-15	NTclustered	gi\|2841713191\|gb\|CP146371.1\|	3122055	g3281	i0	77.841	0.694444444444444	176	26	33	7	228	395	3681568	3681398	Mycobacterium sp. AMU20-3851 chromosome, complete genome	blastn	350	97.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp. AMU20-3851
13922423	13922423	PRJNA675331_P_NODE_12211_length_290_cov_1.493088_g12039_i0	PRJNA675331	12211	290	1.493088	4.3299552	Brevibacterium	1696	Bacteria	Bacteria	58.4	5.77e-4	NTclustered	gi\|2161746310\|gb\|CP088298.1\|	2898795	g12039	i0	100	0.213793103448276	31	0	11	0	98	128	1165781	1165751	Brevibacterium zhoupengii strain HY170 chromosome, complete genome	blastn	62	58.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium zhoupengii
15950471	15950471	PRJNA675331_P_NODE_14553_length_274_cov_1.094527_g14381_i0	PRJNA675331	14553	274	1.094527	2.99900398	Actinacidiphila bryophytorum	1436133	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2294970197\|gb\|CP103871.1\|	1436133	g14381	i0	100	0.529197080291971	30	0	11	0	125	154	3041567	3041596	Actinacidiphila bryophytorum strain DS3 chromosome, complete genome	blastn	145	56.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Actinacidiphila	Actinacidiphila bryophytorum
15950500	15950500	PRJNA675331_P_NODE_20013_length_248_cov_0.880000_g19841_i0	PRJNA675331	20013	248	0.88	2.1824	Cutibacterium modestum	2559073	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1061027374\|gb\|CP017040.1\|	2559073	g19841	i0	100	2	248	0	100	0	1	248	1428294	1428047	Cutibacterium modestum strain F0672, complete sequence	blastn	496	459	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium modestum
17746401	17746401	PRJNA675331_P_NODE_9434_length_322_cov_1.353414_g9262_i0	PRJNA675331	9434	322	1.353414	4.35799308	Corynebacterium	1716	Bacteria	Bacteria	579	1.1199999999999997e-160	NTclustered	gi\|1980274752\|gb\|CP068291.1\|	38290	g9262	i0	99.068	391.44099378882	322	3	100	0	1	322	1315330	1315651	Corynebacterium macginleyi strain 180208 chromosome, complete genome	blastn	126044	584	0.991438356164384	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium macginleyi
18500028	18500028	PRJNA675331_P_NODE_19595_length_248_cov_2.022857_g19423_i0	PRJNA675331	19595	248	2.022857	5.01668536	Paraclostridium bifermentans	1490	Bacteria	Bacteria	449	6.81e-122	NTclustered	gi\|2223161236\|gb\|CP094933.1\|	1490	g19423	i0	100	1119.5564516129	243	0	98	0	3	245	14899	14657	Paraclostridium bifermentans strain HD0315_2 chromosome, complete genome	blastn	277650	449	1	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium bifermentans
21050303	21050303	PRJNA675331_P_NODE_23237_length_242_cov_1.047337_g23065_i0	PRJNA675331	23237	242	1.047337	2.53455554	Corynebacterium kefirresidentii	1979527	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2869824480\|gb\|CP175781.1\|	1979527	g23065	i0	99.587	357.00826446281	242	1	100	0	1	242	191862	191621	Corynebacterium kefirresidentii strain YSMAA1_2_G9 chromosome, complete genome	blastn	86396	442	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
22325141	22325141	PRJNA675331_P_NODE_18758_length_250_cov_0.870056_g18586_i0	PRJNA675331	18758	250	0.870056	2.17514	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	455	1.48e-123	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g18586	i0	99.598	26.788	249	1	99	0	1	249	901307	901555	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	6697	455	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
24120481	24120481	PRJNA675331_P_NODE_2439_length_593_cov_1.015385_g2273_i0	PRJNA675331	2439	593	1.015385	6.02123305	Cutibacterium	1912216	Bacteria	Bacteria	957	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2273	i0	95.939	280.4586846543	591	23	99	1	1	590	56683	56093	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	166312	957	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes

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