metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA1174207" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA1174207" 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
1590158	1590158	PRJNA1174207_P_NODE_20722_length_311_cov_1.285714_g20193_i0	PRJNA1174207	20722	311	1.285714	3.99857054	Clostridioides difficile	1496	Bacteria	Bacteria	167	5.89e-50	NR	MCJ0157547.1	1496	g20193	i0	71.6	5.78778135048232	102	25	98.4	1	309	4	21	118	MCJ0157547.1 WD40 repeat domain-containing protein [Clostridioides difficile]	diamond	1800	167	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
4142654	4142654	PRJNA1174207_P_NODE_33664_length_251_cov_0.865169_g33135_i0	PRJNA1174207	33664	251	0.865169	2.17157419	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	157	1.8899999999999993e-43	NR	MCX7657827.1	2485925	g33135	i0	98.8	2.97609561752988	83	1	99.2	0	2	250	389	471	MCX7657827.1 ATP-dependent Clp protease ATP-binding subunit [Oscillospiraceae bacterium]	diamond	747	157	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
5419090	5419090	PRJNA1174207_P_NODE_9905_length_487_cov_2.103865_g9379_i0	PRJNA1174207	9905	487	2.103865	10.24582255	root	1	Root_unresolved	Root_unresolved	277	8.109999999999999e-92	NR	MBO8907837.1	1280	g9379	i0	80.9	230.482546201232	162	31	99.8	0	1	486	85	246	MBO8907837.1 hypothetical protein [Staphylococcus aureus]	diamond	112245	278	0.996402877697842	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
27134948	27134948	PRJNA1174207_P_NODE_25402_length_284_cov_1.431280_g24873_i0	PRJNA1174207	25402	284	1.43128	4.0648352	Bacillus velezensis	492670	Bacteria	Bacteria	194	4.22e-62	NR	MEA5632492.1	492670	g24873	i0	98.9	2.97887323943662	94	1	99.3	0	2	283	12	105	MEA5632492.1 4'-phosphopantetheinyl transferase [Bacillus velezensis]	diamond	846	194	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus velezensis
27546090	27546090	PRJNA1174207_P_NODE_26344_length_280_cov_1.362319_g25815_i0	PRJNA1174207	26344	280	1.362319	3.8144932	Alkalihalobacterium alkalinitrilicum	427920	Bacteria	Bacteria	177	2.03e-49	NR	WP_238457938.1	427920	g25815	i0	88.2	0.996428571428571	93	11	99.6	0	2	280	234	326	WP_238457938.1 DEAD/DEAH box helicase [Alkalihalobacterium alkalinitrilicum]	diamond	279	177	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalobacterium	Alkalihalobacterium alkalinitrilicum
27988150	27988150	PRJNA1174207_P_NODE_30865_length_261_cov_1.638298_g30336_i0	PRJNA1174207	30865	261	1.638298	4.27595778	Anaeroglobus geminatus	156456	Bacteria	Bacteria	127	1.95e-36	NR	WP_040347123.1	156456	g30336	i0	95.6	0.781609195402299	68	3	78.2	0	56	259	1	68	WP_040347123.1 ribosomal L7Ae/L30e/S12e/Gadd45 family protein [Anaeroglobus geminatus]	diamond	204	127	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Anaeroglobus	Anaeroglobus geminatus
28335404	28335404	PRJNA1174207_P_NODE_37366_length_246_cov_0.890173_g36837_i0	PRJNA1174207	37366	246	0.890173	2.18982558	Anaerococcus sp.	1872515	Bacteria	Bacteria	159	2.4899999999999997e-48	NR	MDU5535107.1	1872515	g36837	i0	100	0.926829268292683	76	0	92.7	0	18	245	1	76	MDU5535107.1 butyryl-CoA:acetate CoA-transferase [Anaerococcus sp.]	diamond	228	159	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp.
28398555	28398555	PRJNA1174207_P_NODE_25666_length_283_cov_1.171429_g25137_i0	PRJNA1174207	25666	283	1.171429	3.31514407	Selenomonas sp.	2053611	Bacteria	Bacteria	152	2.12e-41	NR	MBP8598956.1	2053611	g25137	i0	91.9	0.911660777385159	86	7	91.2	0	26	283	1	86	MBP8598956.1 type I restriction-modification system subunit M [Selenomonas sp.]	diamond	258	152	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas sp.
28859696	28859696	PRJNA1174207_P_NODE_41408_length_241_cov_0.916667_g40879_i0	PRJNA1174207	41408	241	0.916667	2.20916747	root	1	Root_unresolved	Root_unresolved	43.1	0.0271	NR	TKW62483.1	1308	g40879	i0	58.1	2.47717842323651	86	17	99.6	2	241	2	251	323	TKW62483.1 MAG: hypothetical protein DI612_08705, partial [Streptococcus thermophilus]	diamond	597	43.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
28986350	28986350	PRJNA1174207_P_NODE_25748_length_282_cov_2.622010_g25219_i0	PRJNA1174207	25748	282	2.62201	7.3940682	Streptococcaceae	1300	Bacteria	Bacteria	177	3.45e-53	NR	WP_068163331.1	1365	g25219	i0	98.9	1.97872340425532	93	1	98.9	0	2	280	109	201	WP_068163331.1 carbohydrate ABC transporter permease [Lactococcus plantarum]	diamond	558	177	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Pseudolactococcus	Pseudolactococcus plantarum
29661089	29661089	PRJNA1174207_P_NODE_33390_length_251_cov_0.865169_g32861_i0	PRJNA1174207	33390	251	0.865169	2.17157419	Clostridiales bacterium S5-A14a	1230734	Bacteria	Bacteria	151	9.959999999999997e-43	NR	KGF09301.1	1230734	g32861	i0	100	0.884462151394422	74	0	88.4	0	250	29	272	345	KGF09301.1 hypothetical protein HMPREF1635_03630 [Clostridiales bacterium S5-A14a]	diamond	222	151	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae		Clostridiales bacterium S5-A14a
29914351	29914351	PRJNA1174207_P_NODE_39291_length_244_cov_0.900585_g38762_i0	PRJNA1174207	39291	244	0.900585	2.1974274	Metabacillus sp.	2675275	Bacteria	Bacteria	148	3.21e-41	NR	HZH60177.1	2675275	g38762	i0	87.7	0.995901639344262	81	10	99.6	0	243	1	4	84	HZH60177.1 rod shape-determining protein RodA [Metabacillus sp.]	diamond	243	148	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus sp.
30325420	30325420	PRJNA1174207_P_NODE_28732_length_270_cov_1.203046_g28203_i0	PRJNA1174207	28732	270	1.203046	3.2482242	Bacillus toyonensis	155322	Bacteria	Bacteria	51.6	1.64e-5	NR	MBG9885229.1	155322	g28203	i0	63.4	0.455555555555556	41	15	45.6	0	2	124	39	79	MBG9885229.1 hypothetical protein [Bacillus toyonensis]	diamond	123	51.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus toyonensis
30325425	30325425	PRJNA1174207_P_NODE_41072_length_241_cov_2.220238_g40543_i0	PRJNA1174207	41072	241	2.220238	5.35077358	Lactococcus plantarum	1365	Bacteria	Bacteria	147	5.59e-40	NR	WP_068161750.1	1365	g40543	i0	96.3	0.995850622406639	80	3	99.6	0	241	2	283	362	WP_068161750.1 MFS transporter [Lactococcus plantarum]	diamond	240	147	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Pseudolactococcus	Pseudolactococcus plantarum
30818038	30818038	PRJNA1174207_P_NODE_29934_length_265_cov_1.390625_g29405_i0	PRJNA1174207	29934	265	1.390625	3.68515625	Bacillati	1783272	Bacteria	Bacteria	53.9	5.38e-6	NR	CDC80126.1	1262848	g29405	i0	37.2	7.07547169811321	86	54	97.4	0	3	260	259	344	CDC80126.1 yjeF domain protein [Clostridium sp. CAG:964]	diamond	1875	54.3	0.992633517495396	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. CAG:964
31778807	31778807	PRJNA1174207_P_NODE_34077_length_250_cov_1.333333_g33548_i0	PRJNA1174207	34077	250	1.333333	3.3333325	Streptococcus	1301	Bacteria	Bacteria	144	5.499999999999999e-39	NR	WP_244491692.1	1301	g33548	i0	81.9	1.992	83	15	99.6	0	250	2	192	274	WP_244491692.1 MULTISPECIES: serine/threonine-protein kinase [Streptococcus]	diamond	498	144	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus
32695711	32695711	PRJNA1174207_P_NODE_21720_length_306_cov_1.266094_g21191_i0	PRJNA1174207	21720	306	1.266094	3.87424764	Staphylococcus warneri	1292	Bacteria	Bacteria	87.4	1.37e-20	NR	MDU1259852.1	1292	g21191	i0	95.5	0.431372549019608	44	2	43.1	0	215	84	1	44	MDU1259852.1 hypothetical protein [Staphylococcus warneri]	diamond	132	87.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
32840779	32840779	PRJNA1174207_P_NODE_42280_length_235_cov_7.024691_g41751_i0	PRJNA1174207	42280	235	7.024691	16.50802385	Bacteria	2	Bacteria	Bacteria	143	7.19e-42	NR	MDG6689955.1	1280	g41751	i0	88.3	4.91489361702128	77	9	98.3	0	233	3	21	97	MDG6689955.1 transposase [Staphylococcus aureus]	diamond	1155	144	0.993055555555556	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus

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