metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA564810" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA564810" 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
9482538	9482538	PRJNA564810_S_NODE_1308_length_376_cov_5.691318_g1286_i0	PRJNA564810	1308	376	5.691318	21.39935568	Hathewaya histolytica	1498	Bacteria	Bacteria	87.8	1.72e-17	NR	WP_171012051.1	1498	g1286	i0	44.3	0.917553191489362	115	62	91.8	2	3	347	291	403	WP_171012051.1 BppU family phage baseplate upper protein [Hathewaya histolytica]	diamond	345	87.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
26903361	26903361	PRJNA564810_S_NODE_3861_length_276_cov_2.279621_g3839_i0	PRJNA564810	3861	276	2.279621	6.29175396	Bacillati	1783272	Bacteria	Bacteria	48.5	5.09e-4	NR	WP_085832162.1	1958780	g3839	i0	49	1.32608695652174	51	20	55.4	2	274	122	711	755	WP_085832162.1 YfhO family protein [Clostridium merdae]	diamond	366	48.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium merdae
27110747	27110747	PRJNA564810_S_NODE_1682_length_352_cov_1.184669_g1660_i0	PRJNA564810	1682	352	1.184669	4.17003488	Clostridium botulinum	1491	Bacteria	Bacteria	186	7.66e-53	NR	WP_230869856.1	1491	g1660	i0	80.5	8.70170454545454	113	22	96.3	0	13	351	248	360	WP_230869856.1 NACHT domain-containing protein [Clostridium botulinum]	diamond	3063	186	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
28089944	28089944	PRJNA564810_S_NODE_6885_length_224_cov_3.138365_g6863_i0	PRJNA564810	6885	224	3.138365	7.0299376	Sporosalibacterium faouarense	516123	Bacteria	Bacteria	63.9	1.39e-10	NR	WP_202707238.1	516123	g6863	i0	55.8	1.19196428571429	43	19	57.6	0	215	87	117	159	WP_202707238.1 TspO/MBR family protein [Sporosalibacterium faouarense]	diamond	267	63.9	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Thermohalobacteraceae	Sporosalibacterium	Sporosalibacterium faouarense
29068979	29068979	PRJNA564810_S_NODE_5548_length_244_cov_1.899441_g5526_i0	PRJNA564810	5548	244	1.899441	4.63463604	Brevibacillus dissolubilis	1844116	Bacteria	Bacteria	54.7	2.24e-6	NR	WP_139490473.1	1844116	g5526	i0	51.8	0.688524590163934	56	26	68.9	1	242	75	580	634	WP_139490473.1 CocE/NonD family hydrolase [Brevibacillus dissolubilis]	diamond	168	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus dissolubilis
29258010	29258010	PRJNA564810_S_NODE_4049_length_272_cov_1.811594_g4027_i0	PRJNA564810	4049	272	1.811594	4.92753568	Clostridium diolis	223919	Bacteria	Bacteria	157	1.4200000000000001e-44	NR	WP_179207979.1	223919	g4027	i0	80	1.98529411764706	90	18	99.3	0	2	271	76	165	WP_179207979.1 hypothetical protein [Clostridium diolis]	diamond	540	157	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium diolis
30174005	30174005	PRJNA564810_S_NODE_7812_length_215_cov_0.906667_g7790_i0	PRJNA564810	7812	215	0.906667	1.94933405	Clostridium sp.	1506	Bacteria	Bacteria	132	8.89e-36	NR	WP_367664529.1	1506	g7790	i0	88.7	1.98139534883721	71	8	99.1	0	213	1	175	245	WP_367664529.1 ABC transporter ATP-binding protein [Clostridium sp.]	diamond	426	132	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
30535345	30535345	PRJNA564810_S_NODE_5553_length_244_cov_1.519553_g5531_i0	PRJNA564810	5553	244	1.519553	3.70770932	Bacilli	91061	Bacteria	Bacteria	50.8	2.42e-5	NR	WP_256237718.1	2806345	g5531	i0	52.4	2.95081967213115	42	20	51.6	0	2	127	126	167	WP_256237718.1 50S ribosomal protein L6 [Bacillus sp. EB600]	diamond	720	50.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. EB600
32039233	32039233	PRJNA564810_S_NODE_3958_length_274_cov_2.000000_g3936_i0	PRJNA564810	3958	274	2	5.48	Hathewaya histolytica	1498	Bacteria	Bacteria	87.8	1.01e-18	NR	WP_138209604.1	1498	g3936	i0	67.7	0.678832116788321	62	20	67.9	0	87	272	75	136	WP_138209604.1 Tim44 domain-containing protein [Hathewaya histolytica]	diamond	186	87.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
32545685	32545685	PRJNA564810_S_NODE_2459_length_317_cov_1.349206_g2437_i0	PRJNA564810	2459	317	1.349206	4.27698302	Clostridium hydrogeniformans	349933	Bacteria	Bacteria	188	5.83e-57	NR	WP_034849062.1	349933	g2437	i0	92.4	0.993690851735016	105	8	99.4	0	315	1	214	318	WP_034849062.1 ABC transporter permease subunit [Clostridium hydrogeniformans]	diamond	315	188	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium hydrogeniformans
32829024	32829024	PRJNA564810_S_NODE_2620_length_311_cov_1.516260_g2598_i0	PRJNA564810	2620	311	1.51626	4.7155686	Staphylococcus aureus	1280	Bacteria	Bacteria	47	0.00249	NR	WP_190346037.1	1280	g2598	i0	50	0.92604501607717	96	24	89.7	4	32	310	290	364	WP_190346037.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	288	47	1	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);;