RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA1123436", tax_clade = "PVC group" and tax_phylum = "Lentisphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lentisphaerota · 13 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 13 ✖

bioproject 1

  • PRJNA1123436 · 13 ✖

analysis 1

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
21431208 21431208 PRJNA1123436_P_NODE_118897_length_244_cov_0.888889_g117683_i0 PRJNA1123436 118897 244 0.888889 2.16888916 Bacteria 2 Bacteria Bacteria 129 7.34e-34   NR OGV82301.1 1798577 g117683 i0 71.6 24.7131147540984 81 23 99.6 0 244 2 29 109 OGV82301.1 MAG: hypothetical protein A3K18_00810 [Lentisphaerae bacterium RIFOXYA12_64_32] diamond 6030 130 0.992307692307692 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerae bacterium RIFOXYA12_64_32
27101782 27101782 PRJNA1123436_P_NODE_97262_length_251_cov_0.865169_g96048_i0 PRJNA1123436 97262 251 0.865169 2.17157419 Lentisphaerota bacterium 1932692 Bacteria Bacteria 91.7 1.34e-19   NR NQU38423.1 1932692 g96048 i0 57 3.77689243027888 79 34 94.4 0 242 6 273 351 NQU38423.1 hybrid sensor histidine kinase/response regulator [Lentisphaerota bacterium] diamond 948 91.7 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
27133033 27133033 PRJNA1123436_P_NODE_102862_length_249_cov_0.875000_g101648_i0 PRJNA1123436 102862 249 0.875 2.17875 Lentisphaerae bacterium RIFOXYA12_64_32 1798577 Bacteria Bacteria 91.3 3.3e-19   NR OGV62701.1 1798577 g101648 i0 75.5 0.63855421686747 53 13 63.9 0 248 90 489 541 OGV62701.1 MAG: hypothetical protein A3K18_05435 [Lentisphaerae bacterium RIFOXYA12_64_32] diamond 159 91.3 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerae bacterium RIFOXYA12_64_32
27575797 27575797 PRJNA1123436_P_NODE_83184_length_272_cov_1.276382_g81970_i0 PRJNA1123436 83184 272 1.276382 3.47175904 Lentisphaeria bacterium 2053569 Bacteria Bacteria 45.1 0.00795   NR MCQ2402373.1 2053569 g81970 i0 36.5 0.816176470588235 74 36 69.5 1 19 207 152 225 MCQ2402373.1 hypothetical protein [Lentisphaeria bacterium] diamond 222 45.1 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
28196271 28196271 PRJNA1123436_P_NODE_116906_length_244_cov_0.900585_g115692_i0 PRJNA1123436 116906 244 0.900585 2.1974274 Pseudomonadati 3379134 Bacteria Bacteria 51.6 2.56e-5   NR OGV67539.1 1798577 g115692 i0 52.2 4.51229508196721 46 22 56.6 0 105 242 5 50 OGV67539.1 MAG: hypothetical protein A3K18_28845 [Lentisphaerae bacterium RIFOXYA12_64_32] diamond 1101 51.6 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerae bacterium RIFOXYA12_64_32
28491476 28491476 PRJNA1123436_P_NODE_121287_length_243_cov_0.905882_g120073_i0 PRJNA1123436 121287 243 0.905882 2.20129326 Lentisphaerota bacterium 1932692 Bacteria Bacteria 63.5 1.8e-9   NR MBT3378447.1 1932692 g120073 i0 42.3 0.962962962962963 78 43 96.3 1 243 10 690 765 MBT3378447.1 DUF4091 domain-containing protein [Lentisphaerota bacterium] diamond 234 63.5 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
30323531 30323531 PRJNA1123436_P_NODE_103252_length_249_cov_0.875000_g102038_i0 PRJNA1123436 103252 249 0.875 2.17875 Lentisphaeria bacterium 2053569 Bacteria Bacteria 92.8 7.41e-20   NR MBN2452046.1 2053569 g102038 i0 62.2 0.987951807228916 82 31 98.8 0 248 3 255 336 MBN2452046.1 glycosyltransferase family 4 protein [Lentisphaeria bacterium] diamond 246 92.8 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
31639529 31639529 PRJNA1123436_P_NODE_98416_length_250_cov_0.870056_g97202_i0 PRJNA1123436 98416 250 0.870056 2.17514 Bacteria 2 Bacteria Bacteria 48.9 1.43e-4   NR OGV70597.1 1798577 g97202 i0 100 1.92 20 0 24 0 249 190 162 181 OGV70597.1 MAG: hypothetical protein A3K18_02110 [Lentisphaerae bacterium RIFOXYA12_64_32] diamond 480 48.9 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerae bacterium RIFOXYA12_64_32
31829204 31829204 PRJNA1123436_P_NODE_109037_length_247_cov_0.885057_g107823_i0 PRJNA1123436 109037 247 0.885057 2.18609079 Pseudomonadati 3379134 Bacteria Bacteria 122 1.6499999999999998e-30   NR OGV74602.1 1798577 g107823 i0 72.8 3.92307692307692 81 22 98.4 0 3 245 417 497 OGV74602.1 MAG: sodium:solute symporter [Lentisphaerae bacterium RIFOXYA12_64_32] diamond 969 123 0.991869918699187 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerae bacterium RIFOXYA12_64_32
32177608 32177608 PRJNA1123436_P_NODE_127598_length_241_cov_0.916667_g126384_i0 PRJNA1123436 127598 241 0.916667 2.20916747 Pseudomonadati 3379134 Bacteria Bacteria 76.3 4.87e-14   NR MCK5806192.1 2053569 g126384 i0 52.1 1.76763485477178 71 34 88.4 0 214 2 26 96 MCK5806192.1 ISKra4 family transposase [Lentisphaeria bacterium] diamond 426 76.6 0.996083550913838 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
32494024 32494024 PRJNA1123436_P_NODE_118719_length_244_cov_0.900585_g117505_i0 PRJNA1123436 118719 244 0.900585 2.1974274 Pseudomonadati 3379134 Bacteria Bacteria 90.1 6.05e-19   NR MEI6423052.1 1932692 g117505 i0 60.9 1.69672131147541 69 26 84.8 1 242 36 104 171 MEI6423052.1 metallophosphoesterase family protein [Lentisphaerota bacterium] diamond 414 90.9 0.991199119911991 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
32725443 32725443 PRJNA1123436_P_NODE_111640_length_246_cov_0.890173_g110426_i0 PRJNA1123436 111640 246 0.890173 2.18982558 Victivallales bacterium 2212475 Bacteria Bacteria 92.4 1.28e-19   NR MBT7166840.1 2212475 g110426 i0 56.1 2 82 34 100 1 246 1 304 383 MBT7166840.1 hypothetical protein [Victivallales bacterium] diamond 492 92.4 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
32882695 32882695 PRJNA1123436_P_NODE_101800_length_249_cov_0.875000_g100586_i0 PRJNA1123436 101800 249 0.875 2.17875 Lentisphaerae bacterium ADurb.BinA184 1852901 Bacteria Bacteria 93.6 5.19e-20   NR OPZ30629.1 1852901 g100586 i0 58 2.95180722891566 81 33 96.4 1 241 2 1095 1175 OPZ30629.1 MAG: NHL repeat protein [Lentisphaerae bacterium ADurb.BinA184] diamond 735 93.6 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerae bacterium ADurb.BinA184

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