metadata: contig_metadata: 16 rows where bioproject = "PRJNA798511", tax_kingdom = "Bacillati" and tax

16 rows where bioproject = "PRJNA798511", 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
789611	789611	PRJNA798511_P_NODE_102981_length_241_cov_0.916667_g98715_i0	PRJNA798511	102981	241	0.916667	2.20916747	Mycobacteroides salmoniphilum	404941	Bacteria	Bacteria	390	4.05e-104	NTclustered	gi\|1626698579\|gb\|CP024633.1\|	404941	g98715	i0	95.851	14.7966804979253	241	10	100	0	1	241	3054817	3055057	Mycobacteroides salmoniphilum strain DSM 43276 chromosome	blastn	3566	390	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides salmoniphilum
3342342	3342342	PRJNA798511_P_NODE_97323_length_245_cov_0.895349_g93057_i0	PRJNA798511	97323	245	0.895349	2.19360505	Corynebacterium accolens	38284	Bacteria	Bacteria	305	1.54e-78	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g93057	i0	89.431	25.0530612244898	246	21	99	4	1	243	1386880	1387123	Corynebacterium accolens strain CA3 chromosome	blastn	6138	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
10994553	10994553	PRJNA798511_P_NODE_47229_length_371_cov_2.902685_g42963_i0	PRJNA798511	47229	371	2.902685	10.76896135	Rothia dentocariosa	2047	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2894503601\|gb\|CP178332.1\|	2047	g42963	i0	96.875	0.0862533692722372	32	0	9	1	138	169	1169337	1169367	Rothia dentocariosa strain SOSUI018 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia dentocariosa
17369667	17369667	PRJNA798511_P_NODE_95594_length_246_cov_0.890173_g91328_i0	PRJNA798511	95594	246	0.890173	2.18982558	Schaalia sp. HMT-877	3059029	Bacteria	Bacteria	117	7.77e-22	NTclustered	gi\|2557565758\|gb\|CP130059.1\|	3059029	g91328	i0	85.088	0.463414634146341	114	17	46	0	133	246	327598	327711	Schaalia sp. HMT-877 strain F0543 chromosome, complete genome	blastn	114	117	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia sp. HMT-877
17795416	17795416	PRJNA798511_P_NODE_103234_length_241_cov_0.916667_g98968_i0	PRJNA798511	103234	241	0.916667	2.20916747	Cutibacterium	1912216	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g98968	i0	100	56.7344398340249	241	0	100	0	1	241	1553996	1554236	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13673	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21193626	21193626	PRJNA798511_P_NODE_88497_length_251_cov_0.865169_g84231_i0	PRJNA798511	88497	251	0.865169	2.17157419	Actinomycetes	1760	Bacteria	Bacteria	113	7.030000000000001e-27	NR	WP_218026015.1	282684	g84231	i0	70.2	38.4262948207171	84	24	99.2	1	1	249	1895	1978	WP_218026015.1 SDR family NAD(P)-dependent oxidoreductase [Nocardia miyunensis]	diamond	9645	113	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia miyunensis
22895300	22895300	PRJNA798511_P_NODE_36238_length_457_cov_1.375000_g31979_i0	PRJNA798511	36238	457	1.375	6.28375	Gardnerella	2701	Bacteria	Bacteria	52.8	0.044	NTclustered	gi\|2769796964\|gb\|CP160093.1\|	2702	g31979	i0	100	0.12253829321663	28	0	6	0	159	186	1116982	1116955	Gardnerella vaginalis strain 1683_1263_1_CBA4 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Gardnerella	Gardnerella vaginalis
27654370	27654370	PRJNA798511_P_NODE_53544_length_341_cov_1.059701_g49278_i0	PRJNA798511	53544	341	1.059701	3.61358041	Solirubrobacteraceae bacterium	2586742	Bacteria	Bacteria	46.2	0.00581	NR	HZO36794.1	2586742	g49278	i0	37.3	1.63636363636364	75	41	60.7	1	24	230	5	79	HZO36794.1 DsbA family oxidoreductase [Solirubrobacteraceae bacterium]	diamond	558	46.2	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
29138447	29138447	PRJNA798511_P_NODE_91909_length_248_cov_1.760000_g87643_i0	PRJNA798511	91909	248	1.76	4.3648	Nonomuraea spiralis	46182	Bacteria	Bacteria	43.1	0.0273	NR	WP_189649627.1	46182	g87643	i0	42.9	0.508064516129032	42	23	50.8	1	87	212	23	63	WP_189649627.1 aldo/keto reductase [Nonomuraea spiralis]	diamond	126	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Nonomuraea	Nonomuraea spiralis
29201453	29201453	PRJNA798511_P_NODE_104409_length_232_cov_2.094340_g100143_i0	PRJNA798511	104409	232	2.09434	4.8588688	Pseudonocardiales bacterium	2201155	Bacteria	Bacteria	82.8	1.42e-18	NR	PZS03413.1	2201155	g100143	i0	53.7	1.82327586206897	67	30	85.3	1	14	211	13	79	PZS03413.1 MAG: hypothetical protein DLM56_09360 [Pseudonocardiales bacterium]	diamond	423	82.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales			Pseudonocardiales bacterium
29233038	29233038	PRJNA798511_P_NODE_55889_length_332_cov_1.189189_g51623_i0	PRJNA798511	55889	332	1.189189	3.94810748	Blastococcus sp. Marseille-P5729	2086582	Bacteria	Bacteria	47.8	0.00145	NR	WP_106850528.1	2086582	g51623	i0	36.4	0.596385542168675	66	40	57.8	1	279	88	124	189	WP_106850528.1 respiratory nitrate reductase subunit gamma [Blastococcus sp. Marseille-P5729]	diamond	198	47.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus sp. Marseille-P5729
29453589	29453589	PRJNA798511_P_NODE_82430_length_261_cov_2.829787_g78164_i0	PRJNA798511	82430	261	2.829787	7.38574407	Mycobacterium simulans	627089	Bacteria	Bacteria	42.7	0.0472	NR	WP_191496213.1	627089	g78164	i0	31.6	0.873563218390805	76	51	87.4	1	229	2	761	835	WP_191496213.1 type VII secretion protein EccCa [Mycobacterium simulans]	diamond	228	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium simulans
29896098	29896098	PRJNA798511_P_NODE_30531_length_530_cov_6.733042_g26291_i0	PRJNA798511	30531	530	6.733042	35.6851226	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	101	1.69e-23	NR	HEX3946098.1	2201156	g26291	i0	33.3	1.83396226415094	162	102	91.1	3	486	4	6	162	HEX3946098.1 hemerythrin domain-containing protein [Acidimicrobiales bacterium]	diamond	972	101	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
30370344	30370344	PRJNA798511_P_NODE_59472_length_319_cov_1.991870_g55206_i0	PRJNA798511	59472	319	1.99187	6.3540653	Kutzneria chonburiensis	1483604	Bacteria	Bacteria	76.6	1.4e-14	NR	WP_273938474.1	1483604	g55206	i0	48.8	1.5141065830721	80	41	75.2	0	42	281	103	182	WP_273938474.1 ATP-dependent Clp protease proteolytic subunit [Kutzneria chonburiensis]	diamond	483	76.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Kutzneria	Kutzneria chonburiensis
30685706	30685706	PRJNA798511_P_NODE_37713_length_441_cov_5.796196_g33453_i0	PRJNA798511	37713	441	5.796196	25.56122436	Rubrobacter sp.	2036010	Bacteria	Bacteria	101	2.9e-24	NR	HET7270448.1	2036010	g33453	i0	43.8	3.73469387755102	121	68	82.3	0	363	1	26	146	HET7270448.1 Hsp20/alpha crystallin family protein [Rubrobacter sp.]	diamond	1647	101	1	Bacteria	Bacillati	Actinomycetota	Rubrobacteria	Rubrobacterales	Rubrobacteraceae	Rubrobacter	Rubrobacter sp.
31231870	31231870	PRJNA798511_P_NODE_95595_length_246_cov_0.890173_g91329_i0	PRJNA798511	95595	246	0.890173	2.18982558	Streptomyces	1883	Bacteria	Bacteria	42.7	0.0166	NR	WP_127828415.1	1883	g91329	i0	52.3	4.32926829268293	44	19	51.2	1	34	159	48	91	WP_127828415.1 MULTISPECIES: DUF742 domain-containing protein [Streptomyces]	diamond	1065	43.1	0.990719257540603	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces

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