metadata: contig_metadata: 14 rows where bioproject = "PRJNA1193541" and tax

14 rows where bioproject = "PRJNA1193541" 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
2317743	2317743	PRJNA1193541_P_NODE_12502_length_250_cov_0.870056_g12364_i0	PRJNA1193541	12502	250	0.870056	2.17514	Bacillus	1386	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|2006627593\|gb\|CP065159.1\|	1390	g12364	i0	99.2	100	250	2	100	0	1	250	2919638	2919887	Bacillus amyloliquefaciens strain GXU-1 chromosome, complete genome	blastn	25000	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
4147489	4147489	PRJNA1193541_P_NODE_12944_length_248_cov_1.462857_g12806_i0	PRJNA1193541	12944	248	1.462857	3.62788536	Enterococcus cecorum	44008	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|939198273\|gb\|CP010060.1\|	44008	g12806	i0	98.79	27	248	3	100	0	1	248	1805585	1805338	Enterococcus cecorum strain SA1 genome	blastn	6696	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus cecorum
5423928	5423928	PRJNA1193541_P_NODE_9465_length_285_cov_1.198113_g9327_i0	PRJNA1193541	9465	285	1.198113	3.41462205	Enterococcus cecorum	44008	Bacteria	Bacteria	521	1.6699999999999996e-143	NTclustered	gi\|2737620634\|gb\|CP144498.1\|	44008	g9327	i0	99.649	27	285	1	100	0	1	285	985257	984973	Enterococcus cecorum strain 66 chromosome, complete genome	blastn	7695	521	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus cecorum
7420291	7420291	PRJNA1193541_P_NODE_13306_length_247_cov_0.885057_g13168_i0	PRJNA1193541	13306	247	0.885057	2.18609079	Bacilli	91061	Bacteria	Bacteria	287	5.62e-73	NTclustered	gi\|1395792743\|gb\|CP029653.1\|	1280	g13168	i0	98.758	52.2024291497976	161	2	65	0	1	161	1646561	1646721	Staphylococcus aureus strain AR_0470 chromosome, complete genome	blastn	12894	287	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
7420292	7420292	PRJNA1193541_P_NODE_13646_length_246_cov_0.890173_g13508_i0	PRJNA1193541	13646	246	0.890173	2.18982558	Bacillota	1239	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1963758695\|emb\|LR962115.1\|	1351	g13508	i0	100	12.0365853658537	246	0	100	0	1	246	511378	511133	Enterococcus faecalis isolate 26975_1#262 genome assembly, chromosome: 1	blastn	2961	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
9970529	9970529	PRJNA1193541_P_NODE_11068_length_265_cov_1.203125_g10930_i0	PRJNA1193541	11068	265	1.203125	3.18828125	Lactobacillus	1578	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|470474342\|ref\|NR_076210.1\|	33959	g10930	i0	100	504.747169811321	265	0	100	0	1	265	1775	1511	Lactobacillus johnsonii strain NCC 533 23S ribosomal RNA gene, complete sequence	blastn	133758	490	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus johnsonii
16344936	16344936	PRJNA1193541_P_NODE_9993_length_279_cov_0.878641_g9855_i0	PRJNA1193541	9993	279	0.878641	2.45140839	Clostridium botulinum	1491	Bacteria	Bacteria	167	3.67e-51	NR	MBY7057768.1	1491	g9855	i0	91.4	3	93	8	100	0	279	1	21	113	MBY7057768.1 dipeptide ABC transporter permease DppC [Clostridium botulinum]	diamond	837	167	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
18172188	18172188	PRJNA1193541_P_NODE_12775_length_249_cov_0.875000_g12637_i0	PRJNA1193541	12775	249	0.875	2.17875	Caldifermentibacillus hisashii	996558	Bacteria	Bacteria	250	7.4499999999999995e-62	NTclustered	gi\|2760084077\|gb\|CP159977.1\|	996558	g12637	i0	100	27.0481927710843	135	0	54	0	1	135	3295691	3295557	Caldifermentibacillus hisashii strain FSL W8-0751 chromosome, complete genome	blastn	6735	250	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Caldifermentibacillus	Caldifermentibacillus hisashii
18893856	18893856	PRJNA1193541_P_NODE_13355_length_247_cov_0.885057_g13217_i0	PRJNA1193541	13355	247	0.885057	2.18609079	Bacillus	1386	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2207831829\|gb\|CP044132.1\|	1390	g13217	i0	99.595	22	247	1	100	0	1	247	1925432	1925678	Bacillus amyloliquefaciens strain ZKY01 chromosome, complete genome	blastn	5434	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
21444339	21444339	PRJNA1193541_P_NODE_14457_length_243_cov_0.905882_g14319_i0	PRJNA1193541	14457	243	0.905882	2.20129326	Streptococcus	1301	Bacteria	Bacteria	388	1.47e-103	NTclustered	gi\|2072520965\|gb\|CP079821.1\|	1234680	g14319	i0	95.473	13.8518518518519	243	11	100	0	1	243	13902	14144	Streptococcus rubneri strain LPB0404 chromosome, complete genome	blastn	3366	388	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus rubneri
27546331	27546331	PRJNA1193541_P_NODE_10104_length_277_cov_1.465686_g9966_i0	PRJNA1193541	10104	277	1.465686	4.05995022	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	84	1.9e-16	NR	MBR5577876.1	1898203	g9966	i0	53.3	0.974729241877256	90	40	97.5	2	7	276	1223	1310	MBR5577876.1 beta-N-acetylglucosaminidase domain-containing protein [Lachnospiraceae bacterium]	diamond	270	84	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28935638	28935638	PRJNA1193541_P_NODE_14008_length_245_cov_0.895349_g13870_i0	PRJNA1193541	14008	245	0.895349	2.19360505	Staphylococcus aureus	1280	Bacteria	Bacteria	93.2	9.33e-23	NR	WP_348968639.1	1280	g13870	i0	100	0.6	49	0	60	0	98	244	1	49	WP_348968639.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	147	93.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
30072282	30072282	PRJNA1193541_P_NODE_13632_length_246_cov_0.890173_g13494_i0	PRJNA1193541	13632	246	0.890173	2.18982558	Brevibacillus thermoruber	33942	Bacteria	Bacteria	43.5	0.0195	NR	WP_035297969.1	33942	g13494	i0	36.4	0.670731707317073	55	35	67.1	0	47	211	6	60	WP_035297969.1 hypothetical protein [Brevibacillus thermoruber]	diamond	165	43.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus thermoruber
30925676	30925676	PRJNA1193541_P_NODE_14054_length_245_cov_0.895349_g13916_i0	PRJNA1193541	14054	245	0.895349	2.19360505	Thermicanus aegyptius	94009	Bacteria	Bacteria	137	3.57e-37	NR	WP_028986596.1	94009	g13916	i0	86.4	0.991836734693878	81	11	99.2	0	245	3	34	114	WP_028986596.1 flavodoxin-dependent (E)-4-hydroxy-3-methylbut-2-enyl-diphosphate synthase [Thermicanus aegyptius]	diamond	243	137	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius

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