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

11 rows where analysis = "diamond", bioproject = "PRJNA1218816" 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
10537378	10537378	PRJNA1218816_P_NODE_55949_length_249_cov_0.875000_g55516_i0	PRJNA1218816	55949	249	0.875	2.17875	Veillonella sp. VA142	741834	Bacteria	Bacteria	160	2.4099999999999998e-46	NR	WP_126938816.1	741834	g55516	i0	98.8	1.96385542168675	82	1	98.8	0	248	3	214	295	WP_126938816.1 galactose ABC transporter substrate-binding protein [Veillonella sp. VA142]	diamond	489	160	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella sp. VA142
26755999	26755999	PRJNA1218816_P_NODE_56581_length_248_cov_0.880000_g56148_i0	PRJNA1218816	56581	248	0.88	2.1824	Clostridiales bacterium	1898207	Bacteria	Bacteria	159	2.51e-43	NR	MCI6603851.1	1898207	g56148	i0	95.1	0.991935483870968	82	4	99.2	0	247	2	614	695	MCI6603851.1 leucine--tRNA ligase [Clostridiales bacterium]	diamond	246	159	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
27515091	27515091	PRJNA1218816_P_NODE_58343_length_246_cov_0.890173_g57910_i0	PRJNA1218816	58343	246	0.890173	2.18982558	Veillonellaceae bacterium	2049049	Bacteria	Bacteria	147	6.84e-39	NR	NMC35009.1	2049049	g57910	i0	91.4	0.98780487804878	81	7	98.8	0	1	243	604	684	NMC35009.1 fibronectin type III domain-containing protein [Veillonellaceae bacterium]	diamond	243	147	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae		Veillonellaceae bacterium
27609885	27609885	PRJNA1218816_P_NODE_50204_length_263_cov_1.352632_g49771_i0	PRJNA1218816	50204	263	1.352632	3.5574221600000002	Clostridioides difficile	1496	Bacteria	Bacteria	140	8.22e-38	NR	WP_022620693.1	1496	g49771	i0	97.7	0.992395437262357	87	2	99.2	0	263	3	208	294	WP_022620693.1 Orn/DAP/Arg decarboxylase 2 [Clostridioides difficile]	diamond	261	140	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
27723699	27723699	PRJNA1218816_P_NODE_42224_length_295_cov_1.387387_g41791_i0	PRJNA1218816	42224	295	1.387387	4.09279165	Bacteria	2	Bacteria	Bacteria	78.6	1.81e-14	NR	MCA9750439.1	1965302	g41791	i0	44.6	3.78305084745763	92	46	88.5	3	262	2	42	133	MCA9750439.1 GTPase RsgA [Romboutsia sp.]	diamond	1116	78.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia sp.
28039149	28039149	PRJNA1218816_P_NODE_57425_length_247_cov_0.885057_g56992_i0	PRJNA1218816	57425	247	0.885057	2.18609079	Bacillati	1783272	Bacteria	Bacteria	48.1	3.21e-5	NR	MDU1007400.1	1492	g56992	i0	74.1	0.65587044534413	27	7	32.8	0	124	204	29	55	MDU1007400.1 hypothetical protein [Clostridium butyricum]	diamond	162	48.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium butyricum
29693344	29693344	PRJNA1218816_P_NODE_59470_length_245_cov_0.895349_g59037_i0	PRJNA1218816	59470	245	0.895349	2.19360505	Alicyclobacillus sendaiensis	192387	Bacteria	Bacteria	90.1	1.72e-19	NR	WP_304459054.1	192387	g59037	i0	89.1	0.563265306122449	46	5	56.3	0	140	3	94	139	WP_304459054.1 hypothetical protein [Alicyclobacillus sendaiensis]	diamond	138	90.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Alicyclobacillaceae	Alicyclobacillus	Alicyclobacillus sendaiensis
30799264	30799264	PRJNA1218816_P_NODE_57574_length_247_cov_0.885057_g57141_i0	PRJNA1218816	57574	247	0.885057	2.18609079	Bacillota bacterium	1879010	Bacteria	Bacteria	119	1.22e-30	NR	MFO7249095.1	1879010	g57141	i0	65.9	4.97975708502024	82	28	99.6	0	1	246	16	97	MFO7249095.1 alcohol dehydrogenase AdhP [Bacillota bacterium]	diamond	1230	119	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31071088	31071088	PRJNA1218816_P_NODE_61655_length_242_cov_0.911243_g61222_i0	PRJNA1218816	61655	242	0.911243	2.20520806	Caldibacillus	1276290	Bacteria	Bacteria	168	1.28e-46	NR	WP_276643715.1	301148	g61222	i0	98.8	1.98347107438017	80	1	99.2	0	1	240	191	270	WP_276643715.1 glycoside hydrolase family 31 protein [Caldibacillus debilis]	diamond	480	169	0.994082840236686	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Caldibacillus	Caldibacillus debilis
31956335	31956335	PRJNA1218816_P_NODE_52677_length_254_cov_1.883978_g52244_i0	PRJNA1218816	52677	254	1.883978	4.78530412	FCB group	1783270	Bacteria	Bacteria	139	8.55e-37	NR	WP_303447577.1	372463	g52244	i0	75.9	19.3582677165354	83	20	98	0	6	254	291	373	WP_303447577.1 aldehyde dehydrogenase [Oceanobacillus profundus]	diamond	4917	139	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Oceanobacillus	Oceanobacillus profundus
32885176	32885176	PRJNA1218816_P_NODE_50800_length_261_cov_1.287234_g50367_i0	PRJNA1218816	50800	261	1.287234	3.35968074	Clostridiales bacterium	1898207	Bacteria	Bacteria	83.6	9.94e-17	NR	MCH5163652.1	1898207	g50367	i0	59.5	0.850574712643678	74	26	83.9	3	219	1	126	196	MCH5163652.1 hypothetical protein [Clostridiales bacterium]	diamond	222	83.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium

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