RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB14175" and tax_phylum = "Vulcanimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Vulcanimicrobiota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJEB14175 · 5 ✖

analysis 1

  • diamond · 5 ✖

tax_clade 0

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
25500932 25500932 PRJEB14175_P_NODE_100993_length_355_cov_12.823129_g98727_i0 PRJEB14175 100993 355 12.823129 45.52210795 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 130 5.03e-33   NR MFN8614286.1 3107663 g98727 i0 63.8 0.887323943661972 105 38 88.7 0 320 6 249 353 MFN8614286.1 hypothetical protein [Vulcanimicrobiota bacterium] diamond 315 130 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
32995372 32995372 PRJEB14175_P_NODE_46411_length_548_cov_1.451745_g44188_i0 PRJEB14175 46411 548 1.451745 7.9555626 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 312 3.86e-103   NR MFN8612886.1 3107663 g44188 i0 90.8 0.952554744525547 174 16 95.3 0 26 547 95 268 MFN8612886.1 IS256 family transposase [Vulcanimicrobiota bacterium] diamond 522 312 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
33028027 33028027 PRJEB14175_P_NODE_122268_length_316_cov_1.019608_g120002_i0 PRJEB14175 122268 316 1.019608 3.22196128 Candidatus Cybelea sp. 2952917 Bacteria Bacteria 152 5.39e-42   NR HYM32311.1 2952917 g120002 i0 69.2 2.00316455696203 104 32 98.7 0 3 314 62 165 HYM32311.1 hypothetical protein [Candidatus Cybelea sp.] diamond 633 152 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
33062887 33062887 PRJEB14175_P_NODE_210757_length_220_cov_1.874214_g208490_i0 PRJEB14175 210757 220 1.874214 4.1232708 Candidatus Eremiobacteraceae bacterium 3069296 Bacteria Bacteria 60.5 1.56e-8   NR HME81451.1 3069296 g208490 i0 64.3 1.13181818181818 42 15 57.3 0 211 86 524 565 HME81451.1 di-heme-cytochrome C peroxidase [Candidatus Eremiobacteraceae bacterium] diamond 249 60.5 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Candidatus Eremiobacterales Candidatus Eremiobacteraceae   Candidatus Eremiobacteraceae bacterium
33096366 33096366 PRJEB14175_P_NODE_135238_length_296_cov_4.600000_g132971_i0 PRJEB14175 135238 296 4.6 13.616 Candidatus Xenobia bacterium 3036772 Bacteria Bacteria 94.7 1.47e-22   NR GMU56020.1 3036772 g132971 i0 45.9 0.993243243243243 98 48 94.3 2 281 3 1 98 GMU56020.1 MAG: hypothetical protein AMXMBFR33_51660 [Candidatus Xenobia bacterium] diamond 294 94.7 1 Bacteria   Bacillati Vulcanimicrobiota Candidatus Xenobia       Candidatus Xenobia 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);;