contig_metadata
13 rows where bioproject = "PRJNA699078" and tax_clade = "core chlorophytes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10112714 | 10112714 | PRJNA699078_S_NODE_33628_length_298_cov_2.024096_g32679_i0 | PRJNA699078 | 33628 | 298 | 2.024096 | 6.03180608 | Sphaeropleales | 35491 | Plants | Plants | 69.7 | 2.45e-11 | NR | KAI8474822.1 | 39955 | g32679 | i0 | 34.5 | 2.36577181208054 | 84 | 55 | 84.6 | 0 | 255 | 4 | 846 | 929 | KAI8474822.1 MAG: hypothetical protein J3K34DRAFT_517905 [Monoraphidium minutum] | diamond | 705 | 70.1 | 0.994293865905849 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 28030338 | 28030338 | PRJNA699078_S_NODE_87545_length_179_cov_1.200000_g86596_i0 | PRJNA699078 | 87545 | 179 | 1.2 | 2.148 | Monoraphidium minutum | 39955 | Plants | Plants | 64.7 | 2.76e-10 | NR | KAI8464399.1 | 39955 | g86596 | i0 | 50 | 6.70391061452514 | 58 | 29 | 97.2 | 0 | 4 | 177 | 321 | 378 | KAI8464399.1 MAG: tRNA-guanine(15) transglycosylase-like protein [Monoraphidium minutum] | diamond | 1200 | 64.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 28061766 | 28061766 | PRJNA699078_S_NODE_106585_length_163_cov_0.912281_g105636_i0 | PRJNA699078 | 106585 | 163 | 0.912281 | 1.48701803 | Micractinium tetrahymenae | 2728915 | Plants | Plants | 47 | 3.11e-4 | NR | KAL4459165.1 | 2728915 | g105636 | i0 | 56.8 | 2.02453987730061 | 37 | 16 | 68.1 | 0 | 161 | 51 | 143 | 179 | KAL4459165.1 hypothetical protein ABPG75_014030 [Micractinium tetrahymenae] | diamond | 330 | 47 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium tetrahymenae | |
| 28230662 | 28230662 | PRJNA699078_S_NODE_31946_length_305_cov_2.988281_g30997_i0 | PRJNA699078 | 31946 | 305 | 2.988281 | 9.11425705 | Eukaryota | 2759 | Plants | Plants | 60.8 | 3.08e-8 | NR | XP_002951445.1 | 3068 | g30997 | i0 | 38.9 | 3.94426229508197 | 95 | 47 | 87.5 | 2 | 305 | 39 | 249 | 338 | XP_002951445.1 uncharacterized protein VOLCADRAFT_91941 [Volvox carteri f. nagariensis] | diamond | 1203 | 61.2 | 0.993464052287582 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 29103921 | 29103921 | PRJNA699078_S_NODE_43928_length_260_cov_1.407583_g42979_i0 | PRJNA699078 | 43928 | 260 | 1.407583 | 3.6597158 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 93.6 | 1.6400000000000002e-21 | NR | RMZ54723.1 | 3075 | g42979 | i0 | 50 | 0.992307692307692 | 86 | 43 | 99.2 | 0 | 1 | 258 | 105 | 190 | RMZ54723.1 hypothetical protein APUTEX25_003101, partial [Auxenochlorella protothecoides] | diamond | 258 | 93.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 29388108 | 29388108 | PRJNA699078_S_NODE_27349_length_328_cov_2.691756_g26400_i0 | PRJNA699078 | 27349 | 328 | 2.691756 | 8.82895968 | Pleodorina starrii | 330485 | Plants | Plants | 69.3 | 9.48e-12 | NR | GLC63338.1 | 330485 | g26400 | i0 | 59.7 | 1.66463414634146 | 62 | 14 | 46.6 | 1 | 188 | 36 | 9 | 70 | GLC63338.1 hypothetical protein PLESTF_000025700 [Pleodorina starrii] | diamond | 546 | 69.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Pleodorina | Pleodorina starrii | |
| 30789037 | 30789037 | PRJNA699078_S_NODE_12894_length_438_cov_23.637532_g11965_i0 | PRJNA699078 | 12894 | 438 | 23.637532 | 103.53239016 | Eukaryota | 2759 | Plants | Plants | 107 | 1.0699999999999997e-23 | NR | PRW32846.1 | 3076 | g11965 | i0 | 50.4 | 14.1095890410959 | 125 | 61 | 84.9 | 1 | 18 | 389 | 69 | 193 | PRW32846.1 60S ribosomal L19-2 isoform A [Chlorella sorokiniana] | diamond | 6180 | 108 | 0.990740740740741 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 31010168 | 31010168 | PRJNA699078_S_NODE_86554_length_180_cov_1.381679_g85605_i0 | PRJNA699078 | 86554 | 180 | 1.381679 | 2.4870222 | Chlorophyta | 3041 | Plants | Plants | 64.7 | 6.98e-11 | NR | MEW5299441.1 | 2578422 | g85605 | i0 | 56.7 | 6 | 60 | 25 | 98.3 | 1 | 2 | 178 | 88 | 147 | MEW5299441.1 hypothetical protein [Sanguina aurantia] | diamond | 1080 | 64.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Sanguina | Sanguina aurantia | |
| 31167875 | 31167875 | PRJNA699078_S_NODE_11855_length_451_cov_17.512438_g10933_i0 | PRJNA699078 | 11855 | 451 | 17.512438 | 78.98109538 | Eukaryota | 2759 | Plants | Plants | 132 | 7.27e-36 | NR | KAF5835469.1 | 3046 | g10933 | i0 | 47.6 | 19.0909090909091 | 124 | 65 | 82.5 | 0 | 451 | 80 | 39 | 162 | KAF5835469.1 60S ribosomal protein L18a-2 [Dunaliella salina] | diamond | 8610 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 31219837 | 31219837 | PRJNA699078_S_NODE_23895_length_348_cov_2.481605_g22946_i0 | PRJNA699078 | 23895 | 348 | 2.481605 | 8.6359854 | [Myrmecia] bisecta | 41462 | Plants | Plants | 43.5 | 0.0429 | NR | KAK9817134.1 | 41462 | g22946 | i0 | 43.8 | 0.413793103448276 | 48 | 26 | 41.4 | 1 | 347 | 204 | 146 | 192 | KAK9817134.1 hypothetical protein WJX72_010029 [[Myrmecia] bisecta] | diamond | 144 | 43.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 32800688 | 32800688 | PRJNA699078_S_NODE_93800_length_172_cov_1.691057_g92851_i0 | PRJNA699078 | 93800 | 172 | 1.691057 | 2.90861804 | Helicosporidium sp. ATCC 5 | 1907511 | Plants | Plants | 43.5 | 0.00719 | NR | KDD75821.1 | 1291522 | g92851 | i0 | 41.2 | 1.18604651162791 | 68 | 22 | 87.2 | 2 | 20 | 169 | 152 | 219 | KDD75821.1 ribosomal protein L6e [Helicosporidium sp. ATCC 50920] | diamond | 204 | 43.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ATCC 50920 | |
| 32863794 | 32863794 | PRJNA699078_S_NODE_59520_length_220_cov_1.315789_g58571_i0 | PRJNA699078 | 59520 | 220 | 1.315789 | 2.8947358 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 47 | 9.12e-4 | NR | KAF8055331.1 | 2742167 | g58571 | i0 | 50 | 2.29090909090909 | 40 | 20 | 54.5 | 0 | 58 | 177 | 1189 | 1228 | KAF8055331.1 SYM1 [Scenedesmus sp. PABB004] | diamond | 504 | 47 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 32895155 | 32895155 | PRJNA699078_S_NODE_18780_length_382_cov_8.477477_g17833_i0 | PRJNA699078 | 18780 | 382 | 8.477477 | 32.38396214 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 118 | 2.3899999999999993e-31 | NR | KAA6424298.1 | 2608996 | g17833 | i0 | 56 | 2.56806282722513 | 109 | 48 | 85.6 | 0 | 1 | 327 | 27 | 135 | KAA6424298.1 MAG: histone H3 [Trebouxia sp. A1-2] | diamond | 981 | 118 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 |
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);;