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

26 rows where analysis = "blastn", bioproject = "PRJNA900028" 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
874725	874725	PRJNA900028_P_NODE_143741_length_165_cov_0.879310_g142992_i0	PRJNA900028	143741	165	0.87931	1.4508615	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	213	5.98e-51	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g142992	i0	93.662	0.860606060606061	142	9	86	0	1	142	2540606	2540465	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	142	213	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
875153	875153	PRJNA900028_P_NODE_186721_length_161_cov_1.821429_g185972_i0	PRJNA900028	186721	161	1.821429	2.93250069	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	93.5	7.88e-15	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g185972	i0	80.469	0.795031055900621	128	19	78	6	32	156	3906387	3906263	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	128	93.5	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1244980	1244980	PRJNA900028_P_NODE_186261_length_162_cov_0.884956_g185512_i0	PRJNA900028	186261	162	0.884956	1.43362872	Luteitalea	2004797	Bacteria	Bacteria	202	1.26e-47	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g185512	i0	89.441	7.98765432098765	161	15	99	2	3	162	4171819	4171660	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	1294	202	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
4702944	4702944	PRJNA900028_P_NODE_11344_length_334_cov_1.382456_g10596_i0	PRJNA900028	11344	334	1.382456	4.61740304	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	241	6.26e-59	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g10596	i0	81.579	4.89520958083832	304	44	88	11	1	295	3019850	3020150	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	1635	241	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5978173	5978173	PRJNA900028_P_NODE_163425_length_164_cov_0.886957_g162676_i0	PRJNA900028	163425	164	0.886957	1.45460948	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	243	7.57e-60	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g162676	i0	93.293	8.99390243902439	164	11	100	0	1	164	6237502	6237665	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	1475	243	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7253547	7253547	PRJNA900028_P_NODE_32286_length_234_cov_2.151351_g31537_i0	PRJNA900028	32286	234	2.151351	5.03416134	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	180	9.21e-41	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g31537	i0	91.538	5.16666666666667	130	11	56	0	1	130	706755	706884	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	1209	180	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
8528620	8528620	PRJNA900028_P_NODE_63707_length_193_cov_1.583333_g62958_i0	PRJNA900028	63707	193	1.583333	3.05583269	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	255	1.18e-63	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g62958	i0	91.099	177.782383419689	191	14	98	3	1	190	2908724	2908912	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	34312	255	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8528724	8528724	PRJNA900028_P_NODE_72287_length_188_cov_1.467626_g71538_i0	PRJNA900028	72287	188	1.467626	2.75913688	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	93.5	9.49e-15	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g71538	i0	84.946	0.49468085106383	93	12	49	2	80	171	1378968	1378877	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	93	93.5	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9802815	9802815	PRJNA900028_P_NODE_169928_length_163_cov_0.894737_g169179_i0	PRJNA900028	169928	163	0.894737	1.45842131	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g169179	i0	100	0.171779141104294	28	0	17	0	76	103	1713369	1713396	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11078319	11078319	PRJNA900028_P_NODE_160709_length_164_cov_0.886957_g159960_i0	PRJNA900028	160709	164	0.886957	1.45460948	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	102	1.34e-17	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g159960	i0	80.142	1.22560975609756	141	25	85	3	25	164	4935141	4935279	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	201	102	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11078660	11078660	PRJNA900028_P_NODE_191249_length_161_cov_0.910714_g190500_i0	PRJNA900028	191249	161	0.910714	1.46624954	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	176	7.609999999999999e-40	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g190500	i0	86.709	3.27329192546584	158	21	98	0	1	158	2720172	2720329	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	527	176	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12353636	12353636	PRJNA900028_P_NODE_14890_length_300_cov_12.533865_g14141_i0	PRJNA900028	14890	300	12.533865	37.601595	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	333	8.900000000000001e-87	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g14141	i0	86.885	190.136666666667	305	30	100	9	1	300	15	314	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	57041	333	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12724807	12724807	PRJNA900028_P_NODE_3210_length_606_cov_1.754039_g2499_i0	PRJNA900028	3210	606	1.754039	10.62947634	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	941	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g2499	i0	95.571	137.338283828383	587	26	97	0	19	605	3298744	3299330	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	83227	941	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
13629839	13629839	PRJNA900028_P_NODE_85831_length_182_cov_1.533835_g85082_i0	PRJNA900028	85831	182	1.533835	2.7915797	Luteitalea pratensis	1855912	Bacteria	Bacteria	220	4.01e-53	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g85082	i0	88.462	2.00549450549451	182	21	100	0	1	182	4382785	4382604	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	365	220	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
14902525	14902525	PRJNA900028_P_NODE_130552_length_166_cov_1.307692_g129803_i0	PRJNA900028	130552	166	1.307692	2.17076872	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	291	2.7099999999999998e-74	NTclustered	gi\|76574295\|gb\|DQ139443.1\|	171953	g129803	i0	98.193	10.9036144578313	166	3	100	0	1	166	1227	1392	Uncultured Acidobacteria bacterium clone CAL2 23S ribosomal RNA gene, partial sequence	blastn	1810	291	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14902799	14902799	PRJNA900028_P_NODE_161292_length_164_cov_0.886957_g160543_i0	PRJNA900028	161292	164	0.886957	1.45460948	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	71.3	3.78e-8	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g160543	i0	93.617	0.676829268292683	47	3	29	0	32	78	1558454	1558500	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	111	71.3	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14902874	14902874	PRJNA900028_P_NODE_168552_length_163_cov_0.894737_g167803_i0	PRJNA900028	168552	163	0.894737	1.45842131	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	126	7.89e-25	NTclustered	gi\|2874253769\|emb\|OY969716.1\|	171953	g167803	i0	86.726	1.60122699386503	113	15	69	0	34	146	3646339	3646227	MAG: uncultured Acidobacteriota bacterium isolate MFD04540.bin.c.1 genome assembly, chromosome: 1	blastn	261	126	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16177607	16177607	PRJNA900028_P_NODE_163373_length_164_cov_0.886957_g162624_i0	PRJNA900028	163373	164	0.886957	1.45460948	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	135	1.32e-27	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g162624	i0	81.707	7.90853658536585	164	28	99	2	2	164	1059683	1059845	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	1297	135	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16177758	16177758	PRJNA900028_P_NODE_178153_length_162_cov_0.902655_g177404_i0	PRJNA900028	178153	162	0.902655	1.4623011	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	97.1	6.14e-16	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g177404	i0	91.549	1.51234567901235	71	4	43	2	93	162	5314812	5314743	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	245	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16178818	16178818	PRJNA900028_P_NODE_91733_length_180_cov_0.778626_g90984_i0	PRJNA900028	91733	180	0.778626	1.4015268	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	185	1.44e-42	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g90984	i0	86.127	62.15	173	22	96	2	3	174	1601997	1602168	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	11187	185	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
21276505	21276505	PRJNA900028_P_NODE_13077_length_316_cov_1.756554_g12329_i0	PRJNA900028	13077	316	1.756554	5.55071064	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	110	1.73e-19	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g12329	i0	73.846	18.3132911392405	325	64	99	18	3	316	3116382	3116696	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	5787	110	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
21277946	21277946	PRJNA900028_P_NODE_78577_length_185_cov_3.904412_g77828_i0	PRJNA900028	78577	185	3.904412	7.2231622	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	196	6.9e-46	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g77828	i0	85.946	11.1081081081081	185	25	99	1	2	185	3298183	3298367	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	2055	196	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
21278159	21278159	PRJNA900028_P_NODE_99257_length_176_cov_1.448819_g98508_i0	PRJNA900028	99257	176	1.448819	2.54992144	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	165	1.83e-36	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g98508	i0	83.523	1	176	29	100	0	1	176	1451398	1451223	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	176	165	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
22552158	22552158	PRJNA900028_P_NODE_24498_length_255_cov_0.951456_g23749_i0	PRJNA900028	24498	255	0.951456	2.4262128	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	82.4	2.95e-11	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g23749	i0	94.34	0.854901960784314	53	3	21	0	1	53	1813147	1813199	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	218	82.4	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
25101527	25101527	PRJNA900028_P_NODE_41240_length_219_cov_1.200000_g40491_i0	PRJNA900028	41240	219	1.2	2.628	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	148	2.4e-31	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g40491	i0	82.927	1.45662100456621	164	28	75	0	3	166	2837637	2837800	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	319	148	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
25101890	25101890	PRJNA900028_P_NODE_69460_length_189_cov_2.014286_g68711_i0	PRJNA900028	69460	189	2.014286	3.80700054	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	204	4.2299999999999997e-48	NTclustered	gi\|2874254120\|emb\|OY970205.1\|	194844	g68711	i0	86.17	3.05820105820106	188	26	99	0	2	189	1615568	1615381	MAG: uncultured Acidobacteriaceae bacterium isolate MFD02248.bin.1.24 genome assembly, chromosome: 1	blastn	578	204	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae 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);;