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

10 rows where bioproject = "PRJNA352850", 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_species
9323456	9323456	PRJNA352850_P_NODE_34728_length_441_cov_2.112245_g31897_i0	PRJNA352850	34728	441	2.112245	9.31500045	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	497	4.56e-136	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g31897	i0	88.152	68.9274376417234	422	45	95	4	1	419	4840368	4840787	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	30397	497	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
9324363	9324363	PRJNA352850_P_NODE_62668_length_290_cov_3.419087_g59835_i0	PRJNA352850	62668	290	3.419087	9.9153523	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	252	2.47e-62	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g59835	i0	83.212	90.4793103448276	274	46	94	0	17	290	277349	277076	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	26239	252	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
22073037	22073037	PRJNA352850_P_NODE_69838_length_269_cov_0.927273_g67005_i0	PRJNA352850	69838	269	0.927273	2.49436437	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	170	5.129999999999999e-48	NR	HEX2253350.1	2651171	g67005	i0	96.5	0.95910780669145	86	3	95.9	0	259	2	361	446	HEX2253350.1 peptide chain release factor 3 [Thermoanaerobaculia bacterium]	diamond	258	170	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia			Thermoanaerobaculia bacterium
26853540	26853540	PRJNA352850_P_NODE_66901_length_277_cov_1.842105_g64068_i0	PRJNA352850	66901	277	1.842105	5.10263085	Blastocatellia bacterium	2052146	Bacteria	Bacteria	129	1.45e-33	NR	MDX6712966.1	2052146	g64068	i0	63.7	0.985559566787004	91	33	98.6	0	5	277	220	310	MDX6712966.1 colanic acid/amylovoran biosynthesis protein [Blastocatellia bacterium]	diamond	273	129	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia			Blastocatellia bacterium
29159222	29159222	PRJNA352850_P_NODE_64629_length_284_cov_2.204255_g61796_i0	PRJNA352850	64629	284	2.204255	6.2600842	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	77	2.05e-15	NR	HXG90579.1	2910147	g61796	i0	80	0.580985915492958	55	11	58.1	0	118	282	1	55	HXG90579.1 hypothetical protein [Vicinamibacterales bacterium]	diamond	165	77	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales		Vicinamibacterales bacterium
29365698	29365698	PRJNA352850_P_NODE_47589_length_353_cov_2.986842_g44756_i0	PRJNA352850	47589	353	2.986842	10.54355226	Bacteria	2	Bacteria	Bacteria	53.5	1.99e-5	NR	MEM9556290.1	1978231	g44756	i0	43.5	2.32011331444759	69	39	58.6	0	130	336	100	168	MEM9556290.1 hypothetical protein [Acidobacteriota bacterium]	diamond	819	53.5	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
29474491	29474491	PRJNA352850_P_NODE_65350_length_282_cov_1.712446_g62517_i0	PRJNA352850	65350	282	1.712446	4.82909772	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	65.5	1.99e-11	NR	HXG87994.1	2910147	g62517	i0	50	0.638297872340426	60	28	61.7	1	174	1	1	60	HXG87994.1 hypothetical protein [Vicinamibacterales bacterium]	diamond	180	65.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales		Vicinamibacterales bacterium
30296451	30296451	PRJNA352850_P_NODE_63832_length_287_cov_1.310924_g60999_i0	PRJNA352850	63832	287	1.310924	3.76235188	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	41.6	0.0284	NR	MEK6303641.1	1978231	g60999	i0	40.6	0.668989547038328	64	36	65.9	2	247	59	20	82	MEK6303641.1 hypothetical protein [Acidobacteriota bacterium]	diamond	192	41.6	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
30706639	30706639	PRJNA352850_P_NODE_24314_length_565_cov_3.967054_g21500_i0	PRJNA352850	24314	565	3.967054	22.4138551	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	173	1.86e-51	NR	HYO81400.1	2212468	g21500	i0	60.1	0.838938053097345	158	61	82.8	2	470	3	9	166	HYO81400.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	474	173	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae bacterium
32066240	32066240	PRJNA352850_P_NODE_28738_length_503_cov_3.317181_g25912_i0	PRJNA352850	28738	503	3.317181	16.68542043	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	122	8.05e-32	NR	MEW6736723.1	1978231	g25912	i0	40.5	0.94234592445328	158	77	94.2	4	474	1	14	154	MEW6736723.1 aspartyl/asparaginyl beta-hydroxylase domain-containing protein [Acidobacteriota bacterium]	diamond	474	122	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);;