metadata: contig_metadata: 10 rows where bioproject = "PRJNA565778", tax_phylum = "Acidobacteriota" and tax

10 rows where bioproject = "PRJNA565778", tax_phylum = "Acidobacteriota" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1135775	1135775	PRJNA565778_S_NODE_21481_length_239_cov_3.455446_g21185_i0	PRJNA565778	21481	239	3.455446	8.25851594	Vicinamibacteraceae bacterium	2590576	Bacteria	Bacteria	96.3	8.76e-23	NR	MEO5824180.1	2590576	g21185	i0	80.7	0.715481171548117	57	11	71.5	0	35	205	113	169	MEO5824180.1 16S rRNA (guanine(966)-N(2))-methyltransferase RsmD [Vicinamibacteraceae bacterium]	diamond	171	96.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae		Vicinamibacteraceae bacterium
8211467	8211467	PRJNA565778_S_NODE_42207_length_154_cov_1.521368_g41911_i0	PRJNA565778	42207	154	1.521368	2.34290672	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	191	2.57e-44	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g41911	i0	94.355	163.948051948052	124	7	81	0	25	148	1822665	1822542	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	25248	191	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
12614708	12614708	PRJNA565778_S_NODE_1010_length_839_cov_46.901496_g936_i0	PRJNA565778	1010	839	46.901496	393.50355144	Acidobacteriota	57723	Bacteria	Bacteria	334	3.419999999999999e-105	NR	MCS6807119.1	2052146	g936	i0	62.1	2.88557806912992	269	99	95.5	2	38	838	34	301	MCS6807119.1 SufD family Fe-S cluster assembly protein [Blastocatellia bacterium]	diamond	2421	336	0.994047619047619	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
15860711	15860711	PRJNA565778_S_NODE_12213_length_313_cov_118.742754_g11917_i0	PRJNA565778	12213	313	118.742754	371.66482002	Bacteria	2	Bacteria	Bacteria	153	9.279999999999998e-42	NR	MBW8825661.1	1978231	g11917	i0	82.6	23.8562300319489	92	16	88.2	0	308	33	300	391	MBW8825661.1 NADH-quinone oxidoreductase subunit M [Acidobacteriota bacterium]	diamond	7467	153	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
15861202	15861202	PRJNA565778_S_NODE_9873_length_345_cov_101.883117_g9577_i0	PRJNA565778	9873	345	101.883117	351.49675365	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	366	1.0299999999999996e-96	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g9577	i0	89.347	133.240579710145	291	31	84	0	38	328	3298163	3298453	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	45968	366	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26762942	26762942	PRJNA565778_S_NODE_1441_length_743_cov_7.101983_g1339_i0	PRJNA565778	1441	743	7.101983	52.76773369	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	119	3.86e-29	NR	HEX8847750.1	2283092	g1339	i0	43.4	1.01345895020188	122	69	49.3	0	684	319	83	204	HEX8847750.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	753	119	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27016127	27016127	PRJNA565778_S_NODE_28922_length_204_cov_149.586826_g28626_i0	PRJNA565778	28922	204	149.586826	305.15712504	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	80.9	3.83e-16	NR	MBA4121894.1	1978231	g28626	i0	86	1.98529411764706	43	6	63.2	0	160	32	218	260	MBA4121894.1 ABC transporter ATP-binding protein [Acidobacteriota bacterium]	diamond	405	80.9	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27553201	27553201	PRJNA565778_S_NODE_5724_length_437_cov_68.817500_g5468_i0	PRJNA565778	5724	437	68.8175	300.732475	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	117	8.53e-29	NR	HEV3059680.1	2910147	g5468	i0	53.3	1.51716247139588	120	53	82.4	1	40	399	3	119	HEV3059680.1 FAD-dependent thymidylate synthase [Vicinamibacterales bacterium]	diamond	663	117	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
28640733	28640733	PRJNA565778_S_NODE_11287_length_325_cov_6.767361_g10991_i0	PRJNA565778	11287	325	6.767361	21.99392325	Pseudomonadati	3379134	Bacteria	Bacteria	53.9	6.27e-6	NR	WP_243295907.1	2922723	g10991	i0	35.3	2.16	68	44	62.8	0	258	55	10	77	WP_243295907.1 hypothetical protein [Geothrix mesophila]	diamond	702	54.3	0.992633517495396	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix mesophila
32070994	32070994	PRJNA565778_S_NODE_32038_length_193_cov_95.371795_g31742_i0	PRJNA565778	32038	193	95.371795	184.06756435	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	47.8	3.35e-4	NR	HEY8562411.1	2283092	g31742	i0	66.7	1.11917098445596	36	12	56	0	145	38	1	36	HEY8562411.1 glycoside hydrolase family 2 protein [Pyrinomonadaceae bacterium]	diamond	216	47.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae 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);;