metadata: contig_metadata: 14 rows where bioproject = "PRJNA599208", tax_phylum = "Acidobacteriota" and tax

14 rows where bioproject = "PRJNA599208", 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
2416740	2416740	PRJNA599208_P_NODE_10542_length_208_cov_1.415205_g10346_i0	PRJNA599208	10542	208	1.415205	2.9436264	Bacteria	2	Bacteria	Bacteria	93.5	1.07e-14	NTclustered	gi\|76574296\|gb\|DQ139444.1\|	171953	g10346	i0	82.857	3.49038461538462	105	16	50	2	40	144	1509	1407	Uncultured Acidobacteria bacterium clone CAL5 23S ribosomal RNA gene, partial sequence	blastn	726	93.5	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3692994	3692994	PRJNA599208_P_NODE_923_length_1049_cov_18.183794_g834_i0	PRJNA599208	923	1049	18.183794	190.74799906	Bacteria	2	Bacteria	Bacteria	1022	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g834	i0	86.947	168.183031458532	927	99	88	21	132	1049	3299573	3298660	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	176424	1022	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
8225401	8225401	PRJNA599208_P_NODE_2227_length_606_cov_24.249561_g2054_i0	PRJNA599208	2227	606	24.249561	146.95233966	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	710	0	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g2054	i0	87.805	109.155115511551	615	63	100	8	1	606	1821537	1822148	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	66148	710	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
9500646	9500646	PRJNA599208_P_NODE_13988_length_169_cov_2.469697_g13792_i0	PRJNA599208	13988	169	2.469697	4.17378793	uncultured Holophaga sp.	188475	Bacteria	Bacteria	228	2.179999999999999e-55	NTclustered	gi\|2621785467\|emb\|OY781925.1\|	188475	g13792	i0	91.124	191.337278106509	169	13	99	2	2	169	1837173	1837340	MAG: uncultured Holophaga sp. isolate 48fd71e5-2ffc-43bf-b6f5-ca4e00a42c30 genome assembly, chromosome: 1	blastn	32336	228	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
10070106	10070106	PRJNA599208_P_NODE_7428_length_270_cov_3.098712_g7232_i0	PRJNA599208	7428	270	3.098712	8.3665224	Chloracidobacterium	458032	Bacteria	Bacteria	143	1.43e-29	NTclustered	gi\|470487921\|ref\|NR_076842.1\|	458033	g7232	i0	82.635	8.85925925925926	167	23	61	6	1	164	500	337	Chloracidobacterium thermophilum strain B 23S ribosomal RNA, complete sequence	blastn	2392	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium thermophilum
10776483	10776483	PRJNA599208_P_NODE_14029_length_169_cov_1.477273_g13833_i0	PRJNA599208	14029	169	1.477273	2.49659137	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	302	1.27e-77	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g13833	i0	98.817	66.7514792899408	169	2	100	0	1	169	187	19	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	11281	302	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12051465	12051465	PRJNA599208_P_NODE_7270_length_274_cov_4.308017_g7074_i0	PRJNA599208	7270	274	4.308017	11.80396658	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	355	1.7099999999999997e-93	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g7074	i0	90.706	146.284671532847	269	22	98	3	1	269	3556711	3556446	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	40082	355	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
15874943	15874943	PRJNA599208_P_NODE_14533_length_165_cov_2.023438_g14337_i0	PRJNA599208	14533	165	2.023438	3.3386727	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	289	9.66e-74	NTclustered	gi\|317120511\|gb\|HQ010189.1\|	171953	g14337	i0	99.371	97.8545454545455	159	1	96	0	7	165	163	5	Uncultured Acidobacteria bacterium clone Amr1_A2 16S ribosomal RNA gene, partial sequence	blastn	16146	289	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16444307	16444307	PRJNA599208_P_NODE_8233_length_250_cov_2.549296_g8037_i0	PRJNA599208	8233	250	2.549296	6.37324	Bacteria	2	Bacteria	Bacteria	370	5.499999999999999e-98	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g8037	i0	93.333	98.308	255	10	100	4	1	250	2908356	2908104	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	24577	370	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17149919	17149919	PRJNA599208_P_NODE_7434_length_270_cov_2.429185_g7238_i0	PRJNA599208	7434	270	2.429185	6.5587995	Acidisarcina polymorpha	2211140	Bacteria	Bacteria	460	3.4699999999999996e-125	NTclustered	gi\|1431854037\|gb\|CP030840.1\|	2211140	g7238	i0	97.407	104.559259259259	270	7	100	0	1	270	1122636	1122367	Acidisarcina polymorpha strain SBC82 chromosome, complete genome	blastn	28231	460	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidisarcina	Acidisarcina polymorpha
17719326	17719326	PRJNA599208_P_NODE_3314_length_475_cov_3.420091_g3120_i0	PRJNA599208	3314	475	3.420091	16.24543225	Bacteria	2	Bacteria	Bacteria	472	2.99e-128	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g3120	i0	85.408	301.616842105263	466	54	97	8	16	475	4232759	4233216	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	143268	472	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20267913	20267913	PRJNA599208_P_NODE_16776_length_150_cov_1.353982_g16580_i0	PRJNA599208	16776	150	1.353982	2.030973	Bacteria	2	Bacteria	Bacteria	243	6.75e-60	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g16580	i0	95.973	241.813333333333	149	6	99	0	2	150	2285200	2285052	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	36272	244	0.995901639344262	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22249318	22249318	PRJNA599208_P_NODE_12378_length_184_cov_2.503401_g12182_i0	PRJNA599208	12378	184	2.503401	4.60625784	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	291	3.05e-74	NTclustered	gi\|76574291\|gb\|DQ139439.1\|	171953	g12182	i0	95.58	134.755434782609	181	8	98	0	2	182	1154	1334	Uncultured Acidobacteria bacterium clone CAL9 23S ribosomal RNA gene, partial sequence	blastn	24795	291	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
28311700	28311700	PRJNA599208_P_NODE_9266_length_229_cov_1.364583_g9070_i0	PRJNA599208	9266	229	1.364583	3.12489507	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	120	2.0299999999999997e-31	NR	MET0168239.1	2910147	g9070	i0	65.3	2.94759825327511	75	26	98.3	0	3	227	202	276	MET0168239.1 LysR family transcriptional regulator [Vicinamibacterales bacterium]	diamond	675	120	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales 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);;