RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA493244" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA493244 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
4283123 4283123 PRJNA493244_P_NODE_1608944_length_218_cov_3.133758_g1585819_i0 PRJNA493244 1608944 218 3.133758 6.83159244 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 63.9 8.9e-6   NTclustered gi|2108314823|gb|CP070670.1| 2026742 g1585819 i0 90 0.871559633027523 50 4 22 1 169 217 907223 907174 MAG: Gemmatimonadetes bacterium isolate bin741 chromosome blastn 190 63.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
5559110 5559110 PRJNA493244_P_NODE_1391725_length_270_cov_4.779904_g1368600_i0 PRJNA493244 1391725 270 4.779904 12.9057408 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 276 1.35e-69   NTclustered gi|2874253728|emb|OY969570.1| 412054 g1368600 i0 88.066 132.237037037037 243 16 87 10 1 236 173231 172995 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 35704 276 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
8110986 8110986 PRJNA493244_P_NODE_998467_length_407_cov_7.468208_g975382_i0 PRJNA493244 998467 407 7.468208 30.39560656 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 331 4.48e-86   NTclustered gi|575456455|gb|CP007128.1| 861299 g975382 i0 82.487 65.3660933660934 394 53 95 14 17 402 3042420 3042805 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 26604 331 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
10659140 10659140 PRJNA493244_P_NODE_1331109_length_287_cov_10.057522_g1307985_i0 PRJNA493244 1331109 287 10.057522 28.86508814 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 350 8.400000000000001e-92   NTclustered gi|2874253728|emb|OY969570.1| 412054 g1307985 i0 90.53 95.7839721254355 264 25 92 0 24 287 3132722 3132459 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 27490 350 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
13208963 13208963 PRJNA493244_P_NODE_1253571_length_311_cov_2.264000_g1230447_i0 PRJNA493244 1253571 311 2.264 7.04104 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 357 5.5e-94   NTclustered gi|575456455|gb|CP007128.1| 861299 g1230447 i0 87.46 107.389067524116 311 37 99 2 2 311 3649367 3649058 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 33398 357 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
15758844 15758844 PRJNA493244_P_NODE_1642393_length_211_cov_4.100000_g1619268_i0 PRJNA493244 1642393 211 4.1 8.651 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 143 1.07e-29   NTclustered gi|2874253978|emb|OY970303.1| 412054 g1619268 i0 81.818 1.61137440758294 176 26 82 5 3 175 363592 363764 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 340 143 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
15759045 15759045 PRJNA493244_P_NODE_1707073_length_203_cov_0.901408_g1683948_i0 PRJNA493244 1707073 203 0.901408 1.82985824 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 84.2 6.27e-12   NTclustered gi|575456455|gb|CP007128.1| 861299 g1683948 i0 86.667 0.881773399014778 75 10 37 0 10 84 1880161 1880087 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 179 84.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
15760414 15760414 PRJNA493244_P_NODE_908253_length_449_cov_10.353093_g885282_i0 PRJNA493244 908253 449 10.353093 46.48538757 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 387 1.05e-102   NTclustered gi|2874253728|emb|OY969570.1| 412054 g885282 i0 84.119 4.07349665924276 403 61 90 3 43 444 1090623 1091023 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 1829 387 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
18951455 18951455 PRJNA493244_P_NODE_1648635_length_210_cov_1.778523_g1625510_i0 PRJNA493244 1648635 210 1.778523 3.7348983 Gemmatimonas 173479 Bacteria Bacteria 320 4.58e-83   NTclustered gi|470475286|ref|NR_076270.1| 173480 g1625510 i0 97.34 43.6857142857143 188 5 90 0 23 210 1 188 Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence blastn 9174 322 0.993788819875776 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
20857178 20857178 PRJNA493244_P_NODE_1393677_length_270_cov_1.545455_g1370552_i0 PRJNA493244 1393677 270 1.545455 4.1727285 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 305 1.72e-78   NTclustered gi|2874253789|emb|OY969773.1| 412054 g1370552 i0 90.254 61.7222222222222 236 20 87 2 1 235 423501 423734 MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 blastn 16665 305 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales 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);;