metadata: contig_metadata: 26 rows where bioproject = "PRJNA870096", tax_kingdom = "Bacillati" and tax

26 rows where bioproject = "PRJNA870096", tax_kingdom = "Bacillati" and tax_phylum = "Actinomycetota"

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
2512868	2512868	PRJNA870096_S_NODE_49162_length_251_cov_1.985577_g47498_i0	PRJNA870096	49162	251	1.985577	4.98379827	Microbacterium	33882	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|392312294\|gb\|JQ897420.1\|	36807	g47498	i0	100	100.462151394422	251	0	100	0	1	251	17	267	Microbacterium laevaniformans 16S ribosomal RNA gene, partial sequence	blastn	25216	464	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium laevaniformans
6341223	6341223	PRJNA870096_S_NODE_23865_length_369_cov_3.466258_g22202_i0	PRJNA870096	23865	369	3.466258	12.79049202	PVC group	1783257	Bacteria	Bacteria	69.4	3.48e-7	NTclustered	gi\|1346221182\|gb\|CP026923.1\|	1159327	g22202	i0	95.349	12.0487804878049	43	2	12	0	1	43	1691139	1691181	Pontimonas salivibrio strain CL-TW6 chromosome, complete genome	blastn	4446	69.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Pontimonas	Pontimonas salivibrio
8502717	8502717	PRJNA870096_S_NODE_145387_length_150_cov_1.345794_g143723_i0	PRJNA870096	145387	150	1.345794	2.018691	Nocardioides okcheonensis	2894081	Bacteria	Bacteria	176	6.95e-40	NTclustered	gi\|2156608594\|gb\|CP087710.1\|	2894081	g143723	i0	88.079	107.466666666667	151	15	100	3	1	150	745377	745229	Nocardioides okcheonensis strain MMS20-HV4-12 chromosome, complete genome	blastn	16120	176	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides okcheonensis
9777960	9777960	PRJNA870096_S_NODE_36288_length_296_cov_1.031621_g34624_i0	PRJNA870096	36288	296	1.031621	3.05359816	Streptomyces bacillaris	68179	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1409660139\|gb\|CP029378.1\|	68179	g34624	i0	100	0.0945945945945946	28	0	9	0	136	163	4653081	4653054	Streptomyces bacillaris strain ATCC 15855 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces bacillaris
11053651	11053651	PRJNA870096_S_NODE_27869_length_340_cov_3.131313_g26205_i0	PRJNA870096	27869	340	3.131313	10.6464642	Rhodococcus sp. B7740	1564114	Bacteria	Bacteria	584	2.56e-162	NTclustered	gi\|769526933\|gb\|CP010797.1\|	1564114	g26205	i0	97.647	81.9882352941176	340	8	100	0	1	340	1952536	1952875	Rhodococcus sp. B7740, complete genome	blastn	27876	584	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. B7740
12716773	12716773	PRJNA870096_S_NODE_120130_length_162_cov_2.016807_g118466_i0	PRJNA870096	120130	162	2.016807	3.26722734	Rhodococcus	1827	Bacteria	Bacteria	283	4.39e-72	NTclustered	gi\|2660106423\|gb\|CP138905.1\|	1831	g118466	i0	98.148	75.5864197530864	162	3	100	0	1	162	38162	38323	MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome	blastn	12245	283	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. (in: high G+C Gram-positive bacteria)
13602926	13602926	PRJNA870096_S_NODE_10191_length_578_cov_4.183178_g8629_i0	PRJNA870096	10191	578	4.183178	24.17876884	Microbacterium sp. PM5	2014534	Bacteria	Bacteria	754	0	NTclustered	gi\|1419380645\|gb\|CP022162.1\|	2014534	g8629	i0	93.077	245.399653979239	520	29	89	5	1	514	1409493	1410011	Microbacterium sp. PM5 genome	blastn	141841	754	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. PM5
16539943	16539943	PRJNA870096_S_NODE_7033_length_704_cov_5.438729_g5664_i0	PRJNA870096	7033	704	5.438729	38.28865216	Nocardiaceae	85025	Bacteria	Bacteria	1131	0	NTclustered	gi\|2637134465\|gb\|CP140264.1\|	1828	g5664	i0	98.742	369.742897727273	636	8	90	0	69	704	1710611	1709976	Rhodococcoides fascians strain GS01 chromosome, complete genome	blastn	260299	1131	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
17428581	17428581	PRJNA870096_S_NODE_65334_length_217_cov_1.103448_g63670_i0	PRJNA870096	65334	217	1.103448	2.39448216	Rubrobacter xylanophilus	49319	Bacteria	Bacteria	359	1.01e-94	NTclustered	gi\|2076041053\|gb\|CP073779.1\|	266117	g63670	i0	97.17	2.93087557603687	212	6	98	0	6	217	2753641	2753430	Rubrobacter xylanophilus DSM 9941 chromosome	blastn	636	359	1	Bacteria	Bacillati	Actinomycetota	Rubrobacteria	Rubrobacterales	Rubrobacteraceae	Rubrobacter	Rubrobacter xylanophilus
18701206	18701206	PRJNA870096_S_NODE_15155_length_470_cov_2.241218_g13517_i0	PRJNA870096	15155	470	2.241218	10.5337246	Microbacterium proteolyticum	1572644	Bacteria	Bacteria	774	0	NTclustered	gi\|2482566189\|gb\|CP121274.1\|	1572644	g13517	i0	96.383	177.51914893617	470	17	100	0	1	470	2452224	2452693	Microbacterium proteolyticum strain ustc chromosome, complete genome	blastn	83434	774	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium proteolyticum
25076099	25076099	PRJNA870096_S_NODE_32900_length_312_cov_1.840149_g31236_i0	PRJNA870096	32900	312	1.840149	5.74126488	Rhodococcoides fascians	1828	Bacteria	Bacteria	505	1.8599999999999995e-138	NTclustered	gi\|2637134465\|gb\|CP140264.1\|	1828	g31236	i0	95.847	101.650641025641	313	11	100	2	1	312	1243174	1242863	Rhodococcoides fascians strain GS01 chromosome, complete genome	blastn	31715	505	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
25464016	25464016	PRJNA870096_S_NODE_6520_length_732_cov_6.626996_g5201_i0	PRJNA870096	6520	732	6.626996	48.50961072	Microbacterium	33882	Bacteria	Bacteria	1317	0	NTclustered	gi\|2164491193\|gb\|CP082781.1\|	156977	g5201	i0	99.314	185.572404371585	729	4	99	1	5	732	397671	396943	Microbacterium resistens strain MZT7 chromosome, complete genome	blastn	135839	1330	0.990225563909774	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium resistens
26801931	26801931	PRJNA870096_S_NODE_12481_length_521_cov_4.537657_g10861_i0	PRJNA870096	12481	521	4.537657	23.64119297	Kribbella turkmenica	2530375	Bacteria	Bacteria	51.2	6.59e-4	NR	WP_132315269.1	2530375	g10861	i0	33.3	0.293666026871401	51	34	29.4	0	486	334	483	533	WP_132315269.1 tectonin domain-containing protein [Kribbella turkmenica]	diamond	153	51.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Kribbellaceae	Kribbella	Kribbella turkmenica
26897148	26897148	PRJNA870096_S_NODE_116101_length_165_cov_1.180328_g114437_i0	PRJNA870096	116101	165	1.180328	1.9475412	Actinomycetota bacterium	2900548	Bacteria	Bacteria	45.1	0.00196	NR	MEO8477945.1	2900548	g114437	i0	63	5.45454545454545	27	10	49.1	0	2	82	598	624	MEO8477945.1 primary-amine oxidase [Actinomycetota bacterium]	diamond	900	45.1	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
27023527	27023527	PRJNA870096_S_NODE_53222_length_241_cov_1.616162_g51558_i0	PRJNA870096	53222	241	1.616162	3.89495042	Smaragdicoccus niigatensis	359359	Bacteria	Bacteria	54.3	5.32e-7	NR	WP_018160479.1	359359	g51558	i0	39.4	2.66390041493776	71	43	88.4	0	25	237	32	102	WP_018160479.1 nuclear transport factor 2 family protein [Smaragdicoccus niigatensis]	diamond	642	54.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Smaragdicoccus	Smaragdicoccus niigatensis
27442789	27442789	PRJNA870096_S_NODE_143583_length_151_cov_0.888889_g141919_i0	PRJNA870096	143583	151	0.888889	1.34222239	Corynebacterium	1716	Bacteria	Bacteria	40.8	0.0467	NR	WP_187405490.1	2044585	g141919	i0	39.5	2.56291390728477	43	26	85.4	0	1	129	125	167	WP_187405490.1 hypothetical protein [Corynebacterium sp. LK15]	diamond	387	41.2	0.990291262135922	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. LK15
27727113	27727113	PRJNA870096_S_NODE_126504_length_158_cov_2.086957_g124840_i0	PRJNA870096	126504	158	2.086957	3.29739206	Bacteria	2	Bacteria	Bacteria	58.5	3.09e-8	NR	HJQ78200.1	2080302	g124840	i0	67.6	8.9050632911392391	37	12	70.3	0	158	48	350	386	HJQ78200.1 bifunctional sulfate adenylyltransferase/adenylylsulfate kinase [Acidimicrobiia bacterium]	diamond	1407	58.5	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
27813555	27813555	PRJNA870096_S_NODE_50724_length_247_cov_2.117647_g49060_i0	PRJNA870096	50724	247	2.117647	5.23058809	Streptomyces tsukubensis	83656	Bacteria	Bacteria	49.3	9.39e-5	NR	WP_077970353.1	83656	g49060	i0	38.6	0.850202429149798	70	40	81.4	1	38	238	10	79	WP_077970353.1 EF-hand domain-containing protein [Streptomyces tsukubensis]	diamond	210	49.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces tsukubensis
28894779	28894779	PRJNA870096_S_NODE_93468_length_182_cov_1.726619_g91804_i0	PRJNA870096	93468	182	1.726619	3.14244658	Bacteria	2	Bacteria	Bacteria	100	1.68e-23	NR	WP_104122816.1	547334	g91804	i0	75	1.97802197802198	60	15	98.9	0	181	2	191	250	WP_104122816.1 VPA1269 family protein [Arthrobacter pityocampae]	diamond	360	100	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter pityocampae
29526493	29526493	PRJNA870096_S_NODE_92870_length_183_cov_1.028571_g91206_i0	PRJNA870096	92870	183	1.028571	1.88228493	PVC group	1783257	Bacteria	Bacteria	53.9	1.77e-6	NR	WP_301648591.1	29301	g91206	i0	44.8	8.98360655737705	58	32	95.1	0	5	178	168	225	WP_301648591.1 hypothetical protein [Streptomyces arenae]	diamond	1644	53.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces arenae
29865641	29865641	PRJNA870096_S_NODE_70531_length_208_cov_3.400000_g68867_i0	PRJNA870096	70531	208	3.4	7.072	Gaiellaceae bacterium	2838783	Bacteria	Bacteria	85.1	9.82e-19	NR	HXK13170.1	2838783	g68867	i0	56.5	4.93269230769231	69	30	99.5	0	208	2	13	81	HXK13170.1 thioredoxin [Gaiellaceae bacterium]	diamond	1026	85.1	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Gaiellales	Gaiellaceae		Gaiellaceae bacterium
30371583	30371583	PRJNA870096_S_NODE_42852_length_270_cov_6.449339_g41188_i0	PRJNA870096	42852	270	6.449339	17.4132153	Kitasatospora sp. NBC_	1871188	Bacteria	Bacteria	80.5	4.32e-17	NR	WP_371520111.1	2903574	g41188	i0	67.2	0.644444444444444	58	17	62.2	1	168	1	63	120	WP_371520111.1 nuclear transport factor 2 family protein [Kitasatospora sp. NBC_01300]	diamond	174	80.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora sp. NBC_01300
31255862	31255862	PRJNA870096_S_NODE_40455_length_279_cov_2.033898_g38791_i0	PRJNA870096	40455	279	2.033898	5.67457542	Microthrixaceae bacterium	2497627	Bacteria	Bacteria	42.7	0.0316	NR	MCB1026617.1	2497627	g38791	i0	33.9	0.634408602150538	59	34	63.4	1	8	184	26	79	MCB1026617.1 hypothetical protein [Microthrixaceae bacterium]	diamond	177	42.7	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Microthrixaceae		Microthrixaceae bacterium
31793346	31793346	PRJNA870096_S_NODE_90157_length_185_cov_2.028169_g88493_i0	PRJNA870096	90157	185	2.028169	3.75211265	Nocardiopsis sp. NPDC	310350	Bacteria	Bacteria	41.6	0.0452	NR	WP_378895109.1	3346256	g88493	i0	41.3	0.745945945945946	46	24	69.7	1	4	132	308	353	WP_378895109.1 LamG-like jellyroll fold domain-containing protein [Nocardiopsis sp. NPDC057823]	diamond	138	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis sp. NPDC057823
31825026	31825026	PRJNA870096_S_NODE_106357_length_172_cov_1.116279_g104693_i0	PRJNA870096	106357	172	1.116279	1.91999988	Mycobacterium sp.	1785	Bacteria	Bacteria	39.7	0.0449	NR	MDT5217080.1	1785	g104693	i0	42	0.872093023255814	50	29	87.2	0	5	154	30	79	MDT5217080.1 hypothetical protein [Mycobacterium sp.]	diamond	150	39.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
31920142	31920142	PRJNA870096_S_NODE_54577_length_238_cov_1.205128_g52913_i0	PRJNA870096	54577	238	1.205128	2.86820464	Atopobium sp.	1872650	Bacteria	Bacteria	40.8	0.0441	NR	MBF0921145.1	1872650	g52913	i0	44.4	0.453781512605042	36	20	45.4	0	77	184	1	36	MBF0921145.1 hypothetical protein [Atopobium sp.]	diamond	108	40.8	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Atopobiaceae	Atopobium	Atopobium sp.

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