metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA564013" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA564013" 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
546889	546889	PRJNA564013_P_NODE_12341_length_1005_cov_7.676907_g10519_i0	PRJNA564013	12341	1005	7.676907	77.15291535	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	183	3.4599999999999987e-41	NTclustered	gi\|2874253939\|emb\|OY970264.1\|	171953	g10519	i0	86.31	3.44676616915423	168	23	20	0	15	182	3437183	3437350	MAG: uncultured Acidobacteriota bacterium isolate MFD03726.bin.c.8 genome assembly, chromosome: 1	blastn	3464	183	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2408647	2408647	PRJNA564013_P_NODE_8002_length_1202_cov_17.691499_g6521_i0	PRJNA564013	8002	1202	17.691499	212.65181798	Chloracidobacterium	458032	Bacteria	Bacteria	758	0	NTclustered	gi\|2033637735\|gb\|CP072633.1\|	458033	g6521	i0	84.411	42.5374376039933	789	103	65	12	23	801	631053	630275	Chloracidobacterium thermophilum strain B chromosome 2, complete sequence	blastn	51130	758	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium thermophilum
3101080	3101080	PRJNA564013_P_NODE_275543_length_242_cov_1.480663_g272691_i0	PRJNA564013	275543	242	1.480663	3.58320446	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	117	7.62e-22	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g272691	i0	92.593	0.334710743801653	81	6	33	0	158	238	3152586	3152666	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	81	117	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
6930583	6930583	PRJNA564013_P_NODE_6166_length_1340_cov_6.043784_g4899_i0	PRJNA564013	6166	1340	6.043784	80.9867056	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	375	7.1699999999999976e-99	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g4899	i0	79.482	4.48582089552239	541	101	40	10	280	815	3859892	3860427	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	6011	375	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13303664	13303664	PRJNA564013_P_NODE_24131_length_761_cov_2.878571_g21732_i0	PRJNA564013	24131	761	2.878571	21.90592531	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	128	1.23e-24	NTclustered	gi\|2621701250\|emb\|OY759970.1\|	2910147	g21732	i0	80.606	0.216819973718791	165	32	22	0	596	760	2737675	2737839	MAG: Vicinamibacterales bacterium isolate d8048395-9ec3-4be5-9403-ce9d0d334964 genome assembly, chromosome: 1	blastn	165	128	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
14580042	14580042	PRJNA564013_P_NODE_325112_length_211_cov_0.866667_g322260_i0	PRJNA564013	325112	211	0.866667	1.82866737	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g322260	i0	96.97	0.156398104265403	33	0	15	1	175	206	6176802	6176834	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	33	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
15159826	15159826	PRJNA564013_P_NODE_178952_length_326_cov_1.471698_g176102_i0	PRJNA564013	178952	326	1.471698	4.79773548	Acidobacteriota	57723	Bacteria	Bacteria	213	1.33e-50	NTclustered	gi\|2033637735\|gb\|CP072633.1\|	458033	g176102	i0	99.153	3.50306748466258	118	1	36	0	209	326	622831	622948	Chloracidobacterium thermophilum strain B chromosome 2, complete sequence	blastn	1142	213	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium thermophilum
18399277	18399277	PRJNA564013_P_NODE_142075_length_359_cov_3.791946_g139226_i0	PRJNA564013	142075	359	3.791946	13.61308614	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	198	4.13e-46	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g139226	i0	82.805	0.615598885793872	221	38	62	0	117	337	2069550	2069770	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	221	198	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
18404724	18404724	PRJNA564013_P_NODE_69175_length_485_cov_9.228774_g66365_i0	PRJNA564013	69175	485	9.228774	44.7595539	Chloracidobacterium aggregatum	2851959	Bacteria	Bacteria	287	1.1899999999999998e-72	NTclustered	gi\|2033649862\|gb\|CP072641.1\|	2821539	g66365	i0	78.222	4.91546391752577	450	97	93	1	8	456	91598	91149	Chloracidobacterium sp. A chromosome 2, complete sequence	blastn	2384	287	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium aggregatum
18984127	18984127	PRJNA564013_P_NODE_34075_length_657_cov_5.546980_g31432_i0	PRJNA564013	34075	657	5.54698	36.4436586	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	128	1.06e-24	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g31432	i0	100	12.5053272450533	69	0	11	0	23	91	430202	430134	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	8216	128	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
19678853	19678853	PRJNA564013_P_NODE_51196_length_553_cov_21.388211_g48439_i0	PRJNA564013	51196	553	21.388211	118.27680683	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	399	1.6899999999999998e-106	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g48439	i0	81.891	0.89873417721519	497	69	86	13	53	528	3781259	3781755	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	497	399	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20259163	20259163	PRJNA564013_P_NODE_32236_length_672_cov_24.284779_g29628_i0	PRJNA564013	32236	672	24.284779	163.19371488	Chloracidobacterium	458032	Bacteria	Bacteria	381	7.519999999999998e-101	NTclustered	gi\|2033637735\|gb\|CP072633.1\|	458033	g29628	i0	94.715	0.827380952380952	246	11	41	2	418	663	637603	637360	Chloracidobacterium thermophilum strain B chromosome 2, complete sequence	blastn	556	381	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium thermophilum
20259672	20259672	PRJNA564013_P_NODE_75116_length_466_cov_44.212346_g72295_i0	PRJNA564013	75116	466	44.212346	206.02953236	Pseudomonadati	3379134	Bacteria	Bacteria	60.2	2.71e-4	NTclustered	gi\|2874253679\|emb\|OY969113.1\|	171953	g72295	i0	94.737	0.156652360515021	38	2	8	0	25	62	665789	665826	MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.1.55 genome assembly, chromosome: 1	blastn	73	60.2	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20949340	20949340	PRJNA564013_P_NODE_137257_length_364_cov_1.534653_g134409_i0	PRJNA564013	137257	364	1.534653	5.58613692	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|2913438576\|emb\|OZ223985.1\|	2793154	g134409	i0	94.444	0.0989010989010989	36	1	10	1	190	224	3108690	3108655	MAG: Vicinamibacteria bacterium isolate c1004ee9-65a7-452c-baee-c28c3200ebb6 genome assembly, chromosome: 1	blastn	36	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
22809186	22809186	PRJNA564013_P_NODE_226818_length_281_cov_6.686364_g223967_i0	PRJNA564013	226818	281	6.686364	18.78868284	Chloracidobacterium	458032	Bacteria	Bacteria	385	2.25e-102	NTclustered	gi\|2033637735\|gb\|CP072633.1\|	458033	g223967	i0	96.17	1.7864768683274	235	9	84	0	23	257	637219	637453	Chloracidobacterium thermophilum strain B chromosome 2, complete sequence	blastn	502	385	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium thermophilum

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);;