metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA561212" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA561212" 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
545376	545376	PRJNA561212_P_NODE_23161_length_247_cov_0.896552_g22950_i0	PRJNA561212	23161	247	0.896552	2.21448344	Staphylococcus epidermidis	1282	Bacteria	Bacteria	414	2.47e-111	NTclustered	gi\|2505675366\|gb\|CP118829.1\|	1282	g22950	i0	99.13	93.1174089068826	230	2	93	0	10	239	242331	242102	Staphylococcus epidermidis strain 7055 chromosome, complete genome	blastn	23000	414	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
545414	545414	PRJNA561212_P_NODE_25241_length_243_cov_0.917647_g25030_i0	PRJNA561212	25241	243	0.917647	2.22988221	Finegoldia magna	1260	Bacteria	Bacteria	342	1.16e-89	NTclustered	gi\|1848608259\|gb\|CP054000.1\|	1260	g25030	i0	94.196	2.76543209876543	224	13	92	0	11	234	1833456	1833233	Finegoldia magna strain FDAARGOS_764 chromosome, complete genome	blastn	672	342	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
1821009	1821009	PRJNA561212_P_NODE_17002_length_275_cov_1.306931_g16791_i0	PRJNA561212	17002	275	1.306931	3.59406025	Streptococcus salivarius	1304	Bacteria	Bacteria	468	2.12e-127	NTclustered	gi\|2890261556\|gb\|CP177179.1\|	1304	g16791	i0	99.228	43.4509090909091	259	2	94	0	8	266	2066248	2066506	Streptococcus salivarius strain MRD-NRLLH chromosome, complete genome	blastn	11949	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
3096302	3096302	PRJNA561212_P_NODE_18583_length_264_cov_1.010471_g18372_i0	PRJNA561212	18583	264	1.010471	2.66764344	Candidatus Paraimprobicoccus trichonymphae	3033793	Bacteria	Bacteria	75	5.15e-9	NTclustered	gi\|2567583683\|dbj\|AP027925.1\|	3033793	g18372	i0	95.652	18.780303030303	46	2	17	0	10	55	640650	640605	MAG: Candidatus Paraimprobicoccus trichonymphae RsTa-C01 DNA, complete genome	blastn	4958	75	1	Bacteria	Bacillati	Bacillota	Clostridia			Candidatus Paraimprobicoccus	Candidatus Paraimprobicoccus trichonymphae
3096335	3096335	PRJNA561212_P_NODE_20963_length_252_cov_0.871508_g20752_i0	PRJNA561212	20963	252	0.871508	2.19620016	Staphylococcus aureus	1280	Bacteria	Bacteria	433	6.98e-117	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g20752	i0	99.17	138.706349206349	241	1	96	1	3	243	1841951	1842190	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	34954	433	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
5649261	5649261	PRJNA561212_P_NODE_24725_length_244_cov_0.912281_g24514_i0	PRJNA561212	24725	244	0.912281	2.22596564	Tepidibacillus marianensis	3131995	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2707205938\|gb\|CP149939.1\|	3131995	g24514	i0	100	0.114754098360656	28	0	11	0	175	202	200260	200233	Tepidibacillus marianensis strain LSZ-M11000 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Tepidibacillus	Tepidibacillus marianensis
6923425	6923425	PRJNA561212_P_NODE_21326_length_251_cov_0.876404_g21115_i0	PRJNA561212	21326	251	0.876404	2.19977404	Streptococcus gordonii	1302	Bacteria	Bacteria	431	2.4999999999999996e-116	NTclustered	gi\|1348270962\|gb\|CP020450.2\|	1302	g21115	i0	100	11.0478087649402	233	0	93	0	10	242	1504989	1505221	Streptococcus gordonii strain FDAARGOS_257 chromosome, complete genome	blastn	2773	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
8198359	8198359	PRJNA561212_P_NODE_25027_length_244_cov_0.883041_g24816_i0	PRJNA561212	25027	244	0.883041	2.15462004	Pediococcus argentinicus	480391	Bacteria	Bacteria	407	4.08e-109	NTclustered	gi\|2754319441\|gb\|CP159610.1\|	480391	g24816	i0	99.115	0.926229508196721	226	2	93	0	10	235	21931	22156	Pediococcus argentinicus strain z30 chromosome, complete genome	blastn	226	407	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus argentinicus
8783621	8783621	PRJNA561212_P_NODE_26247_length_235_cov_2.432099_g26036_i0	PRJNA561212	26247	235	2.432099	5.71543265	Streptococcus	1301	Bacteria	Bacteria	401	1.8199999999999993e-107	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g26036	i0	100	318.608510638298	217	0	92	0	10	226	1568782	1568998	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	74873	401	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
9473966	9473966	PRJNA561212_P_NODE_21508_length_251_cov_0.876404_g21297_i0	PRJNA561212	21508	251	0.876404	2.19977404	Streptococcus mitis	28037	Bacteria	Bacteria	368	1.99e-97	NTclustered	gi\|927035354\|gb\|CP012646.1\|	28037	g21297	i0	94.894	93.5737051792829	235	12	94	0	9	243	938246	938480	Streptococcus mitis strain KCOM 1350 (= ChDC B183), complete genome	blastn	23487	368	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
10059240	10059240	PRJNA561212_P_NODE_12888_length_311_cov_0.823529_g12677_i0	PRJNA561212	12888	311	0.823529	2.56117519	Streptococcus	1301	Bacteria	Bacteria	527	3.9599999999999996e-145	NTclustered	gi\|2886512733\|emb\|OZ217346.1\|	28037	g12677	i0	98.983	313.022508038585	295	1	94	1	10	302	19167	18873	Streptococcus mitis isolate S. mitis D22 genome assembly, chromosome: 1	blastn	97350	527	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
10059258	10059258	PRJNA561212_P_NODE_24808_length_244_cov_0.912281_g24597_i0	PRJNA561212	24808	244	0.912281	2.22596564	Bacillus	1386	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2168261830\|gb\|CP089530.1\|	1390	g24597	i0	100	11.8852459016393	29	0	12	0	191	219	1577757	1577729	Bacillus amyloliquefaciens strain LS1-002-014s chromosome, complete genome	blastn	2900	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
11333827	11333827	PRJNA561212_P_NODE_18569_length_264_cov_1.136126_g18358_i0	PRJNA561212	18569	264	1.136126	2.99937264	Streptococcus	1301	Bacteria	Bacteria	60.2	1.44e-4	NTclustered	gi\|2170975497\|dbj\|AP025331.1\|	1917441	g18358	i0	100	0.685606060606061	32	0	12	0	13	44	724806	724837	Streptococcus ruminantium GUT-183 DNA, complete genome	blastn	181	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus ruminantium
12609671	12609671	PRJNA561212_P_NODE_19050_length_261_cov_0.941489_g18839_i0	PRJNA561212	19050	261	0.941489	2.45728629	Streptococcus	1301	Bacteria	Bacteria	449	7.22e-122	NTclustered	gi\|2814310616\|gb\|CP065478.1\|	1308	g18839	i0	99.593	117.352490421456	246	1	94	0	7	252	134478	134723	Streptococcus thermophilus strain 4134 chromosome, complete genome	blastn	30629	453	0.991169977924945	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
13299492	13299492	PRJNA561212_P_NODE_21871_length_250_cov_0.881356_g21660_i0	PRJNA561212	21871	250	0.881356	2.20339	uncultured Clostridia bacterium	244328	Bacteria	Bacteria	357	4.28e-94	NTclustered	gi\|451917157\|gb\|KC451021.1\|	244328	g21660	i0	94.444	74.624	234	9	93	4	10	241	320	89	Uncultured Clostridia bacterium clone RLBp5271 16S ribosomal RNA gene, partial sequence	blastn	18656	357	1	Bacteria	Bacillati	Bacillota	Clostridia				uncultured Clostridia bacterium
13299511	13299511	PRJNA561212_P_NODE_22811_length_248_cov_0.891429_g22600_i0	PRJNA561212	22811	248	0.891429	2.21074392	Acetoanaerobium sticklandii	1511	Bacteria	Bacteria	355	1.53e-93	NTclustered	gi\|308824094\|emb\|FP565809.1\|	1511	g22600	i0	94.737	1.84677419354839	228	12	92	0	10	237	514401	514174	Clostridium sticklandii str. DSM 519 chromosome, complete genome	blastn	458	355	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Filifactoraceae	Acetoanaerobium	Acetoanaerobium sticklandii
13884546	13884546	PRJNA561212_P_NODE_17811_length_269_cov_1.510204_g17600_i0	PRJNA561212	17811	269	1.510204	4.06244876	Acetoanaerobium	186831	Bacteria	Bacteria	309	1.32e-79	NTclustered	gi\|308824094\|emb\|FP565809.1\|	1511	g17600	i0	89.2	514.28624535316	250	24	93	3	12	261	16137	16383	Clostridium sticklandii str. DSM 519 chromosome, complete genome	blastn	138343	309	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Filifactoraceae	Acetoanaerobium	Acetoanaerobium sticklandii
15158740	15158740	PRJNA561212_P_NODE_19972_length_254_cov_1.276243_g19761_i0	PRJNA561212	19972	254	1.276243	3.24165722	Bacillales	1385	Bacteria	Bacteria	431	2.539999999999999e-116	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g19761	i0	99.163	497.137795275591	239	2	94	0	10	248	750201	749963	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	126273	433	0.995381062355658	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
15848312	15848312	PRJNA561212_P_NODE_24193_length_245_cov_0.906977_g23982_i0	PRJNA561212	24193	245	0.906977	2.22209365	Acetoanaerobium noterae	745369	Bacteria	Bacteria	241	4.400000000000001e-59	NTclustered	gi\|2727634373\|gb\|CP154629.1\|	745369	g23982	i0	86.425	0.902040816326531	221	28	90	2	18	237	2397540	2397321	Acetoanaerobium noterae strain DSL2 chromosome, complete genome	blastn	221	241	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Filifactoraceae	Acetoanaerobium	Acetoanaerobium noterae
19671804	19671804	PRJNA561212_P_NODE_14596_length_293_cov_2.072727_g14385_i0	PRJNA561212	14596	293	2.072727	6.07309011	uncultured Bacillota bacterium	344338	Bacteria	Bacteria	141	5.64e-29	NTclustered	gi\|300089006\|gb\|GQ484294.1\|	344338	g14385	i0	89.908	79.839590443686	109	11	37	0	176	284	708	600	Uncultured Firmicutes bacterium clone ITSButtonC10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	23393	141	1	Bacteria	Bacillati	Bacillota					uncultured Bacillota bacterium
19671936	19671936	PRJNA561212_P_NODE_22316_length_249_cov_0.886364_g22105_i0	PRJNA561212	22316	249	0.886364	2.20704636	Finegoldia magna	1260	Bacteria	Bacteria	429	8.91e-116	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g22105	i0	99.576	15.2409638554217	236	0	95	1	5	240	1271774	1271540	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	3795	429	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
20947445	20947445	PRJNA561212_P_NODE_14877_length_291_cov_1.316514_g14666_i0	PRJNA561212	14877	291	1.316514	3.83105574	Streptococcus oralis	1303	Bacteria	Bacteria	459	1.36e-124	NTclustered	gi\|1948677368\|gb\|CP066059.1\|	1303	g14666	i0	96.727	90.9828178694158	275	9	95	0	10	284	528393	528119	Streptococcus oralis strain FDAARGOS_1021 chromosome, complete genome	blastn	26476	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
22807851	22807851	PRJNA561212_P_NODE_7278_length_407_cov_1.320359_g7067_i0	PRJNA561212	7278	407	1.320359	5.37386113	Streptococcus	1301	Bacteria	Bacteria	701	0	NTclustered	gi\|1948677368\|gb\|CP066059.1\|	1303	g7067	i0	98.734	328.125307125307	395	4	97	1	9	403	951677	951284	Streptococcus oralis strain FDAARGOS_1021 chromosome, complete genome	blastn	133547	706	0.992917847025496	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
23497677	23497677	PRJNA561212_P_NODE_15679_length_285_cov_1.028302_g15468_i0	PRJNA561212	15679	285	1.028302	2.9306607	Staphylococcus aureus	1280	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1403776180\|emb\|LS483311.1\|	1280	g15468	i0	96.875	4.94035087719298	32	0	11	1	176	207	1975382	1975352	Staphylococcus aureus strain NCTC6136 genome assembly, chromosome: 1	blastn	1408	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
24082633	24082633	PRJNA561212_P_NODE_15539_length_286_cov_1.136150_g15328_i0	PRJNA561212	15539	286	1.13615	3.249389	Lactococcus	1357	Bacteria	Bacteria	497	2.82e-136	NTclustered	gi\|2844548646\|gb\|CP158368.1\|	1359	g15328	i0	100	55.7167832167832	269	0	94	0	10	278	361964	362232	Lactococcus cremoris strain UC023 chromosome, complete genome	blastn	15935	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
24082649	24082649	PRJNA561212_P_NODE_4559_length_517_cov_3.155405_g4350_i0	PRJNA561212	4559	517	3.155405	16.31344385	Acetoanaerobium	186831	Bacteria	Bacteria	922	0	NTclustered	gi\|308824094\|emb\|FP565809.1\|	1511	g4350	i0	100	1022.11798839458	499	0	97	0	10	508	16139	16637	Clostridium sticklandii str. DSM 519 chromosome, complete genome	blastn	528435	922	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Filifactoraceae	Acetoanaerobium	Acetoanaerobium sticklandii
25357017	25357017	PRJNA561212_P_NODE_14740_length_292_cov_1.347032_g14529_i0	PRJNA561212	14740	292	1.347032	3.93333344	Bacillus	1386	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|510140713\|gb\|CP005965.1\|	766760	g14529	i0	100	3.47602739726027	29	0	10	0	222	250	53936	53964	Bacillus paralicheniformis ATCC 9945a chromosome, complete genome	blastn	1015	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus paralicheniformis

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