RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1041773" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1041773 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
27691000 27691000 PRJNA1041773_P_NODE_26024_length_408_cov_1.510448_g25693_i0 PRJNA1041773 26024 408 1.510448 6.16262784 Pseudomonadati 3379134 Bacteria Bacteria 188 1.9599999999999999e-54   NR HNV25104.1 70125 g25693 i0 69.6 2.02941176470588 138 40 100 1 1 408 130 267 HNV25104.1 hypothetical protein [Nitrospira sp.] diamond 828 189 0.994708994708995 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27817096 27817096 PRJNA1041773_P_NODE_48524_length_306_cov_2.879828_g48191_i0 PRJNA1041773 48524 306 2.879828 8.81227368 Pseudomonadati 3379134 Bacteria Bacteria 122 2.6e-33   NR HNA87647.1 70125 g48191 i0 62.9 3.80392156862745 97 36 95.1 0 15 305 1 97 HNA87647.1 lytic transglycosylase domain-containing protein [Nitrospira sp.] diamond 1164 122 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27856435 27856435 PRJNA1041773_P_NODE_86065_length_247_cov_1.511494_g85732_i0 PRJNA1041773 86065 247 1.511494 3.73339018 Nitrospira sp. OLB3 1617410 Bacteria Bacteria 79.3 4.32e-15   NR KXJ99137.1 1617410 g85732 i0 67.3 0.631578947368421 52 16 61.9 1 153 1 1 52 KXJ99137.1 MAG: Steroid C26-monooxygenase [Nitrospira sp. OLB3] diamond 156 79.3 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. OLB3
28266746 28266746 PRJNA1041773_P_NODE_72306_length_258_cov_2.064865_g71973_i0 PRJNA1041773 72306 258 2.064865 5.3273517 Nitrospira sp. 70125 Bacteria Bacteria 178 3.8e-53   NR HNC83900.1 70125 g71973 i0 96.5 0.988372093023256 85 3 98.8 0 2 256 158 242 HNC83900.1 conjugal transfer pilus assembly protein TraU [Nitrospira sp.] diamond 255 178 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28361567 28361567 PRJNA1041773_P_NODE_104106_length_232_cov_2.345912_g103773_i0 PRJNA1041773 104106 232 2.345912 5.44251584 Nitrospira sp. OLB3 1617410 Bacteria Bacteria 122 2.7599999999999996e-31   NR KXK01394.1 1617410 g103773 i0 72.4 1.96551724137931 76 21 98.3 0 230 3 165 240 KXK01394.1 MAG: hypothetical protein UZ03_NOB001002243 [Nitrospira sp. OLB3] diamond 456 122 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. OLB3
29017060 29017060 PRJNA1041773_P_NODE_100148_length_241_cov_1.375000_g99815_i0 PRJNA1041773 100148 241 1.375 3.31375 Pseudomonadati 3379134 Bacteria Bacteria 83.6 8.67e-17   NR MBP9636409.1 70125 g99815 i0 84.1 2.71369294605809 44 7 54.8 0 241 110 314 357 MBP9636409.1 hypothetical protein [Nitrospira sp.] diamond 654 83.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29561340 29561340 PRJNA1041773_P_NODE_103190_length_235_cov_4.358025_g102857_i0 PRJNA1041773 103190 235 4.358025 10.24135875 Nitrospira sp. 70125 Bacteria Bacteria 77.8 5.06e-16   NR HNV26290.1 70125 g102857 i0 71.7 0.676595744680851 53 15 67.7 0 2 160 62 114 HNV26290.1 hypothetical protein [Nitrospira sp.] diamond 159 77.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29805942 29805942 PRJNA1041773_P_NODE_6111_length_824_cov_1.774967_g5834_i0 PRJNA1041773 6111 824 1.774967 14.62572808 Pseudomonadati 3379134 Bacteria Bacteria 229 3.25e-68   NR HNV25104.1 70125 g5834 i0 77 1.0121359223301 139 32 50.6 0 3 419 367 505 HNV25104.1 hypothetical protein [Nitrospira sp.] diamond 834 229 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29813978 29813978 PRJNA1041773_P_NODE_29091_length_387_cov_2.315287_g28759_i0 PRJNA1041773 29091 387 2.315287 8.96016069 Nitrospira sp. 70125 Bacteria Bacteria 98.6 5.229999999999999e-24   NR HNV25107.1 70125 g28759 i0 58.4 1.37984496124031 89 33 65.9 1 272 18 1 89 HNV25107.1 hypothetical protein [Nitrospira sp.] diamond 534 98.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29845668 29845668 PRJNA1041773_P_NODE_39531_length_336_cov_3.285171_g39198_i0 PRJNA1041773 39531 336 3.285171 11.03817456 Nitrospirota bacterium 2026887 Bacteria Bacteria 230 3.2299999999999998e-74   NR MEW6248961.1 2026887 g39198 i0 100 1 112 0 100 0 336 1 79 190 MEW6248961.1 hypothetical protein [Nitrospirota bacterium] diamond 336 230 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30098285 30098285 PRJNA1041773_P_NODE_107192_length_199_cov_4.404762_g106859_i0 PRJNA1041773 107192 199 4.404762 8.76547638 Nitrospirota bacterium 2026887 Bacteria Bacteria 117 1.83e-32   NR MEW6248959.1 2026887 g106859 i0 98.4 0.949748743718593 63 1 95 0 11 199 1 63 MEW6248959.1 hypothetical protein [Nitrospirota bacterium] diamond 189 117 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30951662 30951662 PRJNA1041773_P_NODE_22274_length_440_cov_2.299728_g21944_i0 PRJNA1041773 22274 440 2.299728 10.1188032 Nitrospira sp. 70125 Bacteria Bacteria 203 1.5e-63   NR HNC83901.1 70125 g21944 i0 87.6 0.770454545454546 113 14 77 0 438 100 93 205 HNC83901.1 type-F conjugative transfer system protein TraW [Nitrospira sp.] diamond 339 203 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31203794 31203794 PRJNA1041773_P_NODE_104795_length_229_cov_3.108974_g104462_i0 PRJNA1041773 104795 229 3.108974 7.11955046 Nitrospira sp. 70125 Bacteria Bacteria 111 7.389999999999999e-30   NR HNV25106.1 70125 g104462 i0 64.5 0.995633187772926 76 27 99.6 0 1 228 20 95 HNV25106.1 glutaredoxin family protein [Nitrospira sp.] diamond 228 111 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31417609 31417609 PRJNA1041773_P_NODE_90756_length_245_cov_1.122093_g90423_i0 PRJNA1041773 90756 245 1.122093 2.74912785 Pseudomonadati 3379134 Bacteria Bacteria 137 1.75e-39   NR HNV26294.1 70125 g90423 i0 86.8 1.86122448979592 76 10 93.1 0 244 17 83 158 HNV26294.1 hypothetical protein [Nitrospira sp.] diamond 456 137 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31520693 31520693 PRJNA1041773_P_NODE_69836_length_262_cov_2.375661_g69503_i0 PRJNA1041773 69836 262 2.375661 6.22423182 Nitrospirota bacterium 2026887 Bacteria Bacteria 166 2.04e-49   NR MEW6248960.1 2026887 g69503 i0 97.7 0.99618320610687 87 2 99.6 0 2 262 21 107 MEW6248960.1 hypothetical protein [Nitrospirota bacterium] diamond 261 166 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
32026716 32026716 PRJNA1041773_P_NODE_43798_length_321_cov_1.951613_g43465_i0 PRJNA1041773 43798 321 1.951613 6.26467773 Nitrospira sp. 70125 Bacteria Bacteria 114 3.04e-29   NR HNC83901.1 70125 g43465 i0 72.5 0.747663551401869 80 22 74.8 0 77 316 4 83 HNC83901.1 type-F conjugative transfer system protein TraW [Nitrospira sp.] diamond 240 114 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32469872 32469872 PRJNA1041773_P_NODE_55579_length_288_cov_3.865116_g55246_i0 PRJNA1041773 55579 288 3.865116 11.13153408 Nitrospira sp. 70125 Bacteria Bacteria 147 4.18e-42   NR HNV26289.1 70125 g55246 i0 68.1 0.979166666666667 94 30 97.9 0 287 6 136 229 HNV26289.1 hypothetical protein [Nitrospira sp.] diamond 282 147 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.

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