metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA833575" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA833575" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
824576	824576	PRJNA833575_P_NODE_44601_length_228_cov_0.905660_g44464_i0	PRJNA833575	44601	228	0.90566	2.0649048	Lachnospiraceae bacterium JLR.KK009	3114295	Bacteria	Bacteria	246	8.69e-61	NTclustered	gi\|2692820420\|gb\|CP143549.1\|	3114295	g44464	i0	86.547	153.171052631579	223	30	98	0	6	228	1520	1742	Lachnospiraceae bacterium JLR.KK009 strain JLR.KK002 chromosome	blastn	34923	246	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium JLR.KK009
4652769	4652769	PRJNA833575_P_NODE_33204_length_257_cov_1.356383_g33067_i0	PRJNA833575	33204	257	1.356383	3.48590431	Streptomyces sp. cg36	3238798	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2784064359\|gb\|CP163520.1\|	3238798	g33067	i0	96.875	0.124513618677043	32	1	12	0	82	113	995429	995398	Streptomyces sp. cg36 chromosome, complete genome	blastn	32	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. cg36
5056883	5056883	PRJNA833575_P_NODE_24564_length_300_cov_1.341991_g24427_i0	PRJNA833575	24564	300	1.341991	4.025973	Mycobacteriales	85007	Bacteria	Bacteria	534	2.2699999999999998e-147	NTclustered	gi\|2164774525\|gb\|CP089227.1\|	1824	g24427	i0	98.997	382.886666666667	299	1	99	2	3	300	3871024	3871321	Nocardia asteroides strain FDAARGOS_1622 chromosome, complete genome	blastn	114866	536	0.996268656716418	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia asteroides
6333188	6333188	PRJNA833575_P_NODE_45565_length_227_cov_0.911392_g45428_i0	PRJNA833575	45565	227	0.911392	2.06885984	Cutibacterium	1912216	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g45428	i0	100	68.4977973568282	227	0	100	0	1	227	1565727	1565501	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	15549	420	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
8477135	8477135	PRJNA833575_P_NODE_28367_length_279_cov_2.057143_g28230_i0	PRJNA833575	28367	279	2.057143	5.73942897	Corynebacterium aurimucosum	169292	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2264102322\|gb\|CP071874.1\|	169292	g28230	i0	100	0.311827956989247	29	0	10	0	126	154	1274072	1274100	Corynebacterium aurimucosum strain DSM 44532 chromosome	blastn	87	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium aurimucosum
11027944	11027944	PRJNA833575_P_NODE_22529_length_313_cov_1.016393_g22392_i0	PRJNA833575	22529	313	1.016393	3.18131009	Nocardioides sp. S5	2017486	Bacteria	Bacteria	556	5.09e-154	NTclustered	gi\|1999037722\|gb\|CP022296.1\|	2017486	g22392	i0	98.722	327.977635782748	313	4	100	0	1	313	1843067	1843379	Nocardioides sp. S5 chromosome, complete genome	blastn	102657	556	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. S5
12303699	12303699	PRJNA833575_P_NODE_40830_length_232_cov_1.312883_g40693_i0	PRJNA833575	40830	232	1.312883	3.04588856	Gardnerella swidsinskii	2792979	Bacteria	Bacteria	424	3.82e-114	NTclustered	gi\|2911082113\|gb\|CP180511.1\|	2792979	g40693	i0	99.569	10.7155172413793	232	1	100	0	1	232	1136629	1136398	Gardnerella swidsinskii strain Marseille-Q9669 chromosome	blastn	2486	424	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Gardnerella	Gardnerella swidsinskii
13982692	13982692	PRJNA833575_P_NODE_23431_length_307_cov_1.210084_g23294_i0	PRJNA833575	23431	307	1.210084	3.71495788	Chroococcidiopsis	54298	Bacteria	Bacteria	568	2.3e-157	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g23294	i0	100	117.807817589577	307	0	100	0	1	307	1687	1381	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	36167	568	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
16127126	16127126	PRJNA833575_P_NODE_42733_length_230_cov_0.894410_g42596_i0	PRJNA833575	42733	230	0.89441	2.057143	Streptomyces sp. II-2-2-2	2859784	Bacteria	Bacteria	420	4.89e-113	NTclustered	gi\|2800755081\|gb\|CP081300.1\|	2859784	g42596	i0	99.565	98.5304347826087	230	1	100	0	1	230	3352193	3351964	Streptomyces sp. II-2-2-2 strain Soil LB -1 chromosome, complete genome	blastn	22662	420	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. II-2-2-2
16531389	16531389	PRJNA833575_P_NODE_16673_length_360_cov_0.989691_g16536_i0	PRJNA833575	16673	360	0.989691	3.5628876	Cutibacterium	1912216	Bacteria	Bacteria	660	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g16536	i0	99.722	274.130555555556	360	1	100	0	1	360	56425	56066	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	98687	660	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17402661	17402661	PRJNA833575_P_NODE_32774_length_259_cov_1.247368_g32637_i0	PRJNA833575	32774	259	1.247368	3.23068312	Blautia producta	33035	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1575847935\|gb\|CP035945.1\|	33035	g32637	i0	100	0.108108108108108	28	0	11	0	81	108	3257834	3257807	Blautia producta strain PMF1 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia producta
18675480	18675480	PRJNA833575_P_NODE_19215_length_336_cov_1.415730_g19078_i0	PRJNA833575	19215	336	1.41573	4.7568528	Microbacterium sp. PM5	2014534	Bacteria	Bacteria	619	6.93e-173	NTclustered	gi\|1419380645\|gb\|CP022162.1\|	2014534	g19078	i0	100	177.529761904762	335	0	99	0	1	335	1408080	1408414	Microbacterium sp. PM5 genome	blastn	59650	619	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. PM5
18675601	18675601	PRJNA833575_P_NODE_26995_length_287_cov_0.784404_g26858_i0	PRJNA833575	26995	287	0.784404	2.25123948	Leucobacter aridicollis	283878	Bacteria	Bacteria	442	1.3499999999999993e-119	NTclustered	gi\|2276937852\|gb\|CP075339.1\|	283878	g26858	i0	94.464	261.459930313589	289	12	100	4	1	287	666959	667245	Leucobacter aridicollis strain J1 chromosome, complete genome	blastn	75039	442	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leucobacter	Leucobacter aridicollis
18675678	18675678	PRJNA833575_P_NODE_31855_length_263_cov_1.371134_g31718_i0	PRJNA833575	31855	263	1.371134	3.60608242	Streptomyces sp. II-2-2-2	2859784	Bacteria	Bacteria	158	4.949999999999999e-34	NTclustered	gi\|2800755081\|gb\|CP081300.1\|	2859784	g31718	i0	86.093	3.74144486692015	151	15	57	4	115	263	3760594	3760448	Streptomyces sp. II-2-2-2 strain Soil LB -1 chromosome, complete genome	blastn	984	158	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. II-2-2-2
20355410	20355410	PRJNA833575_P_NODE_40656_length_232_cov_4.012270_g40519_i0	PRJNA833575	40656	232	4.01227	9.3084664	Micrococcus	1269	Bacteria	Bacteria	429	8.2e-116	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g40519	i0	100	290.556034482759	232	0	100	0	1	232	346696	346465	Micrococcus luteus strain V017 chromosome, complete genome	blastn	67409	429	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
22501249	22501249	PRJNA833575_P_NODE_37838_length_236_cov_1.652695_g37701_i0	PRJNA833575	37838	236	1.652695	3.9003602	Rothia dentocariosa	2047	Bacteria	Bacteria	420	5.04e-113	NTclustered	gi\|1848622588\|gb\|CP054018.1\|	2047	g37701	i0	98.729	8	236	3	100	0	1	236	967574	967339	Rothia dentocariosa strain FDAARGOS_752 chromosome, complete genome	blastn	1888	420	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia dentocariosa
22501420	22501420	PRJNA833575_P_NODE_47098_length_212_cov_2.440559_g46961_i0	PRJNA833575	47098	212	2.440559	5.17398508	Corynebacterium sp. LaCa97	3391431	Bacteria	Bacteria	377	2.71e-100	NTclustered	gi\|2888564179\|gb\|CP177110.1\|	3391431	g46961	i0	98.598	333.155660377359	214	1	100	1	1	212	768821	769034	Corynebacterium sp. LaCa97 chromosome, complete genome	blastn	70629	377	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. LaCa97
22906510	22906510	PRJNA833575_P_NODE_32078_length_262_cov_1.471503_g31941_i0	PRJNA833575	32078	262	1.471503	3.85533786	Staphylococcus	1279	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|2536850969\|gb\|CP129362.1\|	1283	g31941	i0	99.618	52	262	1	100	0	1	262	2374045	2374306	Staphylococcus haemolyticus strain CCSH-121 chromosome, complete genome	blastn	13624	479	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
25050738	25050738	PRJNA833575_P_NODE_39820_length_233_cov_2.792683_g39683_i0	PRJNA833575	39820	233	2.792683	6.50695139	Dolosigranulum pigrum	29394	Bacteria	Bacteria	429	8.239999999999998e-116	NTclustered	gi\|2020690643\|gb\|CP040409.1\|	29394	g39683	i0	100	24.8927038626609	232	0	99	0	1	232	1199757	1199988	Dolosigranulum pigrum strain KPL3274 chromosome, complete genome	blastn	5800	429	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum

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