metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1168532" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1168532" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1040232	1040232	PRJNA1168532_S_NODE_226421_length_203_cov_1.762500_g223478_i0	PRJNA1168532	226421	203	1.7625	3.577875	root	1	Root_unresolved	Root_unresolved	375	9.24e-100	NTclustered	gi\|2497259144\|gb\|OQ874907.1\|	1306	g223478	i0	100	100	203	0	100	0	1	203	498	296	Streptococcus sp. strain QT-53 16S ribosomal RNA gene, partial sequence	blastn	20300	375	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.
1589845	1589845	PRJNA1168532_S_NODE_219762_length_207_cov_1.310976_g216819_i0	PRJNA1168532	219762	207	1.310976	2.71372032	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	355	1.23e-93	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g216819	i0	97.585	325.729468599034	207	5	100	0	1	207	552129	551923	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	67426	355	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
5418256	5418256	PRJNA1168532_S_NODE_256445_length_187_cov_1.437500_g253502_i0	PRJNA1168532	256445	187	1.4375	2.688125	uncultured Actinomycetes bacterium	152507	Bacteria	Bacteria	62.1	2.66e-5	NTclustered	gi\|530190787\|emb\|HG379975.1\|	152507	g253502	i0	93.182	0.235294117647059	44	0	22	3	114	154	68	25	Uncultured actinobacterium partial 16S rRNA gene, clone ET3Rk82	blastn	44	62.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				uncultured Actinomycetes bacterium
5418264	5418264	PRJNA1168532_S_NODE_295985_length_170_cov_1.645669_g293042_i0	PRJNA1168532	295985	170	1.645669	2.7976373	Staphylococcus auricularis	29379	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|1403688813\|emb\|LS483491.1\|	29379	g293042	i0	100	495.6	170	0	100	0	1	170	1486561	1486730	Staphylococcus auricularis strain NCTC12101 genome assembly, chromosome: 1	blastn	84252	315	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus auricularis
6143095	6143095	PRJNA1168532_S_NODE_221685_length_206_cov_1.159509_g218742_i0	PRJNA1168532	221685	206	1.159509	2.38858854	root	1	Root_unresolved	Root_unresolved	241	3.5800000000000007e-59	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g218742	i0	100	69.8155339805825	130	0	100	0	1	130	1185	1314	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	14382	241	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
7418092	7418092	PRJNA1168532_S_NODE_242326_length_194_cov_2.337748_g239383_i0	PRJNA1168532	242326	194	2.337748	4.53523112	Streptococcus	1301	Bacteria	Bacteria	353	4.1e-93	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g239383	i0	99.485	428.329896907216	194	1	100	0	1	194	424105	424298	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	83096	353	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
7968502	7968502	PRJNA1168532_S_NODE_318607_length_162_cov_1.579832_g315664_i0	PRJNA1168532	318607	162	1.579832	2.55932784	Mycoplasma wenyonii	65123	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g315664	i0	100	1	162	0	100	0	1	162	447386	447225	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	162	300	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
8693201	8693201	PRJNA1168532_S_NODE_288207_length_173_cov_1.446154_g285264_i0	PRJNA1168532	288207	173	1.446154	2.50184642	root	1	Root_unresolved	Root_unresolved	309	7.81e-80	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g285264	i0	98.844	97.9479768786127	173	2	100	0	1	173	259	87	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	16945	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8693203	8693203	PRJNA1168532_S_NODE_5047_length_1001_cov_3.054280_g4069_i0	PRJNA1168532	5047	1001	3.05428	30.5733428	Cutibacterium	1912216	Bacteria	Bacteria	1844	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4069	i0	99.9	254.448551448551	1001	1	100	0	1	1001	55515	56515	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	254703	1844	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9968382	9968382	PRJNA1168532_S_NODE_347308_length_153_cov_1.572727_g344365_i0	PRJNA1168532	347308	153	1.572727	2.40627231	Corynebacterium	1716	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g344365	i0	100	368	153	0	100	0	1	153	2492766	2492918	Corynebacterium accolens strain CA3 chromosome	blastn	56304	283	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
11243535	11243535	PRJNA1168532_S_NODE_250889_length_190_cov_1.102041_g247946_i0	PRJNA1168532	250889	190	1.102041	2.0938779	Staphylococcus	1279	Bacteria	Bacteria	351	1.4399999999999997e-92	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g247946	i0	100	84.2473684210526	190	0	100	0	1	190	2002019	2001830	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	16007	351	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
11793795	11793795	PRJNA1168532_S_NODE_288550_length_173_cov_1.261538_g285607_i0	PRJNA1168532	288550	173	1.261538	2.18246074	Corynebacterium kefirresidentii	1979527	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|2869817591\|gb\|CP175775.1\|	1979527	g285607	i0	100	355.71676300578	173	0	100	0	1	173	1846	1674	Corynebacterium kefirresidentii strain YSMAA3_1_H1 chromosome, complete genome	blastn	61539	320	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
12518935	12518935	PRJNA1168532_S_NODE_206770_length_215_cov_1.308140_g203827_i0	PRJNA1168532	206770	215	1.30814	2.812501	Micrococcus	1269	Bacteria	Bacteria	350	5.999999999999999e-92	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g203827	i0	96.244	312.158139534884	213	8	99	0	1	213	347478	347266	Micrococcus luteus strain V017 chromosome, complete genome	blastn	67114	350	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
16342763	16342763	PRJNA1168532_S_NODE_55373_length_409_cov_1.568306_g52501_i0	PRJNA1168532	55373	409	1.568306	6.41437154	Bacillati	1783272	Bacteria	Bacteria	715	0	NTclustered	gi\|9623518\|gb\|AF269622.1\|AF269622	1282	g52501	i0	98.997	505.672371638142	399	4	98	0	11	409	3766	3368	Staphylococcus epidermidis strain SR1 clone step.1014c03 genomic sequence	blastn	206820	715	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20166586	20166586	PRJNA1168532_S_NODE_110356_length_306_cov_1.844106_g107413_i0	PRJNA1168532	110356	306	1.844106	5.64296436	Corynebacterium	1716	Bacteria	Bacteria	555	1.7799999999999996e-153	NTclustered	gi\|2869817591\|gb\|CP175775.1\|	1979527	g107413	i0	99.346	339.052287581699	306	2	100	0	1	306	2773	3078	Corynebacterium kefirresidentii strain YSMAA3_1_H1 chromosome, complete genome	blastn	103750	555	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
20166591	20166591	PRJNA1168532_S_NODE_226536_length_203_cov_1.625000_g223593_i0	PRJNA1168532	226536	203	1.625	3.29875	Staphylococcus	1279	Bacteria	Bacteria	375	9.24e-100	NTclustered	gi\|2071692135\|gb\|CP073824.1\|	1282	g223593	i0	100	545.768472906404	203	0	100	0	1	203	699770	699972	Staphylococcus epidermidis strain B1200599 chromosome, complete genome	blastn	110791	375	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20716532	20716532	PRJNA1168532_S_NODE_254117_length_188_cov_1.620690_g251174_i0	PRJNA1168532	254117	188	1.62069	3.0468972	Mycoplasma ovis	171632	Bacteria	Bacteria	187	4.2299999999999985e-43	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g251174	i0	84.574	1	188	29	100	0	1	188	59113	59300	Mycoplasma ovis str. Michigan, complete genome	blastn	188	187	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
22717158	22717158	PRJNA1168532_S_NODE_210058_length_213_cov_1.176471_g207115_i0	PRJNA1168532	210058	213	1.176471	2.50588323	Corynebacterium	1716	Bacteria	Bacteria	344	2.76e-90	NTclustered	gi\|2869858840\|gb\|CP175793.1\|	3383589	g207115	i0	100	319.201877934272	186	0	87	0	1	186	723712	723527	Corynebacterium sp. YSMAA1_1_D6 chromosome, complete genome	blastn	67990	344	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. YSMAA1_1_D6

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