RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1180292" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1180292 · 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
14346882 14346882 PRJNA1180292_P_NODE_12972_length_242_cov_0.923077_g12840_i0 PRJNA1180292 12972 242 0.923077 2.23384634 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 153 6.579999999999999e-46   NR HRZ09802.1 2448054 g12840 i0 97.5 0.991735537190083 80 2 99.2 0 2 241 33 112 HRZ09802.1 ATP-binding cassette domain-containing protein [Gemmatimonadales bacterium] diamond 240 153 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
18169561 18169561 PRJNA1180292_P_NODE_9455_length_250_cov_0.881356_g9323_i0 PRJNA1180292 9455 250 0.881356 2.20339 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 160 1.72e-44   NR MBM3907024.1 2026742 g9323 i0 94 2.988 83 5 99.6 0 1 249 82 164 MBM3907024.1 L-serine ammonia-lyase, iron-sulfur-dependent, subunit alpha [Gemmatimonadota bacterium] diamond 747 160 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
20719270 20719270 PRJNA1180292_P_NODE_8377_length_252_cov_0.871508_g8245_i0 PRJNA1180292 8377 252 0.871508 2.19620016 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 149 6.21e-40   NR HEY3286728.1 2026741 g8245 i0 82.9 4.89285714285714 82 14 97.6 0 251 6 114 195 HEY3286728.1 glutamine-hydrolyzing GMP synthase [Gemmatimonadaceae bacterium] diamond 1233 149 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27028111 27028111 PRJNA1180292_P_NODE_11262_length_246_cov_0.901734_g11130_i0 PRJNA1180292 11262 246 0.901734 2.21826564 Bacteria 2 Bacteria Bacteria 134 1.4599999999999998e-35   NR HVF40851.1 2026741 g11130 i0 76.8 3.97560975609756 82 19 100 0 246 1 96 177 HVF40851.1 glycosyltransferase [Gemmatimonadaceae bacterium] diamond 978 134 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27230204 27230204 PRJNA1180292_P_NODE_8823_length_251_cov_0.876404_g8691_i0 PRJNA1180292 8823 251 0.876404 2.19977404 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 101 1.09e-22   NR HEY7685027.1 2448054 g8691 i0 69.9 0.99203187250996006 83 25 99.2 0 2 250 1577 1659 HEY7685027.1 hypothetical protein [Gemmatimonadales bacterium] diamond 249 101 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
27483015 27483015 PRJNA1180292_P_NODE_11023_length_246_cov_0.901734_g10891_i0 PRJNA1180292 11023 246 0.901734 2.21826564 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 159 8.929999999999999e-47   NR TFG45894.1 2448054 g10891 i0 97.6 1 82 2 100 0 246 1 126 207 TFG45894.1 MAG: ABC transporter ATP-binding protein [Gemmatimonadales bacterium] diamond 246 159 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
27546193 27546193 PRJNA1180292_P_NODE_9964_length_249_cov_0.886364_g9832_i0 PRJNA1180292 9964 249 0.886364 2.20704636 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 110 6.51e-29   NR MDH4349161.1 2026742 g9832 i0 86.9 0.734939759036145 61 8 73.5 0 66 248 20 80 MDH4349161.1 hypothetical protein [Gemmatimonadota bacterium] diamond 183 110 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28133766 28133766 PRJNA1180292_P_NODE_8805_length_251_cov_0.876404_g8673_i0 PRJNA1180292 8805 251 0.876404 2.19977404 Bacteria 2 Bacteria Bacteria 102 7.72e-24   NR HEX6967160.1 2026741 g8673 i0 62.2 2.9402390438247 82 31 98 0 4 249 130 211 HEX6967160.1 glycosyltransferase [Gemmatimonadaceae bacterium] diamond 738 103 0.990291262135922 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28418006 28418006 PRJNA1180292_P_NODE_10806_length_247_cov_0.896552_g10674_i0 PRJNA1180292 10806 247 0.896552 2.21448344 Pseudomonadati 3379134 Bacteria Bacteria 55.8 1.92e-7   NR HEU5217239.1 2448054 g10674 i0 40.3 2.25910931174089 62 37 75.3 0 195 10 35 96 HEU5217239.1 DUF1772 domain-containing protein [Gemmatimonadales bacterium] diamond 558 55.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28651282 28651282 PRJNA1180292_P_NODE_10747_length_247_cov_0.896552_g10615_i0 PRJNA1180292 10747 247 0.896552 2.21448344 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 61.6 8.79e-9   NR HYN80394.1 2026741 g10615 i0 53.6 2.91497975708502 56 26 68 0 80 247 240 295 HYN80394.1 IS4 family transposase [Gemmatimonadaceae bacterium] diamond 720 61.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29503610 29503610 PRJNA1180292_P_NODE_10490_length_247_cov_0.896552_g10358_i0 PRJNA1180292 10490 247 0.896552 2.21448344 Longimicrobiales bacterium 2910168 Bacteria Bacteria 130 3.36e-33   NR HSG08075.1 2910168 g10358 i0 84.1 0.995951417004049 82 13 99.6 0 2 247 456 537 HSG08075.1 hypothetical protein [Longimicrobiales bacterium] diamond 246 130 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
29617259 29617259 PRJNA1180292_P_NODE_12350_length_243_cov_0.917647_g12218_i0 PRJNA1180292 12350 243 0.917647 2.22988221 Bacteria 2 Bacteria Bacteria 93.2 5.23e-20   NR HEY3286054.1 2026741 g12218 i0 66.2 3.19753086419753 65 22 80.2 0 242 48 408 472 HEY3286054.1 nitronate monooxygenase [Gemmatimonadaceae bacterium] diamond 777 93.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29692852 29692852 PRJNA1180292_P_NODE_12190_length_244_cov_0.912281_g12058_i0 PRJNA1180292 12190 244 0.912281 2.22596564 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 162 3.22e-44   NR MBK8250428.1 2026742 g12058 i0 91.3 1.9672131147541 80 7 98.4 0 3 242 266 345 MBK8250428.1 SusC/RagA family TonB-linked outer membrane protein [Gemmatimonadota bacterium] diamond 480 162 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30420108 30420108 PRJNA1180292_P_NODE_9093_length_251_cov_0.870787_g8961_i0 PRJNA1180292 9093 251 0.870787 2.18567537 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 154 2.21e-42   NR HEX9166684.1 2448054 g8961 i0 89 0.9800796812749 82 9 98 0 246 1 434 515 HEX9166684.1 chemotaxis protein CheA [Gemmatimonadales bacterium] diamond 246 154 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31209172 31209172 PRJNA1180292_P_NODE_12575_length_243_cov_0.917647_g12443_i0 PRJNA1180292 12575 243 0.917647 2.22988221 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 122 4.6799999999999996e-34   NR HEX9166637.1 2448054 g12443 i0 70 0.987654320987654 80 24 98.8 0 243 4 18 97 HEX9166637.1 four helix bundle protein [Gemmatimonadales bacterium] diamond 240 122 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31715724 31715724 PRJNA1180292_P_NODE_12657_length_243_cov_0.917647_g12525_i0 PRJNA1180292 12657 243 0.917647 2.22988221 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 112 4.270000000000001e-27   NR MDH4352033.1 2026742 g12525 i0 74.3 0.91358024691358 74 19 91.4 0 232 11 162 235 MDH4352033.1 lysophospholipid acyltransferase family protein [Gemmatimonadota bacterium] diamond 222 112 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32253885 32253885 PRJNA1180292_P_NODE_8418_length_252_cov_0.871508_g8286_i0 PRJNA1180292 8418 252 0.871508 2.19620016 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 124 8.94e-32   NR HEU4700592.1 2448054 g8286 i0 73.8 1 84 22 100 0 1 252 215 298 HEU4700592.1 amidase [Gemmatimonadales bacterium] diamond 252 124 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
32506934 32506934 PRJNA1180292_P_NODE_2019_length_479_cov_7.209360_g1887_i0 PRJNA1180292 2019 479 7.20936 34.5328344 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 115 1.54e-28   NR HEX8718619.1 2026741 g1887 i0 39.3 1.89770354906054 150 83 88.9 1 37 462 82 231 HEX8718619.1 Hsp20/alpha crystallin family protein [Gemmatimonadaceae bacterium] diamond 909 115 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32758873 32758873 PRJNA1180292_P_NODE_10500_length_247_cov_0.896552_g10368_i0 PRJNA1180292 10500 247 0.896552 2.21448344 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 162 4.799999999999998e-44   NR MDX2261316.1 2448054 g10368 i0 100 0.995951417004049 82 0 99.6 0 1 246 650 731 MDX2261316.1 glycoside hydrolase family 2 TIM barrel-domain containing protein [Gemmatimonadales bacterium] diamond 246 162 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
32853257 32853257 PRJNA1180292_P_NODE_11260_length_246_cov_0.901734_g11128_i0 PRJNA1180292 11260 246 0.901734 2.21826564 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 107 9.19e-25   NR MBK8004611.1 2026742 g11128 i0 66.7 0.98780487804878 81 27 98.8 0 245 3 673 753 MBK8004611.1 hypothetical protein [Gemmatimonadota bacterium] diamond 243 107 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota 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);;