RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA896758" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA896758 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
28413815 28413815 PRJNA896758_P_NODE_17006_length_280_cov_1.743961_g16616_i0 PRJNA896758 17006 280 1.743961 4.8830908 Opitutaceae bacterium 2006848 Bacteria Bacteria 112 2.66e-26   NR MCU0791279.1 2006848 g16616 i0 60 0.964285714285714 90 36 96.4 0 11 280 717 806 MCU0791279.1 translocation/assembly module TamB [Opitutaceae bacterium] diamond 270 112 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
29013944 29013944 PRJNA896758_P_NODE_13028_length_319_cov_0.841463_g12638_i0 PRJNA896758 13028 319 0.841463 2.68426697 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.5 0.0314   NR MEI6341235.1 2026799 g12638 i0 33.7 0.780564263322884 83 46 69.6 2 58 279 84 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 249 43.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29297837 29297837 PRJNA896758_P_NODE_19949_length_260_cov_1.256684_g19559_i0 PRJNA896758 19949 260 1.256684 3.2673784 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 46.2 0.00173   NR MEI6341235.1 2026799 g19559 i0 36.8 0.876923076923077 76 39 77.3 2 218 18 84 159 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 228 46.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29329320 29329320 PRJNA896758_P_NODE_17189_length_279_cov_1.470874_g16799_i0 PRJNA896758 17189 279 1.470874 4.10373846 Luteolibacter luteus 2728835 Bacteria Bacteria 140 1.94e-36   NR WP_169455091.1 2728835 g16799 i0 67.7 1 93 29 100 1 279 1 555 646 WP_169455091.1 multicopper oxidase domain-containing protein [Luteolibacter luteus] diamond 279 140 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter luteus
30750872 30750872 PRJNA896758_P_NODE_23314_length_247_cov_0.885057_g22924_i0 PRJNA896758 23314 247 0.885057 2.18609079 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 111 2.39e-29   NR HEU5071473.1 2499141 g22924 i0 76.4 0.874493927125506 72 17 87.4 0 247 32 57 128 HEU5071473.1 hypothetical protein [Verrucomicrobiia bacterium] diamond 216 111 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia 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);;