metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA560932" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA560932" 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
5648416	5648416	PRJNA560932_P_NODE_26385_length_348_cov_1.294545_g26029_i0	PRJNA560932	26385	348	1.294545	4.5050166	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	202	3.09e-47	NTclustered	gi\|2893358426\|emb\|OZ220718.1\|	2910147	g26029	i0	80.899	1.47701149425287	267	41	75	10	85	346	1182312	1182573	MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1	blastn	514	202	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
10749223	10749223	PRJNA560932_P_NODE_8389_length_600_cov_1.409867_g8036_i0	PRJNA560932	8389	600	1.409867	8.459202	Bryobacterales bacterium	2026791	Bacteria	Bacteria	640	9.96e-179	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g8036	i0	86.134	95.8866666666667	613	62	99	18	2	600	6659280	6659883	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	57532	640	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
12023785	12023785	PRJNA560932_P_NODE_39130_length_290_cov_2.327189_g38774_i0	PRJNA560932	39130	290	2.327189	6.7488481	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	316	8.62e-82	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g38774	i0	86.644	112.413793103448	292	32	99	4	2	290	4840555	4840842	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	32600	316	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13298879	13298879	PRJNA560932_P_NODE_61171_length_245_cov_0.895349_g60815_i0	PRJNA560932	61171	245	0.895349	2.19360505	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	263	9.38e-66	NTclustered	gi\|2893358397\|emb\|OZ220688.1\|	2651171	g60815	i0	91.579	78.8938775510204	190	16	78	0	53	242	997214	997025	MAG: Thermoanaerobaculia bacterium isolate 17c936d4-adfa-4882-ba3e-7fd0bc385902 genome assembly, chromosome: 1	blastn	19329	263	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
13884412	13884412	PRJNA560932_P_NODE_48931_length_260_cov_1.524064_g48575_i0	PRJNA560932	48931	260	1.524064	3.9625664	Bacteria	2	Bacteria	Bacteria	436	5.600000000000001e-118	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g48575	i0	96.923	159.184615384615	260	8	100	0	1	260	4841526	4841785	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	41388	436	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14573639	14573639	PRJNA560932_P_NODE_38952_length_291_cov_1.412844_g38596_i0	PRJNA560932	38952	291	1.412844	4.11137604	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	464	2.9199999999999998e-126	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g38596	i0	95.517	107.264604810997	290	13	99	0	1	290	3556780	3556491	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	31214	464	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
15847648	15847648	PRJNA560932_P_NODE_52113_length_251_cov_0.865169_g51757_i0	PRJNA560932	52113	251	0.865169	2.17157419	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2893358421\|emb\|OZ220713.1\|	2793154	g51757	i0	96.774	0.123505976095618	31	1	12	0	103	133	3112837	3112807	MAG: Vicinamibacteria bacterium isolate f5636fb4-303b-4095-abf0-868cc3675b90 genome assembly, chromosome: 1	blastn	31	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
18396546	18396546	PRJNA560932_P_NODE_35655_length_304_cov_1.813853_g35299_i0	PRJNA560932	35655	304	1.813853	5.51411312	Luteitalea pratensis	1855912	Bacteria	Bacteria	375	1.48e-99	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g35299	i0	89.251	128.644736842105	307	24	100	9	1	304	655015	654715	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	39108	375	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
18396665	18396665	PRJNA560932_P_NODE_50175_length_256_cov_1.409836_g49819_i0	PRJNA560932	50175	256	1.409836	3.60918016	Holophagales bacterium	2478486	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1958024485\|gb\|CP064972.1\|	2478486	g49819	i0	100	0.109375	28	0	11	0	163	190	1857101	1857074	Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales bacterium
19671366	19671366	PRJNA560932_P_NODE_64876_length_242_cov_1.230769_g64520_i0	PRJNA560932	64876	242	1.230769	2.97846098	Geothrix sp. 21YS21S-2	3068893	Bacteria	Bacteria	171	5.77e-38	NTclustered	gi\|2566094019\|gb\|CP132910.1\|	3068893	g64520	i0	79.668	56.9504132231405	241	46	99	3	2	242	3374396	3374633	Geothrix sp. 21YS21S-2 chromosome, complete genome	blastn	13782	171	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-2
24771013	24771013	PRJNA560932_P_NODE_46420_length_268_cov_1.533333_g46064_i0	PRJNA560932	46420	268	1.533333	4.10933244	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	305	1.71e-78	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g46064	i0	87.5	139.160447761194	264	33	99	0	5	268	3559054	3559317	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	37295	305	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae 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);;