RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1198392" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1198392 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
324600 324600 PRJNA1198392_P_NODE_19921_length_244_cov_0.859649_g19780_i0 PRJNA1198392 19921 244 0.859649 2.09754356 Phycisphaerae 666505 Bacteria Bacteria 76.3 5.85e-14   NR UCD76450.1 2052180 g19780 i0 84.1 1.63524590163934 44 7 54.1 0 1 132 464 507 UCD76450.1 MAG: sugar ABC transporter ATP-binding protein [Phycisphaerales bacterium] diamond 399 76.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
13078063 13078063 PRJNA1198392_P_NODE_12851_length_268_cov_1.579487_g12710_i0 PRJNA1198392 12851 268 1.579487 4.23302516 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 65.5 5.09e-10   NR HEV2296228.1 2876886 g12710 i0 75.6 0.458955223880597 41 10 45.9 0 267 145 670 710 HEV2296228.1 response regulator [Tepidisphaeraceae bacterium] diamond 123 65.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
26660730 26660730 PRJNA1198392_P_NODE_10961_length_278_cov_1.141463_g10820_i0 PRJNA1198392 10961 278 1.141463 3.17326714 Planctomycetota bacterium 2026780 Bacteria Bacteria 56.6 7.15e-7   NR RMD62086.1 2026780 g10820 i0 40.3 0.669064748201439 62 37 66.9 0 277 92 366 427 RMD62086.1 MAG: hypothetical protein D6824_07215, partial [Planctomycetota bacterium] diamond 186 56.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29144385 29144385 PRJNA1198392_P_NODE_8269_length_290_cov_1.419355_g8128_i0 PRJNA1198392 8269 290 1.419355 4.1161295 Tautonia 2680020 Bacteria Bacteria 47 0.00202   NR WP_390622223.1 2653855 g8128 i0 95.2 0.651724137931034 21 1 21.7 0 1 63 414 434 WP_390622223.1 hypothetical protein [Tautonia marina] diamond 189 47 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Tautonia Tautonia marina
29598495 29598495 PRJNA1198392_P_NODE_16170_length_250_cov_1.740113_g16029_i0 PRJNA1198392 16170 250 1.740113 4.3502825 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.9 0.0159   NR RME79982.1 2026780 g16029 i0 37.7 0.636 53 33 63.6 0 204 46 455 507 RME79982.1 MAG: hypothetical protein D6785_10785 [Planctomycetota bacterium] diamond 159 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29914751 29914751 PRJNA1198392_P_NODE_10751_length_279_cov_1.199029_g10610_i0 PRJNA1198392 10751 279 1.199029 3.34529091 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 153 2.3499999999999992e-43   NR HEV2293406.1 2876886 g10610 i0 76.9 0.978494623655914 91 21 97.8 0 3 275 176 266 HEV2293406.1 hypothetical protein [Tepidisphaeraceae bacterium] diamond 273 153 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
31874146 31874146 PRJNA1198392_P_NODE_8597_length_289_cov_1.115741_g8456_i0 PRJNA1198392 8597 289 1.115741 3.22449149 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 45.8 0.00521   NR HSU69413.1 2876886 g8456 i0 34.7 2.67820069204152 75 47 77.9 1 11 235 50 122 HSU69413.1 FtsX-like permease family protein [Tepidisphaeraceae bacterium] diamond 774 45.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae 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);;