metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA763718" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA763718" 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
2020231	2020231	PRJNA763718_S_NODE_8142_length_155_cov_0.991525_g7934_i0	PRJNA763718	8142	155	0.991525	1.53686375	Catenibacterium mitsuokai	100886	Bacteria	Bacteria	279	5.37e-71	NTclustered	gi\|2299336055\|gb\|CP102271.1\|	100886	g7934	i0	99.351	15.8322580645161	154	1	99	0	2	155	143940	143787	Catenibacterium mitsuokai strain DSM 15897 chromosome, complete genome	blastn	2454	279	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Catenibacterium	Catenibacterium mitsuokai
3757181	3757181	PRJNA763718_S_NODE_8503_length_152_cov_1.669565_g8295_i0	PRJNA763718	8503	152	1.669565	2.5377388	Jeotgalicoccus	227979	Bacteria	Bacteria	265	1.47e-66	NTclustered	gi\|1949519824\|gb\|CP066224.1\|	946435	g8295	i0	98.026	493.032894736842	152	3	100	0	1	152	14488	14337	Jeotgalicoccus sp. ATCC 8456 chromosome, complete genome	blastn	74941	265	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus sp. ATCC 8456
7122911	7122911	PRJNA763718_S_NODE_4146_length_216_cov_1.284916_g3938_i0	PRJNA763718	4146	216	1.284916	2.77541856	Clostridium estertheticum	238834	Bacteria	Bacteria	137	5.119999999999999e-28	NTclustered	gi\|2557236457\|gb\|CP077610.1\|	238834	g3938	i0	79.787	0.87037037037037	188	38	87	0	25	212	2386514	2386701	Clostridium estertheticum strain CF005 chromosome, complete genome	blastn	188	137	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium estertheticum
7122921	7122921	PRJNA763718_S_NODE_6306_length_174_cov_1.372263_g6098_i0	PRJNA763718	6306	174	1.372263	2.38773762	Caldanaerobacter subterraneus	911092	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|20671658\|gb\|AE008691.1\|	273068	g6098	i0	96.97	0.189655172413793	33	0	18	1	26	57	2129690	2129722	Thermoanaerobacter tengcongensis MB4, complete genome	blastn	33	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Caldanaerobacter	Caldanaerobacter subterraneus
7583423	7583423	PRJNA763718_S_NODE_2026_length_329_cov_3.815068_g1818_i0	PRJNA763718	2026	329	3.815068	12.55157372	Streptococcus	1301	Bacteria	Bacteria	592	1.4799999999999996e-164	NTclustered	gi\|2091509769\|gb\|CP082778.1\|	1307	g1818	i0	99.088	384.118541033435	329	3	100	0	1	329	19651	19323	Streptococcus suis strain ID32098 chromosome, complete genome	blastn	126375	592	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus suis
8858496	8858496	PRJNA763718_S_NODE_1627_length_382_cov_2.968116_g1419_i0	PRJNA763718	1627	382	2.968116	11.33820312	Streptococcus	1301	Bacteria	Bacteria	706	0	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g1419	i0	100	562.767015706806	382	0	100	0	1	382	162069	161688	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	214977	706	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
11409226	11409226	PRJNA763718_S_NODE_3789_length_227_cov_1.026316_g3581_i0	PRJNA763718	3789	227	1.026316	2.32973732	Staphylococcaceae	90964	Bacteria	Bacteria	409	1.04e-109	NTclustered	gi\|2563359124\|gb\|CP132366.1\|	1280	g3581	i0	99.119	166.770925110132	227	2	100	0	1	227	28032	27806	Staphylococcus aureus strain UNC_SA54 plasmid p2, complete sequence	blastn	37857	409	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
12685086	12685086	PRJNA763718_S_NODE_4490_length_207_cov_1.811765_g4282_i0	PRJNA763718	4490	207	1.811765	3.75035355	root	1	Root_unresolved	Root_unresolved	52.8	0.018	NTclustered	gi\|1957938246\|gb\|CP065314.1\|	1531	g4282	i0	100	0.628019323671498	28	0	14	0	149	176	2135379	2135406	Enterocloster clostridioformis strain YL32 chromosome	blastn	130	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Enterocloster	Enterocloster clostridioformis
13497963	13497963	PRJNA763718_S_NODE_7151_length_164_cov_1.519685_g6943_i0	PRJNA763718	7151	164	1.519685	2.4922834	Clostridium tagluense	360422	Bacteria	Bacteria	115	1.72e-21	NTclustered	gi\|2557231455\|gb\|CP077605.1\|	360422	g6943	i0	85.455	1.77439024390244	110	16	67	0	17	126	3040564	3040673	Clostridium tagluense strain CM008 chromosome, complete genome	blastn	291	115	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium tagluense
13959427	13959427	PRJNA763718_S_NODE_7971_length_156_cov_2.462185_g7763_i0	PRJNA763718	7971	156	2.462185	3.8410086	Veillonella	29465	Bacteria	Bacteria	261	1.96e-65	NTclustered	gi\|1175700537\|gb\|CP020566.1\|	39777	g7763	i0	96.815	691.358974358974	157	4	100	1	1	156	80617	80773	Veillonella atypica strain OK5, complete genome	blastn	107852	261	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella atypica
15233904	15233904	PRJNA763718_S_NODE_4712_length_202_cov_1.836364_g4504_i0	PRJNA763718	4712	202	1.836364	3.70945528	Bacillales	1385	Bacteria	Bacteria	340	3.35e-89	NTclustered	gi\|2866365417\|gb\|CP174470.1\|	1404	g4504	i0	97.03	761.277227722772	202	6	100	0	1	202	12231	12030	Priestia megaterium strain WSY10 chromosome, complete genome	blastn	153778	340	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
19870988	19870988	PRJNA763718_S_NODE_2696_length_276_cov_3.924686_g2488_i0	PRJNA763718	2696	276	3.924686	10.83213336	Staphylococcus auricularis	29379	Bacteria	Bacteria	483	7.589999999999998e-132	NTclustered	gi\|1403688813\|emb\|LS483491.1\|	29379	g2488	i0	98.535	486.286231884058	273	4	99	0	1	273	2002278	2002550	Staphylococcus auricularis strain NCTC12101 genome assembly, chromosome: 1	blastn	134215	483	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus auricularis
20331826	20331826	PRJNA763718_S_NODE_616_length_753_cov_4.840782_g458_i0	PRJNA763718	616	753	4.840782	36.45108846	Streptococcus	1301	Bacteria	Bacteria	1201	0	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g458	i0	95.509	572.36786188579	757	25	99	9	2	753	18250	17498	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	430993	1201	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
22883110	22883110	PRJNA763718_S_NODE_3678_length_230_cov_22.865285_g3470_i0	PRJNA763718	3678	230	22.865285	52.5901555	Bacillales	1385	Bacteria	Bacteria	425	1.05e-114	NTclustered	gi\|2556673542\|gb\|OR367734.1\|	1282	g3470	i0	100	110.008695652174	230	0	100	0	1	230	288	517	Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence	blastn	25302	425	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
24157109	24157109	PRJNA763718_S_NODE_3539_length_236_cov_2.788945_g3331_i0	PRJNA763718	3539	236	2.788945	6.5819102	Streptococcus	1301	Bacteria	Bacteria	436	4.999999999999999e-118	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g3331	i0	100	354.402542372881	236	0	100	0	1	236	1568695	1568930	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	83639	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
25432053	25432053	PRJNA763718_S_NODE_4960_length_197_cov_1.200000_g4752_i0	PRJNA763718	4960	197	1.2	2.364	Bacillati	1783272	Bacteria	Bacteria	364	1.929999999999999e-96	NTclustered	gi\|2283119276\|gb\|CP071933.1\|	1390	g4752	i0	100	85.507614213198	197	0	100	0	1	197	622	426	Bacillus amyloliquefaciens strain CAS02 plasmid unnamed, complete sequence	blastn	16845	364	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
25432056	25432056	PRJNA763718_S_NODE_5240_length_191_cov_3.259740_g5032_i0	PRJNA763718	5240	191	3.25974	6.2261034	Clostridium	1485	Bacteria	Bacteria	171	4.3499999999999997e-38	NTclustered	gi\|2574148218\|gb\|CP121696.1\|	1491	g5032	i0	83.077	22.1151832460733	195	25	100	7	1	191	2961244	2961434	Clostridium botulinum strain BT-22100019 chromosome, complete genome	blastn	4224	171	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum

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