RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA694557", tax_phylum = "Nitrospirota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 20 ✖

tax_phylum 1

  • Nitrospirota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA694557 · 20 ✖

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
4501493 4501493 PRJNA694557_P_NODE_5184_length_651_cov_4.896194_g4967_i0 PRJNA694557 5184 651 4.896194 31.87422294 Nitrospira sp. 70125 Bacteria Bacteria 241 7.33e-77   NR HBH78474.1 70125 g4967 i0 99.2 1.12442396313364 121 1 55.8 0 365 3 1 121 HBH78474.1 hypothetical protein [Nitrospira sp.] diamond 732 241 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
8326655 8326655 PRJNA694557_P_NODE_9787_length_437_cov_6.425824_g9567_i0 PRJNA694557 9787 437 6.425824 28.08085088 Nitrospira sp. 70125 Bacteria Bacteria 195 6.63e-45   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g9567 i0 77.545 1.55148741418764 334 67 76 7 88 418 2106048 2105720 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 678 195 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
9601948 9601948 PRJNA694557_P_NODE_6608_length_561_cov_3.735656_g6389_i0 PRJNA694557 6608 561 3.735656 20.95703016 Nitrospira sp. 70125 Bacteria Bacteria 638 3.3399999999999996e-178   NTclustered gi|2511635996|gb|CP126122.1| 70125 g6389 i0 87.636 1.96613190730838 550 67 98 1 11 560 1763665 1763117 MAG: Nitrospira sp. isolate bin_005 chromosome blastn 1103 638 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
14702242 14702242 PRJNA694557_P_NODE_16852_length_312_cov_1.924686_g16632_i0 PRJNA694557 16852 312 1.924686 6.00502032 Nitrospira sp. 70125 Bacteria Bacteria 204 5.44e-61   NR MCS6284387.1 70125 g16632 i0 100 3.69230769230769 96 0 92.3 0 24 311 393 488 MCS6284387.1 site-specific DNA-methyltransferase [Nitrospira sp.] diamond 1152 204 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
15976212 15976212 PRJNA694557_P_NODE_4353_length_724_cov_3.992320_g4142_i0 PRJNA694557 4353 724 3.99232 28.9043968 Nitrospira sp. 70125 Bacteria Bacteria 944 0   NTclustered gi|2194428397|gb|CP092079.1| 70125 g4142 i0 90.896 3.90883977900552 703 64 97 0 22 724 266445 265743 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 2830 944 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
17251170 17251170 PRJNA694557_P_NODE_18074_length_298_cov_4.275556_g17854_i0 PRJNA694557 18074 298 4.275556 12.74115688 Nitrospira sp. 70125 Bacteria Bacteria 198 3.3599999999999993e-46   NTclustered gi|2194428397|gb|CP092079.1| 70125 g17854 i0 86.932 1.27181208053691 176 23 59 0 25 200 3512202 3512377 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 379 198 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
26892960 26892960 PRJNA694557_P_NODE_19481_length_284_cov_2.066351_g19261_i0 PRJNA694557 19481 284 2.066351 5.86843684 Nitrospira sp. 70125 Bacteria Bacteria 65.5 1.94e-11   NR MCS6290368.1 70125 g19261 i0 38.7 0.792253521126761 75 39 79.2 2 58 282 1 68 MCS6290368.1 hypothetical protein [Nitrospira sp.] diamond 225 65.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27019317 27019317 PRJNA694557_P_NODE_16942_length_311_cov_1.802521_g16722_i0 PRJNA694557 16942 311 1.802521 5.60584031 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 213 4.299999999999999e-68   NR MBX9657885.1 2026770 g16722 i0 100 0.993569131832797 103 0 99.4 0 311 3 27 129 MBX9657885.1 hypothetical protein [Nitrospiraceae bacterium] diamond 309 213 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
27019318 27019318 PRJNA694557_P_NODE_20142_length_278_cov_1.502439_g19922_i0 PRJNA694557 20142 278 1.502439 4.17678042 Nitrospira sp. 70125 Bacteria Bacteria 161 5.14e-45   NR MDH4185517.1 70125 g19922 i0 80.7 1.89928057553957 88 17 95 0 4 267 99 186 MDH4185517.1 hypothetical protein [Nitrospira sp.] diamond 528 161 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27588205 27588205 PRJNA694557_P_NODE_4084_length_751_cov_6.281711_g3876_i0 PRJNA694557 4084 751 6.281711 47.17564961 Nitrospira sp. ST-bin5 1978765 Bacteria Bacteria 454 1.9599999999999993e-157   NR OQW63539.1 1978765 g3876 i0 97 0.922769640479361 231 7 92.3 0 714 22 1 231 OQW63539.1 MAG: hypothetical protein BVN29_15420 [Nitrospira sp. ST-bin5] diamond 693 454 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. ST-bin5
28377333 28377333 PRJNA694557_P_NODE_22006_length_262_cov_1.470899_g21786_i0 PRJNA694557 22006 262 1.470899 3.85375538 Nitrospiria bacterium 2306052 Bacteria Bacteria 80.1 3.26e-15   NR HTN42671.1 2306052 g21786 i0 68.5 2.0381679389313 54 15 59.5 1 161 6 113 166 HTN42671.1 carbamoyltransferase HypF [Nitrospiria bacterium] diamond 534 80.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria       Nitrospiria bacterium
29419242 29419242 PRJNA694557_P_NODE_7149_length_534_cov_2.394794_g6929_i0 PRJNA694557 7149 534 2.394794 12.78819996 Nitrospira cf. moscoviensis SBR1 96242 Bacteria Bacteria 224 2.12e-72   NR WP_087475600.1 96242 g6929 i0 89.7 2.20224719101124 116 12 65.2 0 362 15 1 116 WP_087475600.1 hypothetical protein [Nitrospira cf. moscoviensis SBR1015] diamond 1176 224 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira cf. moscoviensis SBR1015
29608456 29608456 PRJNA694557_P_NODE_18270_length_296_cov_2.883408_g18050_i0 PRJNA694557 18270 296 2.883408 8.53488768 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 49.3 3.21e-4   NR MBX9661110.1 2026770 g18050 i0 100 0.233108108108108 23 0 23.3 0 5 73 229 251 MBX9661110.1 hypothetical protein [Nitrospiraceae bacterium] diamond 69 49.3 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30304241 30304241 PRJNA694557_P_NODE_8392_length_482_cov_1.860636_g8172_i0 PRJNA694557 8392 482 1.860636 8.96826552 Nitrospira sp. 70125 Bacteria Bacteria 62.4 1.29e-8   NR MDI3463685.1 70125 g8172 i0 54.8 0.385892116182573 62 28 38.6 0 96 281 26 87 MDI3463685.1 hypothetical protein [Nitrospira sp.] diamond 186 62.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31156496 31156496 PRJNA694557_P_NODE_7275_length_528_cov_3.938462_g7055_i0 PRJNA694557 7275 528 3.938462 20.79507936 Nitrospira sp. BLG_1 3395883 Bacteria Bacteria 334 9.999999999999999e-110   NR WP_413936745.1 3395883 g7055 i0 95.3 1.92045454545455 169 8 96 0 528 22 109 277 WP_413936745.1 hypothetical protein [Nitrospira sp. BLG_1] diamond 1014 334 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. BLG_1
31188101 31188101 PRJNA694557_P_NODE_5215_length_649_cov_2.118056_g4998_i0 PRJNA694557 5215 649 2.118056 13.74618344 Nitrospira sp. 70125 Bacteria Bacteria 401 8.93e-138   NR MBS0156165.1 70125 g4998 i0 98.6 0.966101694915254 209 3 96.6 0 648 22 188 396 MBS0156165.1 replication initiator protein A [Nitrospira sp.] diamond 627 401 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31251586 31251586 PRJNA694557_P_NODE_23215_length_252_cov_1.910615_g22995_i0 PRJNA694557 23215 252 1.910615 4.8147498 Nitrospira sp. 70125 Bacteria Bacteria 136 2.65e-36   NR HBR51825.1 70125 g22995 i0 100 0.821428571428571 69 0 82.1 0 1 207 65 133 HBR51825.1 hypothetical protein [Nitrospira sp.] diamond 207 136 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31357973 31357973 PRJNA694557_P_NODE_20696_length_273_cov_1.995000_g20476_i0 PRJNA694557 20696 273 1.995 5.44635 Nitrospira 1234 Bacteria Bacteria 168 5.5e-50   NR MBL8054765.1 70125 g20476 i0 93.1 1.91208791208791 87 6 95.6 0 12 272 34 120 MBL8054765.1 hypothetical protein [Nitrospira sp.] diamond 522 168 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31536523 31536523 PRJNA694557_P_NODE_11436_length_397_cov_3.111111_g11216_i0 PRJNA694557 11436 397 3.111111 12.35111067 Nitrospira sp. 70125 Bacteria Bacteria 92 5.44e-19   NR HNP40719.1 70125 g11216 i0 64.5 0.468513853904282 62 22 46.9 0 396 211 167 228 HNP40719.1 AAA family ATPase [Nitrospira sp.] diamond 186 92 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32359158 32359158 PRJNA694557_P_NODE_21099_length_269_cov_2.678571_g20879_i0 PRJNA694557 21099 269 2.678571 7.20535599 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 90.5 1.41e-21   NR MBX9658028.1 2026770 g20879 i0 100 0.490706319702602 44 0 49.1 0 134 3 1 44 MBX9658028.1 hypothetical protein [Nitrospiraceae bacterium] diamond 132 90.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae 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);;