RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA603943" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA603943 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
10782351 10782351 PRJNA603943_P_NODE_68929_length_242_cov_0.881657_g68737_i0 PRJNA603943 68929 242 0.881657 2.13360994 Pseudomonadati 3379134 Bacteria Bacteria 94.7 1.87e-20   NR MSR66747.1 2024890 g68737 i0 62.5 8.82644628099174 80 22 99.2 1 1 240 140 211 MSR66747.1 glycine dehydrogenase (aminomethyl-transferring) [Pedosphaera sp.] diamond 2136 94.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera sp.
26604917 26604917 PRJNA603943_P_NODE_32161_length_320_cov_2.457490_g31969_i0 PRJNA603943 32161 320 2.45749 7.863968 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 186 9.25e-56   NR RYD65414.1 2026800 g31969 i0 81.1 0.99375 106 20 99.4 0 319 2 218 323 RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] diamond 318 186 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
27396207 27396207 PRJNA603943_P_NODE_10423_length_497_cov_1.344340_g10232_i0 PRJNA603943 10423 497 1.34434 6.6813698 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 66.2 3.26e-9   NR RYD20361.1 2026800 g10232 i0 41.5 1.13480885311871 94 50 54.3 3 408 139 203 295 RYD20361.1 MAG: phosphatidylinositol-specific phospholipase C domain-containing protein [Verrucomicrobiaceae bacterium] diamond 564 66.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
27585485 27585485 PRJNA603943_P_NODE_14344_length_436_cov_1.272727_g14152_i0 PRJNA603943 14344 436 1.272727 5.54908972 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 61.6 7.73e-8   NR MCU0778604.1 2562705 g14152 i0 33.6 0.839449541284404 122 78 83.3 3 410 48 561 680 MCU0778604.1 Ig-like domain-containing protein [Akkermansiaceae bacterium] diamond 366 61.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
27617204 27617204 PRJNA603943_P_NODE_66884_length_243_cov_0.905882_g66692_i0 PRJNA603943 66884 243 0.905882 2.20129326 Coraliomargarita sp. CAG:312 1262865 Bacteria Bacteria 105 1.95e-24   NR CDE85146.1 1262865 g66692 i0 98.1 0.666666666666667 54 1 66.7 0 2 163 344 397 CDE85146.1 unknown [Coraliomargarita sp. CAG:312] diamond 162 105 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Coraliomargaritaceae Coraliomargarita Coraliomargarita sp. CAG:312
28027630 28027630 PRJNA603943_P_NODE_58085_length_248_cov_0.880000_g57893_i0 PRJNA603943 58085 248 0.88 2.1824 Lacunisphaera sp. 1961806 Bacteria Bacteria 92 1.47e-19   NR HEY0864215.1 1961806 g57893 i0 64.2 1.97177419354839 81 24 96.8 3 7 246 364 440 HEY0864215.1 ATP-binding protein [Lacunisphaera sp.] diamond 489 92 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Lacunisphaera Lacunisphaera sp.
28090598 28090598 PRJNA603943_P_NODE_60705_length_247_cov_0.885057_g60513_i0 PRJNA603943 60705 247 0.885057 2.18609079 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 85.9 8.65e-18   NR MBE6413505.1 2026800 g60513 i0 50.6 1.91902834008097 79 38 96 1 245 9 7 84 MBE6413505.1 hypothetical protein [Verrucomicrobiaceae bacterium] diamond 474 85.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
28216721 28216721 PRJNA603943_P_NODE_66346_length_243_cov_0.905882_g66154_i0 PRJNA603943 66346 243 0.905882 2.20129326 Coraliomargarita sp. CAG:312 1262865 Bacteria Bacteria 165 9.73e-46   NR CDE85003.1 1262865 g66154 i0 100 0.987654320987654 80 0 98.8 0 242 3 350 429 CDE85003.1 carboxyl-terminal protease [Coraliomargarita sp. CAG:312] diamond 240 165 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Coraliomargaritaceae Coraliomargarita Coraliomargarita sp. CAG:312
28735425 28735425 PRJNA603943_P_NODE_47307_length_268_cov_1.492308_g47115_i0 PRJNA603943 47307 268 1.492308 3.99938544 PVC group 1783257 Bacteria Bacteria 182 4.44e-52   NR CDE84058.1 1262865 g47115 i0 100 1.99253731343284 89 0 99.6 0 1 267 167 255 CDE84058.1 phosphoglucomutase/phosphomannomutase alpha/beta/alpha domain I [Coraliomargarita sp. CAG:312] diamond 534 182 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Coraliomargaritaceae Coraliomargarita Coraliomargarita sp. CAG:312
29164411 29164411 PRJNA603943_P_NODE_57909_length_248_cov_0.880000_g57717_i0 PRJNA603943 57909 248 0.88 2.1824 Coraliomargarita sp. CAG:312 1262865 Bacteria Bacteria 112 1.01e-26   NR CDE83527.1 1262865 g57717 i0 100 0.641129032258065 53 0 64.1 0 90 248 1 53 CDE83527.1 aspartyl/glutamyl-tRNA(Asn/Gln) amidotransferase subunit B [Coraliomargarita sp. CAG:312] diamond 159 112 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Coraliomargaritaceae Coraliomargarita Coraliomargarita sp. CAG:312
29448123 29448123 PRJNA603943_P_NODE_60290_length_247_cov_0.885057_g60098_i0 PRJNA603943 60290 247 0.885057 2.18609079 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 57.8 1.94e-7   NR MBE6414360.1 2026800 g60098 i0 57.1 0.595141700404858 49 21 59.5 0 149 3 107 155 MBE6414360.1 hypothetical protein [Verrucomicrobiaceae bacterium] diamond 147 57.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
30585333 30585333 PRJNA603943_P_NODE_32493_length_319_cov_1.252033_g32301_i0 PRJNA603943 32493 319 1.252033 3.99398527 Akkermansia muciniphila 239935 Bacteria Bacteria 155 3.849999999999999e-47   NR WP_102742001.1 239935 g32301 i0 100 0.705329153605016 75 0 70.5 0 271 47 1 75 WP_102742001.1 helix-turn-helix domain-containing protein [Akkermansia muciniphila] diamond 225 155 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia muciniphila
31122236 31122236 PRJNA603943_P_NODE_43695_length_280_cov_1.062802_g43503_i0 PRJNA603943 43695 280 1.062802 2.9758456 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 68.2 6.77e-11   NR MFM7099803.1 2026799 g43503 i0 51.7 8.51785714285714 60 25 64.3 1 2 181 321 376 MFM7099803.1 PA14 domain-containing protein [Verrucomicrobiota bacterium] diamond 2385 68.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31312234 31312234 PRJNA603943_P_NODE_46155_length_272_cov_1.160804_g45963_i0 PRJNA603943 46155 272 1.160804 3.15738688 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 157 7.289999999999999e-45   NR RYD81270.1 2026800 g45963 i0 76.7 0.992647058823529 90 21 99.3 0 270 1 193 282 RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium] diamond 270 157 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
32008257 32008257 PRJNA603943_P_NODE_66478_length_243_cov_0.905882_g66286_i0 PRJNA603943 66478 243 0.905882 2.20129326 Coraliomargarita sp. CAG:312 1262865 Bacteria Bacteria 150 1.71e-42   NR CDE82923.1 1262865 g66286 i0 98.7 0.962962962962963 78 1 96.3 0 9 242 1 78 CDE82923.1 unknown [Coraliomargarita sp. CAG:312] diamond 234 150 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Coraliomargaritaceae Coraliomargarita Coraliomargarita sp. CAG:312
32134909 32134909 PRJNA603943_P_NODE_62938_length_245_cov_0.895349_g62746_i0 PRJNA603943 62938 245 0.895349 2.19360505 Coraliomargarita sp. CAG:312 1262865 Bacteria Bacteria 135 2.0899999999999997e-35   NR CDE84401.1 1262865 g62746 i0 86.3 0.979591836734694 80 11 98 0 240 1 335 414 CDE84401.1 putative DNA methylase [Coraliomargarita sp. CAG:312] diamond 240 135 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Coraliomargaritaceae Coraliomargarita Coraliomargarita sp. CAG:312
32166592 32166592 PRJNA603943_P_NODE_39058_length_295_cov_1.085586_g38866_i0 PRJNA603943 39058 295 1.085586 3.2024787 Puniceicoccales bacterium 2478473 Bacteria Bacteria 49.3 3.36e-4   NR MDR1906826.1 2478473 g38866 i0 44.8 0.68135593220339 67 27 58 2 16 186 129 195 MDR1906826.1 hypothetical protein [Puniceicoccales bacterium] diamond 201 49.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales     Puniceicoccales bacterium
32451450 32451450 PRJNA603943_P_NODE_59399_length_247_cov_0.885057_g59207_i0 PRJNA603943 59399 247 0.885057 2.18609079 Coraliomargarita sp. CAG:312 1262865 Bacteria Bacteria 154 6.08e-42   NR CDE85507.1 1262865 g59207 i0 100 1.96761133603239 81 0 98.4 0 3 245 357 437 CDE85507.1 unknown [Coraliomargarita sp. CAG:312] diamond 486 154 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Coraliomargaritaceae Coraliomargarita Coraliomargarita sp. CAG:312
32703510 32703510 PRJNA603943_P_NODE_52880_length_251_cov_0.865169_g52688_i0 PRJNA603943 52880 251 0.865169 2.17157419 Coraliomargarita sp. CAG:312 1262865 Bacteria Bacteria 167 4.789999999999999e-46   NR CDE85201.1 1262865 g52688 i0 100 0.99203187250996006 83 0 99.2 0 1 249 554 636 CDE85201.1 pyruvate-flavodoxin oxidoreductase [Coraliomargarita sp. CAG:312] diamond 249 167 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Coraliomargaritaceae Coraliomargarita Coraliomargarita sp. CAG:312
32703521 32703521 PRJNA603943_P_NODE_65240_length_244_cov_0.900585_g65048_i0 PRJNA603943 65240 244 0.900585 2.1974274 Opitutales bacterium 2026772 Bacteria Bacteria 102 8.24e-24   NR MEL0005360.1 2026772 g65048 i0 73.6 2.68032786885246 72 19 88.5 0 244 29 259 330 MEL0005360.1 flotillin-like protein FloA [Opitutales bacterium] diamond 654 102 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales     Opitutales 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);;