RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA879221" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA879221 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
857290 857290 PRJNA879221_P_NODE_59621_length_243_cov_1.694118_g59481_i0 PRJNA879221 59621 243 1.694118 4.11670674 Chthoniobacteraceae bacterium 2811408 Bacteria Bacteria 112 8.410000000000001e-27   NR MEQ1850051.1 2811408 g59481 i0 66.3 0.987654320987654 80 27 98.8 0 241 2 1286 1365 MEQ1850051.1 MG2 domain-containing protein [Chthoniobacteraceae bacterium] diamond 240 112 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales Chthoniobacteraceae   Chthoniobacteraceae bacterium
26865723 26865723 PRJNA879221_P_NODE_56021_length_246_cov_0.872832_g55881_i0 PRJNA879221 56021 246 0.872832 2.14716672 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 117 7.66e-29   NR MES2466076.1 2026799 g55881 i0 71.6 0.98780487804878 81 23 98.8 0 245 3 137 217 MES2466076.1 O-antigen ligase family protein [Verrucomicrobiota bacterium] diamond 243 117 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27308340 27308340 PRJNA879221_P_NODE_57123_length_245_cov_0.895349_g56983_i0 PRJNA879221 57123 245 0.895349 2.19360505 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 129 7.09e-33   NR MDB6071178.1 2026801 g56983 i0 90.1 0.991836734693878 81 8 99.2 0 1 243 294 374 MDB6071178.1 glxR 1 [Verrucomicrobiales bacterium] diamond 243 129 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
28516132 28516132 PRJNA879221_P_NODE_37427_length_286_cov_1.192488_g37287_i0 PRJNA879221 37427 286 1.192488 3.41051568 Bacteria 2 Bacteria Bacteria 133 1.05e-33   NR MFM2199721.1 2026799 g37287 i0 61.7 1.96153846153846 94 36 98.6 0 284 3 77 170 MFM2199721.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 561 133 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28666037 28666037 PRJNA879221_P_NODE_51547_length_248_cov_0.880000_g51407_i0 PRJNA879221 51547 248 0.88 2.1824 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 43.1 0.0287   NR MCP5541041.1 2562705 g51407 i0 82.6 0.278225806451613 23 4 27.8 0 40 108 524 546 MCP5541041.1 transposase [Akkermansiaceae bacterium] diamond 69 43.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
28799988 28799988 PRJNA879221_P_NODE_51067_length_248_cov_0.880000_g50927_i0 PRJNA879221 51067 248 0.88 2.1824 Lacunisphaera 1961799 Bacteria Bacteria 116 1.59e-30   NR HKB57571.1 1961806 g50927 i0 65.9 1.98387096774194 82 28 99.2 0 3 248 71 152 HKB57571.1 sigma-70 family RNA polymerase sigma factor [Lacunisphaera sp.] diamond 492 116 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Lacunisphaera Lacunisphaera sp.
28981867 28981867 PRJNA879221_P_NODE_53008_length_247_cov_0.885057_g52868_i0 PRJNA879221 53008 247 0.885057 2.18609079 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 85.1 4.27e-17   NR MCU0780393.1 2562705 g52868 i0 48.1 2.95141700404858 81 42 98.4 0 245 3 113 193 MCU0780393.1 BamA/TamA family outer membrane protein [Akkermansiaceae bacterium] diamond 729 85.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
29423466 29423466 PRJNA879221_P_NODE_60589_length_243_cov_0.905882_g60449_i0 PRJNA879221 60589 243 0.905882 2.20129326 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 122 1.33e-33   NR MEY4485144.1 2026799 g60449 i0 92.4 0.814814814814815 66 5 81.5 0 241 44 67 132 MEY4485144.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 198 122 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29612780 29612780 PRJNA879221_P_NODE_55210_length_246_cov_0.890173_g55070_i0 PRJNA879221 55210 246 0.890173 2.18982558 Verrucomicrobium sp. 72225 Bacteria Bacteria 147 4.12e-41   NR MEZ0389366.1 72225 g55070 i0 81.5 1.98780487804878 81 15 98.8 0 243 1 225 305 MEZ0389366.1 DUF3500 domain-containing protein [Verrucomicrobium sp.] diamond 489 147 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Verrucomicrobium Verrucomicrobium sp.
29992171 29992171 PRJNA879221_P_NODE_60711_length_243_cov_0.905882_g60571_i0 PRJNA879221 60711 243 0.905882 2.20129326 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 61.6 8.59e-9   NR MCE9520108.1 2026799 g60571 i0 71.6 1 81 23 100 0 1 243 107 187 MCE9520108.1 chromosome segregation protein SMC [Verrucomicrobiota bacterium] diamond 243 61.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30750475 30750475 PRJNA879221_P_NODE_64594_length_241_cov_0.916667_g64454_i0 PRJNA879221 64594 241 0.916667 2.20916747 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 87.4 1.79e-19   NR MEI6534364.1 2026800 g64454 i0 81.8 0.547717842323652 44 8 54.8 0 2 133 112 155 MEI6534364.1 hypothetical protein [Verrucomicrobiaceae bacterium] diamond 132 87.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
31003227 31003227 PRJNA879221_P_NODE_60034_length_243_cov_0.905882_g59894_i0 PRJNA879221 60034 243 0.905882 2.20129326 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 94 3.24e-20   NR MES2705122.1 2026799 g59894 i0 61.3 0.987654320987654 80 31 98.8 0 3 242 37 116 MES2705122.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 240 94 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31043121 31043121 PRJNA879221_P_NODE_59035_length_244_cov_0.900585_g58895_i0 PRJNA879221 59035 244 0.900585 2.1974274 Prosthecobacter 48463 Bacteria Bacteria 151 6.85e-44   NR WP_300932137.1 1965333 g58895 i0 92.6 1.99180327868852 81 6 99.6 0 2 244 54 134 WP_300932137.1 HpcH/HpaI aldolase family protein [Prosthecobacter sp.] diamond 486 151 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
31477522 31477522 PRJNA879221_P_NODE_50576_length_249_cov_0.875000_g50436_i0 PRJNA879221 50576 249 0.875 2.17875 Lacunisphaera sp. 1961806 Bacteria Bacteria 135 9.779999999999996e-35   NR HEX7631115.1 1961806 g50436 i0 84.1 0.987951807228916 82 13 98.8 0 3 248 510 591 HEX7631115.1 L-glutamate gamma-semialdehyde dehydrogenase [Lacunisphaera sp.] diamond 246 135 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Lacunisphaera Lacunisphaera sp.
31477528 31477528 PRJNA879221_P_NODE_61716_length_242_cov_0.911243_g61576_i0 PRJNA879221 61716 242 0.911243 2.20520806 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 147 1.02e-39   NR MEY4484604.1 2026799 g61576 i0 98.8 0.991735537190083 80 1 99.2 0 3 242 483 562 MEY4484604.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 240 147 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31635451 31635451 PRJNA879221_P_NODE_46976_length_251_cov_0.865169_g46836_i0 PRJNA879221 46976 251 0.865169 2.17157419 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 58.2 5.85e-9   NR MCX6873948.1 2026799 g46836 i0 96.4 0.334661354581673 28 1 33.5 0 168 251 1 28 MCX6873948.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 84 58.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32078395 32078395 PRJNA879221_P_NODE_57378_length_245_cov_0.895349_g57238_i0 PRJNA879221 57378 245 0.895349 2.19360505 Prosthecobacter sp. 1965333 Bacteria Bacteria 87.8 7.790000000000001e-21   NR MDP1587501.1 1965333 g57238 i0 87.5 0.587755102040816 48 6 58.8 0 245 102 18 65 MDP1587501.1 CsbD family protein [Prosthecobacter sp.] diamond 144 87.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
32205043 32205043 PRJNA879221_P_NODE_46018_length_251_cov_0.865169_g45878_i0 PRJNA879221 46018 251 0.865169 2.17157419 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 158 6.63e-48   NR MEY4485222.1 2026799 g45878 i0 85.5 0.99203187250996006 83 12 99.2 0 251 3 1 83 MEY4485222.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 249 158 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32804936 32804936 PRJNA879221_P_NODE_51240_length_248_cov_0.880000_g51100_i0 PRJNA879221 51240 248 0.88 2.1824 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 68.2 4.51e-11   NR MES2709103.1 2026799 g51100 i0 45.9 0.895161290322581 74 35 83.5 1 42 248 1297 1370 MES2709103.1 RHS repeat-associated core domain-containing protein [Verrucomicrobiota bacterium] diamond 222 68.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota 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);;