RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA917598" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA917598 · 14 ✖

analysis 1

  • blastn · 14 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
896033 896033 PRJNA917598_P_NODE_43681_length_347_cov_2.386861_g42737_i0 PRJNA917598 43681 347 2.386861 8.28240767 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 451 2.77e-122   NTclustered gi|2874254027|emb|OY970352.1| 171953 g42737 i0 90.23 67.9567723342939 348 31 100 3 1 347 2366886 2367231 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 23581 451 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
896232 896232 PRJNA917598_P_NODE_51901_length_317_cov_2.405738_g50957_i0 PRJNA917598 51901 317 2.405738 7.62618946 Acidobacteriota bacterium 1978231 Bacteria Bacteria 296 1.24e-75   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g50957 i0 83.75 4.54574132492114 320 44 100 6 1 317 3631571 3631885 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 1441 296 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
1251240 1251240 PRJNA917598_P_NODE_28401_length_432_cov_2.108635_g27457_i0 PRJNA917598 28401 432 2.108635 9.1093032 Pseudomonadati 3379134 Bacteria Bacteria 150 1.44e-31   NTclustered gi|2874254108|emb|OY970193.1| 171953 g27457 i0 92.381 52.6712962962963 105 8 56 0 6 110 1689493 1689389 MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1 blastn 22754 150 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
3447600 3447600 PRJNA917598_P_NODE_71203_length_269_cov_1.913265_g70259_i0 PRJNA917598 71203 269 1.913265 5.14668285 Acidobacteriota bacterium 1978231 Bacteria Bacteria 134 8.55e-27   NTclustered gi|1958085512|gb|CP065000.1| 1978231 g70259 i0 77.447 1.44237918215613 235 45 87 8 37 269 3097157 3097385 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome blastn 388 134 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
13649618 13649618 PRJNA917598_P_NODE_42191_length_353_cov_2.689286_g41247_i0 PRJNA917598 42191 353 2.689286 9.49317958 Acidobacteriota bacterium 1978231 Bacteria Bacteria 274 6.54e-69   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g41247 i0 80.899 2.01983002832861 356 61 100 7 1 353 3631884 3631533 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 713 274 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
17474321 17474321 PRJNA917598_P_NODE_45394_length_340_cov_3.726592_g44450_i0 PRJNA917598 45394 340 3.726592 12.6704128 Acidobacteriota bacterium 1978231 Bacteria Bacteria 141 6.66e-29   NTclustered gi|1958085512|gb|CP065000.1| 1978231 g44450 i0 75.141 1.42647058823529 354 61 100 21 1 340 1524035 1523695 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome blastn 485 141 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
17474402 17474402 PRJNA917598_P_NODE_48414_length_329_cov_3.039062_g47470_i0 PRJNA917598 48414 329 3.039062 9.99851398 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 148 3.8399999999999998e-31   NTclustered gi|2874253885|emb|OY970060.1| 171953 g47470 i0 78.333 2.07598784194529 240 44 72 6 90 327 4746753 4746520 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 blastn 683 148 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
17475038 17475038 PRJNA917598_P_NODE_74974_length_261_cov_1.638298_g74030_i0 PRJNA917598 74974 261 1.638298 4.27595778 Acidobacteriota bacterium 1978231 Bacteria Bacteria 361 3.48e-95   NTclustered gi|1958093598|gb|CP065003.1| 1978231 g74030 i0 91.571 227.505747126437 261 22 100 0 1 261 320616 320876 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome blastn 59379 361 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
18747787 18747787 PRJNA917598_P_NODE_48555_length_329_cov_1.269531_g47611_i0 PRJNA917598 48555 329 1.269531 4.17675699 Acidobacteriota bacterium 1978231 Bacteria Bacteria 300 1e-76   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g47611 i0 85.05 3.1306990881459 301 37 90 6 34 329 1401856 1402153 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 1030 300 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
18748283 18748283 PRJNA917598_P_NODE_67995_length_276_cov_1.418719_g67051_i0 PRJNA917598 67995 276 1.418719 3.91566444 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 444 3.58e-120   NTclustered gi|2874254027|emb|OY970352.1| 171953 g67051 i0 95.652 763.351449275362 276 12 100 0 1 276 2365927 2365652 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 210685 444 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
19103070 19103070 PRJNA917598_P_NODE_7115_length_904_cov_5.978339_g6327_i0 PRJNA917598 7115 904 5.978339 54.04418456 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 1162 0   NTclustered gi|2874254027|emb|OY970352.1| 171953 g6327 i0 90.088 98.9159292035398 908 72 100 14 1 904 2367723 2366830 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 89420 1173 0.990622335890878 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
20023664 20023664 PRJNA917598_P_NODE_81816_length_250_cov_0.870056_g80872_i0 PRJNA917598 81816 250 0.870056 2.17514 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 154 6.03e-33   NTclustered gi|2874253710|emb|OY969475.1| 2283092 g80872 i0 85.235 32.404 149 22 60 0 3 151 2708876 2708728 MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1 blastn 8101 154 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
21299099 21299099 PRJNA917598_P_NODE_86957_length_246_cov_1.965318_g86013_i0 PRJNA917598 86957 246 1.965318 4.83468228 Acidobacteriota bacterium 1978231 Bacteria Bacteria 93.5 1.31e-14   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g86013 i0 85.556 0.943089430894309 90 11 36 2 131 219 1402076 1402164 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 232 93.5 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
25122236 25122236 PRJNA917598_P_NODE_48120_length_330_cov_2.797665_g47176_i0 PRJNA917598 48120 330 2.797665 9.2322945 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 198 3.769999999999999e-46   NTclustered gi|2874253710|emb|OY969475.1| 2283092 g47176 i0 79.72 9.98484848484848 286 48 96 5 1 278 3427666 3427383 MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1 blastn 3295 198 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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