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

26 rows where analysis = "blastn", bioproject = "PRJEB27957" 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
23408	23408	PRJEB27957_P_NODE_46521_length_238_cov_1.486772_g46411_i0	PRJEB27957	46521	238	1.486772	3.53851736	Novisyntrophococcus fermenticellae	2068655	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2052596054\|gb\|CP076458.1\|	2068655	g46411	i0	96.774	0.130252100840336	31	1	13	0	39	69	1687888	1687858	Novisyntrophococcus fermenticellae strain JN500902 chromosome, complete genome	blastn	31	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Novisyntrophococcus	Novisyntrophococcus fermenticellae
23433	23433	PRJEB27957_P_NODE_92141_length_179_cov_1.492308_g92031_i0	PRJEB27957	92141	179	1.492308	2.67123132	Bacillus sp. S3	486398	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1633242871\|gb\|CP039727.1\|	486398	g92031	i0	100	0.162011173184358	29	0	16	0	97	125	5319364	5319392	Bacillus sp. S3 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. S3
986821	986821	PRJEB27957_P_NODE_73721_length_198_cov_2.000000_g73611_i0	PRJEB27957	73721	198	2	3.96	Bacillati	1783272	Bacteria	Bacteria	366	5.4e-97	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g73611	i0	100	481.919191919192	198	0	100	0	1	198	961622	961425	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	95420	366	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
2262131	2262131	PRJEB27957_P_NODE_5482_length_518_cov_2.353945_g5377_i0	PRJEB27957	5482	518	2.353945	12.1934351	Clostridium	1485	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2446185767\|gb\|CP118008.1\|	1502	g5377	i0	100	5.74517374517375	31	0	6	0	155	185	883655	883685	Clostridium perfringens strain OB21 TSA 19 chromosome, complete genome	blastn	2976	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
2262146	2262146	PRJEB27957_P_NODE_85662_length_186_cov_1.131387_g85552_i0	PRJEB27957	85662	186	1.131387	2.10437982	Staphylococcus	1279	Bacteria	Bacteria	344	2.34e-90	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g85552	i0	100	540.89247311828	186	0	100	0	1	186	748715	748530	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	100606	344	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2573293	2573293	PRJEB27957_P_NODE_117023_length_164_cov_2.260870_g116913_i0	PRJEB27957	117023	164	2.26087	3.7078268	Lactobacillus terrae	2269374	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1276010593\|gb\|CP024610.1\|	2269374	g116913	i0	100	0.170731707317073	28	0	17	0	107	134	1374166	1374193	Lactobacillus terrae strain NIBRBAC000499792 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus terrae
3849574	3849574	PRJEB27957_P_NODE_17824_length_343_cov_2.564626_g17714_i0	PRJEB27957	17824	343	2.564626	8.79666718	Staphylococcus sp. IVB6181	2929481	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2313394495\|gb\|CP095096.1\|	2929481	g17714	i0	100	0.0816326530612245	28	0	8	0	64	91	186647	186674	Staphylococcus sp. IVB6181 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus sp. IVB6181
5125824	5125824	PRJEB27957_P_NODE_45885_length_239_cov_2.463158_g45775_i0	PRJEB27957	45885	239	2.463158	5.88694762	Gemella morbillorum	29391	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1403530627\|emb\|LS483440.1\|	29391	g45775	i0	94.118	0.284518828451883	34	2	14	0	156	189	445353	445320	Gemella morbillorum strain NCTC11323 genome assembly, chromosome: 1	blastn	68	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella morbillorum
7364518	7364518	PRJEB27957_P_NODE_34486_length_268_cov_1.045662_g34376_i0	PRJEB27957	34486	268	1.045662	2.80237416	Aerococcus	1375	Bacteria	Bacteria	427	3.49e-115	NTclustered	gi\|984726517\|gb\|CP014164.1\|	1377	g34376	i0	95.522	449.294776119403	268	11	100	1	1	268	18893	19159	Aerococcus viridans strain CCUG4311, complete genome	blastn	120411	427	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus viridans
8639929	8639929	PRJEB27957_P_NODE_25207_length_302_cov_1.644269_g25097_i0	PRJEB27957	25207	302	1.644269	4.96569238	Weissella	46255	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2853049037\|gb\|CP098366.1\|	1249	g25097	i0	100	0.19205298013245	29	0	10	0	1	29	41479	41451	Weissella paramesenteroides strain LCW-28 plasmid unnamed1, complete sequence	blastn	58	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella paramesenteroides
10226182	10226182	PRJEB27957_P_NODE_69589_length_203_cov_1.688312_g69479_i0	PRJEB27957	69589	203	1.688312	3.42727336	Helicovermis profundi	3065157	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2557884615\|dbj\|AP028654.1\|	3065157	g69479	i0	100	0.142857142857143	29	0	14	0	107	135	1804098	1804070	Clostridia bacterium S502 DNA, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia			Helicovermis	Helicovermis profundi
15325593	15325593	PRJEB27957_P_NODE_58533_length_218_cov_1.230769_g58423_i0	PRJEB27957	58533	218	1.230769	2.68307642	uncultured Clostridia bacterium	244328	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2729058678\|emb\|OZ006978.1\|	244328	g58423	i0	100	0.13302752293578	29	0	13	0	76	104	1314977	1315005	MAG: uncultured Clostridia bacterium isolate 6755_HET_CTRL_s226.ctg000285l_hifiasm_large MAG genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia				uncultured Clostridia bacterium
15325598	15325598	PRJEB27957_P_NODE_74353_length_198_cov_1.046980_g74243_i0	PRJEB27957	74353	198	1.04698	2.0730204	Enterococcus gilvus	160453	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2739944680\|emb\|OZ061222.1\|	160453	g74243	i0	100	0.303030303030303	30	0	15	0	123	152	817899	817928	Enterococcus gilvus isolate Enterococcus gilvus CIRM-BIA2700 genome assembly, plasmid: 2	blastn	60	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus gilvus
16600195	16600195	PRJEB27957_P_NODE_113074_length_166_cov_0.888889_g112964_i0	PRJEB27957	113074	166	0.888889	1.47555574	Clostridium fermenticellae	2068654	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1483212838\|gb\|CP032416.1\|	2068654	g112964	i0	100	0.168674698795181	28	0	17	0	59	86	2198956	2198929	Clostridium fermenticellae strain JN500901 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium fermenticellae
16600215	16600215	PRJEB27957_P_NODE_22794_length_314_cov_1.177358_g22684_i0	PRJEB27957	22794	314	1.177358	3.69690412	Clostridium estertheticum	238834	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2557236457\|gb\|CP077610.1\|	238834	g22684	i0	100	0.089171974522293	28	0	9	0	127	154	802225	802198	Clostridium estertheticum strain CF005 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium estertheticum
16600228	16600228	PRJEB27957_P_NODE_40654_length_251_cov_1.544554_g40544_i0	PRJEB27957	40654	251	1.544554	3.87683054	Staphylococcus aureus	1280	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2646566561\|gb\|CP141464.1\|	1280	g40544	i0	100	0.111553784860558	28	0	11	0	170	197	2645360	2645387	Staphylococcus aureus strain Sau50 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
16600255	16600255	PRJEB27957_P_NODE_93634_length_178_cov_1.015504_g93524_i0	PRJEB27957	93634	178	1.015504	1.80759712	Agathobacter rectalis	39491	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2264318351\|gb\|CP100127.1\|	39491	g93524	i0	100	0.162921348314607	29	0	16	0	145	173	1466168	1466196	Agathobacter rectalis strain NB2A-17-FMU chromosome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
18838551	18838551	PRJEB27957_P_NODE_112495_length_166_cov_0.888889_g112385_i0	PRJEB27957	112495	166	0.888889	1.47555574	Clostridium	1485	Bacteria	Bacteria	298	1.62e-76	NTclustered	gi\|2329638396\|gb\|CP070936.1\|	1491	g112385	i0	99.39	73.9397590361446	164	1	99	0	3	166	250500	250337	Clostridium botulinum strain ZJK-3 chromosome, complete genome	blastn	12274	298	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
19148898	19148898	PRJEB27957_P_NODE_26336_length_297_cov_1.467742_g26226_i0	PRJEB27957	26336	297	1.467742	4.35919374	Proteinivorax hydrogeniformans	1826727	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2753484765\|gb\|CP159485.1\|	1826727	g26226	i0	100	0.0942760942760943	28	0	9	0	182	209	948914	948887	Proteinivorax hydrogeniformans strain Z-710 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Proteinivoracaceae	Proteinivorax	Proteinivorax hydrogeniformans
19148905	19148905	PRJEB27957_P_NODE_35256_length_265_cov_2.166667_g35146_i0	PRJEB27957	35256	265	2.166667	5.74166755	Selenobaculum gibii	3054208	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2519780754\|gb\|CP120678.1\|	3054208	g35146	i0	100	0.105660377358491	28	0	11	0	214	241	64455	64428	Selenobaculum gibii strain ICN-92133 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenobaculum	Selenobaculum gibii
19148917	19148917	PRJEB27957_P_NODE_53116_length_226_cov_1.734463_g53006_i0	PRJEB27957	53116	226	1.734463	3.91988638	Peptoniphilus lacrimalis	33031	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2812796007\|gb\|CP165621.1\|	33031	g53006	i0	100	0.128318584070796	29	0	13	0	105	133	56974	56946	Peptoniphilus lacrimalis strain F0141 isolate D048 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus lacrimalis
20424072	20424072	PRJEB27957_P_NODE_108737_length_167_cov_1.322034_g108627_i0	PRJEB27957	108737	167	1.322034	2.20779678	Mordavella massiliensis	1871024	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2729058686\|emb\|OZ006986.1\|	1871024	g108627	i0	100	0.167664670658683	28	0	17	0	75	102	1501659	1501686	MAG: Mordavella massiliensis isolate 6737_HOM_CTRL_s20.ctg000294l_hifiasm_large MAG genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Mordavella	Mordavella massiliensis
20424097	20424097	PRJEB27957_P_NODE_18217_length_341_cov_1.424658_g18107_i0	PRJEB27957	18217	341	1.424658	4.85808378	Anaerococcus sp. AH8042_DFU013_CI05	3385202	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2916126003\|gb\|CP175954.1\|	3385202	g18107	i0	100	0.0821114369501466	28	0	8	0	290	317	1649575	1649548	Anaerococcus sp. DFU013_CI05 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. AH8042_DFU013_CI05
20424129	20424129	PRJEB27957_P_NODE_75577_length_196_cov_1.768707_g75467_i0	PRJEB27957	75577	196	1.768707	3.46666572	Paenibacillus durus	44251	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|686566537\|gb\|CP009288.1\|	44251	g75467	i0	100	0.142857142857143	28	0	14	0	141	168	5083703	5083676	Paenibacillus durus strain DSM 1735, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus durus
21388973	21388973	PRJEB27957_P_NODE_53157_length_226_cov_1.525424_g53047_i0	PRJEB27957	53157	226	1.525424	3.44745824	Streptococcus	1301	Bacteria	Bacteria	399	6.239999999999999e-107	NTclustered	gi\|1403375826\|emb\|LS483375.1\|	1302	g53047	i0	98.667	342.075221238938	225	3	99	0	2	226	625697	625473	Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1	blastn	77309	399	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
22975344	22975344	PRJEB27957_P_NODE_114399_length_165_cov_1.456897_g114289_i0	PRJEB27957	114399	165	1.456897	2.40388005	Acetobacterium woodii	33952	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|375300680\|gb\|CP002987.1\|	931626	g114289	i0	100	0.16969696969697	28	0	17	0	66	93	1720730	1720757	Acetobacterium woodii DSM 1030, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Acetobacterium	Acetobacterium woodii

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