metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA788929" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA788929" 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
2045068	2045068	PRJNA788929_P_NODE_16842_length_406_cov_10.591592_g16183_i0	PRJNA788929	16842	406	10.591592	43.00186352	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	497	4.16e-136	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g16183	i0	90.691	98.2290640394089	376	32	92	2	31	405	3558554	3558181	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	39881	497	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
3320887	3320887	PRJNA788929_P_NODE_48963_length_205_cov_5.704545_g48302_i0	PRJNA788929	48963	205	5.704545	11.69431725	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	318	1.6e-82	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g48302	i0	96.842	55.4682926829268	190	6	93	0	16	205	18	207	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	11371	318	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4597639	4597639	PRJNA788929_P_NODE_32164_length_276_cov_16.118227_g31503_i0	PRJNA788929	32164	276	16.118227	44.48630652	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	357	4.8e-94	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g31503	i0	92.095	316.242753623188	253	20	92	0	1	253	2367465	2367717	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	87283	357	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4597827	4597827	PRJNA788929_P_NODE_43904_length_234_cov_16.571429_g43243_i0	PRJNA788929	43904	234	16.571429	38.77714386	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	296	8.77e-76	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g43243	i0	91.981	143.175213675214	212	16	90	1	24	234	4233960	4233749	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	33503	296	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4597935	4597935	PRJNA788929_P_NODE_6304_length_766_cov_20.132756_g5688_i0	PRJNA788929	6304	766	20.132756	154.21691096	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	239	5.499999999999999e-58	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g5688	i0	77.953	5.67885117493473	381	84	50	0	376	756	4014837	4015217	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	4350	239	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6318360	6318360	PRJNA788929_P_NODE_37605_length_251_cov_25.359551_g36944_i0	PRJNA788929	37605	251	25.359551	63.65247301	Holophaga	35838	Bacteria	Bacteria	342	1.21e-89	NTclustered	gi\|2621704223\|emb\|OY761614.1\|	188475	g36944	i0	93.562	150.394422310757	233	10	92	5	22	251	646608	646378	MAG: uncultured Holophaga sp. isolate c3c763bb-72ba-4188-aae9-c4b83244ba6d genome assembly, chromosome: 1	blastn	37749	342	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
7147724	7147724	PRJNA788929_P_NODE_21366_length_352_cov_13.946237_g20706_i0	PRJNA788929	21366	352	13.946237	49.09075424	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	366	1.0499999999999996e-96	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g20706	i0	88.274	82.4857954545455	307	35	87	1	24	329	317558	317252	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	29035	366	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10973647	10973647	PRJNA788929_P_NODE_47709_length_212_cov_34.143885_g47048_i0	PRJNA788929	47709	212	34.143885	72.3850362	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	206	1.3499999999999999e-48	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g47048	i0	94.697	131.146226415094	132	7	62	0	58	189	1822543	1822674	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	27803	206	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
13523363	13523363	PRJNA788929_P_NODE_46871_length_218_cov_7.544828_g46210_i0	PRJNA788929	46871	218	7.544828	16.44772504	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	230	8.29e-56	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g46210	i0	87.817	28.6238532110092	197	23	90	1	1	196	211	15	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	6240	230	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17347453	17347453	PRJNA788929_P_NODE_18814_length_379_cov_30.454248_g18154_i0	PRJNA788929	18814	379	30.454248	115.42159992	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	442	1.829999999999999e-119	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g18154	i0	89.136	260.857519788918	359	34	94	5	23	378	3176537	3176181	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	98865	442	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
17347695	17347695	PRJNA788929_P_NODE_33814_length_268_cov_22.882051_g33153_i0	PRJNA788929	33814	268	22.882051	61.32389668	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	311	3.6699999999999996e-80	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g33153	i0	89.474	89.1753731343284	247	24	92	2	23	268	73	318	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	23899	311	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18620749	18620749	PRJNA788929_P_NODE_23155_length_335_cov_53.648855_g22494_i0	PRJNA788929	23155	335	53.648855	179.72366425	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	385	2.74e-102	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g22494	i0	89.355	228.280597014925	310	28	92	5	23	329	317250	317557	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	76474	385	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
18621126	18621126	PRJNA788929_P_NODE_48435_length_208_cov_8.637037_g47774_i0	PRJNA788929	48435	208	8.637037	17.96503696	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	191	3.6999999999999995e-44	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g47774	i0	85.789	97.6826923076923	190	15	88	11	24	207	716217	716034	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	20318	191	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23722424	23722424	PRJNA788929_P_NODE_46359_length_221_cov_11.189189_g45698_i0	PRJNA788929	46359	221	11.189189	24.72810769	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	244	3.01e-60	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g45698	i0	88.889	65.131221719457	198	22	90	0	1	198	198	1	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	14394	244	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured 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);;