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

11 rows where analysis = "diamond", bioproject = "PRJNA706190" 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
27368293	27368293	PRJNA706190_P_NODE_27683_length_193_cov_1.458333_g27547_i0	PRJNA706190	27683	193	1.458333	2.81458269	Streptococcus pneumoniae	1313	Bacteria	Bacteria	104	9.41e-28	NR	MBZ4299771.1	1313	g27547	i0	93.1	0.901554404145078	58	4	90.2	0	20	193	1	58	MBZ4299771.1 hypothetical protein [Streptococcus pneumoniae]	diamond	174	104	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
27368294	27368294	PRJNA706190_P_NODE_68083_length_166_cov_0.888889_g67947_i0	PRJNA706190	68083	166	0.888889	1.47555574	Lactobacillus crispatus	47770	Bacteria	Bacteria	47	3.29e-5	NR	TDN29744.1	47770	g67947	i0	59.5	2.36746987951807	37	15	66.9	0	161	51	26	62	TDN29744.1 hypothetical protein CEE73_10795, partial [Lactobacillus crispatus]	diamond	393	47	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
27810198	27810198	PRJNA706190_P_NODE_29784_length_190_cov_1.900709_g29648_i0	PRJNA706190	29784	190	1.900709	3.6113471	unclassified Lactococcus	2643510	Bacteria	Bacteria	117	2.18e-29	NR	WP_167593765.1	2643510	g29648	i0	95.2	0.978947368421053	62	3	97.9	0	5	190	138	199	WP_167593765.1 MULTISPECIES: FAD-binding oxidoreductase [unclassified Lactococcus]	diamond	186	117	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus
29104682	29104682	PRJNA706190_P_NODE_90588_length_162_cov_0.920354_g90452_i0	PRJNA706190	90588	162	0.920354	1.49097348	Alloiococcus otitis	1652	Bacteria	Bacteria	99.8	2.1699999999999998e-23	NR	WP_003778570.1	1652	g90452	i0	100	0.925925925925926	50	0	92.6	0	2	151	290	339	WP_003778570.1 NAD(P)H-dependent glycerol-3-phosphate dehydrogenase [Alloiococcus otitis]	diamond	150	99.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Alloiococcus	Alloiococcus otitis
29167900	29167900	PRJNA706190_P_NODE_93709_length_160_cov_2.126126_g93573_i0	PRJNA706190	93709	160	2.126126	3.4018016	Virgibacillus salexigens	61016	Bacteria	Bacteria	70.5	6.75e-14	NR	WP_337969740.1	61016	g93573	i0	67.9	0.99375	53	16	99.4	1	2	160	14	65	WP_337969740.1 hypothetical protein [Virgibacillus salexigens]	diamond	159	70.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus salexigens
30494311	30494311	PRJNA706190_P_NODE_78733_length_164_cov_0.904348_g78597_i0	PRJNA706190	78733	164	0.904348	1.48313072	Lactobacillus crispatus	47770	Bacteria	Bacteria	46.6	4.68e-5	NR	TDN07424.1	47770	g78597	i0	48.1	0.98780487804878	54	28	98.8	0	3	164	9	62	TDN07424.1 hypothetical protein CEE84_11690 [Lactobacillus crispatus]	diamond	162	46.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
30525743	30525743	PRJNA706190_P_NODE_41473_length_176_cov_0.818898_g41337_i0	PRJNA706190	41473	176	0.818898	1.44126048	Bacillus cereus	1396	Bacteria	Bacteria	40	0.0406	NR	WP_218011624.1	1396	g41337	i0	53.1	0.545454545454545	32	15	54.5	0	10	105	42	73	WP_218011624.1 hypothetical protein, partial [Bacillus cereus]	diamond	96	40	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
30968316	30968316	PRJNA706190_P_NODE_22914_length_201_cov_2.052632_g22778_i0	PRJNA706190	22914	201	2.052632	4.12579032	Catonella massiliensis	2799636	Bacteria	Bacteria	123	1.44e-33	NR	WP_208429929.1	2799636	g22778	i0	95.2	0.940298507462687	63	3	94	0	12	200	117	179	WP_208429929.1 hypothetical protein [Catonella massiliensis]	diamond	189	123	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Catonella	Catonella massiliensis
31220650	31220650	PRJNA706190_P_NODE_40015_length_177_cov_1.382812_g39879_i0	PRJNA706190	40015	177	1.382812	2.44757724	Negativicoccus succinicivorans	620903	Bacteria	Bacteria	47.4	3.51e-4	NR	WP_273260611.1	620903	g39879	i0	40	0.847457627118644	50	30	84.7	0	3	152	293	342	WP_273260611.1 DEAD/DEAH box helicase [Negativicoccus succinicivorans]	diamond	150	47.4	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Negativicoccus	Negativicoccus succinicivorans
32170161	32170161	PRJNA706190_P_NODE_46598_length_169_cov_2.041667_g46462_i0	PRJNA706190	46598	169	2.041667	3.45041723	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	58.9	3.96e-10	NR	KZU46937.1	1590	g46462	i0	75.7	2.07692307692308	37	9	65.7	0	49	159	1	37	KZU46937.1 hypothetical protein Nizo2766_1002 [Lactiplantibacillus plantarum]	diamond	351	58.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
32581378	32581378	PRJNA706190_P_NODE_66939_length_166_cov_0.888889_g66803_i0	PRJNA706190	66939	166	0.888889	1.47555574	Bacillota bacterium	1879010	Bacteria	Bacteria	42	0.0242	NR	HHY19299.1	1879010	g66803	i0	43.5	0.831325301204819	46	25	81.3	1	24	158	344	389	HHY19299.1 hypothetical protein [Bacillota bacterium]	diamond	138	42	1	Bacteria	Bacillati	Bacillota					Bacillota 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);;