contig_metadata
17 rows where bioproject = "PRJNA635397" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6257394 | 6257394 | PRJNA635397_P_NODE_40985_length_249_cov_8.221591_g40531_i0 | PRJNA635397 | 40985 | 249 | 8.221591 | 20.47176159 | Eukaryota | 2759 | Plants | Plants | 459 | 1.1399999999999998e-124 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g40531 | i0 | 100 | 99.6305220883534 | 248 | 0 | 99 | 0 | 2 | 249 | 294 | 47 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 24808 | 459 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 14634594 | 14634594 | PRJNA635397_P_NODE_26572_length_309_cov_2.084746_g26118_i0 | PRJNA635397 | 26572 | 309 | 2.084746 | 6.44186514 | Chlorophyta | 3041 | Plants | Plants | 142 | 1.17e-36 | NR | XP_003056374.1 | 564608 | g26118 | i0 | 71.1 | 11.6504854368932 | 97 | 28 | 94.2 | 0 | 1 | 291 | 785 | 881 | XP_003056374.1 uncharacterized protein MICPUCDRAFT_31433 [Micromonas pusilla CCMP1545] | diamond | 3600 | 142 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas pusilla | ||
| 17731560 | 17731560 | PRJNA635397_P_NODE_16394_length_406_cov_7.195195_g15940_i0 | PRJNA635397 | 16394 | 406 | 7.195195 | 29.2124917 | Eukaryota | 2759 | Plants | Plants | 56.5 | 0.003 | NTclustered | gi|2082247188|ref|XM_043062858.1| | 3055 | g15940 | i0 | 96.97 | 0.435960591133005 | 33 | 1 | 8 | 0 | 176 | 208 | 5341 | 5309 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g265950v5), mRNA | blastn | 177 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 20280183 | 20280183 | PRJNA635397_P_NODE_24416_length_323_cov_3.384000_g23962_i0 | PRJNA635397 | 24416 | 323 | 3.384 | 10.93032 | Eukaryota | 2759 | Plants | Plants | 593 | 4.0199999999999986e-165 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g23962 | i0 | 100 | 99.2383900928793 | 321 | 0 | 99 | 0 | 1 | 321 | 533 | 853 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 32054 | 593 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 23558459 | 23558459 | PRJNA635397_P_NODE_35799_length_264_cov_2.450262_g35345_i0 | PRJNA635397 | 35799 | 264 | 2.450262 | 6.46869168 | root | 1 | Root_unresolved | Root_unresolved | 111 | 2.82e-26 | NR | KAK3282172.1 | 36881 | g35345 | i0 | 66.3 | 27.6931818181818 | 86 | 29 | 97.7 | 0 | 2 | 259 | 179 | 264 | KAK3282172.1 hypothetical protein CYMTET_10079 [Cymbomonas tetramitiformis] | diamond | 7311 | 111 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 24832016 | 24832016 | PRJNA635397_P_NODE_27660_length_303_cov_1.343478_g27206_i0 | PRJNA635397 | 27660 | 303 | 1.343478 | 4.07073834 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 62.1 | 4.69e-5 | NTclustered | gi|2082252565|ref|XM_043065027.1| | 3055 | g27206 | i0 | 100 | 1.09240924092409 | 33 | 0 | 11 | 0 | 137 | 169 | 1504 | 1472 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_08g370700v5), mRNA | blastn | 331 | 62.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 26859803 | 26859803 | PRJNA635397_P_NODE_17681_length_388_cov_1.784127_g17227_i0 | PRJNA635397 | 17681 | 388 | 1.784127 | 6.92241276 | Haematococcus lacustris | 44745 | Plants | Plants | 47.4 | 0.00417 | NR | KAJ9530648.1 | 44745 | g17227 | i0 | 39.3 | 0.649484536082474 | 84 | 44 | 59.5 | 3 | 293 | 63 | 172 | 255 | KAJ9530648.1 hypothetical protein QJQ45_014799, partial [Haematococcus lacustris] | diamond | 252 | 47.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 27061805 | 27061805 | PRJNA635397_P_NODE_24842_length_320_cov_2.724696_g24388_i0 | PRJNA635397 | 24842 | 320 | 2.724696 | 8.7190272 | root | 1 | Root_unresolved | Root_unresolved | 87.4 | 1.13e-17 | NR | KAK3239164.1 | 36881 | g24388 | i0 | 37.2 | 3.890625 | 113 | 57 | 92.8 | 4 | 314 | 18 | 263 | 375 | KAK3239164.1 hypothetical protein CYMTET_50892 [Cymbomonas tetramitiformis] | diamond | 1245 | 87.4 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 27302312 | 27302312 | PRJNA635397_P_NODE_30403_length_288_cov_1.641860_g29949_i0 | PRJNA635397 | 30403 | 288 | 1.64186 | 4.7285568 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 75.9 | 1.33e-13 | NR | GAX78472.1 | 1157962 | g29949 | i0 | 90.2 | 0.854166666666667 | 41 | 4 | 42.7 | 0 | 3 | 125 | 423 | 463 | GAX78472.1 hypothetical protein CEUSTIGMA_g5911.t1 [Chlamydomonas eustigma] | diamond | 246 | 75.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 27472722 | 27472722 | PRJNA635397_P_NODE_29583_length_292_cov_1.858447_g29129_i0 | PRJNA635397 | 29583 | 292 | 1.858447 | 5.42666524 | Viridiplantae | 33090 | Plants | Plants | 99 | 1.2799999999999999e-23 | NR | KAK3278702.1 | 36881 | g29129 | i0 | 50 | 1.95205479452055 | 94 | 45 | 96.6 | 1 | 284 | 3 | 90 | 181 | KAK3278702.1 hypothetical protein CYMTET_13378 [Cymbomonas tetramitiformis] | diamond | 570 | 100 | 0.99 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 29165401 | 29165401 | PRJNA635397_P_NODE_21949_length_343_cov_1.362963_g21495_i0 | PRJNA635397 | 21949 | 343 | 1.362963 | 4.67496309 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 144 | 5.499999999999999e-38 | NR | KAK3253051.1 | 36881 | g21495 | i0 | 59.6 | 1.98542274052478 | 114 | 46 | 99.7 | 0 | 2 | 343 | 285 | 398 | KAK3253051.1 hypothetical protein CYMTET_37680 [Cymbomonas tetramitiformis] | diamond | 681 | 144 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 29291419 | 29291419 | PRJNA635397_P_NODE_9829_length_561_cov_3.895492_g9380_i0 | PRJNA635397 | 9829 | 561 | 3.895492 | 21.85371012 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 109 | 1.57e-24 | NR | XP_011401591.1 | 3075 | g9380 | i0 | 41.4 | 1.40641711229947 | 140 | 78 | 73.3 | 3 | 561 | 151 | 254 | 392 | XP_011401591.1 Peroxiredoxin-2 [Auxenochlorella protothecoides] | diamond | 789 | 109 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 30523236 | 30523236 | PRJNA635397_P_NODE_28453_length_298_cov_3.537778_g27999_i0 | PRJNA635397 | 28453 | 298 | 3.537778 | 10.54257844 | Bathycoccus prasinos | 41875 | Plants | Plants | 81.6 | 2.85e-18 | NR | XP_007515728.1 | 41875 | g27999 | i0 | 85 | 0.402684563758389 | 40 | 6 | 40.3 | 0 | 234 | 115 | 1 | 40 | XP_007515728.1 predicted protein [Bathycoccus prasinos] | diamond | 120 | 81.6 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Bathycoccus | Bathycoccus prasinos | ||
| 30776138 | 30776138 | PRJNA635397_P_NODE_14754_length_433_cov_2.772222_g14300_i0 | PRJNA635397 | 14754 | 433 | 2.772222 | 12.00372126 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 175 | 2.87e-49 | NR | KAK3253051.1 | 36881 | g14300 | i0 | 65.2 | 0.956120092378753 | 138 | 48 | 95.6 | 0 | 1 | 414 | 364 | 501 | KAK3253051.1 hypothetical protein CYMTET_37680 [Cymbomonas tetramitiformis] | diamond | 414 | 175 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 31641943 | 31641943 | PRJNA635397_P_NODE_42556_length_247_cov_1.465517_g42102_i0 | PRJNA635397 | 42556 | 247 | 1.465517 | 3.61982699 | Chlorellaceae | 35461 | Plants | Plants | 108 | 1.17e-25 | NR | KAL4855203.1 | 3077 | g42102 | i0 | 66.7 | 6.89878542510121 | 81 | 24 | 98.4 | 1 | 245 | 3 | 47 | 124 | KAL4855203.1 Adenylylsulfatase HINT1 [Chlorella vulgaris] | diamond | 1704 | 109 | 0.990825688073395 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 32072474 | 32072474 | PRJNA635397_P_NODE_46138_length_242_cov_2.218935_g45684_i0 | PRJNA635397 | 46138 | 242 | 2.218935 | 5.3698227 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 119 | 2.68e-29 | NR | KAK3253051.1 | 36881 | g45684 | i0 | 63.8 | 0.991735537190083 | 80 | 29 | 99.2 | 0 | 241 | 2 | 146 | 225 | KAK3253051.1 hypothetical protein CYMTET_37680 [Cymbomonas tetramitiformis] | diamond | 240 | 119 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 32811490 | 32811490 | PRJNA635397_P_NODE_21300_length_348_cov_2.774545_g20846_i0 | PRJNA635397 | 21300 | 348 | 2.774545 | 9.6554166 | Viridiplantae | 33090 | Plants | Plants | 57.4 | 3.02e-8 | NR | XP_007514946.1 | 41875 | g20846 | i0 | 56.5 | 0.956896551724138 | 46 | 20 | 39.7 | 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 |
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);;