RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1105232" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1105232 · 6 ✖

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
27762934 27762934 PRJNA1105232_S_NODE_1024_length_481_cov_5.129630_g812_i0 PRJNA1105232 1024 481 5.12963 24.6735203 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 128 2.9499999999999993e-31   NR HXX41603.1 2201154 g812 i0 47.2 1.004158004158 161 83 99.2 2 1 477 342 502 HXX41603.1 S8 family serine peptidase [Chthoniobacterales bacterium] diamond 483 128 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
27952147 27952147 PRJNA1105232_S_NODE_4085_length_287_cov_2.840336_g3869_i0 PRJNA1105232 4085 287 2.840336 8.15176432 Prosthecobacter sp. 1965333 Bacteria Bacteria 47 0.00207   NR WP_395752574.1 1965333 g3869 i0 50 1.27526132404181 40 20 41.8 0 279 160 491 530 WP_395752574.1 hypothetical protein [Prosthecobacter sp.] diamond 366 47 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
29584936 29584936 PRJNA1105232_S_NODE_10710_length_196_cov_1.877551_g10494_i0 PRJNA1105232 10710 196 1.877551 3.67999996 Bacteria 2 Bacteria Bacteria 86.3 4.72e-18   NR HPC60402.1 2026799 g10494 i0 63.8 5.3265306122449 58 21 88.8 0 191 18 233 290 HPC60402.1 peptidoglycan recognition family protein [Verrucomicrobiota bacterium] diamond 1044 86.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30469946 30469946 PRJNA1105232_S_NODE_17673_length_160_cov_2.180180_g17457_i0 PRJNA1105232 17673 160 2.18018 3.488288 Bacteria 2 Bacteria Bacteria 47.8 2.09e-4   NR MBU0677327.1 2026799 g17457 i0 43.6 2.04375 55 27 95.6 1 154 2 723 777 MBU0677327.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 327 47.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31964173 31964173 PRJNA1105232_S_NODE_2058_length_372_cov_4.445820_g1842_i0 PRJNA1105232 2058 372 4.44582 16.5384504 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 124 5.02e-30   NR MEY2546246.1 2026799 g1842 i0 57.3 0.943548387096774 117 48 92.7 1 364 20 401 517 MEY2546246.1 serine protease AprX [Verrucomicrobiota bacterium] diamond 351 124 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32880282 32880282 PRJNA1105232_S_NODE_1580_length_410_cov_7.573407_g1365_i0 PRJNA1105232 1580 410 7.5734069999999996 31.0509687 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 118 8.959999999999999e-28   NR MEY2546246.1 2026799 g1365 i0 47.1 1.00975609756098 138 69 98 1 407 6 369 506 MEY2546246.1 serine protease AprX [Verrucomicrobiota bacterium] diamond 414 118 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota 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);;