contig_metadata
14 rows where bioproject = "PRJNA603943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5680603 | 5680603 | PRJNA603943_P_NODE_27865_length_338_cov_1.464151_g27673_i0 | PRJNA603943 | 27865 | 338 | 1.464151 | 4.94883038 | Chlamydomonas schloesseri | 2026947 | Plants | Plants | 171 | 2.4e-52 | NR | KAG2453719.1 | 2026947 | g27673 | i0 | 78.8 | 0.923076923076923 | 104 | 21 | 91.4 | 1 | 336 | 28 | 53 | 156 | KAG2453719.1 hypothetical protein HYH02_001931 [Chlamydomonas schloesseri] | diamond | 312 | 171 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas schloesseri | |
| 15879281 | 15879281 | PRJNA603943_P_NODE_11873_length_470_cov_2.506297_g11681_i0 | PRJNA603943 | 11873 | 470 | 2.506297 | 11.7795959 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 359 | 2.4e-94 | NTclustered | gi|760444702|ref|XM_011401118.1| | 3075 | g11681 | i0 | 84.615 | 66.1744680851064 | 364 | 52 | 77 | 3 | 80 | 441 | 485 | 124 | Auxenochlorella protothecoides 40S ribosomal protein S23-2 partial mRNA | blastn | 31102 | 359 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 23530045 | 23530045 | PRJNA603943_P_NODE_51599_length_254_cov_1.276243_g51407_i0 | PRJNA603943 | 51599 | 254 | 1.276243 | 3.24165722 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 52.8 | 0.023 | NTclustered | gi|2917929623|emb|OZ234911.1| | 3350044 | g51407 | i0 | 100 | 0.110236220472441 | 28 | 0 | 11 | 0 | 69 | 96 | 1862726 | 1862699 | Trebouxia sp. SL0000003 genome assembly, chromosome: 6 | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 28198453 | 28198453 | PRJNA603943_P_NODE_45506_length_274_cov_1.253731_g45314_i0 | PRJNA603943 | 45506 | 274 | 1.253731 | 3.43522294 | Chlorella | 3071 | Plants | Plants | 45.8 | 0.00394 | NR | PRW56988.1 | 3076 | g45314 | i0 | 48.9 | 0.985401459854015 | 45 | 23 | 49.3 | 0 | 35 | 169 | 44 | 88 | PRW56988.1 DNA-3-methyladenine glycosylase [Chlorella sorokiniana] | diamond | 270 | 46.2 | 0.991341991341991 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 28659123 | 28659123 | PRJNA603943_P_NODE_17987_length_399_cov_1.251534_g17795_i0 | PRJNA603943 | 17987 | 399 | 1.251534 | 4.99362066 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 56.2 | 4.23e-6 | NR | BDA50364.1 | 2315456 | g17795 | i0 | 35.4 | 0.744360902255639 | 99 | 57 | 73.7 | 2 | 103 | 396 | 255 | 347 | BDA50364.1 5'-3' exoribonuclease 2 [Coccomyxa sp. Obi] | diamond | 297 | 56.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 28848252 | 28848252 | PRJNA603943_P_NODE_63348_length_245_cov_0.895349_g63156_i0 | PRJNA603943 | 63348 | 245 | 0.895349 | 2.19360505 | Chlamydomonas schloesseri | 2026947 | Plants | Plants | 52 | 1.69e-5 | NR | KAG2448812.1 | 2026947 | g63156 | i0 | 45.9 | 2.71836734693878 | 74 | 33 | 85.7 | 2 | 243 | 34 | 82 | 152 | KAG2448812.1 hypothetical protein HYH02_006163 [Chlamydomonas schloesseri] | diamond | 666 | 52 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas schloesseri | |
| 29321982 | 29321982 | PRJNA603943_P_NODE_31329_length_324_cov_0.856574_g31137_i0 | PRJNA603943 | 31329 | 324 | 0.856574 | 2.77529976 | Tetradesmus obliquus | 3088 | Plants | Plants | 139 | 6.41e-39 | NR | WIA40074.1 | 3088 | g31137 | i0 | 63 | 3 | 108 | 40 | 100 | 0 | 324 | 1 | 78 | 185 | WIA40074.1 hypothetical protein OEZ86_013489 [Tetradesmus obliquus] | diamond | 972 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 29858763 | 29858763 | PRJNA603943_P_NODE_61011_length_246_cov_1.329480_g60819_i0 | PRJNA603943 | 61011 | 246 | 1.32948 | 3.2705208 | Volvox carteri f. nagariensis | 3068 | Plants | Plants | 40 | 0.0375 | NR | XP_002955050.1 | 3068 | g60819 | i0 | 47.2 | 0.439024390243902 | 36 | 19 | 43.9 | 0 | 245 | 138 | 11 | 46 | XP_002955050.1 uncharacterized protein VOLCADRAFT_47552, partial [Volvox carteri f. nagariensis] | diamond | 108 | 40 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 30409533 | 30409533 | PRJNA603943_P_NODE_22073_length_369_cov_1.351351_g21881_i0 | PRJNA603943 | 22073 | 369 | 1.351351 | 4.98648519 | Chlorophyceae | 3166 | Plants | Plants | 92 | 8.14e-19 | NR | XP_013903103.1 | 145388 | g21881 | i0 | 69.5 | 1.91869918699187 | 59 | 18 | 48 | 0 | 3 | 179 | 499 | 557 | XP_013903103.1 F-type H+-transporting ATPase subunit beta [Monoraphidium neglectum] | diamond | 708 | 92.8 | 0.991379310344828 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 31818311 | 31818311 | PRJNA603943_P_NODE_53857_length_251_cov_0.865169_g53665_i0 | PRJNA603943 | 53857 | 251 | 0.865169 | 2.17157419 | Edaphochlamys debaryana | 47281 | Plants | Plants | 43.5 | 0.0207 | NR | KAG2484077.1 | 47281 | g53665 | i0 | 36.2 | 0.561752988047809 | 47 | 30 | 56.2 | 0 | 143 | 3 | 1 | 47 | KAG2484077.1 hypothetical protein HYH03_017096 [Edaphochlamys debaryana] | diamond | 141 | 43.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 32134913 | 32134913 | PRJNA603943_P_NODE_68038_length_242_cov_0.911243_g67846_i0 | PRJNA603943 | 68038 | 242 | 0.911243 | 2.20520806 | Chlorella sorokiniana | 3076 | Plants | Plants | 51.6 | 2.84e-5 | NR | PRW57253.1 | 3076 | g67846 | i0 | 66.7 | 0.409090909090909 | 33 | 11 | 40.9 | 0 | 102 | 4 | 1752 | 1784 | PRW57253.1 Phosphatidylinositol 4-kinase alpha 1 [Chlorella sorokiniana] | diamond | 99 | 51.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 32451449 | 32451449 | PRJNA603943_P_NODE_5919_length_628_cov_2.812613_g5734_i0 | PRJNA603943 | 5919 | 628 | 2.812613 | 17.66320964 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 95.1 | 2.16e-21 | NR | GAX78538.1 | 1157962 | g5734 | i0 | 64.8 | 0.515923566878981 | 108 | 34 | 51.6 | 1 | 595 | 272 | 4 | 107 | GAX78538.1 hypothetical protein CEUSTIGMA_g5978.t1 [Chlamydomonas eustigma] | diamond | 324 | 95.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 32559637 | 32559637 | PRJNA603943_P_NODE_52099_length_252_cov_1.564246_g51907_i0 | PRJNA603943 | 52099 | 252 | 1.564246 | 3.94189992 | Volvox | 3066 | Plants | Plants | 77.4 | 2.25e-14 | NR | XP_002950948.1 | 3068 | g51907 | i0 | 48 | 11.6309523809524 | 75 | 33 | 89.3 | 1 | 26 | 250 | 351 | 419 | XP_002950948.1 uncharacterized protein VOLCADRAFT_74841 [Volvox carteri f. nagariensis] | diamond | 2931 | 77.8 | 0.994858611825193 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 32672039 | 32672039 | PRJNA603943_P_NODE_54520_length_250_cov_0.870056_g54328_i0 | PRJNA603943 | 54520 | 250 | 0.870056 | 2.17514 | Raphidocelis subcapitata | 307507 | Plants | Plants | 94.4 | 2.88e-20 | NR | GBF89409.1 | 307507 | g54328 | i0 | 70 | 1.44 | 60 | 18 | 72 | 0 | 2 | 181 | 339 | 398 | GBF89409.1 tRNA (cytosine(34)-C(5))-methyltransferase [Raphidocelis subcapitata] | diamond | 360 | 94.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata |
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);;