RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "diamond", bioproject = "PRJNA1061474" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 29 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1061474 · 29 ✖

analysis 1

  • diamond · 29 ✖

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
1453556 1453556 PRJNA1061474_P_NODE_49242_length_248_cov_0.880000_g48996_i0 PRJNA1061474 49242 248 0.88 2.1824 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 142 4.63e-37   NR MDA8079659.1 2026770 g48996 i0 82.9 1.98387096774194 82 14 99.2 0 1 246 680 761 MDA8079659.1 ATP-dependent Clp protease ATP-binding subunit [Nitrospiraceae bacterium] diamond 492 142 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
4005539 4005539 PRJNA1061474_P_NODE_56964_length_242_cov_0.875740_g56718_i0 PRJNA1061474 56964 242 0.87574 2.1192908 Nitrospirota bacterium 2026887 Bacteria Bacteria 151 1.76e-40   NR HTP03915.1 2026887 g56718 i0 91.3 0.991735537190083 80 7 99.2 0 240 1 618 697 HTP03915.1 PAS domain S-box protein [Nitrospirota bacterium] diamond 240 151 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
12490594 12490594 PRJNA1061474_P_NODE_46970_length_250_cov_0.870056_g46724_i0 PRJNA1061474 46970 250 0.870056 2.17514 Nitrospira sp. 70125 Bacteria Bacteria 91.3 3.45e-19   NR MCI0528671.1 70125 g46724 i0 55.4 1.992 83 37 99.6 0 1 249 659 741 MCI0528671.1 ATP-dependent chaperone ClpB [Nitrospira sp.] diamond 498 91.3 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
16755963 16755963 PRJNA1061474_P_NODE_55174_length_243_cov_0.905882_g54928_i0 PRJNA1061474 55174 243 0.905882 2.20129326 Candidatus Sulfobium mesophilum 2016548 Bacteria Bacteria 165 3.53e-48   NR SPQ01457.1 2016548 g54928 i0 96.3 11.8518518518519 80 3 98.8 0 3 242 101 180 SPQ01457.1 Tryptophan--tRNA ligase [Candidatus Sulfobium mesophilum] diamond 2880 165 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Candidatus Sulfobium Candidatus Sulfobium mesophilum
26592008 26592008 PRJNA1061474_P_NODE_51901_length_246_cov_0.890173_g51655_i0 PRJNA1061474 51901 246 0.890173 2.18982558 Nitrospirota bacterium 2026887 Bacteria Bacteria 122 2.81e-30   NR MBI5694323.1 2026887 g51655 i0 70.7 1 82 24 100 0 1 246 1235 1316 MBI5694323.1 hypothetical protein [Nitrospirota bacterium] diamond 246 122 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
26615544 26615544 PRJNA1061474_P_NODE_48701_length_248_cov_1.428571_g48455_i0 PRJNA1061474 48701 248 1.428571 3.54285608 Nitrospirota 40117 Bacteria Bacteria 139 6.86e-38   NR MBM4147236.1 70125 g48455 i0 70.4 10.875 81 24 98 0 4 246 209 289 MBM4147236.1 hypothetical protein [Nitrospira sp.] diamond 2697 140 0.992857142857143 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27216623 27216623 PRJNA1061474_P_NODE_52822_length_245_cov_0.895349_g52576_i0 PRJNA1061474 52822 245 0.895349 2.19360505 Bacteria 2 Bacteria Bacteria 58.5 5.94e-8   NR MDA8422167.1 2026770 g52576 i0 90 1.46938775510204 30 3 36.7 0 92 3 1 30 MDA8422167.1 gamma-glutamyl-gamma-aminobutyrate hydrolase family protein [Nitrospiraceae bacterium] diamond 360 58.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
27667498 27667498 PRJNA1061474_P_NODE_46604_length_250_cov_0.870056_g46358_i0 PRJNA1061474 46604 250 0.870056 2.17514 Nitrospirota bacterium 2026887 Bacteria Bacteria 158 6.92e-44   NR MCK9420702.1 2026887 g46358 i0 91.6 9.924 83 7 99.6 0 2 250 4 86 MCK9420702.1 uroporphyrinogen-III C-methyltransferase [Nitrospirota bacterium] diamond 2481 158 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
28172428 28172428 PRJNA1061474_P_NODE_56726_length_242_cov_0.911243_g56480_i0 PRJNA1061474 56726 242 0.911243 2.20520806 Nitrospirota bacterium 2026887 Bacteria Bacteria 148 1.03e-39   NR HUI68302.1 2026887 g56480 i0 96.3 2.97520661157025 80 3 99.2 0 240 1 26 105 HUI68302.1 DNA mismatch repair endonuclease MutL [Nitrospirota bacterium] diamond 720 148 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
28298723 28298723 PRJNA1061474_P_NODE_52146_length_246_cov_0.861272_g51900_i0 PRJNA1061474 52146 246 0.861272 2.11872912 Nitrospirae bacterium RBG_19FT_COMBO_55_12 1801710 Bacteria Bacteria 43.1 0.027   NR OGW52514.1 1801710 g51900 i0 61.8 0.414634146341463 34 13 41.5 0 2 103 372 405 OGW52514.1 MAG: hypothetical protein A2Z46_07490 [Nitrospirae bacterium RBG_19FT_COMBO_55_12] diamond 102 43.1 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirae bacterium RBG_19FT_COMBO_55_12
28740855 28740855 PRJNA1061474_P_NODE_50967_length_246_cov_1.693642_g50721_i0 PRJNA1061474 50967 246 1.693642 4.16635932 Thermodesulfovibrionales bacterium 2814272 Bacteria Bacteria 145 9.36e-42   NR HXX58468.1 2814272 g50721 i0 91.4 0.98780487804878 81 7 98.8 0 244 2 135 215 HXX58468.1 hypothetical protein [Thermodesulfovibrionales bacterium] diamond 243 145 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales     Thermodesulfovibrionales bacterium
28930354 28930354 PRJNA1061474_P_NODE_57348_length_241_cov_0.916667_g57102_i0 PRJNA1061474 57348 241 0.916667 2.20916747 Nitrospirota bacterium 2026887 Bacteria Bacteria 148 2.57e-41   NR MEK6743720.1 2026887 g57102 i0 89.9 0.983402489626556 79 8 98.3 0 5 241 131 209 MEK6743720.1 aminofutalosine synthase MqnE [Nitrospirota bacterium] diamond 237 148 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29214705 29214705 PRJNA1061474_P_NODE_41569_length_271_cov_1.348485_g41323_i0 PRJNA1061474 41569 271 1.348485 3.65439435 Nitrospira sp. 70125 Bacteria Bacteria 170 4.1399999999999994e-48   NR TKS62324.1 70125 g41323 i0 96.6 5.91143911439114 89 3 98.5 0 269 3 35 123 TKS62324.1 MAG: hypothetical protein EWM73_02587 [Nitrospira sp.] diamond 1602 170 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29309101 29309101 PRJNA1061474_P_NODE_48549_length_249_cov_0.875000_g48303_i0 PRJNA1061474 48549 249 0.875 2.17875 Nitrospira sp. 70125 Bacteria Bacteria 108 5.54e-26   NR WHZ26363.1 70125 g48303 i0 68.4 0.91566265060241 76 24 91.6 0 247 20 144 219 WHZ26363.1 MAG: hypothetical protein OJF51_001158 [Nitrospira sp.] diamond 228 108 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29427020 29427020 PRJNA1061474_P_NODE_57549_length_241_cov_0.916667_g57303_i0 PRJNA1061474 57549 241 0.916667 2.20916747 Bacteria 2 Bacteria Bacteria 59.3 5.16e-8   NR HAK61255.1 2026770 g57303 i0 58.8 1.29460580912863 51 21 63.5 0 160 8 1 51 HAK61255.1 hypothetical protein [Nitrospiraceae bacterium] diamond 312 59.3 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
29656069 29656069 PRJNA1061474_P_NODE_57450_length_241_cov_0.916667_g57204_i0 PRJNA1061474 57450 241 0.916667 2.20916747 Nitrospirota bacterium 2026887 Bacteria Bacteria 73.6 1.3e-14   NR MBI3605531.1 2026887 g57204 i0 85.4 0.510373443983402 41 6 51 0 118 240 1 41 MBI3605531.1 DsrE family protein [Nitrospirota bacterium] diamond 123 73.6 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29750955 29750955 PRJNA1061474_P_NODE_46811_length_250_cov_0.870056_g46565_i0 PRJNA1061474 46811 250 0.870056 2.17514 Nitrospirota bacterium 2026887 Bacteria Bacteria 105 2.13e-24   NR MEK6697840.1 2026887 g46565 i0 57.3 0.984 82 35 98.4 0 248 3 154 235 MEK6697840.1 EAL domain-containing protein [Nitrospirota bacterium] diamond 246 105 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29940883 29940883 PRJNA1061474_P_NODE_51671_length_246_cov_0.890173_g51425_i0 PRJNA1061474 51671 246 0.890173 2.18982558 Nitrospirota bacterium 2026887 Bacteria Bacteria 143 7.29e-38   NR HTG01033.1 2026887 g51425 i0 91.5 5 82 7 100 0 1 246 403 484 HTG01033.1 chemotaxis protein CheA [Nitrospirota bacterium] diamond 1230 143 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29940888 29940888 PRJNA1061474_P_NODE_57211_length_241_cov_0.916667_g56965_i0 PRJNA1061474 57211 241 0.916667 2.20916747 Nitrospirota bacterium 2026887 Bacteria Bacteria 141 1.2899999999999999e-38   NR MBS1232726.1 2026887 g56965 i0 82.5 0.995850622406639 80 14 99.6 0 241 2 284 363 MBS1232726.1 threonine dehydratase [Nitrospirota bacterium] diamond 240 141 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29972298 29972298 PRJNA1061474_P_NODE_56151_length_242_cov_0.911243_g55905_i0 PRJNA1061474 56151 242 0.911243 2.20520806 Nitrospirota bacterium 2026887 Bacteria Bacteria 139 2.96e-36   NR MCK9420522.1 2026887 g55905 i0 83.5 1.95867768595041 79 13 97.9 0 241 5 597 675 MCK9420522.1 hypothetical protein [Nitrospirota bacterium] diamond 474 139 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30153370 30153370 PRJNA1061474_P_NODE_49752_length_248_cov_0.880000_g49506_i0 PRJNA1061474 49752 248 0.88 2.1824 Nitrospirota 40117 Bacteria Bacteria 166 1.79e-49   NR SPQ01623.1 2016548 g49506 i0 93.9 2.9758064516129 82 5 99.2 0 248 3 139 220 SPQ01623.1 conserved membrane hypothetical protein [Candidatus Sulfobium mesophilum] diamond 738 166 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Candidatus Sulfobium Candidatus Sulfobium mesophilum
30951949 30951949 PRJNA1061474_P_NODE_49174_length_248_cov_0.880000_g48928_i0 PRJNA1061474 49174 248 0.88 2.1824 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 114 1.03e-27   NR HAM51289.1 2026770 g48928 i0 65.9 0.991935483870968 82 28 99.2 0 248 3 92 173 HAM51289.1 hypothetical protein [Nitrospiraceae bacterium] diamond 246 114 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
31489421 31489421 PRJNA1061474_P_NODE_50336_length_247_cov_0.885057_g50090_i0 PRJNA1061474 50336 247 0.885057 2.18609079 Thermodesulfovibrionales bacterium 2814272 Bacteria Bacteria 117 2.11e-30   NR HYA31747.1 2814272 g50090 i0 85.5 0.838056680161943 69 10 83.8 0 207 1 1 69 HYA31747.1 formate dehydrogenase accessory protein FdhE [Thermodesulfovibrionales bacterium] diamond 207 117 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales     Thermodesulfovibrionales bacterium
31575932 31575932 PRJNA1061474_P_NODE_47896_length_249_cov_0.875000_g47650_i0 PRJNA1061474 47896 249 0.875 2.17875 Pseudomonadati 3379134 Bacteria Bacteria 47 0.00118   NR PIU79268.1 1974067 g47650 i0 59.5 1.36144578313253 37 15 44.6 0 247 137 276 312 PIU79268.1 MAG: outer membrane lipoprotein-sorting protein [Nitrospirae bacterium CG06_land_8_20_14_3_00_70_43] diamond 339 47 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirae bacterium CG06_land_8_20_14_3_00_70_43
31710607 31710607 PRJNA1061474_P_NODE_49777_length_248_cov_0.868571_g49531_i0 PRJNA1061474 49777 248 0.868571 2.15405608 Nitrospirota bacterium 2026887 Bacteria Bacteria 157 3.96e-46   NR HET6363747.1 2026887 g49531 i0 98.8 0.991935483870968 82 1 99.2 0 246 1 40 121 HET6363747.1 ABC transporter permease [Nitrospirota bacterium] diamond 246 157 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
31742087 31742087 PRJNA1061474_P_NODE_46217_length_251_cov_0.865169_g45971_i0 PRJNA1061474 46217 251 0.865169 2.17157419 Nitrospira sp. 70125 Bacteria Bacteria 170 1.8700000000000002e-49   NR TKB74909.1 70125 g45971 i0 92.8 0.99203187250996006 83 6 99.2 0 250 2 283 365 TKB74909.1 MAG: glycosyltransferase family 4 protein [Nitrospira sp.] diamond 249 170 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32090249 32090249 PRJNA1061474_P_NODE_55418_length_243_cov_0.905882_g55172_i0 PRJNA1061474 55418 243 0.905882 2.20129326 Nitrospirota bacterium 2026887 Bacteria Bacteria 147 4.51e-44   NR MBS1125939.1 2026887 g55172 i0 93.8 6 81 5 100 0 1 243 9 89 MBS1125939.1 rpsG [Nitrospirota bacterium] diamond 1458 147 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
32248765 32248765 PRJNA1061474_P_NODE_51438_length_246_cov_0.890173_g51192_i0 PRJNA1061474 51438 246 0.890173 2.18982558 Nitrospirota bacterium 2026887 Bacteria Bacteria 126 2.29e-35   NR MBI4699474.1 2026887 g51192 i0 71.6 0.98780487804878 81 23 98.8 0 246 4 3 83 MBI4699474.1 DUF86 domain-containing protein [Nitrospirota bacterium] diamond 243 126 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
32690641 32690641 PRJNA1061474_P_NODE_51700_length_246_cov_0.890173_g51454_i0 PRJNA1061474 51700 246 0.890173 2.18982558 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 79.7 3.45e-16   NR MDA8422781.1 2026770 g51454 i0 65.4 0.634146341463415 52 18 63.4 0 1 156 146 197 MDA8422781.1 DedA family protein [Nitrospiraceae bacterium] diamond 156 79.7 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);;