RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJDB4470" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB4470 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
2559015 2559015 PRJDB4470_P_NODE_119683_length_163_cov_0.894737_g118528_i0 PRJDB4470 119683 163 0.894737 1.45842131 Prosthecobacter sp. SYSU 5D2 3134134 Bacteria Bacteria 107 2.07e-27   NR WP_346332765.1 3134134 g118528 i0 90.7 0.993865030674847 54 5 99.4 0 2 163 129 182 WP_346332765.1 type 1 glutamine amidotransferase domain-containing protein [Prosthecobacter sp. SYSU 5D2] diamond 162 107 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp. SYSU 5D2
23933670 23933670 PRJDB4470_P_NODE_118619_length_163_cov_0.912281_g117464_i0 PRJDB4470 118619 163 0.912281 1.48701803 Rubritalea 361050 Bacteria Bacteria 107 2.91e-25   NR WP_018970057.1 361055 g117464 i0 96.3 6.95705521472393 54 2 99.4 0 2 163 170 223 WP_018970057.1 carbamoyl-phosphate synthase large subunit [Rubritalea marina] diamond 1134 107 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Rubritaleaceae Rubritalea Rubritalea marina
27411991 27411991 PRJDB4470_P_NODE_105343_length_167_cov_0.864407_g104188_i0 PRJDB4470 105343 167 0.864407 1.44355969 Opitutaceae bacterium 2006848 Bacteria Bacteria 47.4 1.39e-4   NR MEO6245693.1 2006848 g104188 i0 48.6 0.664670658682635 37 19 66.5 0 31 141 93 129 MEO6245693.1 hypothetical protein [Opitutaceae bacterium] diamond 111 47.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
27474838 27474838 PRJDB4470_P_NODE_113203_length_165_cov_0.870690_g112048_i0 PRJDB4470 113203 165 0.87069 1.4366385 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 62.4 1.47e-9   NR MEN9677548.1 2026799 g112048 i0 97.1 0.618181818181818 34 1 61.8 0 103 2 1 34 MEN9677548.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 102 62.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27664506 27664506 PRJDB4470_P_NODE_114964_length_164_cov_0.904348_g113809_i0 PRJDB4470 114964 164 0.904348 1.48313072 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 41.2 0.0453   NR MEI7962728.1 2026799 g113809 i0 48.8 0.786585365853659 43 21 78.7 1 130 2 280 321 MEI7962728.1 NAD-dependent DNA ligase LigA [Verrucomicrobiota bacterium] diamond 129 41.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28390509 28390509 PRJDB4470_P_NODE_86526_length_188_cov_1.266187_g85371_i0 PRJDB4470 86526 188 1.266187 2.38043156 Verrucomicrobium sp. BvORR 72225 Bacteria Bacteria 65.9 1.61e-11   NR WP_265592646.1 1396418 g85371 i0 45.8 0.941489361702128 59 32 94.1 0 179 3 48 106 WP_265592646.1 hypothetical protein [Verrucomicrobium sp. BvORR034] diamond 177 65.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Verrucomicrobium Verrucomicrobium sp. BvORR034
28485282 28485282 PRJDB4470_P_NODE_105727_length_167_cov_0.864407_g104572_i0 PRJDB4470 105727 167 0.864407 1.44355969 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 89.7 9.9e-21   NR MCI0538931.1 2026801 g104572 i0 87.3 1.97604790419162 55 7 98.8 0 166 2 79 133 MCI0538931.1 GNAT family N-acetyltransferase [Verrucomicrobiales bacterium] diamond 330 89.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
29963430 29963430 PRJDB4470_P_NODE_116811_length_164_cov_0.878261_g115656_i0 PRJDB4470 116811 164 0.878261 1.44034804 Bacteria 2 Bacteria Bacteria 77.4 7.53e-15   NR MEI7775712.1 2026799 g115656 i0 69.1 2.01219512195122 55 16 98.8 1 162 1 296 350 MEI7775712.1 DUF1549 domain-containing protein [Verrucomicrobiota bacterium] diamond 330 77.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31005990 31005990 PRJDB4470_P_NODE_80674_length_198_cov_1.026846_g79519_i0 PRJDB4470 80674 198 1.026846 2.03315508 Pseudomonadati 3379134 Bacteria Bacteria 106 8.72e-25   NR WP_165107678.1 1324935 g79519 i0 83.1 5.87878787878788 65 11 98.5 0 197 3 750 814 WP_165107678.1 magnesium-translocating P-type ATPase [Limisphaera ngatamarikiensis] diamond 1164 107 0.990654205607477 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Limisphaerales Limisphaeraceae Limisphaera Limisphaera ngatamarikiensis
31163691 31163691 PRJDB4470_P_NODE_123735_length_162_cov_0.902655_g122580_i0 PRJDB4470 123735 162 0.902655 1.4623011 Luteolibacter 518753 Bacteria Bacteria 108 3.9099999999999997e-28   NR RYD32642.1 2026800 g122580 i0 96.3 2 54 2 100 0 162 1 53 106 RYD32642.1 MAG: IMP dehydrogenase, partial [Verrucomicrobiaceae bacterium] diamond 324 108 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
31169677 31169677 PRJDB4470_P_NODE_70795_length_219_cov_0.800000_g69640_i0 PRJDB4470 70795 219 0.8 1.752 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42 0.0479   NR MEK7781196.1 2026799 g69640 i0 31.6 1.04109589041096 76 41 90.4 2 200 3 209 283 MEK7781196.1 cytochrome c biogenesis protein CcsA [Verrucomicrobiota bacterium] diamond 228 42 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32150579 32150579 PRJDB4470_P_NODE_67378_length_227_cov_1.876404_g66223_i0 PRJDB4470 67378 227 1.876404 4.25943708 Opitutaceae bacterium 2006848 Bacteria Bacteria 45.4 3.95e-4   NR MFT3829826.1 2006848 g66223 i0 43.9 0.753303964757709 57 27 75.3 2 201 31 14 65 MFT3829826.1 hypothetical protein [Opitutaceae bacterium] diamond 171 45.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
32340556 32340556 PRJDB4470_P_NODE_122159_length_162_cov_0.920354_g121004_i0 PRJDB4470 122159 162 0.920354 1.49097348 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 71.6 2.37e-14   NR MDB6117400.1 2026800 g121004 i0 65.3 0.907407407407407 49 17 90.7 0 149 3 44 92 MDB6117400.1 hypothetical protein [Verrucomicrobiaceae bacterium] diamond 147 71.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae 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);;