RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJEB11748", tax_clade = "PVC group" and tax_phylum = "Kiritimatiellota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kiritimatiellota · 8 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 8 ✖

bioproject 1

  • PRJEB11748 · 8 ✖

analysis 1

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
2567303 2567303 PRJEB11748_P_NODE_279363_length_230_cov_1.591716_g277180_i0 PRJEB11748 279363 230 1.591716 3.6609468 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 82.4 1.17e-17   NR MBQ5795946.1 2212473 g277180 i0 71.7 1.38260869565217 53 15 69.1 0 37 195 55 107 MBQ5795946.1 IS3 family transposase [Kiritimatiellia bacterium] diamond 318 82.4 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
26589453 26589453 PRJEB11748_P_NODE_379461_length_180_cov_4.344538_g377278_i0 PRJEB11748 379461 180 4.344538 7.8201684 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 45.4 0.00175   NR HMP73506.1 2212473 g377278 i0 40.7 1.81666666666667 54 32 90 0 163 2 113 166 HMP73506.1 glycosyltransferase family 4 protein [Kiritimatiellia bacterium] diamond 327 45.4 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27910847 27910847 PRJEB11748_P_NODE_155345_length_329_cov_1.309701_g153163_i0 PRJEB11748 155345 329 1.309701 4.30891629 Pseudomonadati 3379134 Bacteria Bacteria 135 5.789999999999999e-35   NR MFO1521482.1 2212473 g153163 i0 67.7 3.61094224924012 99 32 90.3 0 321 25 198 296 MFO1521482.1 alkaline phosphatase [Kiritimatiellia bacterium] diamond 1188 135 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28643644 28643644 PRJEB11748_P_NODE_200607_length_283_cov_3.599099_g198424_i0 PRJEB11748 200607 283 3.599099 10.18545017 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 55.8 1.41e-6   NR HMP74042.1 2212473 g198424 i0 54.4 0.604240282685512 57 26 60.4 0 55 225 307 363 HMP74042.1 Gfo/Idh/MocA family oxidoreductase [Kiritimatiellia bacterium] diamond 171 55.8 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29464124 29464124 PRJEB11748_P_NODE_70210_length_504_cov_2.559819_g68063_i0 PRJEB11748 70210 504 2.559819 12.90148776 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 258 3.25e-83   NR HMP90365.1 2212473 g68063 i0 77.6 7.36309523809524 156 35 92.9 0 486 19 182 337 HMP90365.1 biotin synthase BioB [Kiritimatiellia bacterium] diamond 3711 258 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29621905 29621905 PRJEB11748_P_NODE_318430_length_211_cov_2.306667_g316247_i0 PRJEB11748 318430 211 2.306667 4.86706737 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 114 1.12e-30   NR MDD4101512.1 2212473 g316247 i0 76.1 1.90521327014218 67 16 95.3 0 11 211 48 114 MDD4101512.1 HIT domain-containing protein [Kiritimatiellia bacterium] diamond 402 114 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
32214175 32214175 PRJEB11748_P_NODE_157618_length_326_cov_3.581132_g155436_i0 PRJEB11748 157618 326 3.581132 11.67449032 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 55.8 2.52e-6   NR MFA7334755.1 2212473 g155436 i0 37 0.993865030674847 108 53 92.9 3 322 20 586 685 MFA7334755.1 immunoglobulin domain-containing protein [Kiritimatiellia bacterium] diamond 324 55.8 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
32751161 32751161 PRJEB11748_P_NODE_216020_length_270_cov_10.942584_g213837_i0 PRJEB11748 216020 270 10.942584 29.5449768 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 54.3 4.06e-6   NR MBR4523586.1 2212473 g213837 i0 34.9 2.88888888888889 86 45 94.4 2 263 9 261 336 MBR4523586.1 hypothetical protein [Kiritimatiellia bacterium] diamond 780 54.3 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);;