metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1005695" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1005695" 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
153690	153690	PRJNA1005695_P_NODE_6921_length_596_cov_3.378585_g6090_i0	PRJNA1005695	6921	596	3.378585	20.1363666	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	752	0	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g6090	i0	91.32	102.578859060403	553	45	93	3	45	596	634952	635502	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	61137	752	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
1428261	1428261	PRJNA1005695_P_NODE_27562_length_285_cov_1.250000_g26710_i0	PRJNA1005695	27562	285	1.25	3.5625	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g26710	i0	100	0.0982456140350877	28	0	10	0	180	207	5483412	5483439	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2703628	2703628	PRJNA1005695_P_NODE_15583_length_385_cov_1.355769_g14731_i0	PRJNA1005695	15583	385	1.355769	5.21971065	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	534	2.99e-147	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g14731	i0	91.688	553.787012987013	385	32	100	0	1	385	4648950	4648566	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	213208	534	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
3979874	3979874	PRJNA1005695_P_NODE_22264_length_318_cov_1.934694_g21412_i0	PRJNA1005695	22264	318	1.934694	6.15232692	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	394	4.3e-105	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g21412	i0	89.028	126.455974842767	319	33	100	2	1	318	4232009	4231692	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	40213	394	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3980111	3980111	PRJNA1005695_P_NODE_8584_length_534_cov_1.171367_g7738_i0	PRJNA1005695	8584	534	1.171367	6.25509978	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	752	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g7738	i0	92.037	142.104868913858	540	35	100	6	1	534	3299732	3299195	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	75884	752	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
5256417	5256417	PRJNA1005695_P_NODE_24285_length_304_cov_7.194805_g23433_i0	PRJNA1005695	24285	304	7.194805	21.8722072	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	257	5.59e-64	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g23433	i0	87.5	187.131578947368	224	26	74	2	5	228	1689585	1689364	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	56888	257	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7806141	7806141	PRJNA1005695_P_NODE_35367_length_251_cov_1.988764_g34515_i0	PRJNA1005695	35367	251	1.988764	4.99179764	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	375	1.1899999999999998e-99	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g34515	i0	93.676	114.733067729084	253	12	100	3	1	251	285268	285018	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	28798	375	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
7806192	7806192	PRJNA1005695_P_NODE_39907_length_242_cov_1.526627_g39055_i0	PRJNA1005695	39907	242	1.526627	3.69443734	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	169	2.07e-37	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g39055	i0	81.132	0.87603305785124	212	38	87	2	32	242	4108587	4108797	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	212	169	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
10356745	10356745	PRJNA1005695_P_NODE_37049_length_248_cov_0.891429_g36197_i0	PRJNA1005695	37049	248	0.891429	2.21074392	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	226	1.2499999999999999e-54	NTclustered	gi\|112980870\|gb\|DQ829674.1\|	171953	g36197	i0	83.065	131.084677419355	248	42	100	0	1	248	319	566	Uncultured Acidobacteria bacterium clone DON24 23S ribosomal RNA gene, partial sequence	blastn	32509	226	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13754624	13754624	PRJNA1005695_P_NODE_8031_length_552_cov_3.736952_g7193_i0	PRJNA1005695	8031	552	3.736952	20.62797504	Chloracidobacterium	458032	Bacteria	Bacteria	665	0	NTclustered	gi\|470487921\|ref\|NR_076842.1\|	458033	g7193	i0	88.73	94.8405797101449	559	43	100	14	1	552	369	914	Chloracidobacterium thermophilum strain B 23S ribosomal RNA, complete sequence	blastn	52352	665	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium thermophilum
14182199	14182199	PRJNA1005695_P_NODE_27752_length_284_cov_1.165877_g26900_i0	PRJNA1005695	27752	284	1.165877	3.31109068	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	291	5.1000000000000005e-74	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g26900	i0	90.222	130.669014084507	225	18	79	3	60	284	634682	634902	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	37110	291	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
15456172	15456172	PRJNA1005695_P_NODE_28993_length_277_cov_3.200980_g28141_i0	PRJNA1005695	28993	277	3.20098	8.8667146	Paludibaculum fermentans	1473598	Bacteria	Bacteria	324	4.89e-84	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g28141	i0	88.087	203.512635379061	277	28	100	3	1	277	4784548	4784819	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	56373	324	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
16730287	16730287	PRJNA1005695_P_NODE_10574_length_477_cov_2.722772_g9722_i0	PRJNA1005695	10574	477	2.722772	12.98762244	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g9722	i0	100	0.117400419287212	28	0	6	0	171	198	1355450	1355423	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
16730346	16730346	PRJNA1005695_P_NODE_17894_length_357_cov_2.577465_g17042_i0	PRJNA1005695	17894	357	2.577465	9.20155005	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	627	4.4199999999999986e-175	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g17042	i0	98.319	129.857142857143	357	6	100	0	1	357	633728	633372	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	46359	627	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
20554661	20554661	PRJNA1005695_P_NODE_23277_length_311_cov_3.500000_g22425_i0	PRJNA1005695	23277	311	3.5	10.885	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	575	1.3899999999999995e-159	NTclustered	gi\|157142413\|gb\|EU122684.1\|	171953	g22425	i0	100	99.7845659163987	311	0	100	0	1	311	218	528	Uncultured Acidobacteria bacterium clone KL2-087 16S ribosomal RNA gene, partial sequence	blastn	31033	575	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21830368	21830368	PRJNA1005695_P_NODE_34898_length_252_cov_2.240223_g34046_i0	PRJNA1005695	34898	252	2.240223	5.64536196	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	444	3.2299999999999996e-120	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g34046	i0	98.413	125.416666666667	252	4	100	0	1	252	2908054	2907803	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	31605	444	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21830379	21830379	PRJNA1005695_P_NODE_35958_length_250_cov_1.440678_g35106_i0	PRJNA1005695	35958	250	1.440678	3.601695	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	309	1.22e-79	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g35106	i0	90.041	101.488	241	20	96	4	1	239	285729	285967	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	25372	309	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
23105864	23105864	PRJNA1005695_P_NODE_39299_length_243_cov_2.294118_g38447_i0	PRJNA1005695	39299	243	2.294118	5.57470674	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	346	8.97e-91	NTclustered	gi\|2874253750\|emb\|OY969625.1\|	194844	g38447	i0	92.857	111.448559670782	238	17	98	0	1	238	2558	2321	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1	blastn	27082	346	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae 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);;