contig_metadata
26 rows where bioproject = "PRJNA611476", tax_clade = "Sar" and tax_phylum = "Cercozoa"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1865260 | 1865260 | PRJNA611476_P_NODE_32002_length_366_cov_4.713311_g31211_i0 | PRJNA611476 | 32002 | 366 | 4.713311 | 17.25071826 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 2.48e-58 | NTclustered | gi|300676716|gb|GQ377714.1| | 323453 | g31211 | i0 | 86.574 | 0.590163934426229 | 216 | 29 | 59 | 0 | 151 | 366 | 454 | 239 | Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds | blastn | 216 | 239 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 1865631 | 1865631 | PRJNA611476_P_NODE_58062_length_288_cov_1.432558_g57271_i0 | PRJNA611476 | 58062 | 288 | 1.432558 | 4.12576704 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 99.8 | 2.23e-22 | NR | MES1910759.1 | 1215613 | g57271 | i0 | 60.8 | 0.822916666666667 | 79 | 31 | 82.3 | 0 | 41 | 277 | 201 | 279 | MES1910759.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 237 | 99.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 15891852 | 15891852 | PRJNA611476_P_NODE_10693_length_596_cov_1.766730_g9909_i0 | PRJNA611476 | 10693 | 596 | 1.76673 | 10.5297108 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 817 | 0 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g9909 | i0 | 91.362 | 74.4110738255034 | 602 | 44 | 99 | 5 | 2 | 596 | 1277 | 1877 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 44349 | 817 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 17167376 | 17167376 | PRJNA611476_P_NODE_44694_length_322_cov_2.473896_g43903_i0 | PRJNA611476 | 44694 | 322 | 2.473896 | 7.96594512 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 1.26e-75 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g43903 | i0 | 83.742 | 34.9751552795031 | 326 | 40 | 100 | 11 | 1 | 322 | 3722 | 4038 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 11262 | 296 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 19716279 | 19716279 | PRJNA611476_P_NODE_61476_length_282_cov_1.473684_g60685_i0 | PRJNA611476 | 61476 | 282 | 1.473684 | 4.15578888 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 1.31e-124 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g60685 | i0 | 95.819 | 101.684397163121 | 287 | 7 | 100 | 4 | 1 | 282 | 2158 | 2444 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 28675 | 459 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 20992318 | 20992318 | PRJNA611476_P_NODE_8197_length_677_cov_4.844371_g7423_i0 | PRJNA611476 | 8197 | 677 | 4.844371 | 32.79639167 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 551 | 5.459999999999998e-152 | NTclustered | gi|301014702|gb|GQ377715.1| | 323453 | g7423 | i0 | 88.791 | 49.1536189069424 | 455 | 44 | 67 | 7 | 216 | 666 | 491 | 40 | Heteromita sp. PRA-74 ribosomal protein S23a (rps23a) mRNA, complete cds | blastn | 33277 | 551 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 21549947 | 21549947 | PRJNA611476_P_NODE_54537_length_296_cov_1.381166_g53746_i0 | PRJNA611476 | 54537 | 296 | 1.381166 | 4.08825136 | Cercozoa sp. DMV | 1342330 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 2.07e-50 | NR | BAN37425.1 | 1342330 | g53746 | i0 | 84.4 | 0.972972972972973 | 96 | 15 | 97.3 | 0 | 7 | 294 | 274 | 369 | BAN37425.1 elongation factor 1-alpha [Cercozoa sp. DMV] | diamond | 288 | 174 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. DMV | ||||||
| 23541626 | 23541626 | PRJNA611476_P_NODE_20739_length_438_cov_1.621918_g19948_i0 | PRJNA611476 | 20739 | 438 | 1.621918 | 7.10400084 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 1.14e-67 | NR | ADK26622.1 | 323453 | g19948 | i0 | 75.4 | 13.4246575342466 | 130 | 32 | 89 | 0 | 410 | 21 | 1 | 130 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 5880 | 211 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 24099638 | 24099638 | PRJNA611476_P_NODE_2979_length_1143_cov_4.742056_g2384_i0 | PRJNA611476 | 2979 | 1143 | 4.742056 | 54.20170008 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 367 | 4.58e-123 | NR | MES1911029.1 | 1215613 | g2384 | i0 | 63.6 | 0.808398950131234 | 308 | 104 | 79.8 | 2 | 1 | 912 | 2 | 305 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 924 | 367 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 24815852 | 24815852 | PRJNA611476_P_NODE_49400_length_309_cov_2.110169_g48609_i0 | PRJNA611476 | 49400 | 309 | 2.110169 | 6.52042221 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 5.21e-36 | NR | AAO89069.1 | 227086 | g48609 | i0 | 68.9 | 2.98058252427184 | 103 | 31 | 99 | 1 | 2 | 307 | 103 | 205 | AAO89069.1 cytosolic class I fructose-1,6-bisphosphate aldolase [Bigelowiella natans] | diamond | 921 | 135 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 26605195 | 26605195 | PRJNA611476_P_NODE_72121_length_262_cov_1.629630_g71330_i0 | PRJNA611476 | 72121 | 262 | 1.62963 | 4.2696306 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 6.13e-10 | NR | MES1909155.1 | 1215613 | g71330 | i0 | 47 | 0.755725190839695 | 66 | 35 | 75.6 | 0 | 3 | 200 | 256 | 321 | MES1909155.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 198 | 65.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27048663 | 27048663 | PRJNA611476_P_NODE_64222_length_277_cov_1.509804_g63431_i0 | PRJNA611476 | 64222 | 277 | 1.509804 | 4.18215708 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 6.65e-19 | NR | MES1916034.1 | 1215613 | g63431 | i0 | 54 | 0.942238267148014 | 87 | 32 | 86.6 | 3 | 242 | 3 | 126 | 211 | MES1916034.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 261 | 87.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27491107 | 27491107 | PRJNA611476_P_NODE_77743_length_251_cov_1.730337_g76952_i0 | PRJNA611476 | 77743 | 251 | 1.730337 | 4.34314587 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 2.63e-24 | NR | ADK26622.1 | 323453 | g76952 | i0 | 82.7 | 0.621513944223108 | 52 | 9 | 62.2 | 0 | 2 | 157 | 79 | 130 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 156 | 98.6 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 27648937 | 27648937 | PRJNA611476_P_NODE_24544_length_408_cov_0.919403_g23753_i0 | PRJNA611476 | 24544 | 408 | 0.919403 | 3.75116424 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 1.33e-32 | NR | AAP34642.1 | 227086 | g23753 | i0 | 74 | 0.566176470588235 | 77 | 20 | 56.6 | 0 | 2 | 232 | 13 | 89 | AAP34642.1 small ubiquitin-like modifier [Bigelowiella natans] | diamond | 231 | 120 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 28311955 | 28311955 | PRJNA611476_P_NODE_18826_length_458_cov_1.031169_g18036_i0 | PRJNA611476 | 18826 | 458 | 1.031169 | 4.72275402 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 2.03e-11 | NR | MES1914773.1 | 1215613 | g18036 | i0 | 73.8 | 0.275109170305677 | 42 | 11 | 27.5 | 0 | 3 | 128 | 80 | 121 | MES1914773.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 126 | 68.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28880135 | 28880135 | PRJNA611476_P_NODE_36488_length_349_cov_0.913043_g35697_i0 | PRJNA611476 | 36488 | 349 | 0.913043 | 3.18652007 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 90.5 | 1.4e-20 | NR | MES1913255.1 | 1215613 | g35697 | i0 | 47.7 | 1.51289398280802 | 88 | 44 | 73.9 | 1 | 92 | 349 | 32 | 119 | MES1913255.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 528 | 90.5 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28911525 | 28911525 | PRJNA611476_P_NODE_64888_length_276_cov_1.418719_g64097_i0 | PRJNA611476 | 64888 | 276 | 1.418719 | 3.91566444 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0151 | NR | MES1914654.1 | 1215613 | g64097 | i0 | 76.9 | 1.91304347826087 | 26 | 6 | 28.3 | 0 | 274 | 197 | 374 | 399 | MES1914654.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 528 | 44.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28943714 | 28943714 | PRJNA611476_P_NODE_36568_length_348_cov_1.789091_g35777_i0 | PRJNA611476 | 36568 | 348 | 1.789091 | 6.22603668 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 71.2 | 7.16e-14 | NR | MES1910746.1 | 1215613 | g35777 | i0 | 60 | 0.474137931034483 | 55 | 20 | 45.7 | 1 | 166 | 324 | 1 | 55 | MES1910746.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 165 | 71.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29164665 | 29164665 | PRJNA611476_P_NODE_64289_length_277_cov_1.509804_g63498_i0 | PRJNA611476 | 64289 | 277 | 1.509804 | 4.18215708 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 1.47e-11 | NR | MES1912506.1 | 1215613 | g63498 | i0 | 38 | 0.996389891696751 | 92 | 53 | 99.6 | 1 | 276 | 1 | 2 | 89 | MES1912506.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 276 | 69.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29227828 | 29227828 | PRJNA611476_P_NODE_76429_length_254_cov_1.276243_g75638_i0 | PRJNA611476 | 76429 | 254 | 1.276243 | 3.24165722 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 6.67e-6 | NR | MES1911260.1 | 1215613 | g75638 | i0 | 47.4 | 0.673228346456693 | 57 | 30 | 67.3 | 0 | 2 | 172 | 250 | 306 | MES1911260.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 171 | 53.5 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29322200 | 29322200 | PRJNA611476_P_NODE_58069_length_288_cov_1.432558_g57278_i0 | PRJNA611476 | 58069 | 288 | 1.432558 | 4.12576704 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 52 | 3.43e-5 | NR | MES1912357.1 | 1215613 | g57278 | i0 | 44.3 | 1.30208333333333 | 61 | 32 | 61.5 | 1 | 1 | 177 | 226 | 286 | MES1912357.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 375 | 52 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29890793 | 29890793 | PRJNA611476_P_NODE_25011_length_404_cov_2.685801_g24220_i0 | PRJNA611476 | 25011 | 404 | 2.685801 | 10.85063604 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 1.57e-11 | NR | MES1911722.1 | 1215613 | g24220 | i0 | 58.5 | 0.393564356435644 | 53 | 22 | 39.4 | 0 | 26 | 184 | 1 | 53 | MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 159 | 65.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30048434 | 30048434 | PRJNA611476_P_NODE_5211_length_845_cov_1.458549_g4484_i0 | PRJNA611476 | 5211 | 845 | 1.458549 | 12.32473905 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 9.57e-32 | NR | MES1907597.1 | 1215613 | g4484 | i0 | 36.8 | 1.4094674556213 | 201 | 118 | 71.4 | 3 | 150 | 752 | 3 | 194 | MES1907597.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1191 | 130 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30111706 | 30111706 | PRJNA611476_P_NODE_43632_length_326_cov_0.913043_g42841_i0 | PRJNA611476 | 43632 | 326 | 0.913043 | 2.97652018 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 88.6 | 7.27e-18 | NR | MES1906957.1 | 1215613 | g42841 | i0 | 83 | 0.432515337423313 | 47 | 8 | 43.3 | 0 | 141 | 1 | 421 | 467 | MES1906957.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 141 | 88.6 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30743724 | 30743724 | PRJNA611476_P_NODE_48394_length_312_cov_1.288703_g47603_i0 | PRJNA611476 | 48394 | 312 | 1.288703 | 4.02075336 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 7.88e-20 | NR | MES1916707.1 | 1215613 | g47603 | i0 | 55 | 0.769230769230769 | 80 | 33 | 76.9 | 1 | 307 | 68 | 183 | 259 | MES1916707.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 240 | 91.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32798065 | 32798065 | PRJNA611476_P_NODE_34580_length_356_cov_1.088339_g33789_i0 | PRJNA611476 | 34580 | 356 | 1.088339 | 3.87448684 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 6.38e-13 | NR | MES1907716.1 | 1215613 | g33789 | i0 | 50.7 | 0.581460674157303 | 69 | 34 | 58.1 | 0 | 3 | 209 | 991 | 1059 | MES1907716.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 207 | 75.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
Advanced export
JSON shape: default, array, newline-delimited
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);;