metadata: contig_metadata: 14 rows where bioproject = "PRJEB6054", tax_kingdom = "Bacillati" and tax

14 rows where bioproject = "PRJEB6054", 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
25658821	25658821	PRJEB6054_S_NODE_11410_length_168_cov_3.511278_g11321_i0	PRJEB6054	11410	168	3.511278	5.89894704	Rothia mucilaginosa	43675	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g11321	i0	100	181.172619047619	168	0	100	0	1	168	653922	654089	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	30437	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
25659070	25659070	PRJEB6054_S_NODE_5314_length_220_cov_1.951351_g5225_i0	PRJEB6054	5314	220	1.951351	4.2929722	Streptomyces sp. RTd22	1841249	Bacteria	Bacteria	198	2.36e-46	NTclustered	gi\|1031970216\|gb\|CP015726.1\|	1841249	g5225	i0	93.893	61.5181818181818	131	8	60	0	1	131	9189409	9189279	Streptomyces sp. RTd22, complete genome	blastn	13534	198	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. RTd22
25751913	25751913	PRJEB6054_S_NODE_842_length_398_cov_7.380165_g754_i0	PRJEB6054	842	398	7.380165	29.3730567	Cutibacterium	1912216	Bacteria	Bacteria	736	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g754	i0	100	248.449748743719	398	0	100	0	1	398	55742	55345	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	98883	736	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25794948	25794948	PRJEB6054_S_NODE_15171_length_153_cov_1.203390_g15082_i0	PRJEB6054	15171	153	1.20339	1.8411867	Micrococcaceae bacterium Sec5.1	3114326	Bacteria	Bacteria	272	8.84e-69	NTclustered	gi\|2732516938\|gb\|CP143430.1\|	3114326	g15082	i0	98.693	372.993464052288	153	2	100	0	1	153	146485	146637	Micrococcaceae bacterium Sec5.1 chromosome, complete genome	blastn	57068	272	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae		Micrococcaceae bacterium Sec5.1
25795054	25795054	PRJEB6054_S_NODE_3395_length_254_cov_4.470320_g3306_i0	PRJEB6054	3395	254	4.47032	11.3546128	Corynebacterium marquesiae	2913503	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|2869813080\|gb\|CP175783.1\|	2913503	g3306	i0	100	365.964566929134	254	0	100	0	1	254	3358	3105	Corynebacterium marquesiae strain YSMAA1_2_D10 chromosome, complete genome	blastn	92955	470	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium marquesiae
25887558	25887558	PRJEB6054_S_NODE_10811_length_172_cov_1.167883_g10722_i0	PRJEB6054	10811	172	1.167883	2.00875876	Corynebacterium	1716	Bacteria	Bacteria	287	3.63e-73	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g10722	i0	100	322.087209302326	155	0	90	0	1	155	623915	624069	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	55399	287	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
26023867	26023867	PRJEB6054_S_NODE_2060_length_302_cov_50676.943820_g1971_i0	PRJEB6054	2060	302	50676.94382	153044.3703364	Cutibacterium	1912216	Bacteria	Bacteria	427	3.9999999999999998e-115	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1971	i0	100	219.62582781457	231	0	76	0	72	302	57316	57086	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	66327	427	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
26295839	26295839	PRJEB6054_S_NODE_4174_length_235_cov_2.310000_g4085_i0	PRJEB6054	4174	235	2.31	5.4285	Cutibacterium	1912216	Bacteria	Bacteria	407	3.9e-109	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4085	i0	100	285.387234042553	220	0	94	0	16	235	55865	56084	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	67066	407	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
26431801	26431801	PRJEB6054_S_NODE_4823_length_227_cov_6.161458_g4734_i0	PRJEB6054	4823	227	6.161458	13.98650966	Cutibacterium	1912216	Bacteria	Bacteria	320	5.02e-83	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4734	i0	99.432	201.493392070485	176	1	78	0	52	227	57101	56926	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	45739	320	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
26431834	26431834	PRJEB6054_S_NODE_7999_length_189_cov_3.350649_g7910_i0	PRJEB6054	7999	189	3.350649	6.33272661	Propionibacteriaceae	31957	Bacteria	Bacteria	287	4.08e-73	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g7910	i0	97.605	260.380952380952	167	4	88	0	23	189	57968	57802	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	49212	287	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
26475517	26475517	PRJEB6054_S_NODE_10816_length_172_cov_1.014599_g10727_i0	PRJEB6054	10816	172	1.014599	1.74511028	Phycicoccus jejuensis	367299	Bacteria	Bacteria	285	1.31e-72	NTclustered	gi\|2851167701\|gb\|CP085209.1\|	367299	g10727	i0	96.512	134.703488372093	172	6	100	0	1	172	2273140	2273311	Phycicoccus jejuensis strain QJJ-866 chromosome, complete genome	blastn	23169	285	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Phycicoccus	Phycicoccus jejuensis
26475594	26475594	PRJEB6054_S_NODE_15368_length_152_cov_4.042735_g15279_i0	PRJEB6054	15368	152	4.042735	6.1449572	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	259	6.82e-65	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g15279	i0	97.368	285.809210526316	152	4	100	0	1	152	551905	551754	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	43443	259	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
32945979	32945979	PRJEB6054_S_NODE_13578_length_158_cov_1.243902_g13489_i0	PRJEB6054	13578	158	1.243902	1.96536516	Spongiactinospora sp. TRM9	2871673	Bacteria	Bacteria	62.8	9.79e-10	NR	WP_277307989.1	3031114	g13489	i0	62.7	0.968354430379747	51	19	96.8	0	153	1	95	145	WP_277307989.1 M20 metallopeptidase family protein [Spongiactinospora sp. TRM90649]	diamond	153	62.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Spongiactinospora	Spongiactinospora sp. TRM90649
33116574	33116574	PRJEB6054_S_NODE_7159_length_197_cov_1.234568_g7070_i0	PRJEB6054	7159	197	1.234568	2.43209896	unclassified Streptomyces	2593676	Bacteria	Bacteria	42.7	0.0202	NR	WP_398017753.1	2593676	g7070	i0	45.7	0.700507614213198	46	22	70.1	1	178	41	132	174	WP_398017753.1 MULTISPECIES: IS110 family transposase [unclassified Streptomyces]	diamond	138	42.7	1	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);;