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

18 rows where analysis = "blastn", bioproject = "PRJNA473799" 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
4272608	4272608	PRJNA473799_P_NODE_30164_length_258_cov_2.600000_g29890_i0	PRJNA473799	30164	258	2.6	6.708	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	200	7.93e-47	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g29890	i0	82.52	291.996124031008	246	26	91	12	20	253	4650154	4649914	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	75335	200	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
4272704	4272704	PRJNA473799_P_NODE_36404_length_250_cov_1.101695_g36130_i0	PRJNA473799	36404	250	1.101695	2.7542375	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	237	5.82e-58	NTclustered	gi\|117557516\|emb\|AM180905.2\|	171953	g36130	i0	84.583	266.024	240	35	96	2	3	241	803	1041	Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone UD5 LS_LKC11_kan4	blastn	66506	237	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5549008	5549008	PRJNA473799_P_NODE_11365_length_312_cov_1.874477_g11091_i0	PRJNA473799	11365	312	1.874477	5.84836824	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	230	1.2599999999999998e-55	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g11091	i0	88.325	65.9647435897436	197	16	100	5	118	312	3917783	3917592	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	20581	230	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5549024	5549024	PRJNA473799_P_NODE_12525_length_307_cov_1.794872_g12251_i0	PRJNA473799	12525	307	1.794872	5.51025704	Luteitalea pratensis	1855912	Bacteria	Bacteria	523	5.049999999999998e-144	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g12251	i0	97.394	128.560260586319	307	8	100	0	1	307	653480	653174	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	39468	523	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
5549336	5549336	PRJNA473799_P_NODE_3765_length_695_cov_3.445338_g3506_i0	PRJNA473799	3765	695	3.445338	23.9450991	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	399	2.1499999999999996e-106	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g3506	i0	78.704	225.402877697842	648	103	91	27	66	695	714958	714328	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	156655	399	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9373504	9373504	PRJNA473799_P_NODE_38168_length_249_cov_1.193182_g37894_i0	PRJNA473799	38168	249	1.193182	2.97102318	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	298	2.62e-76	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g37894	i0	88.571	1.96787148594378	245	28	98	0	5	249	6514909	6514665	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	490	298	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10649179	10649179	PRJNA473799_P_NODE_15289_length_289_cov_0.972222_g15015_i0	PRJNA473799	15289	289	0.972222	2.80972158	Luteitalea pratensis	1855912	Bacteria	Bacteria	335	2.369999999999999e-87	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g15015	i0	87.543	2.55363321799308	289	36	100	0	1	289	5726121	5725833	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	738	335	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
13199320	13199320	PRJNA473799_P_NODE_33631_length_252_cov_1.994413_g33357_i0	PRJNA473799	33631	252	1.994413	5.02592076	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	309	1.23e-79	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g33357	i0	90.87	2.18650793650794	230	21	91	0	21	250	1131196	1130967	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	551	309	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15748599	15748599	PRJNA473799_P_NODE_50653_length_243_cov_0.905882_g50379_i0	PRJNA473799	50653	243	0.905882	2.20129326	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	224	4.3899999999999996e-54	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g50379	i0	85.455	2.15637860082305	220	27	89	5	27	243	2350420	2350637	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	524	224	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18297092	18297092	PRJNA473799_P_NODE_18855_length_281_cov_1.009615_g18581_i0	PRJNA473799	18855	281	1.009615	2.83701815	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	220	6.71e-53	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g18581	i0	80.851	1.00355871886121	282	52	100	2	1	281	2542701	2542421	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	282	220	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18297620	18297620	PRJNA473799_P_NODE_6535_length_445_cov_1.475806_g6266_i0	PRJNA473799	6535	445	1.475806	6.5673367	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	728	0	NTclustered	gi\|2874254056\|emb\|OY970380.1\|	2651171	g6266	i0	96.188	131.215730337079	446	15	100	2	1	445	2980681	2981125	MAG: Thermoanaerobaculia bacterium isolate MFD05537.bin.c.2 genome assembly, chromosome: 1	blastn	58391	728	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
19571147	19571147	PRJNA473799_P_NODE_14556_length_290_cov_1.442396_g14282_i0	PRJNA473799	14556	290	1.442396	4.1829484	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	392	1.39e-104	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g14282	i0	91.289	3.95172413793103	287	25	99	0	4	290	2947100	2946814	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	1146	392	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19571712	19571712	PRJNA473799_P_NODE_53716_length_241_cov_0.916667_g53442_i0	PRJNA473799	53716	241	0.916667	2.20916747	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	187	5.699999999999998e-43	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g53442	i0	84.264	67.1867219917012	197	26	80	4	3	195	248470	248275	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	16192	187	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21497451	21497451	PRJNA473799_P_NODE_19857_length_279_cov_0.980583_g19583_i0	PRJNA473799	19857	279	0.980583	2.73582657	Bacteria	2	Bacteria	Bacteria	412	1.0199999999999999e-110	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g19583	i0	93.502	116.247311827957	277	18	99	0	2	278	2367756	2367480	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	32433	414	0.995169082125604	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23397607	23397607	PRJNA473799_P_NODE_12899_length_302_cov_3.096070_g12625_i0	PRJNA473799	12899	302	3.09607	9.3501314	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	259	1.54e-64	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g12625	i0	85.827	69.6953642384106	254	25	83	11	51	302	360254	360010	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	21048	259	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
23398276	23398276	PRJNA473799_P_NODE_8779_length_360_cov_1.331010_g8505_i0	PRJNA473799	8779	360	1.33101	4.791636	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	374	6.409999999999998e-99	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g8505	i0	88.746	882.805555555556	311	28	85	4	1	306	715758	716066	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	317810	374	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24671731	24671731	PRJNA473799_P_NODE_31880_length_255_cov_2.527473_g31606_i0	PRJNA473799	31880	255	2.527473	6.44505615	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	62.1	3.85e-5	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g31606	i0	94.872	0.525490196078431	39	2	15	0	47	85	5771191	5771153	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	134	62.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
24672018	24672018	PRJNA473799_P_NODE_51240_length_242_cov_1.692308_g50966_i0	PRJNA473799	51240	242	1.692308	4.09538536	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	115	2.7400000000000004e-21	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g50966	i0	94.595	12.7190082644628	74	4	31	0	1	74	2082329	2082256	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	3078	115	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);;