metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA390533" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA390533" 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
1684382	1684382	PRJNA390533_P_NODE_13602_length_514_cov_35.397895_g12628_i0	PRJNA390533	13602	514	35.397895	181.9451803	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	675	0	NTclustered	gi\|2874254159\|emb\|OY970389.1\|	2283092	g12628	i0	91.498	443.250972762646	494	36	95	6	22	511	2618486	2617995	MAG: Pyrinomonadaceae bacterium isolate MFD09206.bin.c.1 genome assembly, chromosome: 1	blastn	227831	675	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
1684693	1684693	PRJNA390533_P_NODE_39902_length_181_cov_1.443662_g38875_i0	PRJNA390533	39902	181	1.443662	2.61302822	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	84.2	5.45e-12	NTclustered	gi\|2814788339\|emb\|OY761475.2\|	2910147	g38875	i0	96.078	0.458563535911602	51	2	28	0	17	67	6409700	6409650	MAG: Vicinamibacterales bacterium isolate 01def6b1-0c8c-435d-859a-076764f3ef92 genome assembly, chromosome: 1	blastn	83	84.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
1684736	1684736	PRJNA390533_P_NODE_44062_length_166_cov_0.960630_g43035_i0	PRJNA390533	44062	166	0.96063	1.5946458	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	143	8.02e-30	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g43035	i0	82.424	21.0481927710843	165	27	99	2	2	165	3345821	3345984	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	3494	143	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2960372	2960372	PRJNA390533_P_NODE_24743_length_316_cov_1.440433_g23716_i0	PRJNA390533	24743	316	1.440433	4.55176828	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	91.6	6.27e-14	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g23716	i0	96.364	1.23417721518987	55	2	17	0	25	79	609643	609697	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	390	91.6	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4236747	4236747	PRJNA390533_P_NODE_26104_length_306_cov_2.217228_g25077_i0	PRJNA390533	26104	306	2.217228	6.78471768	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	111	4.64e-20	NTclustered	gi\|2893358436\|emb\|OZ220728.1\|	2910147	g25077	i0	79.874	5.16666666666667	159	26	51	6	150	305	613100	613255	MAG: Vicinamibacterales bacterium isolate 73bbec36-abbb-48ff-8f96-0d8513c84f17 genome assembly, chromosome: 1	blastn	1581	111	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
4236886	4236886	PRJNA390533_P_NODE_41704_length_174_cov_1.162963_g40677_i0	PRJNA390533	41704	174	1.162963	2.0235556200000002	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	128	2.3599999999999997e-25	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g40677	i0	84.615	0.747126436781609	130	18	74	2	46	174	2785191	2785063	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	130	128	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4236949	4236949	PRJNA390533_P_NODE_48704_length_154_cov_0.939130_g47677_i0	PRJNA390533	48704	154	0.93913	1.4462602	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	119	1.23e-22	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g47677	i0	80.769	1.01298701298701	156	26	100	4	1	154	5134354	5134201	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	156	119	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
5513416	5513416	PRJNA390533_P_NODE_25565_length_315_cov_1.083333_g24538_i0	PRJNA390533	25565	315	1.083333	3.41249895	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	71.3	8.14e-8	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g24538	i0	86.364	0.20952380952381	66	7	21	2	4	68	3536229	3536293	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	66	71.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
6787666	6787666	PRJNA390533_P_NODE_7326_length_726_cov_24.943231_g6584_i0	PRJNA390533	7326	726	24.943231	181.08785706	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	580	7.489999999999998e-161	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g6584	i0	100	68.732782369146	314	0	43	0	5	318	314	1	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	49900	580	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9337964	9337964	PRJNA390533_P_NODE_46088_length_160_cov_1.355372_g45061_i0	PRJNA390533	46088	160	1.355372	2.1685952	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	185	1.2499999999999997e-42	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g45061	i0	88.387	85.39375	155	16	96	2	7	160	2896910	2896757	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	13663	185	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10613526	10613526	PRJNA390533_P_NODE_30829_length_243_cov_3.142157_g29802_i0	PRJNA390533	30829	243	3.142157	7.63544151	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	370	5.32e-98	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g29802	i0	94.215	185.843621399177	242	14	99	0	1	242	320602	320843	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	45160	370	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10613549	10613549	PRJNA390533_P_NODE_33089_length_222_cov_2.322404_g32062_i0	PRJNA390533	33089	222	2.322404	5.15573688	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	222	1.42e-53	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g32062	i0	84.956	1.3963963963964	226	27	100	7	1	222	2366879	2367101	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	310	222	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11888406	11888406	PRJNA390533_P_NODE_22310_length_350_cov_1.678457_g21286_i0	PRJNA390533	22310	350	1.678457	5.8745995	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	132	4.13e-26	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g21286	i0	88.288	0.871428571428571	111	11	31	2	241	350	327681	327572	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	305	132	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
11888437	11888437	PRJNA390533_P_NODE_25070_length_316_cov_1.191336_g24043_i0	PRJNA390533	25070	316	1.191336	3.76462176	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2893358397\|emb\|OZ220688.1\|	2651171	g24043	i0	96.97	0.193037974683544	33	1	10	0	3	35	2496531	2496499	MAG: Thermoanaerobaculia bacterium isolate 17c936d4-adfa-4882-ba3e-7fd0bc385902 genome assembly, chromosome: 1	blastn	61	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
13163463	13163463	PRJNA390533_P_NODE_29791_length_255_cov_1.097222_g28764_i0	PRJNA390533	29791	255	1.097222	2.7979161	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	154	6.17e-33	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g28764	i0	78.261	2.34509803921569	253	45	97	10	4	251	2446874	2446627	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	598	154	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
14438472	14438472	PRJNA390533_P_NODE_22672_length_345_cov_1.473856_g21648_i0	PRJNA390533	22672	345	1.473856	5.0848032	Bryobacterales bacterium	2026791	Bacteria	Bacteria	89.8	2.49e-13	NTclustered	gi\|2913438621\|emb\|OZ224030.1\|	2026791	g21648	i0	84.615	0.820289855072464	91	13	26	1	245	335	672395	672484	MAG: Bryobacterales bacterium isolate 7c2e36ee-14bd-451a-b5bf-70b98c7e11c2 genome assembly, chromosome: 1	blastn	283	89.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
15712410	15712410	PRJNA390533_P_NODE_31733_length_234_cov_3.984615_g30706_i0	PRJNA390533	31733	234	3.984615	9.3239991	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	287	5.28e-73	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g30706	i0	90.698	47.9017094017094	215	20	92	0	1	215	3298399	3298185	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	11209	287	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
15712452	15712452	PRJNA390533_P_NODE_36113_length_201_cov_1.302469_g35086_i0	PRJNA390533	36113	201	1.302469	2.61796269	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	204	4.5599999999999997e-48	NTclustered	gi\|2891481964\|emb\|OZ219745.1\|	2910147	g35086	i0	87.709	80.8457711442786	179	16	87	5	8	181	4561586	4561763	MAG: Vicinamibacterales bacterium isolate d5a9b4ee-eb88-4731-bb2c-80bf662b4d04 genome assembly, chromosome: 2	blastn	16250	204	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
16380517	16380517	PRJNA390533_P_NODE_13753_length_510_cov_18.541401_g12775_i0	PRJNA390533	13753	510	18.541401	94.5611451	Bacteria	2	Bacteria	Bacteria	584	3.979999999999998e-162	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g12775	i0	88.344	292.821568627451	489	53	95	4	5	490	488	1	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	149339	584	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16987260	16987260	PRJNA390533_P_NODE_37214_length_194_cov_2.451613_g36187_i0	PRJNA390533	37214	194	2.451613	4.75612922	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	193	9.46e-45	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g36187	i0	84.615	2.64948453608247	195	28	100	2	1	194	3877288	3877481	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	514	193	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18261372	18261372	PRJNA390533_P_NODE_35595_length_204_cov_1.969697_g34568_i0	PRJNA390533	35595	204	1.969697	4.01818188	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	158	3.67e-34	NTclustered	gi\|2893356047\|emb\|OZ220470.1\|	2793154	g34568	i0	84.431	42.1323529411765	167	19	80	6	21	184	2677800	2677638	MAG: Vicinamibacteria bacterium isolate 188da4bf-f1c8-4219-a28b-c38109137c31 genome assembly, chromosome: 1	blastn	8595	158	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
19535565	19535565	PRJNA390533_P_NODE_34936_length_209_cov_1.347059_g33909_i0	PRJNA390533	34936	209	1.347059	2.81535331	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	193	1.03e-44	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g33909	i0	83.254	19.7655502392345	209	35	100	0	1	209	2770584	2770792	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	4131	193	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22086251	22086251	PRJNA390533_P_NODE_38798_length_186_cov_1.673469_g37771_i0	PRJNA390533	38798	186	1.673469	3.11265234	Tunturiibacter psychrotolerans	3069686	Bacteria	Bacteria	89.8	1.21e-13	NTclustered	gi\|2750702178\|gb\|CP132942.1\|	3069686	g37771	i0	93.333	2.18817204301075	60	4	32	0	96	155	1805107	1805166	Tunturiibacter psychrotolerans strain X5P6 chromosome	blastn	407	89.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter psychrotolerans
24636229	24636229	PRJNA390533_P_NODE_43040_length_169_cov_1.184615_g42013_i0	PRJNA390533	43040	169	1.184615	2.00199935	Granulicella sp. 5B5	1617967	Bacteria	Bacteria	86.1	1.39e-12	NTclustered	gi\|1886125103\|gb\|CP046444.1\|	1617967	g42013	i0	83.696	8.69230769230769	92	13	54	2	79	169	2359447	2359537	Granulicella sp. 5B5 chromosome, complete genome	blastn	1469	86.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella sp. 5B5
24636244	24636244	PRJNA390533_P_NODE_44700_length_164_cov_0.976000_g43673_i0	PRJNA390533	44700	164	0.976	1.60064	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	161	2.1799999999999997e-35	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g43673	i0	85.443	1.76829268292683	158	19	95	3	1	156	345510	345665	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	290	161	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
24636293	24636293	PRJNA390533_P_NODE_50500_length_150_cov_1.828829_g49473_i0	PRJNA390533	50500	150	1.828829	2.7432435	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	75	2.61e-9	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g49473	i0	85.915	0.473333333333333	71	8	47	2	2	71	3715382	3715451	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	71	75	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);;