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

19 rows where analysis = "blastn", bioproject = "PRJNA630877" 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
1879291	1879291	PRJNA630877_S_NODE_84322_length_275_cov_6.611111_g65185_i0	PRJNA630877	84322	275	6.611111	18.18055525	Clostridium botulinum	1491	Bacteria	Bacteria	481	2.72e-131	NTclustered	gi\|1370563981\|gb\|CP027781.1\|	1491	g65185	i0	98.182	110.683636363636	275	5	100	0	1	275	3999418	3999692	Clostridium botulinum strain MAP 5 chromosome, complete genome	blastn	30438	481	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
2426995	2426995	PRJNA630877_S_NODE_149922_length_158_cov_1.504274_g130785_i0	PRJNA630877	149922	158	1.5042739999999999	2.37675292	Aerococcus	1375	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|984726517\|gb\|CP014164.1\|	1377	g130785	i0	100	438.189873417722	158	0	100	0	1	158	18998	19155	Aerococcus viridans strain CCUG4311, complete genome	blastn	69234	292	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus viridans
2426996	2426996	PRJNA630877_S_NODE_153722_length_155_cov_1.429825_g134585_i0	PRJNA630877	153722	155	1.429825	2.21622875	Streptococcus	1301	Bacteria	Bacteria	270	3.23e-68	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g134585	i0	98.065	419.767741935484	155	3	100	0	1	155	424230	424384	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	65064	270	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
5706724	5706724	PRJNA630877_S_NODE_157545_length_152_cov_1.261261_g138408_i0	PRJNA630877	157545	152	1.261261	1.91711672	Alicyclobacillus sendaiensis	192387	Bacteria	Bacteria	267	4.08e-67	NTclustered	gi\|281376722\|gb\|GU208761.1\|	192387	g138408	i0	98.667	157.243421052632	150	2	99	0	1	150	212	63	Alicyclobacillus sendaiensis strain DSM 17614 23S ribosomal RNA gene, partial sequence	blastn	23901	267	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Alicyclobacillaceae	Alicyclobacillus	Alicyclobacillus sendaiensis
10080218	10080218	PRJNA630877_S_NODE_74448_length_323_cov_7.202128_g55311_i0	PRJNA630877	74448	323	7.202128	23.26287344	Staphylococcus	1279	Bacteria	Bacteria	592	1.4499999999999999e-164	NTclustered	gi\|1403688813\|emb\|LS483491.1\|	29379	g55311	i0	99.69	108	323	1	100	0	1	323	1489927	1490249	Staphylococcus auricularis strain NCTC12101 genome assembly, chromosome: 1	blastn	34884	597	0.991624790619765	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus auricularis
11355119	11355119	PRJNA630877_S_NODE_156609_length_153_cov_1.160714_g137472_i0	PRJNA630877	156609	153	1.160714	1.77589242	root	1	Root_unresolved	Root_unresolved	228	1.9399999999999995e-55	NTclustered	gi\|2029783370\|gb\|CP073280.1\|	39488	g137472	i0	95.745	433.908496732026	141	6	92	0	1	141	13876	13736	Anaerobutyricum hallii strain EHAL chromosome	blastn	66388	228	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaerobutyricum	Anaerobutyricum hallii
12082572	12082572	PRJNA630877_S_NODE_93110_length_245_cov_3.299020_g73973_i0	PRJNA630877	93110	245	3.29902	8.082599	Anaerocolumna chitinilytica	1727145	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1886840841\|dbj\|AP023368.1\|	1727145	g73973	i0	100	0.114285714285714	28	0	11	0	94	121	2515687	2515660	Anaerocolumna chitinilytica DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaerocolumna	Anaerocolumna chitinilytica
12630820	12630820	PRJNA630877_S_NODE_111910_length_202_cov_33.788820_g92773_i0	PRJNA630877	111910	202	33.78882	68.2534164	Streptococcus	1301	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|285185485\|gb\|GU421358.1\|	28037	g92773	i0	100	100	202	0	100	0	1	202	335	134	Streptococcus mitis clone GM032 16S ribosomal RNA gene, partial sequence	blastn	20200	374	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
13357328	13357328	PRJNA630877_S_NODE_85331_length_271_cov_4.456522_g66194_i0	PRJNA630877	85331	271	4.456522	12.07717462	Planococcus sp. 107-1	2908840	Bacteria	Bacteria	501	2.05e-137	NTclustered	gi\|2180345768\|gb\|CP090977.1\|	2908840	g66194	i0	100	828.944649446495	271	0	100	0	1	271	70010	69740	Planococcus sp. 107-1 chromosome, complete genome	blastn	224644	501	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus sp. 107-1
15905946	15905946	PRJNA630877_S_NODE_93733_length_244_cov_0.970443_g74596_i0	PRJNA630877	93733	244	0.97044299999999994	2.36788092	Blautia argi	1912897	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|1997760551\|emb\|LR994468.1\|	1912897	g74596	i0	99.18	463.463114754098	244	2	100	0	1	244	18539	18782	Blautia argi isolate Blautia argi canine HQ MAG genome assembly, chromosome: 1	blastn	113085	440	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia argi
16454507	16454507	PRJNA630877_S_NODE_75653_length_316_cov_6.570909_g56516_i0	PRJNA630877	75653	316	6.570909	20.76407244	root	1	Root_unresolved	Root_unresolved	580	3.0499999999999993e-161	NTclustered	gi\|1368665179\|gb\|CP027782.1\|	1513	g56516	i0	100	123.186708860759	314	0	99	0	1	314	2807942	2808255	Clostridium tetani strain Mfbjulcb2 chromosome, complete genome	blastn	38927	580	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium tetani
17729606	17729606	PRJNA630877_S_NODE_117454_length_194_cov_1.150327_g98317_i0	PRJNA630877	117454	194	1.150327	2.23163438	Finegoldia	150022	Bacteria	Bacteria	348	1.91e-91	NTclustered	gi\|2127562652\|gb\|CP085955.1\|	1260	g98317	i0	98.969	288.963917525773	194	2	100	0	1	194	1427063	1427256	Finegoldia magna strain FDAARGOS_1557 chromosome, complete genome	blastn	56059	348	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
19729737	19729737	PRJNA630877_S_NODE_49996_length_570_cov_18.228733_g3816_i5	PRJNA630877	49996	570	18.228733	103.9037781	Paenibacillus lutimineralis	2707005	Bacteria	Bacteria	54.7	0.016	NTclustered	gi\|1547018893\|gb\|CP034346.1\|	2707005	g3816	i5	94.444	0.0631578947368421	36	0	6	2	46	79	4201774	4201809	Paenibacillus lutimineralis strain MBLB1234 chromosome, complete genome	blastn	36	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus lutimineralis
20278205	20278205	PRJNA630877_S_NODE_56436_length_479_cov_4.127854_g37408_i0	PRJNA630877	56436	479	4.127854	19.77242066	Streptococcus	1301	Bacteria	Bacteria	798	0	NTclustered	gi\|2288405307\|gb\|CP076703.1\|	1335	g37408	i0	98.884	428.352818371607	448	4	94	1	32	479	19964	19518	Streptococcus equinus strain S1 chromosome, complete genome	blastn	205181	798	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus equinus
22280244	22280244	PRJNA630877_S_NODE_93798_length_243_cov_3.500000_g74661_i0	PRJNA630877	93798	243	3.5	8.505	Planococcus halotolerans	2233542	Bacteria	Bacteria	333	6.989999999999999e-87	NTclustered	gi\|1799096099\|gb\|CP047673.1\|	2233542	g74661	i0	91.983	915.827160493827	237	19	98	0	1	237	137274	137510	Planococcus halotolerans strain Y50 chromosome, complete genome	blastn	222546	333	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus halotolerans
23555702	23555702	PRJNA630877_S_NODE_152979_length_156_cov_0.843478_g133842_i0	PRJNA630877	152979	156	0.843478	1.31582568	Mediterraneibacter gnavus	33038	Bacteria	Bacteria	255	9.12e-64	NTclustered	gi\|2813041557\|emb\|OZ186759.1\|	33038	g133842	i0	96.154	486.301282051282	156	6	100	0	1	156	3648037	3647882	Mediterraneibacter gnavus isolate LUMC_Rgna_QRD017 genome assembly, chromosome: 1	blastn	75863	255	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Mediterraneibacter gnavus
24103632	24103632	PRJNA630877_S_NODE_64199_length_398_cov_2.386555_g45067_i0	PRJNA630877	64199	398	2.386555	9.4984889	Streptococcus	1301	Bacteria	Bacteria	697	0	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g45067	i0	98.241	565.030150753769	398	7	100	0	1	398	16699	17096	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	224882	697	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
24829377	24829377	PRJNA630877_S_NODE_140100_length_167_cov_1.126984_g120963_i0	PRJNA630877	140100	167	1.126984	1.88206328	Staphylococcus auricularis	29379	Bacteria	Bacteria	292	7.58e-75	NTclustered	gi\|1403688813\|emb\|LS483491.1\|	29379	g120963	i0	98.204	99.9820359281437	167	3	100	0	1	167	2052264	2052430	Staphylococcus auricularis strain NCTC12101 genome assembly, chromosome: 1	blastn	16697	292	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus auricularis
25378152	25378152	PRJNA630877_S_NODE_94660_length_241_cov_1.710000_g75523_i0	PRJNA630877	94660	241	1.71	4.1211	Streptococcus	1301	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|1988318086\|gb\|CP070238.1\|	1335	g75523	i0	99.585	534	241	1	100	0	1	241	24043	24283	Streptococcus equinus strain Colony399 chromosome	blastn	128694	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus equinus

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