RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA550047" and tax_phylum = "Kiritimatiellota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kiritimatiellota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA550047 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
27078098 27078098 PRJNA550047_P_NODE_414842_length_259_cov_9.602151_g412870_i0 PRJNA550047 414842 259 9.602151 24.86957109 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 41.2 0.0378   NR MBR3220951.1 2212473 g412870 i0 35.4 0.752895752895753 65 42 75.3 0 65 259 21 85 MBR3220951.1 hypothetical protein [Kiritimatiellia bacterium] diamond 195 41.2 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27282551 27282551 PRJNA550047_P_NODE_488743_length_234_cov_8.354037_g486770_i0 PRJNA550047 488743 234 8.354037 19.54844658 Pseudomonadati 3379134 Bacteria Bacteria 48.5 3.17e-4   NR MBR1588193.1 2212473 g486770 i0 44.4 1.52564102564103 72 29 92.3 1 1 216 494 554 MBR1588193.1 RHS repeat protein [Kiritimatiellia bacterium] diamond 357 48.5 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28387607 28387607 PRJNA550047_P_NODE_71306_length_345_cov_12.128676_g69346_i0 PRJNA550047 71306 345 12.128676 41.8439322 Bacteria 2 Bacteria Bacteria 47.4 0.00302   NR MBN1669427.1 2212473 g69346 i0 56.8 1.46086956521739 37 16 32.2 0 119 9 10721 10757 MBN1669427.1 DUF2341 domain-containing protein [Kiritimatiellia bacterium] diamond 504 47.8 0.99163179916318 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28625708 28625708 PRJNA550047_P_NODE_383007_length_271_cov_19.191919_g381035_i0 PRJNA550047 383007 271 19.191919 52.01010049 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 178 4.13e-53   NR MFA7054871.1 2212473 g381035 i0 87.8 0.996309963099631 90 11 99.6 0 271 2 207 296 MFA7054871.1 RRXRR domain-containing protein [Kiritimatiellia bacterium] diamond 270 178 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29635471 29635471 PRJNA550047_P_NODE_217670_length_301_cov_14.144737_g215701_i0 PRJNA550047 217670 301 14.144737 42.57565837 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 142 3.219999999999999e-38   NR HRR32931.1 2212473 g215701 i0 87.7 0.807308970099668 81 4 74.8 1 300 76 320 400 HRR32931.1 AAA family ATPase [Kiritimatiellia bacterium] diamond 243 142 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31120319 31120319 PRJNA550047_P_NODE_216435_length_301_cov_15.732456_g214466_i0 PRJNA550047 216435 301 15.732456000000001 47.35469256 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 45.1 0.0113   NR MBQ7667115.1 2212473 g214466 i0 35.7 1.16611295681063 84 37 78.7 2 280 44 266 337 MBQ7667115.1 protein kinase [Kiritimatiellia bacterium] diamond 351 45.1 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31436916 31436916 PRJNA550047_P_NODE_467896_length_241_cov_9.672619_g465923_i0 PRJNA550047 467896 241 9.672619 23.31101179 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 119 1.22e-29   NR HMP77801.1 2212473 g465923 i0 68.4 0.983402489626556 79 25 98.3 0 2 238 16 94 HMP77801.1 alkaline phosphatase family protein [Kiritimatiellia bacterium] diamond 237 119 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia 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);;