metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJEB673" and tax

32 rows where analysis = "blastn", bioproject = "PRJEB673" 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
1409476	1409476	PRJEB673_P_NODE_2762_length_596_cov_5.007130_g2459_i0	PRJEB673	2762	596	5.00713	29.8424948	Malacoplasma microti	38746	Bacteria	Bacteria	577	7.869999999999998e-160	NTclustered	gi\|299851939\|gb\|HM135466.1\|	38746	g2459	i0	87.824	123.164429530201	501	50	83	9	4	500	1642	1149	Mycoplasma microti strain IL371 23S ribosomal RNA gene, partial sequence	blastn	73406	577	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma microti
1409506	1409506	PRJEB673_P_NODE_5442_length_381_cov_2.554913_g5093_i0	PRJEB673	5442	381	2.554913	9.73421853	Epidermidibacterium keratini	1891644	Bacteria	Bacteria	58.4	7.81e-4	NTclustered	gi\|1790790271\|gb\|CP047156.1\|	1891644	g5093	i0	97.059	0.089238845144357	34	1	9	0	331	364	880483	880450	Epidermidibacterium keratini strain EPI-7 chromosome, complete genome	blastn	34	58.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Sporichthyales	Sporichthyaceae	Epidermidibacterium	Epidermidibacterium keratini
2684967	2684967	PRJEB673_P_NODE_12503_length_153_cov_1.644068_g12154_i0	PRJEB673	12503	153	1.644068	2.51542404	Crossiella sp. CA-258035	2981138	Bacteria	Bacteria	58.4	2.69e-4	NTclustered	gi\|2509236845\|gb\|CP116413.1\|	2981138	g12154	i0	100	0.202614379084967	31	0	20	0	39	69	1143225	1143195	Crossiella sp. CA-258035 chromosome, complete genome	blastn	31	58.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Crossiella	Crossiella sp. CA-258035
2685041	2685041	PRJEB673_P_NODE_8743_length_240_cov_6.278049_g8394_i0	PRJEB673	8743	240	6.278049	15.0673176	Microlunatus sagamiharensis	546874	Bacteria	Bacteria	416	6.649999999999998e-112	NTclustered	gi\|1086063565\|emb\|LT629799.1\|	546874	g8394	i0	97.917	207.045833333333	240	5	100	0	1	240	1043809	1044048	Friedmanniella sagamiharensis strain DSM 21743 genome assembly, chromosome: I	blastn	49691	416	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sagamiharensis
4823361	4823361	PRJEB673_P_NODE_6944_length_328_cov_8.552901_g6595_i0	PRJEB673	6944	328	8.552901	28.05351528	Actinomycetes	1760	Bacteria	Bacteria	440	5.639999999999997e-119	NTclustered	gi\|2160157936\|gb\|CP088017.1\|	2897773	g6595	i0	90.881	203.850609756098	329	28	100	2	1	328	2554048	2553721	Ruania halotolerans strain M4N3S171 chromosome, complete genome	blastn	66863	440	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Ruaniaceae	Ruania	Ruania halotolerans
5237487	5237487	PRJEB673_P_NODE_6525_length_340_cov_3.924590_g6176_i0	PRJEB673	6525	340	3.92459	13.343606	Modestobacter sp. L9-4	2851567	Bacteria	Bacteria	420	7.64e-113	NTclustered	gi\|2063288892\|gb\|CP077800.1\|	2851567	g6176	i0	88.921	451.855882352941	343	35	100	2	1	340	3707	4049	Modestobacter sp. L9-4 chromosome, complete genome	blastn	153631	420	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Modestobacter	Modestobacter sp. L9-4
6098475	6098475	PRJEB673_P_NODE_2205_length_657_cov_13.139871_g1929_i0	PRJEB673	2205	657	13.139871	86.32895247	Rhodococcus	1827	Bacteria	Bacteria	926	0	NTclustered	gi\|1995481078\|gb\|CP070619.1\|	2811421	g1929	i0	92.604	379.365296803653	649	41	98	7	13	657	3995348	3994703	Rhodococcus pseudokoreensis strain R79 chromosome, complete genome	blastn	249243	935	0.990374331550802	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus pseudokoreensis
6513018	6513018	PRJEB673_P_NODE_3826_length_507_cov_6.269068_g3496_i0	PRJEB673	3826	507	6.269068	31.78417476	Clostridium perfringens	1502	Bacteria	Bacteria	52.8	0.05	NTclustered	gi\|2029167656\|gb\|CP073070.1\|	1502	g3496	i0	100	0.165680473372781	28	0	6	0	386	413	1708194	1708167	Clostridium perfringens strain 19TSBNCP chromosome, complete genome	blastn	84	52.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
6513060	6513060	PRJEB673_P_NODE_8606_length_255_cov_2.013636_g8257_i0	PRJEB673	8606	255	2.013636	5.1347718	uncultured Fusibacter sp.	291847	Bacteria	Bacteria	154	6.17e-33	NTclustered	gi\|2907625746\|emb\|OZ223306.1\|	291847	g8257	i0	96.739	425.070588235294	92	3	36	0	164	255	524010	523919	MAG: uncultured Fusibacter sp. isolate 578a3ba3-1f1f-47d2-b4ed-96899ed32e8b genome assembly, chromosome: 1	blastn	108393	154	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriales Family XII. Incertae Sedis	Fusibacter	uncultured Fusibacter sp.
7372840	7372840	PRJEB673_P_NODE_12166_length_155_cov_2.191667_g11817_i0	PRJEB673	12166	155	2.191667	3.39708385	Mycoplasmoidaceae	2790998	Bacteria	Bacteria	198	1.5499999999999999e-46	NTclustered	gi\|119369652\|gb\|EF061769.1\|	2097	g11817	i0	90.604	110.367741935484	149	14	96	0	1	149	208	60	Mycoplasma genitalium strain ATCC 33530 23S ribosomal RNA gene, partial sequence	blastn	17107	198	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Mycoplasmoides	Mycoplasmoides genitalium
8648438	8648438	PRJEB673_P_NODE_11947_length_157_cov_1.631148_g11598_i0	PRJEB673	11947	157	1.631148	2.56090236	Streptococcus	1301	Bacteria	Bacteria	291	2.52e-74	NTclustered	gi\|2179901676\|gb\|CP046524.1\|	1303	g11598	i0	100	328	157	0	100	0	1	157	18272	18116	Streptococcus oralis strain SOT chromosome, complete genome	blastn	51496	291	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
9062125	9062125	PRJEB673_P_NODE_10228_length_178_cov_1.461538_g9879_i0	PRJEB673	10228	178	1.461538	2.60153764	Microbacterium lemovicicum	1072463	Bacteria	Bacteria	324	2.89e-84	NTclustered	gi\|1547059546\|gb\|CP031423.1\|	1072463	g9879	i0	99.438	159.578651685393	178	1	100	0	1	178	1189527	1189704	Microbacterium lemovicicum strain Viu22 chromosome, complete genome	blastn	28405	324	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium lemovicicum
9062132	9062132	PRJEB673_P_NODE_10588_length_171_cov_2.080882_g10239_i0	PRJEB673	10588	171	2.080882	3.55830822	Mycoplasma insons	386460	Bacteria	Bacteria	252	1.32e-62	NTclustered	gi\|299851941\|gb\|HM135467.1\|	386460	g10239	i0	92.982	245	171	12	100	0	1	171	2063	2233	Mycoplasma insons strain I17P1 23S ribosomal RNA gene, partial sequence	blastn	41895	252	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma insons
9062243	9062243	PRJEB673_P_NODE_9868_length_185_cov_1.866667_g9519_i0	PRJEB673	9868	185	1.866667	3.45333395	Miniimonas sp. S16	2171623	Bacteria	Bacteria	228	2.4499999999999995e-55	NTclustered	gi\|1384397111\|gb\|CP029049.1\|	2171623	g9519	i0	90.286	182.756756756757	175	15	94	2	1	174	803788	803961	Miniimonas sp. S16 chromosome, complete genome	blastn	33810	228	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Beutenbergiaceae	Miniimonas	Miniimonas sp. S16
9923354	9923354	PRJEB673_P_NODE_4728_length_425_cov_10.697436_g4380_i0	PRJEB673	4728	425	10.697436	45.464103	Rhodococcus	1827	Bacteria	Bacteria	636	8.889999999999999e-178	NTclustered	gi\|2921205402\|gb\|CP134707.1\|	37919	g4380	i0	94.647	385.642352941176	411	21	97	1	4	413	2199619	2199209	Rhodococcus opacus strain DSM 43205 chromosome, complete genome	blastn	163898	641	0.992199687987519	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
10337953	10337953	PRJEB673_P_NODE_3409_length_540_cov_6.069307_g3091_i0	PRJEB673	3409	540	6.069307	32.7742578	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	976	0	NTclustered	gi\|2874253708\|emb\|OY969473.1\|	3039803	g3091	i0	99.259	290.972222222222	540	4	100	0	1	540	1214862	1215401	MAG: uncultured Actinomycetota bacterium isolate MFD01275.bin.c.21 genome assembly, chromosome: 1	blastn	157125	976	1	Bacteria		Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
10337980	10337980	PRJEB673_P_NODE_5589_length_375_cov_2.005882_g5240_i0	PRJEB673	5589	375	2.005882	7.5220575	Epidermidibacterium keratini	1891644	Bacteria	Bacteria	58.4	7.67e-4	NTclustered	gi\|1790790271\|gb\|CP047156.1\|	1891644	g5240	i0	97.059	0.0906666666666667	34	1	9	0	325	358	880483	880450	Epidermidibacterium keratini strain EPI-7 chromosome, complete genome	blastn	34	58.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Sporichthyales	Sporichthyaceae	Epidermidibacterium	Epidermidibacterium keratini
10337990	10337990	PRJEB673_P_NODE_7069_length_325_cov_3.448276_g6720_i0	PRJEB673	7069	325	3.448276	11.206897	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	584	2.4399999999999993e-162	NTclustered	gi\|2874253708\|emb\|OY969473.1\|	3039803	g6720	i0	99.077	408.273846153846	325	3	100	0	1	325	1214075	1213751	MAG: uncultured Actinomycetota bacterium isolate MFD01275.bin.c.21 genome assembly, chromosome: 1	blastn	132689	584	1	Bacteria		Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
11613355	11613355	PRJEB673_P_NODE_10570_length_171_cov_6.676471_g10221_i0	PRJEB673	10570	171	6.676471	11.41676541	Microlunatus sagamiharensis	546874	Bacteria	Bacteria	278	2.17e-70	NTclustered	gi\|1086063565\|emb\|LT629799.1\|	546874	g10221	i0	95.906	249.859649122807	171	7	100	0	1	171	1045872	1045702	Friedmanniella sagamiharensis strain DSM 21743 genome assembly, chromosome: I	blastn	42726	278	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sagamiharensis
13748702	13748702	PRJEB673_P_NODE_6691_length_335_cov_3.450000_g6342_i0	PRJEB673	6691	335	3.45	11.5575	Streptococcus	1301	Bacteria	Bacteria	448	3.4499999999999995e-121	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g6342	i0	90.936	355.301492537313	342	18	100	11	1	335	1571581	1571246	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	119026	448	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
14163283	14163283	PRJEB673_P_NODE_2272_length_646_cov_6.085106_g452_i1	PRJEB673	2272	646	6.085106	39.30978476	Microlunatus sagamiharensis	546874	Bacteria	Bacteria	821	0	NTclustered	gi\|1086063565\|emb\|LT629799.1\|	546874	g452	i1	90.047	215.303405572755	643	50	98	14	1	636	1045734	1045099	Friedmanniella sagamiharensis strain DSM 21743 genome assembly, chromosome: I	blastn	139086	821	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sagamiharensis
15437429	15437429	PRJEB673_P_NODE_593_length_1172_cov_11.905893_g452_i0	PRJEB673	593	1172	11.905893	139.53706596	Microlunatus sagamiharensis	546874	Bacteria	Bacteria	1799	0	NTclustered	gi\|1086063565\|emb\|LT629799.1\|	546874	g452	i0	94.388	295.134812286689	1176	58	100	8	1	1172	1044563	1045734	Friedmanniella sagamiharensis strain DSM 21743 genome assembly, chromosome: I	blastn	345898	1799	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sagamiharensis
18846968	18846968	PRJEB673_P_NODE_12115_length_156_cov_1.264463_g11766_i0	PRJEB673	12115	156	1.264463	1.97256228	Streptococcus	1301	Bacteria	Bacteria	279	5.41e-71	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g11766	i0	99.351	333.076923076923	154	1	99	0	3	156	1568869	1568716	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	51960	279	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
18846972	18846972	PRJEB673_P_NODE_3035_length_571_cov_9.977612_g2722_i0	PRJEB673	3035	571	9.977612	56.97216452	Micrococcus	1269	Bacteria	Bacteria	972	0	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g2722	i0	97.373	263.14711033275	571	15	100	0	1	571	346368	346938	Micrococcus luteus strain V017 chromosome, complete genome	blastn	150257	972	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
19260522	19260522	PRJEB673_P_NODE_4756_length_423_cov_1.603093_g4408_i0	PRJEB673	4756	423	1.603093	6.78108339	uncultured Mycoplasma sp.	167967	Bacteria	Bacteria	754	0	NTclustered	gi\|84873335\|gb\|DQ340193.1\|	167967	g4408	i0	98.818	99.8605200945626	423	5	100	0	1	423	888	466	Uncultured Mycoplasma sp. clone TP-2 16S ribosomal RNA gene, partial sequence	blastn	42241	754	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	uncultured Mycoplasma sp.
20121791	20121791	PRJEB673_P_NODE_676_length_1107_cov_12.180970_g520_i0	PRJEB673	676	1107	12.18097	134.8433379	Propionibacteriales	85009	Bacteria	Bacteria	1620	0	NTclustered	gi\|470475867\|ref\|NR_076305.1\|	29405	g520	i0	93.082	291.09756097561	1113	67	100	10	1	1107	756	1864	Microlunatus phosphovorus strain NM-1 23S ribosomal RNA gene, complete sequence	blastn	322245	1633	0.99203919167177	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus phosphovorus
20121792	20121792	PRJEB673_P_NODE_8816_length_234_cov_1.708543_g8467_i0	PRJEB673	8816	234	1.708543	3.99799062	Nocardioides	1839	Bacteria	Bacteria	361	3.0699999999999996e-95	NTclustered	gi\|1999037722\|gb\|CP022296.1\|	2017486	g8467	i0	94.468	176.059829059829	235	11	100	2	1	234	1842369	1842136	Nocardioides sp. S5 chromosome, complete genome	blastn	41198	361	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. S5
20535875	20535875	PRJEB673_P_NODE_8997_length_218_cov_2.387978_g8648_i0	PRJEB673	8997	218	2.387978	5.20579204	Nocardioides piscis	2714938	Bacteria	Bacteria	215	2.32e-51	NTclustered	gi\|1821135706\|gb\|CP049866.1\|	2714938	g8648	i0	86.058	187.114678899083	208	19	93	9	16	218	2429718	2429516	Nocardioides piscis strain HDW12A chromosome, complete genome	blastn	40791	215	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides piscis
21397417	21397417	PRJEB673_P_NODE_5117_length_398_cov_9.157025_g4768_i0	PRJEB673	5117	398	9.157025	36.4449595	Modestobacter	88138	Bacteria	Bacteria	453	8.940000000000001e-123	NTclustered	gi\|470491309\|ref\|NR_077032.1\|	477641	g4768	i0	97.026	161.502512562814	269	8	68	0	130	398	3072	2804	Modestobacter marinus strain BC501 23S ribosomal RNA, complete sequence	blastn	64278	453	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Modestobacter	Modestobacter marinus
23947820	23947820	PRJEB673_P_NODE_5179_length_395_cov_2.363889_g4830_i0	PRJEB673	5179	395	2.363889	9.33736155	Geodermatophilaceae	85030	Bacteria	Bacteria	276	2.06e-69	NTclustered	gi\|470491309\|ref\|NR_077032.1\|	477641	g4830	i0	96.951	117.554430379747	164	5	78	0	1	164	2	165	Modestobacter marinus strain BC501 23S ribosomal RNA, complete sequence	blastn	46434	276	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Modestobacter	Modestobacter marinus
23947826	23947826	PRJEB673_P_NODE_9019_length_217_cov_3.527473_g8670_i0	PRJEB673	9019	217	3.527473	7.65461641	Bacteria	2	Bacteria	Bacteria	387	4.63e-103	NTclustered	gi\|326205812\|gb\|HQ827432.1\|	1211	g8670	i0	99.07	99.5253456221198	215	2	99	0	3	217	138	352	Uncultured cyanobacterium clone ciam16_P1R2H06 16S ribosomal RNA gene, partial sequence	blastn	21597	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
23947827	23947827	PRJEB673_P_NODE_9319_length_201_cov_2.271084_g8970_i0	PRJEB673	9319	201	2.271084	4.56487884	Streptococcus	1301	Bacteria	Bacteria	355	1.19e-93	NTclustered	gi\|1948677368\|gb\|CP066059.1\|	1303	g8970	i0	98.507	316.034825870647	201	3	100	0	1	201	902549	902349	Streptococcus oralis strain FDAARGOS_1021 chromosome, complete genome	blastn	63523	355	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis

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