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

11 rows where analysis = "diamond", bioproject = "PRJNA573544" and tax_superkingdom = "Bacteria"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26649758	26649758	PRJNA573544_P_NODE_6061_length_250_cov_0.881356_g6043_i0	PRJNA573544	6061	250	0.881356	2.20339	Tahibacter	1453544	Bacteria	Bacteria	132	1.2699999999999998e-35	NR	HVH33847.1	2056211	g6043	i0	79.5	2.988	83	17	99.6	0	2	250	163	245	HVH33847.1 ABC transporter permease [Tahibacter sp.]	diamond	747	132	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Rhodanobacteraceae	Tahibacter	Tahibacter sp.
26699477	26699477	PRJNA573544_P_NODE_5861_length_251_cov_0.876404_g5843_i0	PRJNA573544	5861	251	0.876404	2.19977404	Pedobacter ureilyticus	1393051	Bacteria	Bacteria	146	5.6599999999999986e-40	NR	WP_138722565.1	1393051	g5843	i0	91.6	0.99203187250996006	83	7	99.2	0	1	249	189	271	WP_138722565.1 tRNA lysidine(34) synthetase TilS [Pedobacter ureilyticus]	diamond	249	146	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter ureilyticus
27661939	27661939	PRJNA573544_P_NODE_6144_length_250_cov_0.881356_g6126_i0	PRJNA573544	6144	250	0.881356	2.20339	Sphingomonadaceae	41297	Bacteria	Bacteria	163	1.58e-44	NR	WP_062126125.1	152682	g6126	i0	100	1.92	80	0	96	0	248	9	782	861	WP_062126125.1 type IV secretion system protein TraC [Sphingomonas melonis]	diamond	480	163	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
27743194	27743194	PRJNA573544_P_NODE_5964_length_250_cov_1.316384_g5946_i0	PRJNA573544	5964	250	1.316384	3.29096	Myxococcales bacterium	2026763	Bacteria	Bacteria	77.4	1.33e-14	NR	MCA9602532.1	2026763	g5946	i0	49.4	1.98	83	39	99.6	1	2	250	2	81	MCA9602532.1 fatty acid desaturase [Myxococcales bacterium]	diamond	495	77.4	1	Bacteria		Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28406008	28406008	PRJNA573544_P_NODE_5406_length_253_cov_0.866667_g5388_i0	PRJNA573544	5406	253	0.866667	2.19266751	Sphingomonas sp. TX	28214	Bacteria	Bacteria	171	5.58e-48	NR	WP_198356560.1	2479205	g5388	i0	100	0.99604743083004	84	0	99.6	0	252	1	81	164	WP_198356560.1 phage terminase large subunit family protein, partial [Sphingomonas sp. TX0522]	diamond	252	171	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. TX0522
28658713	28658713	PRJNA573544_P_NODE_4987_length_260_cov_0.930481_g4969_i0	PRJNA573544	4987	260	0.930481	2.4192506	Clostridia bacterium	2044939	Bacteria	Bacteria	45.1	0.00339	NR	MBQ8149526.1	2044939	g4969	i0	48.7	0.45	39	20	45	0	50	166	80	118	MBQ8149526.1 hypothetical protein [Clostridia bacterium]	diamond	117	45.1	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium
28974441	28974441	PRJNA573544_P_NODE_4708_length_267_cov_1.551546_g4690_i0	PRJNA573544	4708	267	1.551546	4.14262782	Micromonosporaceae bacterium	1873464	Bacteria	Bacteria	44.7	0.0099	NR	HEX6073767.1	1873464	g4690	i0	44.6	0.730337078651685	65	20	71.9	3	217	26	145	194	HEX6073767.1 thiolase family protein [Micromonosporaceae bacterium]	diamond	195	44.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae		Micromonosporaceae bacterium
29164001	29164001	PRJNA573544_P_NODE_7029_length_246_cov_0.901734_g7011_i0	PRJNA573544	7029	246	0.901734	2.21826564	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	87	1.02e-17	NR	HHQ48671.1	1978231	g7011	i0	50	10.2439024390244	84	39	98.8	1	246	4	257	340	HHQ48671.1 peptidase M4 [Acidobacteriota bacterium]	diamond	2520	87	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30237518	30237518	PRJNA573544_P_NODE_5652_length_252_cov_0.871508_g5634_i0	PRJNA573544	5652	252	0.871508	2.19620016	Deinococcus koreensis	2054903	Bacteria	Bacteria	59.7	4.37e-8	NR	WP_133161824.1	2054903	g5634	i0	44.3	0.833333333333333	70	31	73.8	1	232	47	642	711	WP_133161824.1 hypothetical protein [Deinococcus koreensis]	diamond	210	59.7	1	Bacteria		Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus koreensis
31501819	31501819	PRJNA573544_P_NODE_7236_length_245_cov_0.906977_g7218_i0	PRJNA573544	7236	245	0.906977	2.22209365	Sphingomonas	13687	Bacteria	Bacteria	129	1.87e-36	NR	WP_203309122.1	13687	g7218	i0	100	0.808163265306122	66	0	80.8	0	243	46	57	122	WP_203309122.1 MULTISPECIES: hypothetical protein [Sphingomonas]	diamond	198	129	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas
32797422	32797422	PRJNA573544_P_NODE_7020_length_246_cov_0.901734_g7002_i0	PRJNA573544	7020	246	0.901734	2.21826564	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	164	2.0299999999999998e-47	NR	HMY02784.1	2711154	g7002	i0	100	0.98780487804878	81	0	98.8	0	2	244	114	194	HMY02784.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	243	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.

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