metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA558770" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA558770" 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
1815396	1815396	PRJNA558770_P_NODE_232882_length_234_cov_2.723618_g230877_i0	PRJNA558770	232882	234	2.723618	6.37326612	Geothrix oryzae	2927975	Bacteria	Bacteria	84.2	7.43e-12	NTclustered	gi\|2490888707\|dbj\|AP027079.1\|	2927975	g230877	i0	90.476	1.65811965811966	63	6	27	0	168	230	2397418	2397356	Geothrix oryzae Red222 DNA, complete genome	blastn	388	84.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix oryzae
6918220	6918220	PRJNA558770_P_NODE_260966_length_234_cov_2.080402_g258961_i0	PRJNA558770	260966	234	2.080402	4.86814068	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	73.1	1.61e-8	NTclustered	gi\|2874253980\|emb\|OY970305.1\|	194844	g258961	i0	93.75	0.205128205128205	48	3	21	0	17	64	282131	282178	MAG: uncultured Acidobacteriaceae bacterium isolate MFD03726.bin.c.10 genome assembly, chromosome: 1	blastn	48	73.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
8193942	8193942	PRJNA558770_P_NODE_322527_length_233_cov_8.166667_g320522_i0	PRJNA558770	322527	233	8.166667	19.02833411	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	75	4.45e-9	NTclustered	gi\|2874253769\|emb\|OY969716.1\|	171953	g320522	i0	85.915	1.10729613733906	71	9	30	1	4	74	1226556	1226487	MAG: uncultured Acidobacteriota bacterium isolate MFD04540.bin.c.1 genome assembly, chromosome: 1	blastn	258	75	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9467156	9467156	PRJNA558770_P_NODE_168048_length_234_cov_5.276382_g166043_i0	PRJNA558770	168048	234	5.276382	12.34673388	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	69.4	2.08e-7	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g166043	i0	86.154	0.277777777777778	65	7	27	2	171	234	643558	643495	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	65	69.4	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12017855	12017855	PRJNA558770_P_NODE_182930_length_234_cov_4.502513_g180925_i0	PRJNA558770	182930	234	4.502513	10.53588042	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	80.5	9.61e-11	NTclustered	gi\|2626289183\|emb\|OY843586.1\|	2052142	g180925	i0	95.918	0.414529914529915	49	2	21	0	15	63	925730	925778	MAG: Acidobacteriaceae bacterium isolate 6f8c9a11-1c30-45b4-a4a5-28695f68a2e2 genome assembly, chromosome: 1	blastn	97	80.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
12017878	12017878	PRJNA558770_P_NODE_183750_length_234_cov_4.467337_g181745_i0	PRJNA558770	183750	234	4.467337	10.45356858	Terriglobus albidus	1592106	Bacteria	Bacteria	135	2.02e-27	NTclustered	gi\|1724546188\|gb\|CP042806.1\|	1592106	g181745	i0	98.684	37.9017094017094	76	1	65	0	1	76	6047423	6047498	Terriglobus albidus strain ORNL chromosome, complete genome	blastn	8869	135	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus albidus
12019440	12019440	PRJNA558770_P_NODE_274510_length_234_cov_1.824121_g272505_i0	PRJNA558770	274510	234	1.824121	4.26844314	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	76.8	1.24e-9	NTclustered	gi\|2893356059\|emb\|OZ220482.1\|	2651171	g272505	i0	85.915	2.14102564102564	71	10	30	0	5	75	2089372	2089302	MAG: Thermoanaerobaculia bacterium isolate 1ba308f5-42e2-4878-81ff-2dc7ade272f8 genome assembly, chromosome: 1	blastn	501	76.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
13293633	13293633	PRJNA558770_P_NODE_225911_length_234_cov_2.919598_g223906_i0	PRJNA558770	225911	234	2.919598	6.83185932	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	67.6	7.48e-7	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g223906	i0	84.848	0.282051282051282	66	10	28	0	164	229	5969220	5969155	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	66	67.6	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
13294309	13294309	PRJNA558770_P_NODE_265971_length_234_cov_1.984925_g263966_i0	PRJNA558770	265971	234	1.984925	4.6447245	Chloracidobacterium aggregatum	2851959	Bacteria	Bacteria	58.4	4.5e-4	NTclustered	gi\|2033656783\|gb\|CP072646.1\|	2821542	g263966	i0	97.059	1.18803418803419	34	1	15	0	21	54	1998164	1998131	Chloracidobacterium sp. MS 40/45 chromosome 1, complete sequence	blastn	278	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium aggregatum
14568494	14568494	PRJNA558770_P_NODE_217532_length_234_cov_3.165829_g215527_i0	PRJNA558770	217532	234	3.165829	7.40803986	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	86.1	2.07e-12	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g215527	i0	88.571	0.581196581196581	70	8	30	0	162	231	2378520	2378451	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	136	86.1	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14568984	14568984	PRJNA558770_P_NODE_246572_length_234_cov_2.386935_g244567_i0	PRJNA558770	246572	234	2.386935	5.5854279	Paludibaculum fermentans	1473598	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g244567	i0	86	0.213675213675214	50	7	21	0	171	220	8925836	8925787	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	50	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
14571838	14571838	PRJNA558770_P_NODE_80152_length_235_cov_3.630000_g78147_i0	PRJNA558770	80152	235	3.63	8.5305	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g78147	i0	96.97	0.140425531914894	33	1	14	0	203	235	2636678	2636710	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	33	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
15841569	15841569	PRJNA558770_P_NODE_178733_length_234_cov_4.708543_g176728_i0	PRJNA558770	178733	234	4.708543	11.01799062	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g176728	i0	100	0.123931623931624	29	0	12	0	1	29	3742882	3742854	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15843023	15843023	PRJNA558770_P_NODE_261373_length_234_cov_2.070352_g259368_i0	PRJNA558770	261373	234	2.070352	4.84462368	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	71.3	5.79e-8	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g259368	i0	90.566	0.444444444444444	53	5	23	0	160	212	103317	103265	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	104	71.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
17117941	17117941	PRJNA558770_P_NODE_263194_length_234_cov_2.035176_g261189_i0	PRJNA558770	263194	234	2.035176	4.76231184	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	67.6	7.48e-7	NTclustered	gi\|2874253950\|emb\|OY970275.1\|	171953	g261189	i0	91.667	0.205128205128205	48	4	21	0	4	51	4348852	4348899	MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.c.2 genome assembly, chromosome: 1	blastn	48	67.6	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18392486	18392486	PRJNA558770_P_NODE_288655_length_234_cov_1.592965_g286650_i0	PRJNA558770	288655	234	1.592965	3.7275381	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	75	4.47e-9	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g286650	i0	92.308	0.222222222222222	52	4	22	0	11	62	8634549	8634600	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	52	75	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22216350	22216350	PRJNA558770_P_NODE_201218_length_234_cov_3.733668_g199213_i0	PRJNA558770	201218	234	3.733668	8.73678312	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	106	1.59e-18	NTclustered	gi\|2893358444\|emb\|OZ220736.1\|	2910147	g199213	i0	84.259	0.461538461538462	108	17	46	0	1	108	7025887	7025994	MAG: Vicinamibacterales bacterium isolate e96e4bd8-36b5-4932-a7c8-d2011ef2eb69 genome assembly, chromosome: 1	blastn	108	106	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
22219395	22219395	PRJNA558770_P_NODE_55098_length_283_cov_20.133065_g53094_i0	PRJNA558770	55098	283	20.133065	56.97657395	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	250	8.63e-62	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g53094	i0	96.078	60.4063604240283	153	6	82	0	83	235	3174632	3174480	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	17095	250	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
24766420	24766420	PRJNA558770_P_NODE_261060_length_234_cov_2.075377_g259055_i0	PRJNA558770	261060	234	2.075377	4.85638218	Granulicella sp. WH15	2602070	Bacteria	Bacteria	58.4	4.5e-4	NTclustered	gi\|1799576755\|gb\|CP042596.1\|	2602070	g259055	i0	94.737	0.162393162393162	38	1	16	1	17	53	2681390	2681353	Granulicella sp. WH15 chromosome, complete genome	blastn	38	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella sp. WH15

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