RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 24 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA488043 · 24 ✖

analysis 1

  • diamond · 24 ✖
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
10653454 10653454 PRJNA488043_P_NODE_11349_length_299_cov_2.281481_g9108_i0 PRJNA488043 11349 299 2.281481 6.82162819 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 167 2.83e-49   NR MCE5266737.1 2026779 g9108 i0 96.4 0.842809364548495 84 3 84.3 0 253 2 176 259 MCE5266737.1 DUF1376 domain-containing protein [Planctomycetaceae bacterium] diamond 252 167 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
26664540 26664540 PRJNA488043_P_NODE_5961_length_527_cov_4.624498_g3954_i0 PRJNA488043 5961 527 4.624498 24.37110446 Planctomycetota bacterium 2026780 Bacteria Bacteria 50.8 5.53e-5   NR HHI80591.1 2026780 g3954 i0 43.9 0.375711574952562 66 37 37.6 0 193 390 8 73 HHI80591.1 hypothetical protein [Planctomycetota bacterium] diamond 198 50.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26696382 26696382 PRJNA488043_P_NODE_11161_length_304_cov_2.010909_g8920_i0 PRJNA488043 11161 304 2.010909 6.11316336 Planctomycetes bacterium RIFCSPHIGHO2_12_39_6 1801977 Bacteria Bacteria 58.2 1.59e-7   NR OHC00340.1 1801977 g8920 i0 36.5 1.02631578947368 104 55 92.8 3 291 10 126 228 OHC00340.1 MAG: hypothetical protein A2Z57_04415 [Planctomycetes bacterium RIFCSPHIGHO2_12_39_6] diamond 312 58.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetes bacterium RIFCSPHIGHO2_12_39_6
26759703 26759703 PRJNA488043_P_NODE_9581_length_354_cov_2.695385_g7345_i0 PRJNA488043 9581 354 2.695385 9.5416629 Planctomycetales bacterium 2053591 Bacteria Bacteria 122 2.19e-32   NR MCA9233288.1 2053591 g7345 i0 54.8 0.974576271186441 115 45 97.5 2 8 352 5 112 MCA9233288.1 hypothetical protein [Planctomycetales bacterium] diamond 345 122 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
26918179 26918179 PRJNA488043_P_NODE_5362_length_568_cov_1.959184_g3414_i0 PRJNA488043 5362 568 1.959184 11.12816512 Sedimentisphaerales bacterium 2813034 Bacteria Bacteria 55.1 4.13e-5   NR MBN1787875.1 2813034 g3414 i0 42.4 1.06161971830986 66 35 33.8 2 221 30 444 508 MBN1787875.1 hypothetical protein [Sedimentisphaerales bacterium] diamond 603 55.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Sedimentisphaerales     Sedimentisphaerales bacterium
26949665 26949665 PRJNA488043_P_NODE_15362_length_222_cov_3.419689_g13120_i0 PRJNA488043 15362 222 3.419689 7.59170958 Planctomycetota bacterium 2026780 Bacteria Bacteria 73.2 1.3e-14   NR MBI3272279.1 2026780 g13120 i0 80.4 0.621621621621622 46 9 62.2 0 139 2 1 46 MBI3272279.1 hypothetical protein [Planctomycetota bacterium] diamond 138 73.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26981373 26981373 PRJNA488043_P_NODE_4202_length_677_cov_3.362654_g2446_i0 PRJNA488043 4202 677 3.362654 22.76516758 Phycisphaerales bacterium 2052180 Bacteria Bacteria 135 2.9e-37   NR MBL4698367.1 2052180 g2446 i0 93.1 0.319054652880355 72 5 31.9 0 136 351 1 72 MBL4698367.1 hypothetical protein [Phycisphaerales bacterium] diamond 216 135 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27297583 27297583 PRJNA488043_P_NODE_15283_length_223_cov_4.876289_g13041_i0 PRJNA488043 15283 223 4.876289 10.87412447 Phycisphaerales bacterium 2052180 Bacteria Bacteria 56.6 2.2e-8   NR MBL4698368.1 2052180 g13041 i0 100 0.36322869955157 27 0 36.3 0 81 1 21 47 MBL4698368.1 hypothetical protein [Phycisphaerales bacterium] diamond 81 56.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27834357 27834357 PRJNA488043_P_NODE_6124_length_517_cov_3.993852_g4097_i0 PRJNA488043 6124 517 3.993852 20.64821484 Phycisphaerales bacterium 2052180 Bacteria Bacteria 135 4.84e-38   NR MBL4698367.1 2052180 g4097 i0 93.1 0.41779497098646 72 5 41.8 0 177 392 1 72 MBL4698367.1 hypothetical protein [Phycisphaerales bacterium] diamond 216 135 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28055316 28055316 PRJNA488043_P_NODE_15365_length_222_cov_3.015544_g13123_i0 PRJNA488043 15365 222 3.015544 6.69450768 Planctomycetota bacterium 2026780 Bacteria Bacteria 74.7 3.22e-15   NR MBI3272279.1 2026780 g13123 i0 82.6 0.621621621621622 46 8 62.2 0 139 2 1 46 MBI3272279.1 hypothetical protein [Planctomycetota bacterium] diamond 138 74.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28181523 28181523 PRJNA488043_P_NODE_8106_length_410_cov_3.196850_g5912_i0 PRJNA488043 8106 410 3.19685 13.107085 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 261 1.1499999999999996e-87   NR MCE5266732.1 2026779 g5912 i0 94.5 0.936585365853659 128 7 93.7 0 405 22 1 128 MCE5266732.1 hypothetical protein [Planctomycetaceae bacterium] diamond 384 261 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28466090 28466090 PRJNA488043_P_NODE_5406_length_565_cov_2.078358_g3451_i0 PRJNA488043 5406 565 2.078358 11.7427227 Phycisphaerales bacterium 2052180 Bacteria Bacteria 140 6.5399999999999996e-40   NR MBL4698367.1 2052180 g3451 i0 97.2 0.382300884955752 72 2 38.2 0 343 558 1 72 MBL4698367.1 hypothetical protein [Phycisphaerales bacterium] diamond 216 140 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29223902 29223902 PRJNA488043_P_NODE_15389_length_222_cov_2.196891_g13147_i0 PRJNA488043 15389 222 2.196891 4.87709802 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 162 2.65e-49   NR MCE5266736.1 2026779 g13147 i0 100 0.986486486486487 73 0 98.6 0 220 2 27 99 MCE5266736.1 hypothetical protein [Planctomycetaceae bacterium] diamond 219 162 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29286727 29286727 PRJNA488043_P_NODE_18169_length_190_cov_2.049689_g15927_i0 PRJNA488043 18169 190 2.049689 3.8944091 Gemmatales bacterium 2838789 Bacteria Bacteria 77.4 9.48e-15   NR HQR41391.1 2838789 g15927 i0 57.1 0.994736842105263 63 27 99.5 0 1 189 106 168 HQR41391.1 hypothetical protein [Gemmatales bacterium] diamond 189 77.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales     Gemmatales bacterium
29696920 29696920 PRJNA488043_P_NODE_17430_length_198_cov_1.786982_g15188_i0 PRJNA488043 17430 198 1.786982 3.53822436 Phycisphaerales bacterium 2052180 Bacteria Bacteria 50.8 3.92e-6   NR MBK8916356.1 2052180 g15188 i0 46.9 1.96969696969697 64 26 86.4 3 186 16 1 63 MBK8916356.1 hypothetical protein [Phycisphaerales bacterium] diamond 390 50.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29696928 29696928 PRJNA488043_P_NODE_6390_length_502_cov_2.923890_g4336_i0 PRJNA488043 6390 502 2.92389 14.6779278 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 66.2 8.21e-11   NR MAX24336.1 2026777 g4336 i0 52.2 0.908366533864542 67 31 40 1 217 417 13 78 MAX24336.1 hypothetical protein [Phycisphaeraceae bacterium] diamond 456 66.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
29855259 29855259 PRJNA488043_P_NODE_11191_length_303_cov_2.145985_g8950_i0 PRJNA488043 11191 303 2.145985 6.50233455 Planctomyces sp. 37635 Bacteria Bacteria 117 1.8099999999999999e-31   NR MFN9288882.1 37635 g8950 i0 56.6 1.04950495049505 106 39 98 2 299 3 5 110 MFN9288882.1 hypothetical protein [Planctomyces sp.] diamond 318 117 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp.
30866144 30866144 PRJNA488043_P_NODE_14394_length_237_cov_2.096154_g12152_i0 PRJNA488043 14394 237 2.096154 4.96788498 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 155 2.64e-46   NR MCE5266736.1 2026779 g12152 i0 97.4 0.987341772151899 78 2 98.7 0 1 234 97 174 MCE5266736.1 hypothetical protein [Planctomycetaceae bacterium] diamond 234 155 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31435100 31435100 PRJNA488043_P_NODE_2076_length_1080_cov_2.398668_g750_i1 PRJNA488043 2076 1080 2.398668 25.9056144 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 75.1 1.1e-12   NR MFN9371944.1 2026779 g750 i1 56.9 0.347222222222222 65 28 18.1 0 736 542 46 110 MFN9371944.1 hypothetical protein [Planctomycetaceae bacterium] diamond 375 75.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31561877 31561877 PRJNA488043_P_NODE_8196_length_406_cov_2.328912_g6000_i0 PRJNA488043 8196 406 2.328912 9.45538272 Planctomyces sp. 37635 Bacteria Bacteria 80.1 2.24e-16   NR MFN9288882.1 37635 g6000 i0 45.3 0.864532019704433 117 54 80.5 6 385 59 2 116 MFN9288882.1 hypothetical protein [Planctomyces sp.] diamond 351 80.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp.
31782940 31782940 PRJNA488043_P_NODE_18797_length_184_cov_1.819355_g16555_i0 PRJNA488043 18797 184 1.819355 3.3476132 Tautonia plasticadhaerens 2527974 Bacteria Bacteria 42.7 0.0176   NR WP_145268593.1 2527974 g16555 i0 51.2 0.668478260869565 41 20 66.8 0 38 160 1 41 WP_145268593.1 LamG domain-containing protein [Tautonia plasticadhaerens] diamond 123 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Tautonia Tautonia plasticadhaerens
32099442 32099442 PRJNA488043_P_NODE_19998_length_172_cov_1.496503_g17756_i0 PRJNA488043 19998 172 1.496503 2.57398516 Gemmatales bacterium 2838789 Bacteria Bacteria 57.4 2.34e-8   NR HQR41390.1 2838789 g17756 i0 74.4 0.680232558139535 39 10 68 0 171 55 120 158 HQR41390.1 hypothetical protein [Gemmatales bacterium] diamond 117 57.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales     Gemmatales bacterium
32636793 32636793 PRJNA488043_P_NODE_8200_length_406_cov_2.225464_g6004_i0 PRJNA488043 8200 406 2.225464 9.03538384 Planctomyces sp. 37635 Bacteria Bacteria 80.1 2.24e-16   NR MFN9288882.1 37635 g6004 i0 45.3 0.864532019704433 117 54 80.5 6 385 59 2 116 MFN9288882.1 hypothetical protein [Planctomyces sp.] diamond 351 80.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp.
32857418 32857418 PRJNA488043_P_NODE_19700_length_175_cov_1.595890_g17458_i0 PRJNA488043 19700 175 1.59589 2.7928075 Planctomycetales bacterium 2053591 Bacteria Bacteria 58.5 1.69e-8   NR MCA9233288.1 2053591 g17458 i0 45.6 0.977142857142857 57 29 94.3 1 10 174 137 193 MCA9233288.1 hypothetical protein [Planctomycetales bacterium] diamond 171 58.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales 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);;