contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA615175" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1149797 | 1149797 | PRJNA615175_P_NODE_12981_length_396_cov_1.566563_g12813_i0 | PRJNA615175 | 12981 | 396 | 1.566563 | 6.20358948 | Trebouxiophyceae | 75966 | Plants | Plants | 665 | 0 | NTclustered | gi|371782094|emb|HE610126.1| | 33092 | g12813 | i0 | 96.97 | 100.247474747475 | 396 | 12 | 100 | 0 | 1 | 396 | 4306 | 4701 | Koliella longiseta 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 470-1 | blastn | 39698 | 665 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 3146032 | 3146032 | PRJNA615175_P_NODE_4863_length_700_cov_7.063796_g4702_i0 | PRJNA615175 | 4863 | 700 | 7.063796 | 49.446572 | Dunaliella salina | 3046 | Plants | Plants | 409 | 3.6e-109 | NTclustered | gi|90191868|gb|DQ414847.1| | 3046 | g4702 | i0 | 79.35 | 73.1557142857143 | 615 | 101 | 86 | 22 | 102 | 700 | 787 | 183 | Dunaliella salina major light-harvesting chlorophyll a/b protein 2.1 mRNA, complete cds | blastn | 51209 | 409 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 5698377 | 5698377 | PRJNA615175_P_NODE_16685_length_344_cov_1.678967_g16517_i0 | PRJNA615175 | 16685 | 344 | 1.678967 | 5.77564648 | Pleurastrum terricola | 34116 | Plants | Plants | 636 | 7.059999999999998e-178 | NTclustered | gi|153805558|ref|NC_009681.1| | 34116 | g16517 | i0 | 100 | 101.468023255814 | 344 | 0 | 100 | 0 | 1 | 344 | 1215 | 872 | Leptosira terrestris chloroplast, complete genome | blastn | 34905 | 636 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Pleurastraceae | Pleurastrum | Pleurastrum terricola | |
| 6973224 | 6973224 | PRJNA615175_P_NODE_15406_length_359_cov_2.706294_g15238_i0 | PRJNA615175 | 15406 | 359 | 2.706294 | 9.71559546 | Trebouxia lynnae | 1825957 | Plants | Plants | 307 | 6.570000000000001e-79 | NTclustered | gi|1750939486|gb|MH917293.1| | 1825957 | g15238 | i0 | 82.222 | 3.56824512534819 | 360 | 60 | 99 | 4 | 1 | 358 | 4214 | 3857 | Trebouxia sp. TR9 mitochondrion, complete genome | blastn | 1281 | 307 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia lynnae | |
| 6973640 | 6973640 | PRJNA615175_P_NODE_7406_length_554_cov_4.744283_g7241_i0 | PRJNA615175 | 7406 | 554 | 4.744283 | 26.28332782 | Ulva compressa | 63659 | Plants | Plants | 896 | 0 | NTclustered | gi|2043344315|gb|MW344287.1| | 63659 | g7241 | i0 | 95.848 | 113.416967509025 | 554 | 23 | 100 | 0 | 1 | 554 | 53559 | 53006 | Ulva compressa isolate Uco2 plastid, complete genome | blastn | 62833 | 896 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva compressa | |
| 7527595 | 7527595 | PRJNA615175_P_NODE_25906_length_264_cov_2.748691_g25738_i0 | PRJNA615175 | 25906 | 264 | 2.748691 | 7.25654424 | Eukaryota | 2759 | Plants | Plants | 54.7 | 0.007 | NTclustered | gi|2082238730|ref|XM_043059385.1| | 3055 | g25738 | i0 | 100 | 3.62121212121212 | 29 | 0 | 11 | 0 | 17 | 45 | 865 | 893 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g089237v5), mRNA | blastn | 956 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 8248081 | 8248081 | PRJNA615175_P_NODE_23567_length_282_cov_1.473684_g23399_i0 | PRJNA615175 | 23567 | 282 | 1.473684 | 4.15578888 | Prototheca wickerhamii | 3111 | Plants | Plants | 505 | 1.6599999999999995e-138 | NTclustered | gi|2674558858|gb|PP291739.1| | 3111 | g23399 | i0 | 98.936 | 2 | 282 | 3 | 100 | 0 | 1 | 282 | 19823 | 20104 | Prototheca wickerhamii strain PK9 plastid, complete genome | blastn | 564 | 505 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 10799447 | 10799447 | PRJNA615175_P_NODE_4709_length_713_cov_3.587500_g4549_i0 | PRJNA615175 | 4709 | 713 | 3.5875 | 25.578875 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 422 | 4.72e-113 | NTclustered | gi|2082248650|ref|XM_043063418.1| | 3055 | g4549 | i0 | 83.047 | 12.7573632538569 | 466 | 77 | 65 | 2 | 206 | 670 | 852 | 388 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA | blastn | 9096 | 422 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 12074572 | 12074572 | PRJNA615175_P_NODE_9510_length_478_cov_2.281481_g9342_i0 | PRJNA615175 | 9510 | 478 | 2.281481 | 10.90547918 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 289 | 3.26e-73 | NTclustered | gi|2917929696|emb|OZ234923.1| | 3350044 | g9342 | i0 | 86.641 | 0.548117154811716 | 262 | 33 | 55 | 2 | 1 | 261 | 1493655 | 1493915 | Trebouxia sp. SL0000003 genome assembly, chromosome: 18 | blastn | 262 | 289 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 13349053 | 13349053 | PRJNA615175_P_NODE_20871_length_303_cov_1.339130_g20703_i0 | PRJNA615175 | 20871 | 303 | 1.33913 | 4.0575639 | Chlorella variabilis | 554065 | Plants | Plants | 156 | 2.09e-33 | NTclustered | gi|552848907|ref|XM_005852154.1| | 554065 | g20703 | i0 | 81.218 | 1.25082508250825 | 197 | 33 | 64 | 4 | 98 | 292 | 3276 | 3082 | Chlorella variabilis hypothetical protein (GLYD1) mRNA, complete cds | blastn | 379 | 156 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 16452648 | 16452648 | PRJNA615175_P_NODE_9333_length_484_cov_2.732360_g9165_i0 | PRJNA615175 | 9333 | 484 | 2.73236 | 13.2246224 | Ulva | 3118 | Plants | Plants | 544 | 6.38e-150 | NTclustered | gi|807046084|gb|KP720616.1| | 1641711 | g9165 | i0 | 89.376 | 89.154958677686 | 433 | 44 | 89 | 2 | 53 | 484 | 67953 | 68384 | Ulva sp. UNA00071828 chloroplast, complete genome | blastn | 43151 | 549 | 0.990892531876138 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva sp. UNA00071828 | |
| 17727721 | 17727721 | PRJNA615175_P_NODE_9714_length_472_cov_2.982456_g9546_i0 | PRJNA615175 | 9714 | 472 | 2.982456 | 14.07719232 | Chlorellaceae | 35461 | Plants | Plants | 287 | 1.16e-72 | NTclustered | gi|1401669229|gb|MH295835.1| | 2219871 | g9546 | i0 | 79.114 | 100.637711864407 | 474 | 55 | 99 | 23 | 2 | 472 | 977 | 1409 | Chlorella endosymbiont of Stentor polymorphus 28S ribosomal RNA gene, partial sequence | blastn | 47501 | 287 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella endosymbiont of Stentor polymorphus | |
| 18446966 | 18446966 | PRJNA615175_P_NODE_2615_length_954_cov_2.721907_g2488_i0 | PRJNA615175 | 2615 | 954 | 2.721907 | 25.966992780000002 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 614 | 9.819999999999999e-171 | NTclustered | gi|2082248989|ref|XM_001691400.2| | 3055 | g2488 | i0 | 82.714 | 67.3448637316562 | 700 | 111 | 73 | 9 | 1 | 695 | 860 | 1554 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g298650v5), mRNA | blastn | 64247 | 614 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 19721799 | 19721799 | PRJNA615175_P_NODE_5036_length_687_cov_6.832248_g4874_i0 | PRJNA615175 | 5036 | 687 | 6.832248 | 46.93754376 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 268 | 6.25e-67 | NTclustered | gi|545367700|ref|XM_005648603.1| | 574566 | g4874 | i0 | 79.381 | 1.62008733624454 | 388 | 74 | 56 | 6 | 26 | 410 | 150 | 534 | Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA | blastn | 1113 | 268 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 19721815 | 19721815 | PRJNA615175_P_NODE_616_length_1648_cov_5.455873_g567_i0 | PRJNA615175 | 616 | 1648 | 5.455873 | 89.91278704 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 1389 | 0 | NTclustered | gi|2082248989|ref|XM_001691400.2| | 3055 | g567 | i0 | 89.526 | 62.5224514563107 | 1098 | 113 | 67 | 2 | 552 | 1648 | 1563 | 467 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g298650v5), mRNA | blastn | 103037 | 1389 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 19721826 | 19721826 | PRJNA615175_P_NODE_6636_length_590_cov_1.502901_g6471_i0 | PRJNA615175 | 6636 | 590 | 1.502901 | 8.8671159 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 307 | 1.13e-78 | NTclustered | gi|2082268533|ref|XM_001695875.2| | 3055 | g6471 | i0 | 81.994 | 18.4118644067797 | 361 | 65 | 61 | 0 | 27 | 387 | 509 | 869 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_16g673650v5), mRNA | blastn | 10863 | 307 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 20276169 | 20276169 | PRJNA615175_P_NODE_10556_length_450_cov_2.787798_g10388_i0 | PRJNA615175 | 10556 | 450 | 2.787798 | 12.545091 | Ignatiaceae | 2682551 | Plants | Plants | 265 | 5.139999999999999e-66 | NTclustered | gi|1197710196|ref|NC_034712.1| | 231078 | g10388 | i0 | 81.595 | 40.4777777777778 | 326 | 55 | 72 | 5 | 2 | 325 | 168770 | 169092 | Ignatius tetrasporus culture UTEX:2012 chloroplast, complete genome | blastn | 18215 | 265 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ignatiales | Ignatiaceae | Ignatius | Ignatius tetrasporus | |
| 20997048 | 20997048 | PRJNA615175_P_NODE_14837_length_367_cov_1.690476_g14669_i0 | PRJNA615175 | 14837 | 367 | 1.690476 | 6.20404692 | Chaetopeltis orbicularis | 56002 | Plants | Plants | 499 | 1.04e-136 | NTclustered | gi|6120005|gb|AF183465.1| | 56002 | g14669 | i0 | 91.328 | 100.760217983651 | 369 | 27 | 100 | 5 | 1 | 367 | 1757 | 1392 | Chaetopeltis orbicularis strain UTEX 422 28S ribosomal RNA gene, partial sequence | blastn | 36979 | 499 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chaetopeltidales | Chaetopeltidaceae | Chaetopeltis | Chaetopeltis orbicularis | |
| 20997136 | 20997136 | PRJNA615175_P_NODE_19637_length_314_cov_1.244813_g19469_i0 | PRJNA615175 | 19637 | 314 | 1.244813 | 3.90871282 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 171 | 7.77e-38 | NTclustered | gi|545374848|ref|XM_005651606.1| | 574566 | g19469 | i0 | 82.09 | 0.640127388535032 | 201 | 34 | 64 | 2 | 3 | 202 | 312 | 113 | Coccomyxa subellipsoidea C-169 ribosomal protein S26 component of cytosolic 80S ribosome and 40S small subunit mRNA | blastn | 201 | 171 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 20997466 | 20997466 | PRJNA615175_P_NODE_5817_length_634_cov_9.855615_g5652_i0 | PRJNA615175 | 5817 | 634 | 9.855615 | 62.4845991 | Desmochloris halophila | 138176 | Plants | Plants | 1149 | 0 | NTclustered | gi|371782086|emb|HE610118.1| | 138176 | g5652 | i0 | 99.369 | 100.145110410095 | 634 | 4 | 100 | 0 | 1 | 634 | 2786 | 2153 | Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 | blastn | 63492 | 1149 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 22272321 | 22272321 | PRJNA615175_P_NODE_3558_length_823_cov_4.106667_g3411_i0 | PRJNA615175 | 3558 | 823 | 4.106667 | 33.79786941 | Percursaria percursa | 153906 | Plants | Plants | 520 | 1.89e-142 | NTclustered | gi|2112329422|gb|MZ911851.1| | 153906 | g3411 | i0 | 83.478 | 37.3462940461725 | 575 | 77 | 75 | 14 | 66 | 638 | 34271 | 33713 | Percursaria percursa mitochondrion, complete genome | blastn | 30736 | 520 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Kornmanniaceae | Percursaria | Percursaria percursa | |
| 22272426 | 22272426 | PRJNA615175_P_NODE_9078_length_492_cov_3.312649_g8910_i0 | PRJNA615175 | 9078 | 492 | 3.312649 | 16.29823308 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 183 | 1.63e-41 | NTclustered | gi|238534981|gb|GQ176399.1| | 3055 | g8910 | i0 | 77.508 | 4.54065040650407 | 329 | 58 | 65 | 14 | 147 | 465 | 456 | 134 | Chlamydomonas reinhardtii clone CNB22 molecular marker mRNA sequence | blastn | 2234 | 183 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 23547758 | 23547758 | PRJNA615175_P_NODE_7479_length_552_cov_1.691023_g7314_i0 | PRJNA615175 | 7479 | 552 | 1.691023 | 9.33444696 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 182 | 6.64e-41 | NTclustered | gi|1825511251|gb|MN642622.1| | 2608996 | g7314 | i0 | 79.478 | 1.46557971014493 | 268 | 46 | 48 | 9 | 2 | 265 | 46936 | 46674 | Trebouxia sp. A1-2 mitochondrion, complete genome | blastn | 809 | 182 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 24821338 | 24821338 | PRJNA615175_P_NODE_33860_length_243_cov_0.905882_g33692_i0 | PRJNA615175 | 33860 | 243 | 0.905882 | 2.20129326 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 351 | 1.93e-92 | NTclustered | gi|1825511251|gb|MN642622.1| | 2608996 | g33692 | i0 | 96.682 | 76.1069958847737 | 211 | 7 | 87 | 0 | 3 | 213 | 81287 | 81497 | Trebouxia sp. A1-2 mitochondrion, complete genome | blastn | 18494 | 351 | 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);;