contig_metadata
20 rows where bioproject = "PRJNA577580" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 564079 | 564079 | PRJNA577580_P_NODE_1641_length_708_cov_6.151181_g1567_i0 | PRJNA577580 | 1641 | 708 | 6.151181 | 43.55036148 | Placocista sp. CC-Grouse Mountain | 741089 | SAR_Eukaryotes | SAR_Eukaryotes | 968 | 0 | NTclustered | gi|290760485|gb|GQ144688.1| | 741089 | g1567 | i0 | 91.48 | 73.6271186440678 | 716 | 44 | 100 | 15 | 1 | 708 | 1646 | 2352 | Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence | blastn | 52128 | 968 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Placocista | Placocista sp. CC-Grouse Mountain | ||
| 3689527 | 3689527 | PRJNA577580_P_NODE_7343_length_332_cov_1.629344_g7265_i0 | PRJNA577580 | 7343 | 332 | 1.629344 | 5.40942208 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 3.32e-34 | NR | MES1913934.1 | 1215613 | g7265 | i0 | 71.6 | 0.731927710843373 | 81 | 21 | 71.4 | 1 | 327 | 91 | 12 | 92 | MES1913934.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 243 | 123 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 4391464 | 4391464 | PRJNA577580_P_NODE_12324_length_264_cov_1.518325_g12246_i0 | PRJNA577580 | 12324 | 264 | 1.518325 | 4.008378 | uncultured Euglyphidae sp. | 1764557 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 3.359999999999999e-130 | NTclustered | gi|959360330|gb|KT272503.1| | 1764557 | g12246 | i0 | 99.242 | 100.003787878788 | 264 | 2 | 100 | 0 | 1 | 264 | 541 | 804 | Uncultured Euglyphidae sp. clone CM2_2_4 18S ribosomal RNA gene, partial sequence | blastn | 26401 | 477 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | uncultured Euglyphidae sp. | |||
| 4391530 | 4391530 | PRJNA577580_P_NODE_5204_length_392_cov_3.727273_g5126_i0 | PRJNA577580 | 5204 | 392 | 3.727273 | 14.61091016 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 719 | 0 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g5126 | i0 | 99.745 | 100.65306122449 | 392 | 1 | 100 | 0 | 1 | 392 | 1555 | 1946 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 39456 | 719 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 5667735 | 5667735 | PRJNA577580_P_NODE_16965_length_230_cov_3.477707_g16887_i0 | PRJNA577580 | 16965 | 230 | 3.477707 | 7.9987261 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 1.07e-104 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g16887 | i0 | 97.391 | 51.095652173913 | 230 | 6 | 100 | 0 | 1 | 230 | 1967 | 2196 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 11752 | 392 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 5667743 | 5667743 | PRJNA577580_P_NODE_1885_length_662_cov_3.073005_g1810_i0 | PRJNA577580 | 1885 | 662 | 3.073005 | 20.3432931 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 7.61e-81 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g1810 | i0 | 83.427 | 34.9033232628399 | 356 | 42 | 94 | 12 | 1 | 355 | 3655 | 3994 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 23106 | 315 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 18415973 | 18415973 | PRJNA577580_P_NODE_6075_length_364_cov_3.859107_g5997_i0 | PRJNA577580 | 6075 | 364 | 3.859107 | 14.04714948 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 510 | 4.74e-140 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g5997 | i0 | 91.848 | 1.15934065934066 | 368 | 26 | 100 | 4 | 1 | 364 | 17656 | 18023 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 422 | 510 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 20264622 | 20264622 | PRJNA577580_P_NODE_12056_length_266_cov_3.943005_g11978_i0 | PRJNA577580 | 12056 | 266 | 3.943005 | 10.4883933 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 5.049999999999999e-31 | NR | MES1910618.1 | 1215613 | g11978 | i0 | 73.3 | 20.6165413533835 | 86 | 22 | 97 | 1 | 9 | 266 | 188 | 272 | MES1910618.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 5484 | 122 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 20264628 | 20264628 | PRJNA577580_P_NODE_14556_length_249_cov_0.886364_g14478_i0 | PRJNA577580 | 14556 | 249 | 0.886364 | 2.20704636 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 5.919999999999998e-43 | NTclustered | gi|33089911|gb|AY283754.1| | 238774 | g14478 | i0 | 81.858 | 64.9076305220884 | 226 | 37 | 90 | 4 | 1 | 224 | 271 | 494 | Clathrulina elegans isolate Cla70_1 actin mRNA, partial cds | blastn | 16162 | 187 | 1 | Eukaryota | Sar | Cercozoa | Clathrulinidae | Clathrulina | Clathrulina elegans | ||||
| 24090014 | 24090014 | PRJNA577580_P_NODE_1859_length_668_cov_1.250420_g1784_i0 | PRJNA577580 | 1859 | 668 | 1.25042 | 8.3528056 | Cercozoa sp. DMV | 1342330 | SAR_Eukaryotes | SAR_Eukaryotes | 378 | 1.01e-127 | NR | BAN37425.1 | 1342330 | g1784 | i0 | 82 | 0.997005988023952 | 222 | 40 | 99.7 | 0 | 666 | 1 | 215 | 436 | BAN37425.1 elongation factor 1-alpha [Cercozoa sp. DMV] | diamond | 666 | 378 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. DMV | ||||||
| 24790202 | 24790202 | PRJNA577580_P_NODE_5580_length_379_cov_1.424837_g5502_i0 | PRJNA577580 | 5580 | 379 | 1.424837 | 5.40013223 | Mesofila limnetica | 1979842 | SAR_Eukaryotes | SAR_Eukaryotes | 560 | 4.85e-155 | NTclustered | gi|88792585|gb|DQ386166.1| | 1979842 | g5502 | i0 | 93.931 | 77.9709762532981 | 379 | 9 | 100 | 8 | 1 | 379 | 1857 | 1493 | Dimorpha-like sp. ATCC 50522 28S ribosomal RNA gene, partial sequence | blastn | 29551 | 560 | 1 | Eukaryota | Sar | Cercozoa | Mesofilidae | Mesofila | Mesofila limnetica | ||||
| 26984666 | 26984666 | PRJNA577580_P_NODE_3122_length_508_cov_2.427586_g3044_i0 | PRJNA577580 | 3122 | 508 | 2.427586 | 12.33213688 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 86.3 | 5.7e-17 | NR | MES1907754.1 | 1215613 | g3044 | i0 | 35.4 | 1.7007874015748 | 144 | 88 | 82.1 | 2 | 34 | 450 | 62 | 205 | MES1907754.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 864 | 86.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28532574 | 28532574 | PRJNA577580_P_NODE_927_length_911_cov_2.776850_g864_i0 | PRJNA577580 | 927 | 911 | 2.77685 | 25.2971035 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 3.4e-12 | NR | MES1915247.1 | 1215613 | g864 | i0 | 58.8 | 0.474204171240395 | 68 | 28 | 22.4 | 0 | 7 | 210 | 187 | 254 | MES1915247.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 432 | 77.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29100802 | 29100802 | PRJNA577580_P_NODE_5008_length_401_cov_1.091463_g4930_i0 | PRJNA577580 | 5008 | 401 | 1.091463 | 4.37676663 | Phaeodaria sp. OSH121 | 1909273 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 4.12e-10 | NR | AOW69256.1 | 1909273 | g4930 | i0 | 35 | 0.875311720698254 | 117 | 55 | 71.8 | 1 | 99 | 386 | 49 | 165 | AOW69256.1 silicon transporter-like 2, partial [Phaeodaria sp. OSH121] | diamond | 351 | 67.4 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Phaeodaria sp. OSH121 | |||||
| 29858457 | 29858457 | PRJNA577580_P_NODE_9331_length_298_cov_2.533333_g9253_i0 | PRJNA577580 | 9331 | 298 | 2.533333 | 7.54933234 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 1.83e-6 | NR | MES1913603.1 | 1215613 | g9253 | i0 | 31.2 | 0.936241610738255 | 93 | 61 | 90.6 | 1 | 8 | 277 | 137 | 229 | MES1913603.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 279 | 55.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29890265 | 29890265 | PRJNA577580_P_NODE_11711_length_270_cov_1.467005_g11633_i0 | PRJNA577580 | 11711 | 270 | 1.467005 | 3.9609135 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 93.2 | 8.47e-22 | NR | MES1914171.1 | 1215613 | g11633 | i0 | 67.2 | 1.34444444444444 | 61 | 20 | 67.8 | 0 | 270 | 88 | 92 | 152 | MES1914171.1 40S ribosomal protein S11-B [Cercozoa sp. M6MM] | diamond | 363 | 93.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30932788 | 30932788 | PRJNA577580_P_NODE_2694_length_550_cov_2.683438_g2616_i0 | PRJNA577580 | 2694 | 550 | 2.683438 | 14.758909 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 223 | 1.3099999999999999e-68 | NR | AAT09103.1 | 227086 | g2616 | i0 | 56.5 | 1.01454545454545 | 186 | 74 | 99.3 | 3 | 2 | 547 | 119 | 301 | AAT09103.1 digestive cysteine proteinase [Bigelowiella natans] | diamond | 558 | 223 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 31059436 | 31059436 | PRJNA577580_P_NODE_14555_length_249_cov_0.886364_g14477_i0 | PRJNA577580 | 14555 | 249 | 0.886364 | 2.20704636 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 6.14e-7 | NR | MES1915826.1 | 1215613 | g14477 | i0 | 54.3 | 2.53012048192771 | 46 | 21 | 55.4 | 0 | 73 | 210 | 80 | 125 | MES1915826.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 630 | 54.7 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31691522 | 31691522 | PRJNA577580_P_NODE_5677_length_376_cov_1.841584_g5599_i0 | PRJNA577580 | 5677 | 376 | 1.841584 | 6.92435584 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 7.74e-11 | NR | MES1910922.1 | 1215613 | g5599 | i0 | 46.8 | 0.61436170212766 | 77 | 41 | 61.4 | 0 | 332 | 102 | 243 | 319 | MES1910922.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 231 | 69.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32134571 | 32134571 | PRJNA577580_P_NODE_3778_length_463_cov_2.069231_g3700_i0 | PRJNA577580 | 3778 | 463 | 2.069231 | 9.58053953 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 1.05e-4 | NR | MES1911396.1 | 1215613 | g3700 | i0 | 37.9 | 0.375809935205184 | 58 | 36 | 37.6 | 0 | 187 | 360 | 196 | 253 | MES1911396.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 174 | 52.4 | 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);;