metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA1226487" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA1226487" 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
334994	334994	PRJNA1226487_P_NODE_59281_length_258_cov_1.664865_g59179_i0	PRJNA1226487	59281	258	1.664865	4.2953517	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	161	3.74e-35	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g59179	i0	80.275	2.47674418604651	218	40	84	3	34	250	1609140	1608925	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	639	161	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
335060	335060	PRJNA1226487_P_NODE_72081_length_245_cov_1.790698_g71979_i0	PRJNA1226487	72081	245	1.790698	4.3872101	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	161	3.52e-35	NTclustered	gi\|2893358450\|emb\|OZ220742.1\|	2651171	g71979	i0	78.776	2.05714285714286	245	48	99	4	1	243	385793	385551	MAG: Thermoanaerobaculia bacterium isolate 0db66e92-d31a-4200-8262-fff8455c21c0 genome assembly, chromosome: 1	blastn	504	161	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
1609541	1609541	PRJNA1226487_P_NODE_25722_length_333_cov_4.053846_g25620_i0	PRJNA1226487	25722	333	4.053846	13.49930718	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	372	2.12e-98	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g25620	i0	89.226	215.90990990991	297	32	89	0	32	328	3298459	3298163	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	71898	372	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
2885910	2885910	PRJNA1226487_P_NODE_52863_length_268_cov_1.579487_g52761_i0	PRJNA1226487	52863	268	1.579487	4.23302516	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	231	2.94e-56	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g52761	i0	82.51	16.0858208955224	263	46	98	0	6	268	5342063	5341801	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	4311	231	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
7988438	7988438	PRJNA1226487_P_NODE_66727_length_249_cov_1.750000_g66625_i0	PRJNA1226487	66727	249	1.75	4.3575	Luteitalea pratensis	1855912	Bacteria	Bacteria	158	4.639999999999999e-34	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g66625	i0	78.455	0.987951807228916	246	49	98	4	1	244	6255766	6256009	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	246	158	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
11813613	11813613	PRJNA1226487_P_NODE_50990_length_271_cov_1.555556_g50888_i0	PRJNA1226487	50990	271	1.555556	4.21555676	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	244	3.82e-60	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g50888	i0	83.026	3.74169741697417	271	44	99	2	2	271	1158256	1157987	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	1014	244	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
11813662	11813662	PRJNA1226487_P_NODE_66390_length_249_cov_3.011364_g66288_i0	PRJNA1226487	66390	249	3.011364	7.49829636	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	80.5	1.03e-10	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g66288	i0	92.727	0.220883534136546	55	4	22	0	30	84	3234669	3234723	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	55	80.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
13088650	13088650	PRJNA1226487_P_NODE_52971_length_268_cov_1.579487_g52869_i0	PRJNA1226487	52971	268	1.579487	4.23302516	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	206	1.7799999999999998e-48	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g52869	i0	80.827	49.7611940298507	266	47	99	4	5	268	1782673	1782410	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	13336	206	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
13088700	13088700	PRJNA1226487_P_NODE_62611_length_253_cov_1.711111_g62509_i0	PRJNA1226487	62611	253	1.711111	4.32911083	Luteitalea pratensis	1855912	Bacteria	Bacteria	285	2.08e-72	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g62509	i0	87.008	1.00395256916996	254	31	100	2	1	253	6251800	6251548	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	254	285	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
14363953	14363953	PRJNA1226487_P_NODE_47232_length_277_cov_1.509804_g47130_i0	PRJNA1226487	47232	277	1.509804	4.18215708	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	243	1.41e-59	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g47130	i0	83.146	3.62454873646209	267	43	96	2	12	277	2654799	2654534	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	1004	243	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
14363988	14363988	PRJNA1226487_P_NODE_54772_length_265_cov_1.604167_g54670_i0	PRJNA1226487	54772	265	1.604167	4.25104255	Luteitalea pratensis	1855912	Bacteria	Bacteria	187	6.3599999999999985e-43	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g54670	i0	79.693	0.984905660377358	261	51	98	2	1	260	4245532	4245791	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	261	187	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
15074431	15074431	PRJNA1226487_P_NODE_7092_length_497_cov_6.379717_g6995_i0	PRJNA1226487	7092	497	6.379717	31.70719349	Bacteria	2	Bacteria	Bacteria	337	1.2e-87	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g6995	i0	82.723	49.010060362173	382	62	76	2	49	428	4827420	4827041	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	24358	340	0.991176470588235	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18186406	18186406	PRJNA1226487_P_NODE_10375_length_441_cov_30.440217_g10275_i0	PRJNA1226487	10375	441	30.440217	134.24135697	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	468	3.57e-127	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g10275	i0	86.136	212.609977324263	440	53	99	8	1	436	3298598	3298163	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	93761	468	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
19460928	19460928	PRJNA1226487_P_NODE_40956_length_287_cov_1.439252_g40854_i0	PRJNA1226487	40956	287	1.439252	4.13065324	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	215	3.2e-51	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g40854	i0	81.853	6.25087108013937	259	44	90	3	12	268	1138538	1138281	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	1794	215	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19461024	19461024	PRJNA1226487_P_NODE_65376_length_250_cov_1.740113_g65274_i0	PRJNA1226487	65376	250	1.740113	4.3502825	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	237	5.82e-58	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g65274	i0	86.916	5.98	214	24	85	3	23	234	2567274	2567063	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	1495	237	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19461044	19461044	PRJNA1226487_P_NODE_70756_length_246_cov_1.780347_g70654_i0	PRJNA1226487	70756	246	1.780347	4.37965362	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	174	4.55e-39	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g70654	i0	79.916	20.1219512195122	239	46	97	2	9	246	1092169	1091932	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	4950	174	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20736416	20736416	PRJNA1226487_P_NODE_49157_length_274_cov_1.532338_g49055_i0	PRJNA1226487	49157	274	1.532338	4.19860612	Luteitalea pratensis	1855912	Bacteria	Bacteria	265	2.97e-66	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g49055	i0	84.307	1	274	39	99	4	2	273	4113143	4112872	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	274	265	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
24561070	24561070	PRJNA1226487_P_NODE_19820_length_361_cov_12.256944_g19718_i0	PRJNA1226487	19820	361	12.256944	44.24756784	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	584	2.73e-162	NTclustered	gi\|389546443\|gb\|JQ401371.1\|	171953	g19718	i0	97.118	95.9861495844875	347	9	96	1	1	347	346	1	Uncultured Acidobacteria bacterium clone CNY_01412 16S ribosomal RNA gene, partial sequence	blastn	34651	584	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24561183	24561183	PRJNA1226487_P_NODE_60560_length_256_cov_1.683060_g60458_i0	PRJNA1226487	60560	256	1.68306	4.3086336	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	200	7.85e-47	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g60458	i0	81.707	4.36328125	246	40	95	5	13	256	5649399	5649641	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	1117	200	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
25272957	25272957	PRJNA1226487_P_NODE_16480_length_383_cov_0.880645_g16378_i0	PRJNA1226487	16480	383	0.880645	3.37287035	Pseudomonadati	3379134	Bacteria	Bacteria	69.4	3.63e-7	NTclustered	gi\|2621785467\|emb\|OY781925.1\|	188475	g16378	i0	100	1.21932114882507	37	0	10	0	59	95	2756431	2756467	MAG: uncultured Holophaga sp. isolate 48fd71e5-2ffc-43bf-b6f5-ca4e00a42c30 genome assembly, chromosome: 1	blastn	467	69.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.

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