metadata: contig_metadata: 12 rows where bioproject = "PRJEB3181", tax_phylum = "Acidobacteriota" and tax

12 rows where bioproject = "PRJEB3181", 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
56104	56104	PRJEB3181_S_NODE_16701_length_159_cov_1.612903_g16408_i0	PRJEB3181	16701	159	1.612903	2.56451577	Terriglobia bacterium	2081523	Bacteria	Bacteria	158	2.71e-34	NTclustered	gi\|2621703257\|emb\|OY762429.1\|	2081523	g16408	i0	90.164	218.666666666667	122	10	76	2	25	145	2748848	2748968	MAG: Terriglobia bacterium isolate aa40cff0-ace7-4b53-8087-0ef5d3f4acaf genome assembly, chromosome: 1	blastn	34768	158	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
12809661	12809661	PRJEB3181_S_NODE_3851_length_297_cov_510.877863_g3558_i0	PRJEB3181	3851	297	510.877863	1517.30725311	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	63.9	2.09e-9	NR	MDR3737318.1	2052142	g3558	i0	49.3	0.676767676767677	67	33	66.7	1	297	100	241	307	MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	201	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
16632976	16632976	PRJEB3181_S_NODE_2634_length_339_cov_12.680921_g2341_i0	PRJEB3181	2634	339	12.680921	42.98832219	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	396	1.28e-105	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g2341	i0	89.711	85.9793510324484	311	31	91	1	30	339	317553	317243	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	29147	396	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
17907546	17907546	PRJEB3181_P_NODE_18135_length_194_cov_6.018405_g17871_i0	PRJEB3181	18135	194	6.018405	11.6757057	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	185	1.5799999999999994e-42	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g17871	i0	84.211	99.5618556701031	209	14	99	11	3	194	716012	716218	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	19315	185	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20456868	20456868	PRJEB3181_S_NODE_17817_length_154_cov_1.537815_g17524_i0	PRJEB3181	17817	154	1.537815	2.3682351	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	82.4	1.61e-11	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g17524	i0	87.5	1.5	72	7	47	2	43	114	803810	803879	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	231	82.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
27001438	27001438	PRJEB3181_P_NODE_6042_length_335_cov_1.986842_g5785_i0	PRJEB3181	6042	335	1.986842	6.6559207	Blastocatellia bacterium	2052146	Bacteria	Bacteria	92.4	8.11e-20	NR	HBB95416.1	2052146	g5785	i0	45.7	3.32238805970149	92	48	82.4	1	4	279	216	305	HBB95416.1 pirin family protein [Blastocatellia bacterium]	diamond	1113	92.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
27444454	27444454	PRJEB3181_P_NODE_6083_length_334_cov_4.264026_g5826_i0	PRJEB3181	6083	334	4.264026	14.24184684	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	115	1.72e-29	NR	HSS78324.1	2651171	g5826	i0	53.5	2.64071856287425	99	43	86.2	1	331	44	86	184	HSS78324.1 putative PEP-binding protein [Thermoanaerobaculia bacterium]	diamond	882	115	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
28391330	28391330	PRJEB3181_P_NODE_4286_length_381_cov_3.171429_g4039_i0	PRJEB3181	4286	381	3.171429	12.08314449	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	84.3	2.04e-16	NR	MDR3737318.1	2052142	g4039	i0	45.8	0.84251968503937	107	51	80.3	3	378	73	203	307	MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	321	84.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
29086146	29086146	PRJEB3181_P_NODE_23548_length_167_cov_1.500000_g23283_i0	PRJEB3181	23548	167	1.5	2.505	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	86.7	3.14e-20	NR	MBK9241680.1	1978231	g23283	i0	76.4	0.988023952095808	55	13	98.8	0	167	3	1	55	MBK9241680.1 uL14 family ribosomal protein [Acidobacteriota bacterium]	diamond	165	86.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30949714	30949714	PRJEB3181_P_NODE_10574_length_261_cov_3.686957_g10310_i0	PRJEB3181	10574	261	3.686957	9.62295777	Terriglobales bacterium	2282142	Bacteria	Bacteria	51.6	2.09e-5	NR	HME33021.1	2282142	g10310	i0	37.3	5.49425287356322	67	42	77	0	251	51	124	190	HME33021.1 hypothetical protein [Terriglobales bacterium]	diamond	1434	51.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
31138809	31138809	PRJEB3181_P_NODE_14695_length_220_cov_2.132275_g14431_i0	PRJEB3181	14695	220	2.132275	4.691005	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	79.7	2.58e-15	NR	MCE2513957.1	1978231	g14431	i0	60.9	1.70454545454545	64	25	87.3	0	220	29	465	528	MCE2513957.1 chaperonin GroEL [Acidobacteriota bacterium]	diamond	375	79.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31448906	31448906	PRJEB3181_P_NODE_24716_length_162_cov_2.381679_g24451_i0	PRJEB3181	24716	162	2.381679	3.85831998	root	1	Root_unresolved	Root_unresolved	53.9	5.89e-7	NR	MBI1762299.1	1978231	g24451	i0	64.7	2.38888888888889	34	12	63	0	160	59	144	177	MBI1762299.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Acidobacteriota bacterium]	diamond	387	53.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);;