metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA1111082" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA1111082" and tax_phylum = "Acidobacteriota"

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
10418692	10418692	PRJNA1111082_P_NODE_11829_length_246_cov_0.901734_g11784_i0	PRJNA1111082	11829	246	0.901734	2.21826564	Chloracidobacterium sp.	2099375	Bacteria	Bacteria	86.3	5.42e-20	NR	MBK7804336.1	2099375	g11784	i0	80	0.609756097560976	50	10	61	0	95	244	1	50	MBK7804336.1 hypothetical protein [Chloracidobacterium sp.]	diamond	150	86.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium sp.
14244243	14244243	PRJNA1111082_P_NODE_5972_length_325_cov_1.841270_g5927_i0	PRJNA1111082	5972	325	1.84127	5.9841275	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	63.5	2.1e-9	NR	HQZ41056.1	2910147	g5927	i0	88.6	0.646153846153846	35	4	32.3	0	107	3	1	35	HQZ41056.1 hypothetical protein [Vicinamibacterales bacterium]	diamond	210	63.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
26783128	26783128	PRJNA1111082_P_NODE_8261_length_282_cov_1.492823_g8216_i0	PRJNA1111082	8261	282	1.492823	4.20976086	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	84.7	3.76e-17	NR	MEO8500478.1	2793154	g8216	i0	46.7	0.978723404255319	92	48	96.8	1	2	274	35	126	MEO8500478.1 hypothetical protein [Vicinamibacteria bacterium]	diamond	276	84.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
27225642	27225642	PRJNA1111082_P_NODE_10103_length_255_cov_4.252747_g10058_i0	PRJNA1111082	10103	255	4.252747	10.84450485	Terracidiphilus sp.	1964191	Bacteria	Bacteria	122	9.84e-32	NR	HUD75876.1	1964191	g10058	i0	57.3	0.964705882352941	82	35	96.5	0	10	255	1	82	HUD75876.1 hypothetical protein [Terracidiphilus sp.]	diamond	246	122	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
27312117	27312117	PRJNA1111082_P_NODE_11003_length_250_cov_0.881356_g10958_i0	PRJNA1111082	11003	250	0.881356	2.20339	Pseudomonadati	3379134	Bacteria	Bacteria	87.4	1.67e-18	NR	HEX5704912.1	2283092	g10958	i0	60.2	1.956	83	29	98.4	3	248	3	9	88	HEX5704912.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	489	87.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27352496	27352496	PRJNA1111082_P_NODE_5003_length_352_cov_3.512545_g4958_i0	PRJNA1111082	5003	352	3.512545	12.3641584	Pyrinomonas methylaliphatogenes	454194	Bacteria	Bacteria	243	8.08e-73	NR	WP_157770649.1	454194	g4958	i0	100	1.99431818181818	117	0	99.7	0	2	352	283	399	WP_157770649.1 DUF5695 domain-containing protein [Pyrinomonas methylaliphatogenes]	diamond	702	243	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonas	Pyrinomonas methylaliphatogenes
27636596	27636596	PRJNA1111082_P_NODE_1144_length_649_cov_4.753472_g1100_i0	PRJNA1111082	1144	649	4.753472	30.85003328	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	44.3	0.0187	NR	MDQ3170314.1	1978231	g1100	i0	40	0.300462249614792	65	36	30	3	74	268	2	63	MDQ3170314.1 hypothetical protein [Acidobacteriota bacterium]	diamond	195	44.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27731489	27731489	PRJNA1111082_P_NODE_7284_length_299_cov_2.013274_g7239_i0	PRJNA1111082	7284	299	2.013274	6.01968926	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	110	1.03e-25	NR	MBX3288375.1	1978231	g7239	i0	50	0.983277591973244	98	49	98.3	0	299	6	365	462	MBX3288375.1 hypothetical protein [Acidobacteriota bacterium]	diamond	294	110	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28109919	28109919	PRJNA1111082_P_NODE_12465_length_243_cov_0.917647_g12420_i0	PRJNA1111082	12465	243	0.917647	2.22988221	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	83.6	1.56e-16	NR	MBS1796597.1	1978231	g12420	i0	50.6	0.975308641975309	79	39	97.5	0	238	2	270	348	MBS1796597.1 WGR domain-containing protein [Acidobacteriota bacterium]	diamond	237	83.6	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28290582	28290582	PRJNA1111082_P_NODE_10986_length_250_cov_0.881356_g10941_i0	PRJNA1111082	10986	250	0.881356	2.20339	Bacteria	2	Bacteria	Bacteria	149	1.04e-39	NR	MBA4123799.1	1978231	g10941	i0	88	2.988	83	10	99.6	0	2	250	836	918	MBA4123799.1 FAD-dependent oxidoreductase [Acidobacteriota bacterium]	diamond	747	150	0.993333333333333	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28457509	28457509	PRJNA1111082_P_NODE_10386_length_253_cov_0.866667_g10341_i0	PRJNA1111082	10386	253	0.866667	2.19266751	Blastocatellia bacterium	2052146	Bacteria	Bacteria	69.7	1.05e-11	NR	HEX8087768.1	2052146	g10341	i0	40.2	0.972332015810277	82	49	97.2	0	8	253	244	325	HEX8087768.1 hypothetical protein [Blastocatellia bacterium]	diamond	246	69.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
28764262	28764262	PRJNA1111082_P_NODE_11387_length_248_cov_0.891429_g11342_i0	PRJNA1111082	11387	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	128	2.16e-33	NR	MDQ3711775.1	1978231	g11342	i0	81.5	8.81854838709677	81	15	98	0	2	244	180	260	MDQ3711775.1 exodeoxyribonuclease VII large subunit [Acidobacteriota bacterium]	diamond	2187	128	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28795741	28795741	PRJNA1111082_P_NODE_4247_length_379_cov_1.797386_g4202_i0	PRJNA1111082	4247	379	1.797386	6.81209294	Pseudomonadati	3379134	Bacteria	Bacteria	42.4	0.0191	NR	MCU1330549.1	2026791	g4202	i0	52.6	0.989445910290237	38	18	30.1	0	50	163	16	53	MCU1330549.1 hypothetical protein [Bryobacterales bacterium]	diamond	375	42.7	0.992974238875878	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
32145484	32145484	PRJNA1111082_P_NODE_10458_length_253_cov_0.866667_g10413_i0	PRJNA1111082	10458	253	0.866667	2.19266751	Acidobacteriota	57723	Bacteria	Bacteria	69.3	1.8e-11	NR	HEV8117519.1	2651171	g10413	i0	53	4.90909090909091	83	33	98.4	1	251	3	297	373	HEV8117519.1 glucosidase [Thermoanaerobaculia bacterium]	diamond	1242	69.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
32597146	32597146	PRJNA1111082_P_NODE_11780_length_246_cov_0.901734_g11735_i0	PRJNA1111082	11780	246	0.901734	2.21826564	Terriglobus roseus	392734	Bacteria	Bacteria	137	6.849999999999999e-38	NR	WP_014785607.1	392734	g11735	i0	81.7	1	82	15	100	0	246	1	116	197	WP_014785607.1 HAD family acid phosphatase [Terriglobus roseus]	diamond	246	137	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus

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