RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA801875" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA801875 · 5 ✖

analysis 1

  • blastn · 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
3352006 3352006 PRJNA801875_P_NODE_63_length_1602_cov_7.909381_g37_i0 PRJNA801875 63 1602 7.909381 126.70828362 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 2143 0   NTclustered gi|1927958621|gb|CP054186.1| 2026777 g37 i0 90.875 355.411985018727 1611 127 99 16 1 1599 1867800 1866198 MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome blastn 569370 2143 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
7179396 7179396 PRJNA801875_P_NODE_266_length_878_cov_5.584816_g188_i0 PRJNA801875 266 878 5.584816 49.03468448 Urbifossiella limnaea 2528023 Bacteria Bacteria 1314 0   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g188 i0 93.95 165.386104783599 876 41 99 12 1 867 2019352 2018480 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 145209 1314 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
9729153 9729153 PRJNA801875_P_NODE_2468_length_219_cov_4.048913_g2365_i0 PRJNA801875 2468 219 4.048913 8.86711947 Urbifossiella limnaea 2528023 Bacteria Bacteria 335 1.7199999999999992e-87   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g2365 i0 94.86 128.643835616438 214 11 98 0 3 216 2020229 2020016 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 28173 335 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
14829498 14829498 PRJNA801875_P_NODE_2712_length_205_cov_3.835294_g2609_i0 PRJNA801875 2712 205 3.835294 7.8623527 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 313 7.4399999999999995e-81   NTclustered gi|1927958621|gb|CP054186.1| 2026777 g2609 i0 94.146 338.892682926829 205 12 100 0 1 205 1868496 1868292 MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome blastn 69473 313 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
17379488 17379488 PRJNA801875_P_NODE_594_length_565_cov_4.316981_g494_i0 PRJNA801875 594 565 4.316981 24.39094265 Urbifossiella limnaea 2528023 Bacteria Bacteria 867 0   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g494 i0 94.504 232.053097345133 564 27 99 4 4 565 4212510 4211949 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 131110 867 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea

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);;