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

26 rows where analysis = "blastn", bioproject = "PRJNA795983" and tax_phylum = "Bacillota"

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
1216422	1216422	PRJNA795983_S_NODE_33601_length_257_cov_1.217391_g33476_i0	PRJNA795983	33601	257	1.217391	3.12869487	Bacteria	2	Bacteria	Bacteria	76.8	1.39e-9	NTclustered	gi\|291529795\|emb\|FP929044.1\|	657319	g33476	i0	92.453	27.7548638132296	53	4	21	0	199	251	965246	965298	Eubacterium siraeum 70/3 draft genome	blastn	7133	76.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		[Eubacterium] siraeum
2055980	2055980	PRJNA795983_S_NODE_23122_length_293_cov_1.304545_g22997_i0	PRJNA795983	23122	293	1.304545	3.82231685	Lysinibacillus sp. JNUCC-51	2792479	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1942708210\|gb\|CP065545.1\|	2792479	g22997	i0	100	0.0955631399317406	28	0	10	0	246	273	83665	83692	Lysinibacillus sp. JNUCC-51 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sp. JNUCC-51
3768179	3768179	PRJNA795983_S_NODE_13083_length_353_cov_1.639286_g12958_i0	PRJNA795983	13083	353	1.639286	5.78667958	Streptococcus	1301	Bacteria	Bacteria	640	5.599999999999999e-179	NTclustered	gi\|1686100242\|gb\|MK330590.1\|	1305	g12958	i0	99.433	358.059490084986	353	1	100	1	1	353	3272	3623	Streptococcus sanguinis strain 4416_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	126395	645	0.992248062015504	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
3768212	3768212	PRJNA795983_S_NODE_35823_length_251_cov_1.230337_g35698_i0	PRJNA795983	35823	251	1.230337	3.08814587	root	1	Root_unresolved	Root_unresolved	457	4.13e-124	NTclustered	gi\|285185215\|gb\|GU421088.1\|	28037	g35698	i0	100	98.4103585657371	247	0	98	0	5	251	90	336	Streptococcus mitis clone ATC_H74_34 16S ribosomal RNA gene, partial sequence	blastn	24701	459	0.995642701525055	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
6320508	6320508	PRJNA795983_S_NODE_16385_length_328_cov_1.313725_g16260_i0	PRJNA795983	16385	328	1.313725	4.309018	Psychrobacillus	1221880	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|1755647179\|gb\|CP031739.1\|	2303505	g16260	i0	100	0.170731707317073	28	0	9	0	279	306	3041736	3041763	Psychrobacillus sp. AK 1817 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Psychrobacillus	Psychrobacillus sp. AK 1817
6320524	6320524	PRJNA795983_S_NODE_25385_length_283_cov_4.485714_g25260_i0	PRJNA795983	25385	283	4.485714	12.69457062	Streptococcus	1301	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g25260	i0	100	106	283	0	100	0	1	283	1572786	1573068	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	29998	523	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
6320552	6320552	PRJNA795983_S_NODE_43825_length_235_cov_2.160494_g43700_i0	PRJNA795983	43825	235	2.160494	5.0771609	root	1	Root_unresolved	Root_unresolved	298	2.45e-76	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g43700	i0	100	71.4936170212766	161	0	69	0	1	161	2481188	2481028	Staphylococcus aureus strain WH9628 chromosome	blastn	16801	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
7158545	7158545	PRJNA795983_S_NODE_32286_length_260_cov_13.192513_g32161_i0	PRJNA795983	32286	260	13.192513	34.3005338	Trichococcus shcherbakoviae	2094020	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2621704421\|emb\|OY761017.1\|	2094020	g32161	i0	100	0.107692307692308	28	0	11	0	67	94	1316626	1316599	MAG: Trichococcus shcherbakoviae isolate 89b17532-9bee-499f-becb-1a49c542a750 genome assembly, chromosome: 2	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Trichococcus	Trichococcus shcherbakoviae
9708537	9708537	PRJNA795983_S_NODE_8608_length_410_cov_1.851632_g8483_i0	PRJNA795983	8608	410	1.851632	7.5916912	uncultured Clostridia bacterium	244328	Bacteria	Bacteria	246	1.68e-60	NTclustered	gi\|2187163480\|emb\|OV788638.1\|	244328	g8483	i0	78.173	46.2414634146341	394	80	95	5	14	404	1221572	1221962	uncultured Clostridia bacterium isolate min17_bin01 genome assembly, chromosome: 1	blastn	18959	246	1	Bacteria	Bacillati	Bacillota	Clostridia				uncultured Clostridia bacterium
10984003	10984003	PRJNA795983_S_NODE_20369_length_305_cov_4.870690_g20244_i0	PRJNA795983	20369	305	4.87069	14.8556045	Trichococcus shcherbakoviae	2094020	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2621704421\|emb\|OY761017.1\|	2094020	g20244	i0	100	0.0918032786885246	28	0	9	0	223	250	1316599	1316626	MAG: Trichococcus shcherbakoviae isolate 89b17532-9bee-499f-becb-1a49c542a750 genome assembly, chromosome: 2	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Trichococcus	Trichococcus shcherbakoviae
12259711	12259711	PRJNA795983_S_NODE_39250_length_246_cov_0.890173_g39125_i0	PRJNA795983	39250	246	0.890173	2.18982558	Streptococcus anginosus	1328	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2451532500\|gb\|CP118046.1\|	1328	g39125	i0	100	383.930894308943	246	0	100	0	1	246	18957	18712	Streptococcus anginosus strain VSI52 chromosome, complete genome	blastn	94447	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus anginosus
13533874	13533874	PRJNA795983_S_NODE_40991_length_243_cov_2.352941_g40866_i0	PRJNA795983	40991	243	2.352941	5.71764663	Lawsonibacter asaccharolyticus	2108523	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2202875140\|gb\|CP091870.1\|	2108523	g40866	i0	100	0.11522633744856	28	0	12	0	188	215	1843038	1843065	Lawsonibacter asaccharolyticus strain OA10 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Lawsonibacter	Lawsonibacter asaccharolyticus
13970434	13970434	PRJNA795983_S_NODE_15431_length_334_cov_2.068966_g15306_i0	PRJNA795983	15431	334	2.068966	6.91034644	Enterococcus	1350	Bacteria	Bacteria	612	1.15e-170	NTclustered	gi\|2437787960\|gb\|CP116571.1\|	1351	g15306	i0	100	392.167664670659	331	0	100	0	4	334	261892	261562	Enterococcus faecalis strain K190-1 chromosome, complete genome	blastn	130984	612	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
14808713	14808713	PRJNA795983_S_NODE_32312_length_260_cov_2.764706_g32187_i0	PRJNA795983	32312	260	2.764706	7.1882356	Paraclostridium bifermentans	1490	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2501758084\|gb\|CP124685.1\|	1490	g32187	i0	100	0.107692307692308	28	0	11	0	65	92	2303745	2303718	Paraclostridium bifermentans strain SampleS7P1 isolate gram staining chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium bifermentans
15244916	15244916	PRJNA795983_S_NODE_17692_length_320_cov_1.323887_g17567_i0	PRJNA795983	17692	320	1.323887	4.2364384	root	1	Root_unresolved	Root_unresolved	388	2.01e-103	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g17567	i0	100	40.021875	210	0	66	0	111	320	2681337	2681128	Staphylococcus aureus strain WH3018 chromosome	blastn	12807	388	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
16082611	16082611	PRJNA795983_S_NODE_27553_length_276_cov_1.133005_g27428_i0	PRJNA795983	27553	276	1.133005	3.1270938	Macrococcus armenti	2875764	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2099400701\|gb\|CP083594.1\|	2875764	g27428	i0	100	0.202898550724638	28	0	10	0	63	90	404443	404416	Macrococcus armenti strain 19Msa0295 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Macrococcus	Macrococcus armenti
16519377	16519377	PRJNA795983_S_NODE_13953_length_345_cov_7.077206_g13828_i0	PRJNA795983	13953	345	7.077206	24.4163607	root	1	Root_unresolved	Root_unresolved	638	1.97e-178	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g13828	i0	100	98.9942028985507	345	0	100	0	1	345	2463318	2463662	Staphylococcus aureus strain WH9628 chromosome	blastn	34153	638	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
16519402	16519402	PRJNA795983_S_NODE_32313_length_260_cov_2.732620_g32188_i0	PRJNA795983	32313	260	2.73262	7.104812	Streptococcus	1301	Bacteria	Bacteria	460	3.32e-125	NTclustered	gi\|1539812483\|emb\|LR134307.1\|	33040	g32188	i0	99.603	323.726923076923	252	1	97	0	1	252	19509	19258	Streptococcus milleri strain NCTC10708 genome assembly, chromosome: 1	blastn	84169	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus milleri
16519406	16519406	PRJNA795983_S_NODE_33473_length_257_cov_1.603261_g33348_i0	PRJNA795983	33473	257	1.603261	4.12038077	Enterococcus	1350	Bacteria	Bacteria	457	4.239999999999999e-124	NTclustered	gi\|2437758097\|gb\|CP116510.1\|	1353	g33348	i0	100	433.15953307393	247	0	96	0	11	257	168443	168197	Enterococcus gallinarum strain K205-4a chromosome, complete genome	blastn	111322	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus gallinarum
20342961	20342961	PRJNA795983_S_NODE_39856_length_245_cov_0.895349_g39731_i0	PRJNA795983	39856	245	0.895349	2.19360505	Paenibacillus	44249	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1769907722\|gb\|CP045295.1\|	562959	g39731	i0	100	0.6	30	0	12	0	43	72	3635311	3635282	Paenibacillus cellulositrophicus strain KACC 16577 chromosome, complete genome	blastn	147	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus cellulositrophicus
21182547	21182547	PRJNA795983_S_NODE_24317_length_288_cov_1.074419_g24192_i0	PRJNA795983	24317	288	1.074419	3.09432672	Paenibacillus sp. URB8-2	2741301	Bacteria	Bacteria	60.2	1.59e-4	NTclustered	gi\|1864356429\|dbj\|AP023239.1\|	2741301	g24192	i0	97.143	0.121527777777778	35	1	12	0	105	139	2417580	2417546	Paenibacillus sp. URB8-2 DNA, complete genome	blastn	35	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. URB8-2
22894093	22894093	PRJNA795983_S_NODE_11738_length_367_cov_1.272109_g11613_i0	PRJNA795983	11738	367	1.272109	4.66864003	Ruminococcus	1263	Bacteria	Bacteria	333	1.11e-86	NTclustered	gi\|268320350\|gb\|GU137317.1\|	1264	g11613	i0	91.463	117.201634877384	246	16	66	5	61	302	356	600	Ruminococcus albus strain Ra8 16S-23S ribosomal RNA intergenic spacer, complete sequence	blastn	43013	333	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus albus
23732875	23732875	PRJNA795983_S_NODE_21739_length_299_cov_1.358407_g21614_i0	PRJNA795983	21739	299	1.358407	4.06163693	Catenibacterium mitsuokai	100886	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2299336055\|gb\|CP102271.1\|	100886	g21614	i0	94.444	0.120401337792642	36	2	12	0	206	241	1824115	1824150	Catenibacterium mitsuokai strain DSM 15897 chromosome, complete genome	blastn	36	56.5	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Catenibacterium	Catenibacterium mitsuokai
24168110	24168110	PRJNA795983_S_NODE_2179_length_697_cov_2.690705_g2075_i0	PRJNA795983	2179	697	2.690705	18.75421385	Enterococcus	1350	Bacteria	Bacteria	1288	0	NTclustered	gi\|2437787960\|gb\|CP116571.1\|	1351	g2075	i0	100	393.005738880918	697	0	100	0	1	697	260844	261540	Enterococcus faecalis strain K190-1 chromosome, complete genome	blastn	273925	1288	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
25443236	25443236	PRJNA795983_S_NODE_10180_length_386_cov_1.856230_g10055_i0	PRJNA795983	10180	386	1.85623	7.1650478	Macrococcus	69965	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|2899141610\|gb\|CP179728.1\|	3395466	g10055	i0	100	0.300518134715026	29	0	8	0	167	195	1405127	1405155	Macrococcus sp. 18KM676 chromosome, complete genome	blastn	116	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Macrococcus	Macrococcus sp. 18KM676
25443250	25443250	PRJNA795983_S_NODE_21820_length_298_cov_4.680000_g21695_i0	PRJNA795983	21820	298	4.68	13.9464	Streptococcus	1301	Bacteria	Bacteria	551	2.239999999999999e-152	NTclustered	gi\|1578096036\|emb\|LR216035.1\|	1313	g21695	i0	100	338	298	0	100	0	1	298	1834981	1835278	Streptococcus pneumoniae isolate SA_GPS_SP505-sc-1895675 genome assembly, chromosome: 1	blastn	100724	551	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae

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