RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA400171" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA400171 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
16991494 16991494 PRJNA400171_S_NODE_894_length_353_cov_3.040123_g804_i0 PRJNA400171 894 353 3.040123 10.73163419 Pseudomonadati 3379134 Bacteria Bacteria 81.6 2.96e-15   NR PIE23186.1 2026780 g804 i0 50.5 6.03399433427762 91 45 77.3 0 329 57 486 576 PIE23186.1 MAG: hypothetical protein CSA62_08215 [Planctomycetota bacterium] diamond 2130 81.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26885784 26885784 PRJNA400171_S_NODE_1721_length_285_cov_2.945312_g1631_i0 PRJNA400171 1721 285 2.945312 8.3941392 Planctomycetota bacterium 2026780 Bacteria Bacteria 82.4 6.22e-16   NR MDP6423350.1 2026780 g1631 i0 47.8 3.71578947368421 90 47 94.7 0 14 283 366 455 MDP6423350.1 AAA domain-containing protein [Planctomycetota bacterium] diamond 1059 82.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27517809 27517809 PRJNA400171_S_NODE_3523_length_222_cov_2.663212_g3433_i0 PRJNA400171 3523 222 2.663212 5.91233064 Planctomycetota bacterium 2026780 Bacteria Bacteria 77 1.01e-14   NR MEK7996606.1 2026780 g3433 i0 62.3 2.17567567567568 53 20 71.6 0 221 63 242 294 MEK7996606.1 AAA family ATPase [Planctomycetota bacterium] diamond 483 77 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30833705 30833705 PRJNA400171_S_NODE_3374_length_225_cov_3.229592_g3284_i0 PRJNA400171 3374 225 3.229592 7.266582 Planctomycetota bacterium 2026780 Bacteria Bacteria 48.1 3.62e-4   NR HKE01494.1 2026780 g3284 i0 39.7 1.04 78 43 98.7 2 224 3 40 117 HKE01494.1 ATP-binding protein [Planctomycetota bacterium] diamond 234 48.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31086486 31086486 PRJNA400171_S_NODE_1755_length_283_cov_2.893701_g1665_i0 PRJNA400171 1755 283 2.893701 8.18917383 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 46.2 0.00359   NR MCD7898252.1 2026779 g1665 i0 40.8 0.752650176678445 71 42 75.3 0 223 11 309 379 MCD7898252.1 PKD domain-containing protein [Planctomycetaceae bacterium] diamond 213 46.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31339296 31339296 PRJNA400171_S_NODE_1636_length_290_cov_2.727969_g1546_i0 PRJNA400171 1636 290 2.727969 7.9111101 Planctomycetota bacterium 2026780 Bacteria Bacteria 112 1.13e-26   NR MCA8942010.1 2026780 g1546 i0 59.8 0.9 87 35 90 0 289 29 94 180 MCA8942010.1 TM0106 family RecB-like putative nuclease [Planctomycetota bacterium] diamond 261 112 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;