metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJEB65099" and tax

14 rows where analysis = "diamond", bioproject = "PRJEB65099" 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
27634311	27634311	PRJEB65099_P_NODE_5784_length_248_cov_0.891429_g5679_i0	PRJEB65099	5784	248	0.891429	2.21074392	Halanaerobium sp. ST46	1895664	Bacteria	Bacteria	72	1.93e-12	NR	WP_114490096.1	2183914	g5679	i0	87.7	1.97177419354839	81	10	98	0	4	246	333	413	WP_114490096.1 MEDS domain-containing protein [Halanaerobium sp. ST460_2HS_T2]	diamond	489	72	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halanaerobiaceae	Halanaerobium	Halanaerobium sp. ST460_2HS_T2
27634312	27634312	PRJEB65099_P_NODE_6584_length_243_cov_2.217647_g6479_i0	PRJEB65099	6584	243	2.217647	5.38888221	Streptococcus pneumoniae	1313	Bacteria	Bacteria	77.8	4.49e-17	NR	CWF69157.1	1313	g6479	i0	97.3	0.45679012345679	37	1	45.7	0	1	111	12	48	CWF69157.1 Uncharacterised protein [Streptococcus pneumoniae]	diamond	111	77.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
27855159	27855159	PRJEB65099_P_NODE_6885_length_242_cov_0.923077_g6780_i0	PRJEB65099	6885	242	0.923077	2.23384634	Halanaerobium sp. MDAL1	1898548	Bacteria	Bacteria	152	1.35e-40	NR	OEG62269.1	1898548	g6780	i0	100	0.991735537190083	80	0	99.2	0	241	2	756	835	OEG62269.1 MAG: hypothetical protein BHK79_07075 [Halanaerobium sp. MDAL1]	diamond	240	152	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halanaerobiaceae	Halanaerobium	Halanaerobium sp. MDAL1
28897045	28897045	PRJEB65099_P_NODE_4368_length_268_cov_1.015385_g4263_i0	PRJEB65099	4368	268	1.015385	2.7212318	Clostridia bacterium	2044939	Bacteria	Bacteria	43.5	0.0273	NR	MBR3739319.1	2044939	g4263	i0	35.5	0.694029850746269	62	39	68.3	1	192	10	487	548	MBR3739319.1 GNAT family N-acetyltransferase [Clostridia bacterium]	diamond	186	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28992189	28992189	PRJEB65099_P_NODE_6508_length_244_cov_0.912281_g6403_i0	PRJEB65099	6508	244	0.912281	2.22596564	Clostridia bacterium	2044939	Bacteria	Bacteria	151	6.39e-42	NR	HKL41583.1	2044939	g6403	i0	92.5	0.983606557377049	80	6	98.4	0	242	3	159	238	HKL41583.1 ABC transporter substrate-binding protein [Clostridia bacterium]	diamond	240	151	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29686157	29686157	PRJEB65099_P_NODE_4490_length_264_cov_1.633508_g4385_i0	PRJEB65099	4490	264	1.633508	4.31246112	Christensenellales bacterium	3083246	Bacteria	Bacteria	167	5.809999999999999e-46	NR	MEF2689691.1	3083246	g4385	i0	95.5	1	88	4	100	0	1	264	59	146	MEF2689691.1 vWA domain-containing protein [Christensenellales bacterium]	diamond	264	167	1	Bacteria	Bacillati	Bacillota	Clostridia	Christensenellales			Christensenellales bacterium
29686159	29686159	PRJEB65099_P_NODE_5770_length_248_cov_0.891429_g5665_i0	PRJEB65099	5770	248	0.891429	2.21074392	Schleiferilactobacillus perolens	100468	Bacteria	Bacteria	102	2.5e-23	NR	WP_415649163.1	100468	g5665	i0	75.8	0.75	62	15	75	0	3	188	248	309	WP_415649163.1 phage minor capsid protein [Schleiferilactobacillus perolens]	diamond	186	102	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Schleiferilactobacillus	Schleiferilactobacillus perolens
29837232	29837232	PRJEB65099_P_NODE_6191_length_246_cov_0.901734_g6086_i0	PRJEB65099	6191	246	0.901734	2.21826564	Ruminococcus	1263	Bacteria	Bacteria	43.5	0.0197	NR	MEF2796709.1	41978	g6086	i0	37.7	1.48780487804878	61	35	73.2	2	15	194	77	135	MEF2796709.1 CDP-glycerol glycerophosphotransferase family protein [Ruminococcus sp.]	diamond	366	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
30002473	30002473	PRJEB65099_P_NODE_6431_length_244_cov_0.912281_g6326_i0	PRJEB65099	6431	244	0.912281	2.22596564	Bacillota bacterium	1879010	Bacteria	Bacteria	151	1.1499999999999999e-42	NR	MCL6481041.1	1879010	g6326	i0	97.5	0.983606557377049	80	2	98.4	0	242	3	234	313	MCL6481041.1 hypothetical protein [Bacillota bacterium]	diamond	240	151	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
30097001	30097001	PRJEB65099_P_NODE_5232_length_251_cov_0.876404_g5127_i0	PRJEB65099	5232	251	0.876404	2.19977404	Oceanobacillus timonensis	1926285	Bacteria	Bacteria	123	2.4199999999999997e-31	NR	WP_080872688.1	1926285	g5127	i0	71.3	0.956175298804781	80	23	95.6	0	6	245	163	242	WP_080872688.1 four-carbon acid sugar kinase family protein [Oceanobacillus timonensis]	diamond	240	123	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Oceanobacillus	Oceanobacillus timonensis
30785158	30785158	PRJEB65099_P_NODE_4754_length_256_cov_1.704918_g4649_i0	PRJEB65099	4754	256	1.704918	4.36459008	Anaerococcus	165779	Bacteria	Bacteria	102	9.39e-24	NR	WP_101540179.1	165779	g4649	i0	78.9	2.00390625	57	12	66.8	0	172	2	1	57	WP_101540179.1 MULTISPECIES: lipid II:glycine glycyltransferase FemX [Anaerococcus]	diamond	513	103	0.990291262135922	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus
31108014	31108014	PRJEB65099_P_NODE_1315_length_541_cov_4.504274_g1210_i0	PRJEB65099	1315	541	4.504274	24.36812234	Staphylococcus pseudintermedius	283734	Bacteria	Bacteria	127	1.1699999999999999e-34	NR	WP_222114562.1	283734	g1210	i0	100	0.931608133086876	84	0	46.6	0	266	517	1	84	WP_222114562.1 hypothetical protein, partial [Staphylococcus pseudintermedius]	diamond	504	127	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pseudintermedius
31424291	31424291	PRJEB65099_P_NODE_6936_length_242_cov_0.923077_g6831_i0	PRJEB65099	6936	242	0.923077	2.23384634	Bacillus methanolicus	1471	Bacteria	Bacteria	126	1.51e-31	NR	WP_248891496.1	1471	g6831	i0	77.5	0.991735537190083	80	18	99.2	0	2	241	194	273	WP_248891496.1 xanthine dehydrogenase family protein molybdopterin-binding subunit [Bacillus methanolicus]	diamond	240	126	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus methanolicus
32531832	32531832	PRJEB65099_P_NODE_6439_length_244_cov_0.912281_g6334_i0	PRJEB65099	6439	244	0.912281	2.22596564	Faecalicatena contorta	39482	Bacteria	Bacteria	61.6	8.51e-9	NR	WP_109709319.1	39482	g6334	i0	84.8	0.405737704918033	33	5	40.6	0	145	243	1	33	WP_109709319.1 helix-turn-helix transcriptional regulator [Faecalicatena contorta]	diamond	99	61.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Faecalicatena	Faecalicatena contorta

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