RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA1174770" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1174770 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
26901683 26901683 PRJNA1174770_P_NODE_10881_length_164_cov_0.895652_g10792_i0 PRJNA1174770 10881 164 0.895652 1.46886928 Pseudomonadati 3379134 Bacteria Bacteria 75.1 9.61e-15   NR MBM4016972.1 2026780 g10792 i0 66.7 8.45121951219512 51 17 93.3 0 156 4 24 74 MBM4016972.1 DUF488 domain-containing protein [Planctomycetota bacterium] diamond 1386 75.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27641035 27641035 PRJNA1174770_P_NODE_8824_length_167_cov_0.881356_g8735_i0 PRJNA1174770 8824 167 0.881356 1.47186452 Pirellulales bacterium 2715253 Bacteria Bacteria 79.7 2.88e-17   NR MBX9790646.1 2715253 g8735 i0 90.5 0.754491017964072 42 4 75.4 0 1 126 96 137 MBX9790646.1 DUF423 domain-containing protein [Pirellulales bacterium] diamond 126 79.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
29314299 29314299 PRJNA1174770_P_NODE_6749_length_181_cov_1.030303_g6660_i0 PRJNA1174770 6749 181 1.030303 1.86484843 Planctomycetota bacterium 2026780 Bacteria Bacteria 42 0.0301   NR MBN1257956.1 2026780 g6660 i0 53.8 0.430939226519337 26 12 43.1 0 99 176 444 469 MBN1257956.1 hypothetical protein [Planctomycetota bacterium] diamond 78 42 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29535304 29535304 PRJNA1174770_P_NODE_10010_length_165_cov_0.896552_g9921_i0 PRJNA1174770 10010 165 0.896552 1.4793108 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 46.2 7.61e-4   NR MEX0717211.1 2026779 g9921 i0 54.8 0.763636363636364 42 15 70.9 2 23 139 15 55 MEX0717211.1 Na+/H+ antiporter subunit D [Planctomycetaceae bacterium] diamond 126 46.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29629660 29629660 PRJNA1174770_P_NODE_9610_length_166_cov_0.880342_g9521_i0 PRJNA1174770 9610 166 0.880342 1.46136772 Gemmataceae bacterium 2052164 Bacteria Bacteria 91.3 1.38e-21   NR MBY0527932.1 2052164 g9521 i0 81.5 2.92771084337349 54 10 97.6 0 162 1 86 139 MBY0527932.1 hypothetical protein [Gemmataceae bacterium] diamond 486 91.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
30103641 30103641 PRJNA1174770_P_NODE_12332_length_162_cov_0.902655_g12243_i0 PRJNA1174770 12332 162 0.902655 1.4623011 Planctomycetota bacterium 2026780 Bacteria Bacteria 66.2 5.62e-11   NR MBN9119861.1 2026780 g12243 i0 76.9 0.722222222222222 39 9 72.2 0 45 161 203 241 MBN9119861.1 hypothetical protein [Planctomycetota bacterium] diamond 117 66.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30640758 30640758 PRJNA1174770_P_NODE_5473_length_198_cov_2.080537_g5384_i0 PRJNA1174770 5473 198 2.080537 4.11946326 Sedimentisphaerales bacterium 2813034 Bacteria Bacteria 79.7 1.89e-15   NR HUV63088.1 2813034 g5384 i0 53.8 0.984848484848485 65 30 98.5 0 3 197 47 111 HUV63088.1 hypothetical protein [Sedimentisphaerales bacterium] diamond 195 79.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Sedimentisphaerales     Sedimentisphaerales bacterium
30735645 30735645 PRJNA1174770_P_NODE_10874_length_164_cov_0.895652_g10785_i0 PRJNA1174770 10874 164 0.895652 1.46886928 Phycisphaerales bacterium 2052180 Bacteria Bacteria 73.2 2.09e-13   NR MFN0011646.1 2052180 g10785 i0 78 0.75 41 9 75 0 153 31 93 133 MFN0011646.1 hypothetical protein [Phycisphaerales bacterium] diamond 123 73.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
31070944 31070944 PRJNA1174770_P_NODE_11655_length_163_cov_0.894737_g11566_i0 PRJNA1174770 11655 163 0.894737 1.45842131 Planctomycetia 203683 Bacteria Bacteria 92 5.22e-20   NR MDZ4687351.1 2026779 g11566 i0 75.5 4.76687116564417 53 13 97.5 0 161 3 336 388 MDZ4687351.1 DUF1549 domain-containing protein [Planctomycetaceae bacterium] diamond 777 92.8 0.991379310344828 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31387091 31387091 PRJNA1174770_P_NODE_10656_length_164_cov_0.904348_g10567_i0 PRJNA1174770 10656 164 0.904348 1.48313072 Bacteria 2 Bacteria Bacteria 82.8 5.67e-19   NR MBI1917961.1 2026780 g10567 i0 72 9.14634146341463 50 14 91.5 0 14 163 1 50 MBI1917961.1 co-chaperone GroES [Planctomycetota bacterium] diamond 1500 82.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31620771 31620771 PRJNA1174770_P_NODE_10876_length_164_cov_0.895652_g10787_i0 PRJNA1174770 10876 164 0.895652 1.46886928 Lacipirellulaceae bacterium 2691534 Bacteria Bacteria 72.4 4.25e-13   NR HJQ79984.1 2691534 g10787 i0 64 1.84756097560976 50 18 91.5 0 158 9 343 392 HJQ79984.1 DUF2092 domain-containing protein [Lacipirellulaceae bacterium] diamond 303 72.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae   Lacipirellulaceae bacterium
32095326 32095326 PRJNA1174770_P_NODE_8558_length_168_cov_0.865546_g8469_i0 PRJNA1174770 8558 168 0.865546 1.45411728 Gemmataceae bacterium 2052164 Bacteria Bacteria 94.7 1.55e-23   NR HLN28481.1 2052164 g8469 i0 78.2 2.94642857142857 55 12 98.2 0 1 165 45 99 HLN28481.1 hypothetical protein [Gemmataceae bacterium] diamond 495 94.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae 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);;