metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA379145" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA379145" 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
1675652	1675652	PRJNA379145_P_NODE_47302_length_249_cov_3.986111_g45149_i0	PRJNA379145	47302	249	3.986111	9.92541639	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	399	6.989999999999999e-107	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g45149	i0	95.582	77.0682730923695	249	11	100	0	1	249	200	448	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	19190	399	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4228037	4228037	PRJNA379145_P_NODE_38064_length_320_cov_9.874564_g35913_i0	PRJNA379145	38064	320	9.874564	31.5986048	Paludibaculum fermentans	1473598	Bacteria	Bacteria	405	1.9999999999999997e-108	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g35913	i0	89.688	160.415625	320	30	100	2	1	320	4784871	4784555	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	51333	405	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
5504196	5504196	PRJNA379145_P_NODE_15985_length_702_cov_26.156951_g14315_i0	PRJNA379145	15985	702	26.156951	183.62179602	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	1085	0	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g14315	i0	94.602	105.005698005698	704	33	99	4	1	701	3558062	3558763	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	73714	1085	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
5504690	5504690	PRJNA379145_P_NODE_61265_length_184_cov_2.072848_g59111_i0	PRJNA379145	61265	184	2.072848	3.81404032	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	291	3.05e-74	NTclustered	gi\|76574289\|gb\|DQ139437.1\|	171953	g59111	i0	95.109	301.157608695652	184	9	100	0	1	184	227	44	Uncultured Acidobacteria bacterium clone CAL8 23S ribosomal RNA gene, partial sequence	blastn	55413	291	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9328815	9328815	PRJNA379145_P_NODE_25348_length_489_cov_14.192982_g23313_i0	PRJNA379145	25348	489	14.192982	69.40368198	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	527	6.499999999999997e-145	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g23313	i0	86.207	313.928425357873	493	60	100	6	1	489	3298661	3298173	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	153511	527	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10604891	10604891	PRJNA379145_P_NODE_68009_length_164_cov_2.503817_g65855_i0	PRJNA379145	68009	164	2.503817	4.10625988	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	281	1.6000000000000001e-71	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g65855	i0	97.561	100.743902439024	164	4	100	0	1	164	9963	10126	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	16522	281	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11879865	11879865	PRJNA379145_P_NODE_65990_length_170_cov_1.080292_g63836_i0	PRJNA379145	65990	170	1.080292	1.8364964	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	261	2.1700000000000002e-65	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g63836	i0	94.706	10.6470588235294	170	6	99	2	2	170	360166	360333	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	1810	261	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
13154618	13154618	PRJNA379145_P_NODE_40531_length_298_cov_4.837736_g38380_i0	PRJNA379145	40531	298	4.837736	14.41645328	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	324	5.32e-84	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g38380	i0	86.333	236.255033557047	300	37	100	3	1	298	311	14	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	70404	324	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14429754	14429754	PRJNA379145_P_NODE_52332_length_221_cov_1.765957_g50178_i0	PRJNA379145	52332	221	1.765957	3.9027649700000002	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	231	2.34e-56	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g50178	i0	85.586	59.5701357466063	222	31	100	1	1	221	3298398	3298177	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	13165	231	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
15101809	15101809	PRJNA379145_P_NODE_26032_length_477_cov_25.317568_g23982_i0	PRJNA379145	26032	477	25.317568	120.76479936	Bacteria	2	Bacteria	Bacteria	754	0	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g23982	i0	95.551	104.79035639413	472	19	99	2	4	475	1019	550	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	49985	761	0.990801576872536	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15703500	15703500	PRJNA379145_P_NODE_31653_length_393_cov_24.333333_g29522_i0	PRJNA379145	31653	393	24.333333	95.62999869	Terriglobus roseus	392734	Bacteria	Bacteria	627	4.9099999999999996e-175	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g29522	i0	95.876	111.114503816794	388	15	99	1	6	393	927178	926792	Terriglobus roseus DSM 18391, complete genome	blastn	43668	627	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
15703693	15703693	PRJNA379145_P_NODE_50333_length_231_cov_7.333333_g48179_i0	PRJNA379145	50333	231	7.333333	16.93999923	Terriglobus roseus	392734	Bacteria	Bacteria	307	3.99e-79	NTclustered	gi\|1085637902\|emb\|LT629690.1\|	392734	g48179	i0	91.15	96.6103896103896	226	20	98	0	6	231	4807470	4807245	Terriglobus roseus strain GAS232 genome assembly, chromosome: I	blastn	22317	307	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
17651687	17651687	PRJNA379145_P_NODE_66774_length_167_cov_7.044776_g64620_i0	PRJNA379145	66774	167	7.044776	11.76477592	Bacteria	2	Bacteria	Bacteria	267	4.599999999999999e-67	NTclustered	gi\|219903990\|emb\|AM935729.1\|	194844	g64620	i0	95.758	97.3233532934132	165	7	99	0	3	167	63	227	Uncultured Acidobacteriaceae bacterium partial 16S rRNA gene, clone AMBC2	blastn	16253	267	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
18252415	18252415	PRJNA379145_P_NODE_30055_length_415_cov_4.591623_g27937_i0	PRJNA379145	30055	415	4.591623	19.05523545	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	231	4.78e-56	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g27937	i0	83.806	261.636144578313	247	36	59	4	171	415	3559054	3559298	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	108579	231	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
19526505	19526505	PRJNA379145_P_NODE_21516_length_561_cov_51.893939_g19596_i0	PRJNA379145	21516	561	51.893939	291.12499779	Alloacidobacterium dinghuense	2763107	Bacteria	Bacteria	664	0	NTclustered	gi\|1895675831\|gb\|CP060394.1\|	2763107	g19596	i0	88.214	115.238859180036	560	50	99	5	1	558	4008597	4008052	Alloacidobacterium dinghuense strain 4Y35 chromosome, complete genome	blastn	64649	664	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Alloacidobacterium	Alloacidobacterium dinghuense
19526984	19526984	PRJNA379145_P_NODE_66976_length_167_cov_1.611940_g64822_i0	PRJNA379145	66976	167	1.61194	2.6919398	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	84.2	4.97e-12	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g64822	i0	90.769	5.22155688622755	65	2	38	4	105	167	5712827	5712889	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	872	84.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
22077120	22077120	PRJNA379145_P_NODE_16438_length_688_cov_15.908397_g14743_i0	PRJNA379145	16438	688	15.908397	109.44977136	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	420	1.6299999999999995e-112	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g14743	i0	86.514	95.3691860465116	393	40	56	12	301	688	3557935	3558319	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	65614	420	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae 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);;