RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA195897" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA195897 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
26902074 26902074 PRJNA195897_P_NODE_8441_length_173_cov_1.443548_g8408_i0 PRJNA195897 8441 173 1.443548 2.49733804 Bacteria 2 Bacteria Bacteria 52 8.91e-7   NR MDE1172013.1 72225 g8408 i0 51 5.09826589595376 49 22 85 1 24 170 36 82 MDE1172013.1 co-chaperone GroES [Verrucomicrobium sp.] diamond 882 52.4 0.99236641221374 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Verrucomicrobium Verrucomicrobium sp.
27231963 27231963 PRJNA195897_P_NODE_1243_length_476_cov_1.421546_g1212_i0 PRJNA195897 1243 476 1.421546 6.76655896 Limisphaerales bacterium 2052186 Bacteria Bacteria 53.1 9.85e-5   NR MFN3408655.1 2052186 g1212 i0 34.6 1.51890756302521 81 50 49.2 3 4 237 169 249 MFN3408655.1 LamG-like jellyroll fold domain-containing protein [Limisphaerales bacterium] diamond 723 53.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Limisphaerales     Limisphaerales bacterium
27926782 27926782 PRJNA195897_P_NODE_7085_length_187_cov_1.130435_g7052_i0 PRJNA195897 7085 187 1.130435 2.11391345 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 52 9.81e-6   NR MBI97544.1 2026801 g7052 i0 43.1 3.85026737967914 58 32 93 1 7 180 393 449 MBI97544.1 hypothetical protein [Verrucomicrobiales bacterium] diamond 720 52 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
28273959 28273959 PRJNA195897_P_NODE_6286_length_196_cov_1.333333_g6253_i0 PRJNA195897 6286 196 1.333333 2.61333268 Chthoniobacter sp. 2510640 Bacteria Bacteria 61.2 5.44e-9   NR HEY3900240.1 2510640 g6253 i0 66.7 0.596938775510204 39 13 59.7 0 80 196 6 44 HEY3900240.1 NAD(P)-dependent alcohol dehydrogenase [Chthoniobacter sp.] diamond 117 61.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales Chthoniobacteraceae Chthoniobacter Chthoniobacter sp.
28558407 28558407 PRJNA195897_P_NODE_327_length_910_cov_1.786295_g303_i0 PRJNA195897 327 910 1.786295 16.2552845 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 75.9 1.77e-11   NR NBR85892.1 2026799 g303 i0 32.3 0.989010989010989 300 157 95.9 13 897 25 25 287 NBR85892.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 900 75.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28653015 28653015 PRJNA195897_P_NODE_3447_length_262_cov_1.225352_g3414_i0 PRJNA195897 3447 262 1.225352 3.21042224 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 112 1.63e-28   NR TAE91423.1 2026799 g3414 i0 72.1 7.86641221374046 68 19 77.9 0 209 6 4 71 TAE91423.1 MAG: pirin family protein [Verrucomicrobiota bacterium] diamond 2061 112 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28716210 28716210 PRJNA195897_P_NODE_447_length_801_cov_1.369681_g420_i0 PRJNA195897 447 801 1.369681 10.97114481 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 53.9 2.82e-4   NR MEM7396574.1 2026799 g420 i0 29 0.99250936329588 138 92 49.8 3 117 515 205 341 MEM7396574.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 795 53.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28733997 28733997 PRJNA195897_P_NODE_4467_length_227_cov_0.769663_g4434_i0 PRJNA195897 4467 227 0.769663 1.74713501 root 1 Root_unresolved Root_unresolved 70.1 6.84e-12   NR MCW0220754.1 1965333 g4434 i0 56.9 1.25550660792952 51 21 67.4 1 5 157 488 537 MCW0220754.1 hypothetical protein [Prosthecobacter sp.] diamond 285 70.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
29807313 29807313 PRJNA195897_P_NODE_7851_length_179_cov_1.076923_g7818_i0 PRJNA195897 7851 179 1.076923 1.92769217 Pseudomonadati 3379134 Bacteria Bacteria 53.5 2.46e-6   NR MBU61027.1 2026771 g7818 i0 53.6 5.46368715083799 56 26 93.9 0 168 1 226 281 MBU61027.1 hypothetical protein [Opitutia bacterium] diamond 978 53.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia       Opitutia bacterium
30453352 30453352 PRJNA195897_P_NODE_7613_length_181_cov_1.181818_g7580_i0 PRJNA195897 7613 181 1.181818 2.13909058 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 112 3.95e-28   NR MBV8969694.1 2026799 g7580 i0 76.7 3.97790055248619 60 14 99.4 0 180 1 53 112 MBV8969694.1 alcohol dehydrogenase catalytic domain-containing protein [Verrucomicrobiota bacterium] diamond 720 112 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31482516 31482516 PRJNA195897_P_NODE_8976_length_169_cov_0.866667_g8943_i0 PRJNA195897 8976 169 0.866667 1.46466723 Pseudomonadati 3379134 Bacteria Bacteria 101 1.32e-23   NR WP_035615464.1 1396141 g8943 i0 85.5 17.5739644970414 55 8 97.6 0 167 3 232 286 WP_035615464.1 aspartate aminotransferase family protein [Haloferula sp. BvORR071] diamond 2970 102 0.990196078431373 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Haloferula Haloferula sp. BvORR071
32178364 32178364 PRJNA195897_P_NODE_10338_length_166_cov_1.076923_g10305_i0 PRJNA195897 10338 166 1.076923 1.78769218 Pseudomonadati 3379134 Bacteria Bacteria 84.3 2.24e-17   NR WP_068772074.1 1184151 g10305 i0 77.8 5.85542168674699 54 12 97.6 0 164 3 31 84 WP_068772074.1 phosphoglycerate kinase [Termitidicoccus mucosus] diamond 972 84.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Termitidicoccus Termitidicoccus mucosus
32305029 32305029 PRJNA195897_P_NODE_159_length_1206_cov_3.274849_g145_i0 PRJNA195897 159 1206 3.274849 39.49467894 Bacteria 2 Bacteria Bacteria 61.6 3.03e-6   NR MCX6884131.1 2026799 g145 i0 31.3 0.659203980099503 128 83 30.8 2 610 239 44 170 MCX6884131.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 795 62 0.993548387096774 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32823594 32823594 PRJNA195897_P_NODE_12120_length_163_cov_0.912281_g12087_i0 PRJNA195897 12120 163 0.912281 1.48701803 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42.4 0.0164   NR MCX6952456.1 2026799 g12087 i0 65.4 0.938650306748466 26 9 47.9 0 159 82 204 229 MCX6952456.1 chemotaxis protein [Verrucomicrobiota bacterium] diamond 153 42.4 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);;