contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA390533" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1684335 | 1684335 | PRJNA390533_P_NODE_10962_length_589_cov_7.243636_g10058_i0 | PRJNA390533 | 10962 | 589 | 7.243636 | 42.66501604 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 219 | 5.42e-52 | NTclustered | gi|2917929690|emb|OZ234918.1| | 3350044 | g10058 | i0 | 97.638 | 0.460101867572156 | 127 | 3 | 46 | 0 | 233 | 359 | 840768 | 840894 | Trebouxia sp. SL0000003 genome assembly, chromosome: 13 | blastn | 271 | 219 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 2960293 | 2960293 | PRJNA390533_P_NODE_17723_length_423_cov_4.526042_g16707_i0 | PRJNA390533 | 17723 | 423 | 4.526042 | 19.14515766 | Dunaliella salina | 3046 | Plants | Plants | 396 | 1.63e-105 | NTclustered | gi|333691274|gb|JF346103.1| | 3046 | g16707 | i0 | 86.761 | 84.1560283687943 | 355 | 47 | 84 | 0 | 69 | 423 | 1435 | 1081 | Dunaliella salina alpha-tubulin protein mRNA, complete cds | blastn | 35598 | 396 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 3628866 | 3628866 | PRJNA390533_P_NODE_20983_length_369_cov_16.784848_g19959_i0 | PRJNA390533 | 20983 | 369 | 16.784848 | 61.93608912 | Jaagichlorella | 2304164 | Plants | Plants | 627 | 4.5799999999999996e-175 | NTclustered | gi|1802907791|gb|MT006212.1| | 2304167 | g19959 | i0 | 99.422 | 93.0379403794038 | 346 | 1 | 93 | 1 | 4 | 348 | 2724 | 2379 | Jaagichlorella africana strain FACHB-2423 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 34331 | 627 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Jaagichlorella | Jaagichlorella africana | |
| 4236582 | 4236582 | PRJNA390533_P_NODE_14524_length_491_cov_1097.674779_g13538_i0 | PRJNA390533 | 14524 | 491 | 1097.674779 | 5389.58316489 | Parietochloris pseudoalveolaris | 3102 | Plants | Plants | 525 | 2.3499999999999993e-144 | NTclustered | gi|725650801|ref|NC_025532.1| | 3102 | g13538 | i0 | 93.277 | 116.659877800407 | 357 | 22 | 92 | 1 | 1 | 355 | 120084 | 119728 | Ettlia pseudoalveolaris culture-collection UTEX:975 chloroplast, complete genome | blastn | 57280 | 525 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Parietochloris | Parietochloris pseudoalveolaris | |
| 6787355 | 6787355 | PRJNA390533_P_NODE_23466_length_333_cov_16.527211_g22442_i0 | PRJNA390533 | 23466 | 333 | 16.527211 | 55.03561263 | Diplosphaera sundellii | 3135960 | Plants | Plants | 339 | 2.15e-88 | NTclustered | gi|2878821371|gb|PQ563290.1| | 3135960 | g22442 | i0 | 96.569 | 1.36936936936937 | 204 | 7 | 75 | 0 | 129 | 332 | 8115 | 8318 | Diplosphaera sundellii mitochondrion, complete genome | blastn | 456 | 339 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Diplosphaera | Diplosphaera sundellii | |
| 10613319 | 10613319 | PRJNA390533_P_NODE_13129_length_527_cov_11.799180_g12168_i0 | PRJNA390533 | 13129 | 527 | 11.79918 | 62.1816786 | Chlorella vulgaris | 3077 | Plants | Plants | 412 | 2.0599999999999994e-110 | NTclustered | gi|77627727|dbj|AB237642.1| | 3077 | g12168 | i0 | 90.031 | 61.6110056925996 | 321 | 29 | 61 | 3 | 209 | 527 | 2179 | 1860 | Chlorella vulgaris NIES:227 gene for 28S ribosomal RNA, partial sequence | blastn | 32469 | 412 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 15712164 | 15712164 | PRJNA390533_P_NODE_11893_length_562_cov_6.678776_g10966_i0 | PRJNA390533 | 11893 | 562 | 6.678776 | 37.53472112 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 161 | 8.819999999999998e-35 | NTclustered | gi|2917929621|emb|OZ234909.1| | 3350044 | g10966 | i0 | 88.806 | 0.238434163701068 | 134 | 12 | 24 | 2 | 411 | 544 | 1430871 | 1430741 | Trebouxia sp. SL0000003 genome assembly, chromosome: 4 | blastn | 134 | 161 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 18261292 | 18261292 | PRJNA390533_P_NODE_28135_length_275_cov_3.805085_g27108_i0 | PRJNA390533 | 28135 | 275 | 3.805085 | 10.46398375 | Trebouxia corticola | 103875 | Plants | Plants | 405 | 1.68e-108 | NTclustered | gi|922575253|gb|JQ921013.1| | 103875 | g27108 | i0 | 94.636 | 96.9236363636364 | 261 | 14 | 95 | 0 | 15 | 275 | 1007 | 747 | Trebouxia corticola strain UTEX 909 23S large subunit ribosomal RNA gene, partial sequence; and putative LAGLIDADG homing endonuclease gene, complete cds; chloroplast | blastn | 26654 | 405 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia corticola | |
| 20811234 | 20811234 | PRJNA390533_P_NODE_20597_length_376_cov_2.103858_g19573_i0 | PRJNA390533 | 20597 | 376 | 2.103858 | 7.91050608 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 243 | 1.9800000000000001e-59 | NTclustered | gi|2917929693|emb|OZ234920.1| | 3350044 | g19573 | i0 | 96 | 42.7739361702128 | 150 | 5 | 68 | 1 | 209 | 357 | 2271060 | 2271209 | Trebouxia sp. SL0000003 genome assembly, chromosome: 15 | blastn | 16083 | 243 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 20811619 | 20811619 | PRJNA390533_P_NODE_9577_length_635_cov_2.328859_g8723_i0 | PRJNA390533 | 9577 | 635 | 2.328859 | 14.78825465 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 141 | 1.31e-28 | NTclustered | gi|545362831|ref|XM_005646559.1| | 574566 | g8723 | i0 | 84.138 | 0.420472440944882 | 145 | 23 | 23 | 0 | 322 | 466 | 319 | 175 | Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA | blastn | 267 | 141 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 22086018 | 22086018 | PRJNA390533_P_NODE_18838_length_404_cov_2.380822_g17818_i0 | PRJNA390533 | 18838 | 404 | 2.380822 | 9.61852088 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 239 | 2.77e-58 | NTclustered | gi|2917929619|emb|OZ234907.1| | 3350044 | g17818 | i0 | 90.27 | 0.457920792079208 | 185 | 15 | 45 | 3 | 222 | 404 | 2063882 | 2064065 | Trebouxia sp. SL0000003 genome assembly, chromosome: 2 | blastn | 185 | 239 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 23362061 | 23362061 | PRJNA390533_P_NODE_7539_length_717_cov_27.390855_g6785_i0 | PRJNA390533 | 7539 | 717 | 27.390855 | 196.39243035 | Diplosphaera sundellii | 3135960 | Plants | Plants | 1110 | 0 | NTclustered | gi|2878821371|gb|PQ563290.1| | 3135960 | g6785 | i0 | 95.546 | 37.6847977684798 | 696 | 28 | 97 | 1 | 22 | 717 | 6780 | 7472 | Diplosphaera sundellii mitochondrion, complete genome | blastn | 27020 | 1110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Diplosphaera | Diplosphaera sundellii | |
| 24636033 | 24636033 | PRJNA390533_P_NODE_21420_length_363_cov_1.990741_g20396_i0 | PRJNA390533 | 21420 | 363 | 1.990741 | 7.22638983 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 318 | 3.07e-82 | NTclustered | gi|2917930141|emb|OZ234926.1| | 3350044 | g20396 | i0 | 96.842 | 26.7603305785124 | 190 | 6 | 77 | 0 | 1 | 190 | 110124 | 110313 | Trebouxia sp. SL0000003 genome assembly, organelle: mitochondrion | blastn | 9714 | 318 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 24636132 | 24636132 | PRJNA390533_P_NODE_31200_length_239_cov_3.570000_g30173_i0 | PRJNA390533 | 31200 | 239 | 3.57 | 8.5323 | Desmodesmus sp. 5 YCY-2023 | 3081737 | Plants | Plants | 171 | 5.68e-38 | NTclustered | gi|2594811836|gb|OR566726.1| | 3081737 | g30173 | i0 | 80.087 | 6.89958158995816 | 231 | 44 | 96 | 2 | 5 | 234 | 349 | 578 | Desmodesmus sp. 5 YCY-2023 strain FBCC-A1293 ATP synthase beta subunit (atpB) gene, partial cds; chloroplast | blastn | 1649 | 171 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Desmodesmus | Desmodesmus sp. 5 YCY-2023 | |
| 25304314 | 25304314 | PRJNA390533_P_NODE_34260_length_213_cov_4.413793_g33233_i0 | PRJNA390533 | 34260 | 213 | 4.413793 | 9.40137909 | Coccomyxa | 41891 | Plants | Plants | 292 | 1.01e-74 | NTclustered | gi|1360638129|gb|AC277064.1| | 574566 | g33233 | i0 | 91.589 | 101.657276995305 | 214 | 14 | 100 | 4 | 1 | 213 | 578 | 368 | Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence | blastn | 21653 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea |
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);;