metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA505329" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA505329" 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
483284	483284	PRJNA505329_P_NODE_25321_length_194_cov_2.117241_g24850_i0	PRJNA505329	25321	194	2.117241	4.10744754	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	296	7.01e-76	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g24850	i0	95.652	460.412371134021	184	8	95	0	4	187	2973541	2973724	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	89320	296	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
483403	483403	PRJNA505329_P_NODE_36681_length_177_cov_1.609375_g36210_i0	PRJNA505329	36681	177	1.609375	2.84859375	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	241	2.97e-59	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g36210	i0	91.429	79.7570621468927	175	15	99	0	3	177	1418257	1418431	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	14117	241	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4310338	4310338	PRJNA505329_P_NODE_34484_length_180_cov_2.610687_g34013_i0	PRJNA505329	34484	180	2.610687	4.6992366	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	255	1.08e-63	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g34013	i0	92.655	40.9611111111111	177	13	98	0	1	177	320873	320697	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	7373	255	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
8136400	8136400	PRJNA505329_P_NODE_22007_length_200_cov_4.503311_g21536_i0	PRJNA505329	22007	200	4.503311	9.006622	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	309	9.34e-80	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g21536	i0	94.924	160.95	197	10	99	0	4	200	4231285	4231089	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	32190	309	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10038877	10038877	PRJNA505329_P_NODE_38988_length_173_cov_2.548387_g38517_i0	PRJNA505329	38988	173	2.548387	4.4087095100000004	Luteitalea	2004797	Bacteria	Bacteria	315	1.68e-81	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g38517	i0	100	91.7341040462428	170	0	98	0	1	170	654346	654177	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	15870	315	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
13237012	13237012	PRJNA505329_P_NODE_12151_length_233_cov_3.244565_g11680_i0	PRJNA505329	12151	233	3.244565	7.55983645	Holophagales bacterium	2478486	Bacteria	Bacteria	73.1	1.6e-8	NTclustered	gi\|1958024485\|gb\|CP064972.1\|	2478486	g11680	i0	82.716	0.347639484978541	81	14	35	0	1	81	4052289	4052209	Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome	blastn	81	73.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales bacterium
13237130	13237130	PRJNA505329_P_NODE_21991_length_200_cov_4.569536_g21520_i0	PRJNA505329	21991	200	4.569536	9.139072	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	137	4.66e-28	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g21520	i0	79.31	7.095	203	36	99	5	1	197	3362022	3362224	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	1419	137	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14512120	14512120	PRJNA505329_P_NODE_15912_length_233_cov_2.532609_g15441_i0	PRJNA505329	15912	233	2.532609	5.90097897	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	115	2.6200000000000003e-21	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g15441	i0	87.879	0.424892703862661	99	10	42	2	4	101	3841375	3841472	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	99	115	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14512583	14512583	PRJNA505329_P_NODE_8072_length_255_cov_4.184466_g7601_i0	PRJNA505329	8072	255	4.184466	10.6703883	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	117	8.1e-22	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g7601	i0	87.879	117.63137254902	99	12	39	0	29	127	318214	318312	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	29996	117	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
15786107	15786107	PRJNA505329_P_NODE_33793_length_181_cov_3.090909_g33322_i0	PRJNA505329	33793	181	3.090909	5.59454529	Granulicella sp. WH15	2602070	Bacteria	Bacteria	148	1.9099999999999998e-31	NTclustered	gi\|1799576755\|gb\|CP042596.1\|	2602070	g33322	i0	81.921	0.977900552486188	177	30	97	2	2	177	3934686	3934861	Granulicella sp. WH15 chromosome, complete genome	blastn	177	148	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella sp. WH15
19609138	19609138	PRJNA505329_P_NODE_10096_length_233_cov_4.706522_g9625_i0	PRJNA505329	10096	233	4.706522	10.96619626	uncultured Vicinamibacterales bacterium	3036250	Bacteria	Bacteria	99	2.64e-16	NTclustered	gi\|2546137835\|emb\|OY282382.1\|	3036250	g9625	i0	86.667	1.75107296137339	90	10	38	2	6	94	5753605	5753693	MAG: uncultured Vicinamibacterales bacterium isolate e65da963-7c29-4b68-91ce-224fd25ea74c genome assembly, chromosome: 1	blastn	408	99	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			uncultured Vicinamibacterales bacterium
19609480	19609480	PRJNA505329_P_NODE_38476_length_174_cov_2.320000_g38005_i0	PRJNA505329	38476	174	2.32	4.0368	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	154	3.9e-33	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g38005	i0	86.525	1.39080459770115	141	17	80	2	32	171	1617988	1618127	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	242	154	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21512157	21512157	PRJNA505329_P_NODE_15157_length_233_cov_2.663043_g14686_i0	PRJNA505329	15157	233	2.663043	6.20489019	Bacteria	2	Bacteria	Bacteria	183	7.089999999999998e-42	NTclustered	gi\|31789363\|gb\|AY281352.1\|	171953	g14686	i0	100	52.622317596566504	99	0	42	0	133	231	1559	1657	Uncultured Acidobacteria bacterium clone 23k22 genomic sequence	blastn	12261	183	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21512195	21512195	PRJNA505329_P_NODE_20577_length_201_cov_3.447368_g20106_i0	PRJNA505329	20577	201	3.447368	6.92920968	Geothrix	44675	Bacteria	Bacteria	169	1.66e-37	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g20106	i0	97	4.39800995024876	100	3	99	0	3	102	3463965	3463866	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	884	169	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
22160075	22160075	PRJNA505329_P_NODE_30678_length_186_cov_2.233577_g30207_i0	PRJNA505329	30678	186	2.233577	4.15445322	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	176	9.04e-40	NTclustered	gi\|31789410\|gb\|AY281354.1\|	171953	g30207	i0	84.615	125.795698924731	182	22	95	5	6	182	36988	37168	Uncultured Acidobacteria bacterium clone 38c7 genomic sequence	blastn	23398	176	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24709154	24709154	PRJNA505329_P_NODE_17100_length_226_cov_7.152542_g16629_i0	PRJNA505329	17100	226	7.152542	16.16474492	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	351	1.77e-92	NTclustered	gi\|112980873\|gb\|DQ829677.1\|	171953	g16629	i0	95.067	380.234513274336	223	11	99	0	4	226	1303	1525	Uncultured Acidobacteria bacterium clone DON3 23S ribosomal RNA gene, partial sequence	blastn	85933	351	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24709194	24709194	PRJNA505329_P_NODE_20300_length_201_cov_3.815789_g19829_i0	PRJNA505329	20300	201	3.815789	7.66973589	Geothrix sp. PMB-07	3068640	Bacteria	Bacteria	126	1.02e-24	NTclustered	gi\|2563347696\|gb\|CP132333.1\|	3068640	g19829	i0	89.796	1.27363184079602	98	10	50	0	103	200	3987883	3987786	Geothrix sp. PMB-07 chromosome, complete genome	blastn	256	126	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. PMB-07
24709257	24709257	PRJNA505329_P_NODE_25160_length_194_cov_2.717241_g24689_i0	PRJNA505329	25160	194	2.717241	5.27144754	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	152	1.5999999999999998e-32	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g24689	i0	82.486	1.83505154639175	177	28	90	3	4	177	5865501	5865677	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	356	152	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22

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