metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJEB39269" and tax

12 rows where analysis = "diamond", bioproject = "PRJEB39269" 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
1331385	1331385	PRJEB39269_P_NODE_77382_length_160_cov_3.239669_g76977_i0	PRJEB39269	77382	160	3.239669	5.1834704	uncultured Subdoligranulum sp.	512298	Bacteria	Bacteria	58.9	2.23e-8	NR	WP_295473178.1	512298	g76977	i0	100	0.4875	26	0	48.8	0	80	3	291	316	WP_295473178.1 glycosyltransferase family 4 protein [uncultured Subdoligranulum sp.]	diamond	78	58.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Subdoligranulum	uncultured Subdoligranulum sp.
27728732	27728732	PRJEB39269_P_NODE_81784_length_157_cov_2.898305_g81379_i0	PRJEB39269	81784	157	2.898305	4.55033885	Liquorilactobacillus nagelii	82688	Bacteria	Bacteria	47	2.24e-5	NR	WP_415609888.1	82688	g81379	i0	61.4	1.68152866242038	44	16	84.1	1	9	140	6	48	WP_415609888.1 Ltp family lipoprotein, partial [Liquorilactobacillus nagelii]	diamond	264	47	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Liquorilactobacillus	Liquorilactobacillus nagelii
28006163	28006163	PRJEB39269_P_NODE_80325_length_158_cov_3.873950_g79920_i0	PRJEB39269	80325	158	3.87395	6.120841	Bacillaceae	186817	Bacteria	Bacteria	44.7	0.00241	NR	WP_173058779.1	2738405	g79920	i0	65.5	2.63924050632911	29	10	55.1	0	156	70	278	306	WP_173058779.1 DHH family phosphoesterase [Neobacillus endophyticus]	diamond	417	44.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus endophyticus
28321629	28321629	PRJEB39269_P_NODE_59246_length_179_cov_1.750000_g58841_i0	PRJEB39269	59246	179	1.75	3.1325	Bacteria	2	Bacteria	Bacteria	96.7	1.32e-21	NR	WP_036720653.1	1236974	g58841	i0	69.5	15.6033519553073	59	18	98.9	0	177	1	21	79	WP_036720653.1 amino acid adenylation domain-containing protein, partial [Paenibacillus sp. JCM 10914]	diamond	2793	96.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. JCM 10914
28328116	28328116	PRJEB39269_P_NODE_10466_length_431_cov_2.701531_g10061_i0	PRJEB39269	10466	431	2.701531	11.64359861	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	43.9	0.0292	NR	MCR5720393.1	1898203	g10061	i0	42.9	0.292343387470998	42	22	29.2	1	55	180	60	99	MCR5720393.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	126	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
29142871	29142871	PRJEB39269_P_NODE_91609_length_150_cov_1.234234_g91204_i0	PRJEB39269	91609	150	1.234234	1.851351	Bacteria	2	Bacteria	Bacteria	95.5	7.14e-24	NR	WP_158084704.1	1313	g91204	i0	100	2.94	49	0	98	0	2	148	27	75	WP_158084704.1 hypothetical protein, partial [Streptococcus pneumoniae]	diamond	441	95.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
29426579	29426579	PRJEB39269_P_NODE_35669_length_231_cov_1.494792_g35264_i0	PRJEB39269	35669	231	1.494792	3.45296952	Bacteria	2	Bacteria	Bacteria	100	8.65e-23	NR	MBU4439869.1	1879010	g35264	i0	73.4	2.49350649350649	64	17	83.1	0	229	38	11	74	MBU4439869.1 DUF1801 domain-containing protein [Bacillota bacterium]	diamond	576	100	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
29938675	29938675	PRJEB39269_P_NODE_25871_length_274_cov_2.940426_g25466_i0	PRJEB39269	25871	274	2.940426	8.05676724	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	43.5	0.0104	NR	MCR5720393.1	1898203	g25466	i0	40.5	0.45985401459854	42	23	46	1	147	272	60	99	MCR5720393.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	126	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30475805	30475805	PRJEB39269_P_NODE_66513_length_170_cov_3.442748_g66108_i0	PRJEB39269	66513	170	3.442748	5.8526716	Weissella cibaria	137591	Bacteria	Bacteria	47.8	6.09e-5	NR	NKO01094.1	137591	g66108	i0	83.3	0.423529411764706	24	4	42.4	0	169	98	82	105	NKO01094.1 hypothetical protein [Weissella cibaria]	diamond	72	47.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella cibaria
31012793	31012793	PRJEB39269_P_NODE_67115_length_170_cov_2.748092_g66710_i0	PRJEB39269	67115	170	2.748092	4.6717564	Clostridioides difficile	1496	Bacteria	Bacteria	57.8	3.9e-9	NR	WP_198102384.1	1496	g66710	i0	100	0.917647058823529	26	0	45.9	0	3	80	65	90	WP_198102384.1 membrane protein insertase YidC, partial [Clostridioides difficile]	diamond	156	57.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
31195425	31195425	PRJEB39269_P_NODE_89975_length_151_cov_1.464286_g89570_i0	PRJEB39269	89975	151	1.464286	2.21107186	root	1	Root_unresolved	Root_unresolved	98.6	2e-25	NR	MDN8996941.1	1280	g89570	i0	96	4.96688741721854	50	2	99.3	0	2	151	8	57	MDN8996941.1 NADH-quinone oxidoreductase subunit H [Staphylococcus aureus]	diamond	750	98.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
32814576	32814576	PRJEB39269_P_NODE_78540_length_159_cov_4.566667_g78135_i0	PRJEB39269	78540	159	4.566667	7.26100053	Enterococcus hermanniensis	249189	Bacteria	Bacteria	57	4.6e-8	NR	WP_071856666.1	249189	g78135	i0	96.3	0.509433962264151	27	1	50.9	0	1	81	38	64	WP_071856666.1 alkaline shock response membrane anchor protein AmaP [Enterococcus hermanniensis]	diamond	81	57	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus hermanniensis

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