metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA773625" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA773625" 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
1207122	1207122	PRJNA773625_P_NODE_7481_length_169_cov_0.866667_g7466_i0	PRJNA773625	7481	169	0.866667	1.46466723	Mycobacterium	1763	Bacteria	Bacteria	202	1.32e-47	NTclustered	gi\|1198028085\|gb\|CP020810.1\|	482462	g7466	i0	88.166	4.69822485207101	169	20	100	0	1	169	24507	24675	Mycobacterium dioxanotrophicus strain PH-06 plasmid unnamed1, complete sequence	blastn	794	202	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium dioxanotrophicus
2482556	2482556	PRJNA773625_P_NODE_10262_length_163_cov_0.912281_g10247_i0	PRJNA773625	10262	163	0.912281	1.48701803	Erysipelotrichales	526525	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2777632677\|dbj\|AP031432.1\|	1982626	g10247	i0	100	14.7668711656442	163	0	100	0	1	163	2553175	2553013	Faecalibacillus intestinalis i32-0019-2J8 DNA, complete genome	blastn	2407	302	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Faecalibacillus	Faecalibacillus intestinalis
2482557	2482557	PRJNA773625_P_NODE_11082_length_162_cov_0.920354_g11067_i0	PRJNA773625	11082	162	0.920354	1.49097348	Cutibacterium	1912216	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g11067	i0	100	54.2222222222222	162	0	100	0	1	162	1252105	1251944	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	8784	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
5035498	5035498	PRJNA773625_P_NODE_4224_length_210_cov_1.291925_g4209_i0	PRJNA773625	4224	210	1.291925	2.7130425	Cutibacterium	1912216	Bacteria	Bacteria	388	1.24e-103	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4209	i0	100	52.9666666666667	210	0	100	0	1	210	1263465	1263256	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	11123	388	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
5852929	5852929	PRJNA773625_P_NODE_8345_length_167_cov_0.881356_g8330_i0	PRJNA773625	8345	167	0.881356	1.47186452	Mycoplasmopsis pulmonis	2107	Bacteria	Bacteria	303	3.5e-78	NTclustered	gi\|49311\|emb\|Z16416.1\|	2107	g8330	i0	99.401	24.1976047904192	167	1	100	0	1	167	1270	1104	M.pulmonis DNA for insertion sequence IS1138 encoding putative transposase	blastn	4041	303	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis pulmonis
6311171	6311171	PRJNA773625_P_NODE_7765_length_168_cov_0.873950_g7750_i0	PRJNA773625	7765	168	0.87395	1.468236	Cutibacterium	1912216	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g7750	i0	100	51.9761904761905	168	0	100	0	1	168	1512352	1512185	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	8732	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
7585216	7585216	PRJNA773625_P_NODE_10566_length_163_cov_0.912281_g10551_i0	PRJNA773625	10566	163	0.912281	1.48701803	Cutibacterium	1912216	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1755605466\|dbj\|AP019664.1\|	1747	g10551	i0	100	85.9877300613497	163	0	100	0	1	163	538283	538445	Cutibacterium acnes TP-CU389 DNA, complete genome	blastn	14016	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
8860358	8860358	PRJNA773625_P_NODE_8507_length_167_cov_0.881356_g8492_i0	PRJNA773625	8507	167	0.881356	1.47186452	Cutibacterium	1912216	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g8492	i0	100	83.1556886227545	167	0	100	0	1	167	2109626	2109460	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13887	309	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9677819	9677819	PRJNA773625_P_NODE_8648_length_166_cov_0.888889_g8633_i0	PRJNA773625	8648	166	0.888889	1.47555574	Corynebacterium accolens	38284	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g8633	i0	100	31.0060240963855	166	0	100	0	1	166	2125388	2125223	Corynebacterium accolens strain CA3 chromosome	blastn	5147	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
11410995	11410995	PRJNA773625_P_NODE_8849_length_166_cov_0.888889_g8834_i0	PRJNA773625	8849	166	0.888889	1.47555574	Cutibacterium	1912216	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g8834	i0	100	53	166	0	100	0	1	166	1077994	1077829	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	8798	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12228926	12228926	PRJNA773625_P_NODE_1970_length_285_cov_4.775424_g1955_i0	PRJNA773625	1970	285	4.775424	13.6099584	Mycoplasmopsis pulmonis	2107	Bacteria	Bacteria	525	1.2899999999999994e-144	NTclustered	gi\|1563796921\|emb\|LR215008.1\|	2107	g1955	i0	100	139.270175438596	284	0	99	0	1	284	799425	799142	Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1	blastn	39692	525	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis pulmonis
12686760	12686760	PRJNA773625_P_NODE_10610_length_163_cov_0.912281_g10595_i0	PRJNA773625	10610	163	0.912281	1.48701803	Cutibacterium	1912216	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10595	i0	100	57.4846625766871	163	0	100	0	1	163	1071213	1071375	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	9370	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12686761	12686761	PRJNA773625_P_NODE_8850_length_166_cov_0.888889_g8835_i0	PRJNA773625	8850	166	0.888889	1.47555574	root	1	Root_unresolved	Root_unresolved	307	2.69e-79	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g8835	i0	100	99.8915662650602	166	0	100	0	1	166	2420644	2420809	Staphylococcus aureus strain WH9628 chromosome	blastn	16582	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
13961095	13961095	PRJNA773625_P_NODE_10811_length_162_cov_0.920354_g10796_i0	PRJNA773625	10811	162	0.920354	1.49097348	Cutibacterium	1912216	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10796	i0	100	53.9876543209877	162	0	100	0	1	162	2114726	2114887	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	8746	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13961098	13961098	PRJNA773625_P_NODE_2911_length_243_cov_1.072165_g2896_i0	PRJNA773625	2911	243	1.072165	2.60536095	Mycoplasma	2093	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|54609775\|gb\|AY765214.1\|	51364	g2896	i0	99.588	187	243	1	100	0	1	243	637	395	Mycoplasma cottewii strain ATCC 43093 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	45441	444	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
15235630	15235630	PRJNA773625_P_NODE_7912_length_168_cov_0.873950_g7897_i0	PRJNA773625	7912	168	0.87395	1.468236	Cutibacterium	1912216	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g7897	i0	100	12	168	0	100	0	1	168	637857	638024	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	2016	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15235631	15235631	PRJNA773625_P_NODE_7932_length_168_cov_0.873950_g7917_i0	PRJNA773625	7932	168	0.87395	1.468236	Cutibacterium	1912216	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g7917	i0	100	67.5357142857143	168	0	100	0	1	168	1657754	1657921	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	11346	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17327555	17327555	PRJNA773625_P_NODE_10794_length_162_cov_0.920354_g10779_i0	PRJNA773625	10794	162	0.920354	1.49097348	Dermacoccus nishinomiyaensis	1274	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2700497357\|gb\|CP147844.1\|	1274	g10779	i0	100	3	162	0	100	0	1	162	2357897	2357736	Dermacoccus nishinomiyaensis strain GlSt318 chromosome, complete genome	blastn	486	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus nishinomiyaensis
17327569	17327569	PRJNA773625_P_NODE_11134_length_162_cov_0.920354_g11119_i0	PRJNA773625	11134	162	0.920354	1.49097348	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g11119	i0	100	76.3395061728395	162	0	100	0	1	162	1240357	1240518	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	12367	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
18601162	18601162	PRJNA773625_P_NODE_9375_length_165_cov_0.896552_g9360_i0	PRJNA773625	9375	165	0.896552	1.4793108	Staphylococcus cohnii	29382	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g9360	i0	100	46.460606060606104	165	0	100	0	1	165	821894	822058	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	7666	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
19058878	19058878	PRJNA773625_P_NODE_1355_length_338_cov_1.072664_g1341_i0	PRJNA773625	1355	338	1.072664	3.62560432	root	1	Root_unresolved	Root_unresolved	619	6.969999999999999e-173	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g1341	i0	99.704	42.9852071005917	338	1	100	0	1	338	2426826	2426489	Staphylococcus aureus strain WH9628 chromosome	blastn	14529	619	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
19058881	19058881	PRJNA773625_P_NODE_8695_length_166_cov_0.888889_g8680_i0	PRJNA773625	8695	166	0.888889	1.47555574	Streptococcus	1301	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2886512733\|emb\|OZ217346.1\|	28037	g8680	i0	100	100	166	0	100	0	1	166	2035574	2035739	Streptococcus mitis isolate S. mitis D22 genome assembly, chromosome: 1	blastn	16600	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
19876054	19876054	PRJNA773625_P_NODE_7396_length_169_cov_0.866667_g7381_i0	PRJNA773625	7396	169	0.866667	1.46466723	Gemella haemolysans	1379	Bacteria	Bacteria	279	5.95e-71	NTclustered	gi\|1829987927\|gb\|CP050965.1\|	1379	g7381	i0	96.45	1	169	6	100	0	1	169	868634	868802	Gemella haemolysans strain FDAARGOS_740 chromosome	blastn	169	279	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
21151855	21151855	PRJNA773625_P_NODE_4217_length_210_cov_1.515528_g4202_i0	PRJNA773625	4217	210	1.515528	3.1826088	Peptoniphilus genitalis	3036303	Bacteria	Bacteria	307	3.5600000000000005e-79	NTclustered	gi\|2246887130\|gb\|CP097885.1\|	3036303	g4202	i0	93.333	521.309523809524	210	11	100	3	1	210	291223	291017	Peptoniphilus genitalis strain SAHP1 chromosome, complete genome	blastn	109475	307	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus genitalis
22426687	22426687	PRJNA773625_P_NODE_7898_length_168_cov_0.873950_g7883_i0	PRJNA773625	7898	168	0.87395	1.468236	Corynebacterium accolens	38284	Bacteria	Bacteria	233	4.7e-57	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g7883	i0	91.667	25.0595238095238	168	14	100	0	1	168	2017174	2017007	Corynebacterium accolens strain CA3 chromosome	blastn	4210	233	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
23702249	23702249	PRJNA773625_P_NODE_6519_length_176_cov_1.228346_g6504_i0	PRJNA773625	6519	176	1.228346	2.16188896	Mycoplasmopsis pulmonis	2107	Bacteria	Bacteria	320	3.69e-83	NTclustered	gi\|1563796921\|emb\|LR215008.1\|	2107	g6504	i0	99.432	2	176	1	100	0	1	176	30811	30986	Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1	blastn	352	320	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis pulmonis

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