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

13 rows where analysis = "blastn", bioproject = "PRJNA799842" 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
792698	792698	PRJNA799842_P_NODE_102321_length_288_cov_1.200000_g100748_i0	PRJNA799842	102321	288	1.2	3.456	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	392	1.3799999999999999e-104	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g100748	i0	91.349	105.954861111111	289	22	100	3	1	288	633932	634218	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	30515	392	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
8448161	8448161	PRJNA799842_P_NODE_50727_length_399_cov_1.101227_g49154_i0	PRJNA799842	50727	399	1.101227	4.39389573	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	549	1.1099999999999999e-151	NTclustered	gi\|2874254159\|emb\|OY970389.1\|	2283092	g49154	i0	92.876	178.691729323308	379	25	95	2	21	399	2617056	2617432	MAG: Pyrinomonadaceae bacterium isolate MFD09206.bin.c.1 genome assembly, chromosome: 1	blastn	71298	549	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
9720941	9720941	PRJNA799842_P_NODE_107548_length_282_cov_1.105263_g105975_i0	PRJNA799842	107548	282	1.105263	3.11684166	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	411	3.729999999999999e-110	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g105975	i0	92.982	519.840425531915	285	15	100	4	1	282	1821946	1821664	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	146595	411	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
9722005	9722005	PRJNA799842_P_NODE_164108_length_246_cov_0.890173_g162535_i0	PRJNA799842	164108	246	0.890173	2.18982558	Luteitalea pratensis	1855912	Bacteria	Bacteria	187	5.839999999999998e-43	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g162535	i0	81.328	0.979674796747967	241	35	96	7	2	237	4142775	4142540	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	241	187	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
9724103	9724103	PRJNA799842_P_NODE_94908_length_298_cov_1.297778_g93335_i0	PRJNA799842	94908	298	1.297778	3.86737844	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	446	1.09e-120	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g93335	i0	93.624	101.295302013423	298	19	100	0	1	298	3558377	3558080	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	30186	446	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
10997627	10997627	PRJNA799842_P_NODE_15269_length_792_cov_1.926287_g13889_i0	PRJNA799842	15269	792	1.926287	15.25619304	Luteitalea pratensis	1855912	Bacteria	Bacteria	1291	0	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g13889	i0	96.086	89.5808080808081	792	31	100	0	1	792	654987	654196	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	70948	1291	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
13547652	13547652	PRJNA799842_P_NODE_173731_length_244_cov_0.900585_g172158_i0	PRJNA799842	173731	244	0.900585	2.1974274	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	243	1.22e-59	NTclustered	gi\|2621704107\|emb\|OY761556.1\|	1978231	g172158	i0	84.774	0.995901639344262	243	35	99	2	3	244	6710030	6710271	MAG: Acidobacteriota bacterium isolate 5ca539cc-3996-4499-a76f-7ad0c810d377 genome assembly, chromosome: 1	blastn	243	243	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
15247104	15247104	PRJNA799842_P_NODE_142072_length_250_cov_0.870056_g140499_i0	PRJNA799842	142072	250	0.870056	2.17514	Pseudomonadati	3379134	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2874253889\|emb\|OY970064.1\|	194844	g140499	i0	96.875	0.256	32	1	13	0	63	94	880698	880729	MAG: uncultured Acidobacteriaceae bacterium isolate MFD06092.bin.c.1 genome assembly, chromosome: 1	blastn	64	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
16096444	16096444	PRJNA799842_P_NODE_166513_length_245_cov_0.895349_g164940_i0	PRJNA799842	166513	245	0.895349	2.19360505	Geothrix sp.	1962974	Bacteria	Bacteria	60.2	1.32e-4	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g164940	i0	97.143	0.269387755102041	35	1	14	0	142	176	1572262	1572296	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	66	60.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
16097433	16097433	PRJNA799842_P_NODE_43553_length_431_cov_2.128492_g41980_i0	PRJNA799842	43553	431	2.128492	9.17380052	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	453	9.76e-123	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g41980	i0	85.714	130.872389791183	434	56	100	6	1	431	3298175	3298605	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	56406	453	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
18644960	18644960	PRJNA799842_P_NODE_140875_length_250_cov_0.870056_g139302_i0	PRJNA799842	140875	250	0.870056	2.17514	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	134	7.860000000000001e-27	NTclustered	gi\|2108199008\|gb\|CP070706.1\|	1978231	g139302	i0	84.444	0.66	135	21	54	0	111	245	3453979	3453845	MAG: Acidobacteria bacterium isolate bin529 chromosome	blastn	165	134	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
22470007	22470007	PRJNA799842_P_NODE_112518_length_276_cov_1.315271_g110945_i0	PRJNA799842	112518	276	1.315271	3.63014796	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	263	1.08e-65	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g110945	i0	84.701	29.4239130434783	268	35	96	6	11	275	3267115	3267379	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	8121	263	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
25020903	25020903	PRJNA799842_P_NODE_190360_length_241_cov_0.916667_g188787_i0	PRJNA799842	190360	241	0.916667	2.20916747	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	167	7.429999999999999e-37	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g188787	i0	81.043	66.6680497925311	211	38	87	2	32	241	3804270	3804479	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	16067	167	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);;