contig_metadata
12 rows where analysis = "diamond", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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);;