contig_metadata
16 rows where bioproject = "PRJNA1061474" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 178655 | 178655 | PRJNA1061474_P_NODE_38821_length_286_cov_1.422535_g38575_i0 | PRJNA1061474 | 38821 | 286 | 1.422535 | 4.0684501 | Chloropicon primus | 1764295 | Plants | Plants | 222 | 1.9e-53 | NTclustered | gi|1678645830|ref|NC_042490.1| | 1764295 | g38575 | i0 | 80.986 | 17.493006993007 | 284 | 50 | 99 | 3 | 1 | 282 | 36668 | 36949 | Chloropicon primus culture CCMP:1205 mitochondrion, complete genome | blastn | 5003 | 222 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon primus | ||
| 2729561 | 2729561 | PRJNA1061474_P_NODE_56303_length_242_cov_0.911243_g56057_i0 | PRJNA1061474 | 56303 | 242 | 0.911243 | 2.20520806 | Coccomyxa viridis | 1274662 | Plants | Plants | 160 | 9.37e-46 | NR | CAK0912297.1 | 1274662 | g56057 | i0 | 97.5 | 3.96694214876033 | 80 | 2 | 99.2 | 0 | 240 | 1 | 261 | 340 | CAK0912297.1 tufA [Coccomyxa viridis] | diamond | 960 | 160 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 7389431 | 7389431 | PRJNA1061474_P_NODE_54466_length_244_cov_0.900585_g54220_i0 | PRJNA1061474 | 54466 | 244 | 0.900585 | 2.1974274 | Desmochloris | 138596 | Plants | Plants | 322 | 1.52e-83 | NTclustered | gi|313476264|emb|FM882217.1| | 578869 | g54220 | i0 | 98.37 | 75.0573770491803 | 184 | 1 | 75 | 2 | 15 | 198 | 344 | 163 | Desmochloris sp. TP-2008 partial 18S rRNA gene, ITS1, 5.8S rRNA and ITS2, strain CCAP 6006/2 | blastn | 18314 | 322 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris mollenhaueri | |
| 7830696 | 7830696 | PRJNA1061474_P_NODE_24087_length_391_cov_0.814465_g23841_i0 | PRJNA1061474 | 24087 | 391 | 0.814465 | 3.18455815 | Eukaryota | 2759 | Plants | Plants | 171 | 1.5899999999999999e-46 | NR | PRW32884.1 | 3076 | g23841 | i0 | 82.1 | 20.7928388746803 | 106 | 19 | 81.3 | 0 | 5 | 322 | 20 | 125 | PRW32884.1 Histone H2A [Chlorella sorokiniana] | diamond | 8130 | 172 | 0.994186046511628 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 17589500 | 17589500 | PRJNA1061474_P_NODE_49834_length_247_cov_1.591954_g49588_i0 | PRJNA1061474 | 49834 | 247 | 1.591954 | 3.93212638 | Chlorophyta | 3041 | Plants | Plants | 396 | 8.95e-106 | NTclustered | gi|45385169|gb|AY553213.1| | 3075 | g49588 | i0 | 95.547 | 100.004048582996 | 247 | 11 | 100 | 0 | 1 | 247 | 862 | 1108 | Auxenochlorella protothecoides 16S small subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 24701 | 396 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 26592001 | 26592001 | PRJNA1061474_P_NODE_4341_length_1055_cov_1.491853_g4177_i0 | PRJNA1061474 | 4341 | 1055 | 1.491853 | 15.73904915 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 433 | 2.24e-146 | NR | KAK3253051.1 | 36881 | g4177 | i0 | 61.1 | 0.972511848341232 | 342 | 133 | 97.3 | 0 | 6 | 1031 | 160 | 501 | KAK3253051.1 hypothetical protein CYMTET_37680 [Cymbomonas tetramitiformis] | diamond | 1026 | 433 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 27541132 | 27541132 | PRJNA1061474_P_NODE_33344_length_317_cov_1.737705_g33098_i0 | PRJNA1061474 | 33344 | 317 | 1.737705 | 5.50852485 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 192 | 3.8899999999999994e-57 | NR | GAX78472.1 | 1157962 | g33098 | i0 | 88.6 | 0.993690851735016 | 105 | 12 | 99.4 | 0 | 315 | 1 | 351 | 455 | GAX78472.1 hypothetical protein CEUSTIGMA_g5911.t1 [Chlamydomonas eustigma] | diamond | 315 | 192 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 27785615 | 27785615 | PRJNA1061474_P_NODE_32584_length_322_cov_1.530120_g32338_i0 | PRJNA1061474 | 32584 | 322 | 1.53012 | 4.9269864 | Chlorophyta | 3041 | Plants | Plants | 111 | 4.9e-26 | NR | KAK3253051.1 | 36881 | g32338 | i0 | 54.8 | 1.93788819875776 | 104 | 47 | 96.9 | 0 | 320 | 9 | 389 | 492 | KAK3253051.1 hypothetical protein CYMTET_37680 [Cymbomonas tetramitiformis] | diamond | 624 | 111 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 27817160 | 27817160 | PRJNA1061474_P_NODE_44944_length_252_cov_2.150838_g44698_i0 | PRJNA1061474 | 44944 | 252 | 2.150838 | 5.42011176 | Eukaryota | 2759 | Plants | Plants | 149 | 1.92e-39 | NR | XP_002500915.1 | 296587 | g44698 | i0 | 85.2 | 13.5119047619048 | 81 | 12 | 96.4 | 0 | 244 | 2 | 299 | 379 | XP_002500915.1 predicted protein [Micromonas commoda] | diamond | 3405 | 149 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 28606274 | 28606274 | PRJNA1061474_P_NODE_56707_length_242_cov_0.911243_g56461_i0 | PRJNA1061474 | 56707 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 53.1 | 7.98e-6 | NR | GIL51318.1 | 51714 | g56461 | i0 | 50 | 2.98760330578512 | 52 | 26 | 64.5 | 0 | 215 | 60 | 124 | 175 | GIL51318.1 hypothetical protein Vafri_7335 [Volvox africanus] | diamond | 723 | 53.5 | 0.992523364485981 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 29340861 | 29340861 | PRJNA1061474_P_NODE_15269_length_519_cov_1.248879_g15024_i0 | PRJNA1061474 | 15269 | 519 | 1.248879 | 6.48168201 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 54.7 | 3.83e-5 | NR | KAK3260007.1 | 36881 | g15024 | i0 | 29.6 | 0.780346820809249 | 135 | 85 | 74 | 4 | 392 | 9 | 34 | 165 | KAK3260007.1 hypothetical protein CYMTET_31022 [Cymbomonas tetramitiformis] | diamond | 405 | 54.7 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 29624416 | 29624416 | PRJNA1061474_P_NODE_35830_length_303_cov_0.982609_g35584_i0 | PRJNA1061474 | 35830 | 303 | 0.982609 | 2.97730527 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 60.8 | 7.63e-9 | NR | KAG7666851.1 | 1650286 | g35584 | i0 | 53.2 | 2.6039603960396 | 62 | 28 | 61.4 | 1 | 118 | 303 | 34 | 94 | KAG7666851.1 hypothetical protein KSW81_000618 [Chlorella desiccata (nom. nud.)] | diamond | 789 | 60.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 30003981 | 30003981 | PRJNA1061474_P_NODE_32371_length_324_cov_0.804781_g32125_i0 | PRJNA1061474 | 32371 | 324 | 0.804781 | 2.60749044 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 49.3 | 2.65e-4 | NR | KAF6259220.1 | 2650976 | g32125 | i0 | 39.5 | 0.703703703703704 | 76 | 38 | 66.7 | 2 | 109 | 324 | 11 | 82 | KAF6259220.1 plastid lipid-associated protein/fibrillin conserved domain-containing protein [Scenedesmus sp. NREL 46B-D3] | diamond | 228 | 49.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 31164377 | 31164377 | PRJNA1061474_P_NODE_37955_length_290_cov_2.129032_g37709_i0 | PRJNA1061474 | 37955 | 290 | 2.129032 | 6.1741928 | Viridiplantae | 33090 | Plants | Plants | 57.4 | 1.64e-8 | NR | XP_007514946.1 | 41875 | g37709 | i0 | 56.5 | 1.14827586206897 | 46 | 20 | 47.6 | 0 | 71 | 208 | 7 | 52 | XP_007514946.1 predicted protein [Bathycoccus prasinos] | diamond | 333 | 57.4 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Bathycoccus | Bathycoccus prasinos | ||
| 31227725 | 31227725 | PRJNA1061474_P_NODE_27935_length_355_cov_1.702128_g27689_i0 | PRJNA1061474 | 27935 | 355 | 1.702128 | 6.0425544 | root | 1 | Root_unresolved | Root_unresolved | 91.3 | 1.32e-18 | NR | WIA21344.1 | 3088 | g27689 | i0 | 64.6 | 2.67887323943662 | 65 | 23 | 54.9 | 0 | 7 | 201 | 597 | 661 | WIA21344.1 hypothetical protein OEZ85_000570 [Tetradesmus obliquus] | diamond | 951 | 91.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 31931905 | 31931905 | PRJNA1061474_P_NODE_21097_length_424_cov_1.316239_g20851_i0 | PRJNA1061474 | 21097 | 424 | 1.316239 | 5.58085336 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 100 | 2.1699999999999994e-24 | NR | CAG9460866.1 | 765719 | g20851 | i0 | 47.3 | 0.92688679245283 | 131 | 53 | 92.7 | 1 | 401 | 9 | 8 | 122 | CAG9460866.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 393 | 100 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 |
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);;