metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA666695" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA666695" 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
1906616	1906616	PRJNA666695_S_NODE_127782_length_194_cov_2.032680_g126688_i0	PRJNA666695	127782	194	2.03268	3.9433992	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	263	7.11e-66	NTclustered	gi\|217038895\|gb\|EU810985.1\|	171953	g126688	i0	91.237	91.1546391752577	194	16	99	1	2	194	2	195	Uncultured Acidobacteria bacterium clone 01QD5 23S ribosomal RNA gene, partial sequence	blastn	17684	263	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3182121	3182121	PRJNA666695_S_NODE_162963_length_169_cov_1.492188_g161869_i0	PRJNA666695	162963	169	1.492188	2.52179772	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g161869	i0	92.5	0.236686390532544	40	1	23	2	40	78	4333868	4333906	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	40	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
3184528	3184528	PRJNA666695_S_NODE_95663_length_224_cov_2.765027_g94569_i0	PRJNA666695	95663	224	2.765027	6.19366048	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874254159\|emb\|OY970389.1\|	2283092	g94569	i0	96.97	0.147321428571429	33	1	15	0	139	171	134087	134119	MAG: Pyrinomonadaceae bacterium isolate MFD09206.bin.c.1 genome assembly, chromosome: 1	blastn	33	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
4458819	4458819	PRJNA666695_S_NODE_147444_length_179_cov_2.362319_g146350_i0	PRJNA666695	147444	179	2.362319	4.22855101	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	117	5.300000000000001e-22	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g146350	i0	98.485	1.68156424581006	66	1	37	0	51	116	3515471	3515536	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	301	117	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
5735287	5735287	PRJNA666695_S_NODE_20305_length_412_cov_8.590296_g19213_i0	PRJNA666695	20305	412	8.590296	35.39201952	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	326	2.11e-84	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g19213	i0	81.235	40.376213592233	405	74	98	2	8	411	4011710	4011307	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	16635	326	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7008983	7008983	PRJNA666695_S_NODE_122906_length_198_cov_2.050955_g121812_i0	PRJNA666695	122906	198	2.050955	4.0608909	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	154	4.5700000000000005e-33	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g121812	i0	81.622	2.8030303030303	185	34	93	0	6	190	1054201	1054017	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	555	154	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
7010762	7010762	PRJNA666695_S_NODE_3466_length_851_cov_101.153086_g2785_i0	PRJNA666695	3466	851	101.153086	860.81276186	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	1177	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g2785	i0	91.608	162.685076380729	858	62	100	7	1	851	3299244	3300098	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	138445	1177	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
7540397	7540397	PRJNA666695_S_NODE_125826_length_196_cov_1.187097_g124732_i0	PRJNA666695	125826	196	1.187097	2.32671012	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	213	7.35e-51	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g124732	i0	88.202	33.6377551020408	178	21	91	0	1	178	178	1	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	6593	213	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12109608	12109608	PRJNA666695_S_NODE_117050_length_203_cov_2.308642_g115956_i0	PRJNA666695	117050	203	2.308642	4.68654326	Terriglobia bacterium	2081523	Bacteria	Bacteria	115	2.22e-21	NTclustered	gi\|2874253655\|emb\|OY968796.1\|	2081523	g115956	i0	81.818	1.44334975369458	143	21	70	4	1	142	1137188	1137050	MAG: Terriglobia bacterium isolate MFD04463.bin.1.19 genome assembly, chromosome: 1	blastn	293	115	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
18483112	18483112	PRJNA666695_S_NODE_137715_length_186_cov_3.151724_g136621_i0	PRJNA666695	137715	186	3.151724	5.86220664	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	78.7	2.6200000000000003e-10	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g136621	i0	100	8.38172043010753	42	0	23	0	1	42	1357199	1357158	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	1559	78.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
21034747	21034747	PRJNA666695_S_NODE_36137_length_332_cov_7.587629_g35043_i0	PRJNA666695	36137	332	7.587629	25.19092828	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	108	6.58e-19	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g35043	i0	94.286	0.894578313253012	70	4	21	0	110	179	4746753	4746684	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	297	108	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21564795	21564795	PRJNA666695_S_NODE_177597_length_160_cov_1.546218_g176503_i0	PRJNA666695	177597	160	1.546218	2.4739488	Pseudomonadati	3379134	Bacteria	Bacteria	113	6e-21	NTclustered	gi\|2893358397\|emb\|OZ220688.1\|	2651171	g176503	i0	84.298	147.85	121	13	74	5	14	131	2843253	2843136	MAG: Thermoanaerobaculia bacterium isolate 17c936d4-adfa-4882-ba3e-7fd0bc385902 genome assembly, chromosome: 1	blastn	23656	113	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
22308443	22308443	PRJNA666695_S_NODE_1598_length_1194_cov_94.091067_g1146_i0	PRJNA666695	1598	1194	94.091067	1123.44733998	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	1463	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g1146	i0	89.721	391.649078726968	1148	115	96	3	49	1194	3298140	3299286	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	467629	1463	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);;