metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJEB15333" and tax

26 rows where analysis = "blastn", bioproject = "PRJEB15333" 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
985831	985831	PRJEB15333_P_NODE_12081_length_196_cov_2.761905_g11997_i0	PRJEB15333	12081	196	2.761905	5.4133338	Streptococcus	1301	Bacteria	Bacteria	355	1.15e-93	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g11997	i0	100	332.061224489796	192	0	98	0	1	192	1571341	1571532	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	65084	355	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
985832	985832	PRJEB15333_P_NODE_13761_length_185_cov_2.992647_g13677_i0	PRJEB15333	13761	185	2.992647	5.53639695	Mycobacteriaceae	1762	Bacteria	Bacteria	337	3.89e-88	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g13677	i0	99.459	143.448648648649	185	1	100	0	1	185	1314707	1314891	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	26538	337	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
985834	985834	PRJEB15333_P_NODE_7961_length_237_cov_1.654255_g7877_i0	PRJEB15333	7961	237	1.654255	3.92058435	root	1	Root_unresolved	Root_unresolved	438	1.4e-118	NTclustered	gi\|1861649571\|gb\|MT664063.1\|	1306	g7877	i0	100	100	237	0	100	0	1	237	312	76	Streptococcus sp. strain KCOM 2447 (= ChDC F176) 16S ribosomal RNA gene, partial sequence	blastn	23700	438	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.
2261129	2261129	PRJEB15333_P_NODE_9902_length_215_cov_1.927711_g9818_i0	PRJEB15333	9902	215	1.927711	4.14457865	Rothia	32207	Bacteria	Bacteria	381	2.1299999999999996e-101	NTclustered	gi\|470475611\|ref\|NR_076290.1\|	43675	g9818	i0	98.605	233.488372093023	215	3	100	0	1	215	578	364	Rothia mucilaginosa strain DY-18 23S ribosomal RNA gene, complete sequence	blastn	50200	381	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
2571492	2571492	PRJEB15333_P_NODE_19463_length_164_cov_0.904348_g19379_i0	PRJEB15333	19463	164	0.904348	1.48313072	Curtobacterium flaccumfaciens	2035	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2844399317\|gb\|CP172399.1\|	2035	g19379	i0	100	2.75609756097561	30	0	18	0	70	99	403613	403642	Curtobacterium flaccumfaciens strain NRRL B-59340 chromosome, complete genome	blastn	452	56.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Curtobacterium	Curtobacterium flaccumfaciens
3847806	3847806	PRJEB15333_P_NODE_17284_length_168_cov_1.596639_g17200_i0	PRJEB15333	17284	168	1.596639	2.68235352	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	281	1.65e-71	NTclustered	gi\|225696175\|gb\|FJ805842.1\|	259957	g17200	i0	97.024	188.720238095238	168	4	100	1	1	168	2238	2404	Uncultured Chroococcidiopsis sp. clone AU1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31705	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3847814	3847814	PRJEB15333_P_NODE_20584_length_162_cov_0.920354_g20500_i0	PRJEB15333	20584	162	0.920354	1.49097348	Corynebacterium dentalis	2014528	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2831254150\|gb\|CP170996.1\|	2014528	g20500	i0	100	414.413580246914	162	0	100	0	1	162	2931	3092	Corynebacterium dentalis strain WGS1543 chromosome, complete genome	blastn	67135	300	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium dentalis
4813680	4813680	PRJEB15333_P_NODE_3124_length_355_cov_4.160131_g3040_i0	PRJEB15333	3124	355	4.160131	14.76846505	Cutibacterium	1912216	Bacteria	Bacteria	656	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g3040	i0	100	265.915492957746	355	0	100	0	1	355	608452	608806	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	94400	656	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4813681	4813681	PRJEB15333_P_NODE_4024_length_318_cov_8.434944_g3940_i0	PRJEB15333	4024	318	8.434944	26.82312192	root	1	Root_unresolved	Root_unresolved	544	4.0299999999999996e-150	NTclustered	gi\|529406454\|gb\|KF378762.1\|	1771	g3940	i0	97.778	99.0660377358491	315	7	99	0	1	315	441	755	Mycobacterium phlei strain CM32 16S ribosomal RNA gene, partial sequence	blastn	31503	549	0.990892531876138	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phlei
6399751	6399751	PRJEB15333_P_NODE_18186_length_166_cov_8.940171_g18102_i0	PRJEB15333	18186	166	8.940171	14.84068386	Nocardioides mesophilus	433659	Bacteria	Bacteria	265	1.64e-66	NTclustered	gi\|1898514180\|gb\|CP060713.1\|	433659	g18102	i0	95.732	120.560240963855	164	7	99	0	3	166	147498	147661	Nocardioides mesophilus strain KACC 16243 chromosome, complete genome	blastn	20013	265	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides mesophilus
10224366	10224366	PRJEB15333_P_NODE_3669_length_332_cov_1.098940_g3585_i0	PRJEB15333	3669	332	1.09894	3.6484808	Anaerococcus nagyae	1755241	Bacteria	Bacteria	553	7.029999999999998e-153	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g3585	i0	96.96	49.7409638554217	329	10	99	0	3	331	121082	121410	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	16514	553	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
10224367	10224367	PRJEB15333_P_NODE_509_length_733_cov_5.187135_g454_i0	PRJEB15333	509	733	5.187135	38.02169955	Mycolicibacterium phocaicum	319706	Bacteria	Bacteria	1328	0	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g454	i0	99.453	166.085948158254	731	4	99	0	3	733	1311849	1312579	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	121741	1328	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
11499638	11499638	PRJEB15333_P_NODE_16830_length_169_cov_1.300000_g16746_i0	PRJEB15333	16830	169	1.3	2.197	Metabacillus halosaccharovorans	930124	Bacteria	Bacteria	296	5.9e-76	NTclustered	gi\|2780438057\|gb\|CP162630.1\|	930124	g16746	i0	98.225	804.568047337278	169	3	100	0	1	169	14208	14040	Metabacillus halosaccharovorans strain Hao 2024 chromosome, complete genome	blastn	135972	296	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus halosaccharovorans
12465000	12465000	PRJEB15333_P_NODE_10850_length_206_cov_1.942675_g10766_i0	PRJEB15333	10850	206	1.942675	4.0019105	Micrococcus	1269	Bacteria	Bacteria	333	5.739999999999999e-87	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g10766	i0	96.517	315.223300970874	201	7	99	0	3	203	345505	345705	Micrococcus luteus strain V017 chromosome, complete genome	blastn	64936	333	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
12465005	12465005	PRJEB15333_P_NODE_550_length_708_cov_3.969651_g493_i0	PRJEB15333	550	708	3.969651	28.10512908	Cutibacterium	1912216	Bacteria	Bacteria	1293	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g493	i0	99.858	267.618644067797	703	1	99	0	6	708	56047	55345	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	189474	1293	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12775196	12775196	PRJEB15333_P_NODE_19611_length_164_cov_0.904348_g19527_i0	PRJEB15333	19611	164	0.904348	1.48313072	uncultured Actinomycetes bacterium	152507	Bacteria	Bacteria	237	3.52e-58	NTclustered	gi\|2874253870\|emb\|OY969925.1\|	152507	g19527	i0	93.168	2.79878048780488	161	11	98	0	3	163	2533744	2533904	MAG: uncultured Actinomycetes bacterium isolate MFD04850.bin.c.3 genome assembly, chromosome: 1	blastn	459	237	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes				uncultured Actinomycetes bacterium
15013689	15013689	PRJEB15333_P_NODE_14712_length_180_cov_1.190840_g14628_i0	PRJEB15333	14712	180	1.19084	2.143512	Exiguobacterium	33986	Bacteria	Bacteria	333	4.87e-87	NTclustered	gi\|1735050952\|gb\|CP030931.1\|	41170	g14628	i0	100	654.194444444444	180	0	100	0	1	180	473560	473381	Exiguobacterium acetylicum strain AMCC 101217 chromosome, complete genome	blastn	117755	333	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium acetylicum
15013694	15013694	PRJEB15333_P_NODE_5812_length_272_cov_3.748879_g5728_i0	PRJEB15333	5812	272	3.748879	10.19695088	Streptococcus	1301	Bacteria	Bacteria	496	9.59e-136	NTclustered	gi\|2246565702\|gb\|CP097843.1\|	1303	g5728	i0	99.631	330.882352941176	271	1	99	0	2	272	18076	17806	Streptococcus oralis strain HP01 chromosome, complete genome	blastn	90000	496	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
15013698	15013698	PRJEB15333_P_NODE_9512_length_219_cov_1.994118_g9428_i0	PRJEB15333	9512	219	1.994118	4.36711842	Streptococcus	1301	Bacteria	Bacteria	403	4.64e-108	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g9428	i0	100	346.438356164384	218	0	99	0	1	218	1568791	1569008	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	75870	403	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
17563710	17563710	PRJEB15333_P_NODE_16934_length_169_cov_0.866667_g16850_i0	PRJEB15333	16934	169	0.866667	1.46466723	Fimbriimonas	1005038	Bacteria	Bacteria	257	2.79e-64	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g16850	i0	97.973	124.076923076923	148	3	88	0	1	148	28958	28811	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	20969	257	1	Bacteria		Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
18837640	18837640	PRJEB15333_P_NODE_14815_length_179_cov_2.453846_g14731_i0	PRJEB15333	14815	179	2.453846	4.3923843400000004	Cutibacterium	1912216	Bacteria	Bacteria	331	1.74e-86	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g14731	i0	100	273.413407821229	179	0	100	0	1	179	56778	56600	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	48941	331	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18837642	18837642	PRJEB15333_P_NODE_20435_length_162_cov_1.566372_g20351_i0	PRJEB15333	20435	162	1.566372	2.53752264	Bacillus	1386	Bacteria	Bacteria	58.4	2.9e-4	NTclustered	gi\|942009880\|gb\|CP013000.1\|	1428	g20351	i0	100	5.35802469135802	31	0	19	0	27	57	251825	251795	Bacillus thuringiensis strain XL6 chromosome, complete genome	blastn	868	58.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
21698325	21698325	PRJEB15333_P_NODE_15958_length_173_cov_1.596774_g15874_i0	PRJEB15333	15958	173	1.596774	2.76241902	Rothia terrae	396015	Bacteria	Bacteria	309	7.81e-80	NTclustered	gi\|1907834973\|gb\|CP061539.1\|	396015	g15874	i0	98.844	266.687861271676	173	2	100	0	1	173	1731165	1730993	Rothia terrae strain KJZ-14 chromosome, complete genome	blastn	46137	309	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia terrae
22662773	22662773	PRJEB15333_P_NODE_18998_length_165_cov_0.896552_g18914_i0	PRJEB15333	18998	165	0.896552	1.4793108	Microcoleus	44471	Bacteria	Bacteria	298	1.61e-76	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g18914	i0	99.39	138.860606060606	164	1	99	0	1	164	133271	133434	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	22912	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
22662774	22662774	PRJEB15333_P_NODE_2778_length_372_cov_5.318885_g2695_i0	PRJEB15333	2778	372	5.318885	19.7862522	Mycobacteriaceae	1762	Bacteria	Bacteria	678	0	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g2695	i0	99.73	184.19623655914	370	1	99	0	3	372	1312989	1312620	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	68521	678	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
23938214	23938214	PRJEB15333_P_NODE_6679_length_256_cov_2.086957_g6595_i0	PRJEB15333	6679	256	2.086957	5.34260992	Mycobacteriaceae	1762	Bacteria	Bacteria	473	4.189999999999999e-129	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g6595	i0	100	163.36328125	256	0	100	0	1	256	1313226	1312971	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	41821	473	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum

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