RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJEB12237" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB12237 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
2570562 2570562 PRJEB12237_P_NODE_1823_length_532_cov_1.668008_g1639_i0 PRJEB12237 1823 532 1.668008 8.87380256 Pseudomonadati 3379134 Bacteria Bacteria 194 1.99e-57   NR MEY4484424.1 2026799 g1639 i0 62.2 11.046992481203 164 58 92.5 2 492 1 5 164 MEY4484424.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 5877 194 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
26621430 26621430 PRJEB12237_P_NODE_5601_length_251_cov_2.384259_g5405_i0 PRJEB12237 5601 251 2.384259 5.98449009 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 134 4.77e-36   NR RYD81270.1 2026800 g5405 i0 75.9 0.99203187250996006 83 20 99.2 0 1 249 73 155 RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium] diamond 249 134 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
28132283 28132283 PRJEB12237_P_NODE_11765_length_153_cov_1.279661_g11569_i0 PRJEB12237 11765 153 1.279661 1.95788133 Bacteria 2 Bacteria Bacteria 46.6 4.68e-4   NR MES2571580.1 2026799 g11569 i0 47.1 2 51 24 94.1 2 146 3 228 278 MES2571580.1 phosphatidylinositol-specific phospholipase C domain-containing protein [Verrucomicrobiota bacterium] diamond 306 46.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28391045 28391045 PRJEB12237_P_NODE_6306_length_231_cov_1.428571_g6110_i0 PRJEB12237 6306 231 1.428571 3.29999901 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 60.1 1.76e-8   NR MCU0794900.1 2562705 g6110 i0 38.4 0.948051948051948 73 45 94.8 0 13 231 5 77 MCU0794900.1 hypothetical protein [Akkermansiaceae bacterium] diamond 219 60.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
29085834 29085834 PRJEB12237_P_NODE_1588_length_572_cov_5.543762_g1409_i0 PRJEB12237 1588 572 5.543762 31.71031864 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 111 1.5e-25   NR RYD71398.1 2026800 g1409 i0 52.3 0.582167832167832 111 52 57.7 1 572 243 251 361 RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] diamond 333 111 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
30159126 30159126 PRJEB12237_P_NODE_252_length_1352_cov_6.288535_g186_i0 PRJEB12237 252 1352 6.288535 85.0209932 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 440 4.6199999999999996e-150   NR RYD65414.1 2026800 g186 i0 77 0.627958579881657 283 63 62.8 1 334 1182 56 336 RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] diamond 849 440 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
30222500 30222500 PRJEB12237_P_NODE_4692_length_288_cov_1.458498_g4496_i0 PRJEB12237 4692 288 1.458498 4.20047424 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 86.3 1.62e-17   NR RYD71398.1 2026800 g4496 i0 48.1 0.822916666666667 79 41 82.3 0 5 241 124 202 RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] diamond 237 86.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
30222502 30222502 PRJEB12237_P_NODE_9052_length_180_cov_1.241379_g8856_i0 PRJEB12237 9052 180 1.241379 2.2344822 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42 0.0312   NR MCD6050459.1 2026799 g8856 i0 39.2 0.85 51 29 81.7 1 28 174 538 588 MCD6050459.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 153 42 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30917845 30917845 PRJEB12237_P_NODE_5614_length_251_cov_1.453704_g5418_i0 PRJEB12237 5614 251 1.453704 3.64879704 Prosthecobacter sp. 1965333 Bacteria Bacteria 124 6e-32   NR WP_322282923.1 1965333 g5418 i0 72.3 2.96414342629482 83 23 99.2 0 249 1 250 332 WP_322282923.1 alkene reductase [Prosthecobacter sp.] diamond 744 124 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
31581728 31581728 PRJEB12237_P_NODE_8596_length_186_cov_1.854305_g8400_i0 PRJEB12237 8596 186 1.854305 3.4490073 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 44.3 0.00473   NR MFK5922826.1 2026799 g8400 i0 35 0.967741935483871 60 37 95.2 2 8 184 207 265 MFK5922826.1 sulfotransferase family 2 domain-containing protein [Verrucomicrobiota bacterium] diamond 180 44.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31613203 31613203 PRJEB12237_P_NODE_11916_length_152_cov_1.119658_g11720_i0 PRJEB12237 11916 152 1.119658 1.70188016 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 46.6 1.48e-4   NR MCS7338380.1 2499141 g11720 i0 79.3 0.572368421052632 29 6 57.2 0 129 43 99 127 MCS7338380.1 RidA family protein [Verrucomicrobiia bacterium] diamond 87 46.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia 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);;