metadata: contig_metadata: 8 rows where bioproject = "PRJNA773778", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA773778", tax_kingdom = "Pseudomonadati" 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_species
4579135	4579135	PRJNA773778_S_NODE_23024_length_312_cov_3.418410_g22874_i0	PRJNA773778	23024	312	3.41841	10.6654392	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	337	7.189999999999998e-88	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g22874	i0	93.103	78.2019230769231	232	13	74	3	31	260	4648401	4648631	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	24399	337	1	Bacteria	Pseudomonadati	Acidobacteriota	Acidobacteriota bacterium
19058960	19058960	PRJNA773778_S_NODE_2515_length_691_cov_12.668285_g2374_i0	PRJNA773778	2515	691	12.668285	87.53784935	Bacteria	2	Bacteria	Bacteria	176	6.659999999999999e-52	NR	MBK9705593.1	1978231	g2374	i0	83.5	3.78147612156295	109	18	47.3	0	2	328	85	193	MBK9705593.1 orotate phosphoribosyltransferase [Acidobacteriota bacterium]	diamond	2613	177	0.994350282485876	Bacteria	Pseudomonadati	Acidobacteriota	Acidobacteriota bacterium
23703622	23703622	PRJNA773778_S_NODE_11279_length_411_cov_1.213018_g11129_i0	PRJNA773778	11279	411	1.213018	4.98550398	Pseudomonadati	3379134	Bacteria	Bacteria	132	3.68e-34	NR	MFP5212173.1	1978231	g11129	i0	65.7	2.15328467153285	99	31	70.1	1	3	290	293	391	MFP5212173.1 transketolase C-terminal domain-containing protein [Acidobacteriota bacterium]	diamond	885	132	1	Bacteria	Pseudomonadati	Acidobacteriota	Acidobacteriota bacterium
26999402	26999402	PRJNA773778_S_NODE_23242_length_311_cov_3.558824_g23092_i0	PRJNA773778	23242	311	3.558824	11.06794264	Bacteria	2	Bacteria	Bacteria	58.5	6.37e-8	NR	MEM7249741.1	1978231	g23092	i0	60.5	4.85209003215434	43	17	41.5	0	311	183	136	178	MEM7249741.1 SDR family oxidoreductase [Acidobacteriota bacterium]	diamond	1509	58.9	0.99320882852292	Bacteria	Pseudomonadati	Acidobacteriota	Acidobacteriota bacterium
27432841	27432841	PRJNA773778_S_NODE_28063_length_290_cov_1.953917_g27913_i0	PRJNA773778	28063	290	1.953917	5.6663593	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	166	5.9e-50	NR	MFP5214148.1	1978231	g27913	i0	76	1.97586206896552	96	23	99.3	0	289	2	111	206	MFP5214148.1 thiamine pyrophosphate-dependent enzyme [Acidobacteriota bacterium]	diamond	573	166	1	Bacteria	Pseudomonadati	Acidobacteriota	Acidobacteriota bacterium
29778486	29778486	PRJNA773778_S_NODE_11751_length_404_cov_4.676737_g11601_i0	PRJNA773778	11751	404	4.676737	18.89401748	Bacteria	2	Bacteria	Bacteria	118	6.93e-29	NR	MBK7708421.1	1978231	g11601	i0	93.4	5.88861386138614	61	4	45.3	0	183	1	1	61	MBK7708421.1 cystathionine gamma-synthase [Acidobacteriota bacterium]	diamond	2379	119	0.991596638655462	Bacteria	Pseudomonadati	Acidobacteriota	Acidobacteriota bacterium
30243035	30243035	PRJNA773778_S_NODE_26032_length_299_cov_1.022124_g25882_i0	PRJNA773778	26032	299	1.022124	3.05615076	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	77	5.51e-14	NR	MDI9628134.1	1978231	g25882	i0	50.6	0.852842809364548	85	42	85.3	0	263	9	98	182	MDI9628134.1 histidine kinase [Acidobacteriota bacterium]	diamond	255	77	1	Bacteria	Pseudomonadati	Acidobacteriota	Acidobacteriota bacterium
32551383	32551383	PRJNA773778_S_NODE_24499_length_305_cov_3.112069_g24349_i0	PRJNA773778	24499	305	3.112069	9.49181045	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	68.9	3.85e-11	NR	MCE2559937.1	1978231	g24349	i0	46.3	0.659016393442623	67	34	65.9	1	263	63	99	163	MCE2559937.1 alpha/beta hydrolase [Acidobacteriota bacterium]	diamond	201	68.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Acidobacteriota 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);;