metadata: contig_metadata: 10 rows where bioproject = "PRJEB80557", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJEB80557", 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_class	tax_order	tax_family	tax_genus	tax_species
1413645	1413645	PRJEB80557_S_NODE_15262_length_240_cov_1.261780_g14866_i0	PRJEB80557	15262	240	1.26178	3.028272	Pyrinomonas	1562565	Bacteria	Bacteria	105	1.67e-25	NR	WP_041976015.1	454194	g14866	i0	71	1.725	69	20	86.3	0	1	207	72	140	WP_041976015.1 flagellar motor protein MotB [Pyrinomonas methylaliphatogenes]	diamond	414	105	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonas	Pyrinomonas methylaliphatogenes
2689231	2689231	PRJEB80557_S_NODE_31343_length_173_cov_1.661290_g30947_i0	PRJEB80557	31343	173	1.66129	2.8740317	uncultured Granulicella sp.	1241325	Bacteria	Bacteria	75	3.1e-9	NTclustered	gi\|2836016418\|emb\|OZ196148.1\|	1241325	g30947	i0	88.525	0.352601156069364	61	7	35	0	69	129	261946	261886	MAG: uncultured Granulicella sp. isolate 9057d4d9-b77b-4c6f-b84b-ea5519435b63 genome assembly, chromosome: 1	blastn	61	75	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
7791284	7791284	PRJEB80557_S_NODE_12947_length_258_cov_1.478469_g12551_i0	PRJEB80557	12947	258	1.478469	3.81445002	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	132	2.9300000000000003e-26	NTclustered	gi\|2874253744\|emb\|OY969603.1\|	171953	g12551	i0	82.051	2.39922480620155	156	26	60	2	104	258	913174	913328	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1	blastn	619	132	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12892751	12892751	PRJEB80557_S_NODE_8771_length_306_cov_1.408560_g8375_i0	PRJEB80557	8771	306	1.40856	4.3101936	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	124	1.59e-30	NR	HVH90456.1	3069120	g8375	i0	85.3	0.666666666666667	68	10	66.7	0	305	102	455	522	HVH90456.1 DNA polymerase [Candidatus Acidiferrum sp.]	diamond	204	124	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.
15441645	15441645	PRJEB80557_S_NODE_33673_length_168_cov_0.873950_g33277_i0	PRJEB80557	33673	168	0.87395	1.468236	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	91.7	2.71e-20	NR	MEP7305382.1	1978231	g33277	i0	88.5	2.82142857142857	52	6	92.9	0	156	1	34	85	MEP7305382.1 sodium/proton-translocating pyrophosphatase [Acidobacteriota bacterium]	diamond	474	91.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28234188	28234188	PRJEB80557_S_NODE_4146_length_412_cov_2.845730_g3750_i0	PRJEB80557	4146	412	2.84573	11.7244076	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	76.3	5.65e-14	NR	MBD0371117.1	2283092	g3750	i0	67.2	0.422330097087379	58	18	41.5	1	80	250	151	208	MBD0371117.1 VWA domain-containing protein [Pyrinomonadaceae bacterium]	diamond	174	76.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29087067	29087067	PRJEB80557_S_NODE_25208_length_192_cov_1.083916_g24812_i0	PRJEB80557	25208	192	1.083916	2.08111872	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	90.5	2e-19	NR	HVL69247.1	2910147	g24812	i0	71.4	0.984375	63	18	98.4	0	3	191	235	297	HVL69247.1 VWA domain-containing protein [Vicinamibacterales bacterium]	diamond	189	90.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
29939666	29939666	PRJEB80557_S_NODE_26031_length_189_cov_1.392857_g25635_i0	PRJEB80557	26031	189	1.392857	2.63249973	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	59.3	6.3e-9	NR	HVH91277.1	3069120	g25635	i0	52.8	0.841269841269841	53	25	84.1	0	162	4	33	85	HVH91277.1 hypothetical protein [Candidatus Acidiferrum sp.]	diamond	159	59.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.
30595515	30595515	PRJEB80557_S_NODE_28173_length_182_cov_1.533835_g27777_i0	PRJEB80557	28173	182	1.533835	2.7915797	Bacteria	2	Bacteria	Bacteria	90.1	3.24e-19	NR	MBI2149991.1	1978231	g27777	i0	71.9	3.77472527472527	57	16	94	0	177	7	264	320	MBI2149991.1 methylmalonyl-CoA mutase [Acidobacteriota bacterium]	diamond	687	90.5	0.995580110497237	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31867375	31867375	PRJEB80557_S_NODE_32937_length_169_cov_1.741667_g32541_i0	PRJEB80557	32937	169	1.741667	2.94341723	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	41.6	0.0365	NR	MDT7541686.1	1978231	g32541	i0	45.2	0.745562130177515	42	23	74.6	0	151	26	239	280	MDT7541686.1 hypothetical protein [Acidobacteriota bacterium]	diamond	126	41.6	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);;