metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA263496" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA263496" 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
2919732	2919732	PRJNA263496_P_NODE_13843_length_210_cov_1.273292_g13590_i0	PRJNA263496	13843	210	1.273292	2.6739132	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	106	1.36e-25	NR	MBQ8928204.1	2485925	g13590	i0	70.6	3.88571428571429	68	20	97.1	0	5	208	191	258	MBQ8928204.1 aspartate--ammonia ligase [Oscillospiraceae bacterium]	diamond	816	106	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
28558492	28558492	PRJNA263496_P_NODE_21107_length_167_cov_0.864407_g20854_i0	PRJNA263496	21107	167	0.864407	1.44355969	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	50.8	1.73e-5	NR	MBP5305397.1	1898203	g20854	i0	57.4	0.844311377245509	47	17	84.4	1	3	143	248	291	MBP5305397.1 ROK family protein [Lachnospiraceae bacterium]	diamond	141	50.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28621609	28621609	PRJNA263496_P_NODE_17487_length_186_cov_1.481752_g17234_i0	PRJNA263496	17487	186	1.481752	2.75605872	Clostridioides difficile	1496	Bacteria	Bacteria	108	1.23e-27	NR	MCJ0138832.1	1496	g17234	i0	84.7	0.951612903225806	59	9	95.2	0	184	8	23	81	MCJ0138832.1 apolipoprotein A1/A4/E family protein [Clostridioides difficile]	diamond	177	108	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
29568632	29568632	PRJNA263496_P_NODE_19070_length_177_cov_1.593750_g18817_i0	PRJNA263496	19070	177	1.59375	2.8209375	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	81.6	1.03e-18	NR	WP_229963743.1	1590	g18817	i0	83	1.52542372881356	47	8	79.7	0	177	37	4	50	WP_229963743.1 hypothetical protein [Lactiplantibacillus plantarum]	diamond	270	81.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
30800600	30800600	PRJNA263496_P_NODE_15194_length_200_cov_1.933775_g14941_i0	PRJNA263496	15194	200	1.933775	3.86755	Lactiplantibacillus sp. E932	2952565	Bacteria	Bacteria	40	0.0266	NR	MCM8651632.1	2952565	g14941	i0	94.4	0.27	18	1	27	0	3	56	30	47	MCM8651632.1 hypothetical protein [Lactiplantibacillus sp. E932]	diamond	54	40	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus sp. E932
31085106	31085106	PRJNA263496_P_NODE_14655_length_204_cov_1.309677_g14402_i0	PRJNA263496	14655	204	1.309677	2.67174108	Clostridia bacterium	2044939	Bacteria	Bacteria	84.7	3.27e-17	NR	MDD3613683.1	2044939	g14402	i0	61.2	2.95588235294118	67	26	98.5	0	202	2	60	126	MDD3613683.1 NADP-dependent phosphogluconate dehydrogenase [Clostridia bacterium]	diamond	603	84.7	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
32399836	32399836	PRJNA263496_P_NODE_13999_length_209_cov_1.156250_g13746_i0	PRJNA263496	13999	209	1.15625	2.4165625	Clostridia	186801	Bacteria	Bacteria	63.2	3.52e-10	NR	MBO5451947.1	1898203	g13746	i0	63.8	2.6555023923445	47	17	67.5	0	143	3	102	148	MBO5451947.1 DJ-1/PfpI family protein [Lachnospiraceae bacterium]	diamond	555	63.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
32540384	32540384	PRJNA263496_P_NODE_24939_length_162_cov_0.902655_g24686_i0	PRJNA263496	24939	162	0.902655	1.4623011	Caldanaerobacter subterraneus	911092	Bacteria	Bacteria	84.3	4.71e-19	NR	WP_170271202.1	911092	g24686	i0	86.4	0.814814814814815	44	6	81.5	0	136	5	1	44	WP_170271202.1 phage tail terminator family protein [Caldanaerobacter subterraneus]	diamond	132	84.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Caldanaerobacter	Caldanaerobacter subterraneus
32620863	32620863	PRJNA263496_P_NODE_11480_length_231_cov_1.675824_g11227_i0	PRJNA263496	11480	231	1.675824	3.87115344	Bacteria	2	Bacteria	Bacteria	80.1	1.16e-15	NR	MBR3893620.1	2044939	g11227	i0	60.9	1.66233766233766	64	25	83.1	0	194	3	23	86	MBR3893620.1 aspartate--ammonia ligase [Clostridia bacterium]	diamond	384	80.1	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
32666144	32666144	PRJNA263496_P_NODE_24200_length_163_cov_0.894737_g23947_i0	PRJNA263496	24200	163	0.894737	1.45842131	Clostridium tetani	1513	Bacteria	Bacteria	55.8	2.82e-7	NR	WP_317818676.1	1513	g23947	i0	49.1	0.975460122699387	53	27	97.5	0	161	3	205	257	WP_317818676.1 ParM/StbA family protein [Clostridium tetani]	diamond	159	55.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium tetani

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