contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA909412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 890624 | 890624 | PRJNA909412_P_NODE_14601_length_157_cov_1.059322_g14460_i0 | PRJNA909412 | 14601 | 157 | 1.059322 | 1.66313554 | Coelastrum microporum | 55409 | Plants | Plants | 241 | 2.5800000000000007e-59 | NTclustered | gi|2386955046|ref|NC_068582.1| | 55409 | g14460 | i0 | 94.268 | 76.9426751592357 | 157 | 9 | 100 | 0 | 1 | 157 | 47652 | 47496 | Coelastrum microporum chloroplast, complete genome | blastn | 12080 | 241 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Coelastrum | Coelastrum microporum | |
| 5993857 | 5993857 | PRJNA909412_P_NODE_10465_length_172_cov_2.902256_g10324_i0 | PRJNA909412 | 10465 | 172 | 2.902256 | 4.99188032 | Pediastrum duplex | 3105 | Plants | Plants | 252 | 1.33e-62 | NTclustered | gi|21040380|gb|AF183479.2| | 3105 | g10324 | i0 | 93.143 | 30.4418604651163 | 175 | 6 | 100 | 4 | 1 | 172 | 3071 | 3242 | Pediastrum duplex strain UTEX LB 1364 28S ribosomal RNA gene, partial sequence | blastn | 5236 | 252 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Pediastrum | Pediastrum duplex | |
| 5993913 | 5993913 | PRJNA909412_P_NODE_16765_length_151_cov_2.517857_g16624_i0 | PRJNA909412 | 16765 | 151 | 2.517857 | 3.80196407 | Halochlorococcum sp. NIES-1838 | 2249730 | Plants | Plants | 268 | 1.12e-67 | NTclustered | gi|1409970159|gb|MG721781.1| | 2249730 | g16624 | i0 | 98.675 | 115.867549668874 | 151 | 2 | 100 | 0 | 1 | 151 | 731 | 881 | Halochlorococcum sp. NIES-1838 PsbA (psbA) gene, complete cds; chloroplast | blastn | 17496 | 268 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Halochlorococcum | Halochlorococcum sp. NIES-1838 | |
| 7268815 | 7268815 | PRJNA909412_P_NODE_15666_length_153_cov_2.561404_g15525_i0 | PRJNA909412 | 15666 | 153 | 2.561404 | 3.91894812 | Coelastrum microporum | 55409 | Plants | Plants | 283 | 4.0799999999999995e-72 | NTclustered | gi|2386955046|ref|NC_068582.1| | 55409 | g15525 | i0 | 100 | 37.9346405228758 | 153 | 0 | 100 | 0 | 1 | 153 | 92728 | 92880 | Coelastrum microporum chloroplast, complete genome | blastn | 5804 | 283 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Coelastrum | Coelastrum microporum | |
| 7268881 | 7268881 | PRJNA909412_P_NODE_9206_length_177_cov_1.144928_g9065_i0 | PRJNA909412 | 9206 | 177 | 1.144928 | 2.02652256 | Tetraselmis cordiformis | 426497 | Plants | Plants | 261 | 2.28e-65 | NTclustered | gi|371782133|emb|HE610165.1| | 426497 | g9065 | i0 | 93.22 | 158.271186440678 | 177 | 12 | 100 | 0 | 1 | 177 | 3726 | 3902 | Tetraselmis cordiformis plastid 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ile gene, tRNA-Ala gene and ITS1, strain SAG 26.82 | blastn | 28014 | 261 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Tetraselmis | Tetraselmis cordiformis | |
| 11452943 | 11452943 | PRJNA909412_P_NODE_5949_length_214_cov_4.462857_g5808_i0 | PRJNA909412 | 5949 | 214 | 4.462857 | 9.55051398 | Chlorellales | 35460 | Plants | Plants | 335 | 1.6699999999999995e-87 | NTclustered | gi|1134678412|gb|KU598841.1| | 248742 | g5808 | i0 | 94.86 | 96.5654205607477 | 214 | 11 | 100 | 0 | 1 | 214 | 714 | 501 | Coccomyxa subellipsoidea strain SAG 216-13 23S ribosomal RNA (rrl) gene, partial sequence; chloroplast | blastn | 20665 | 335 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 12369835 | 12369835 | PRJNA909412_P_NODE_8290_length_185_cov_0.842466_g8149_i0 | PRJNA909412 | 8290 | 185 | 0.842466 | 1.5585621 | Oedogonium crispum | 321588 | Plants | Plants | 309 | 8.49e-80 | NTclustered | gi|2031444893|gb|MW250872.1| | 321588 | g8149 | i0 | 97.765 | 100.551351351351 | 179 | 4 | 97 | 0 | 7 | 185 | 78036 | 77858 | Oedogonium crispum isolate 33_chl plastid, complete genome | blastn | 18602 | 309 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Oedogoniales | Oedogoniaceae | Oedogonium | Oedogonium crispum | |
| 14918596 | 14918596 | PRJNA909412_P_NODE_10352_length_172_cov_2.977444_g10211_i0 | PRJNA909412 | 10352 | 172 | 2.977444 | 5.12120368 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 84.2 | 5.12e-12 | NTclustered | gi|1825511251|gb|MN642622.1| | 2608996 | g10211 | i0 | 90.625 | 5.01744186046512 | 64 | 4 | 36 | 1 | 93 | 154 | 86144 | 86207 | Trebouxia sp. A1-2 mitochondrion, complete genome | blastn | 863 | 84.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 19100696 | 19100696 | PRJNA909412_P_NODE_16675_length_151_cov_3.017857_g16534_i0 | PRJNA909412 | 16675 | 151 | 3.017857 | 4.55696407 | Chlamydomonas | 3052 | Plants | Plants | 268 | 1.12e-67 | NTclustered | gi|397100|emb|X68910.1| | 28460 | g16534 | i0 | 98.675 | 135.145695364238 | 151 | 2 | 100 | 0 | 1 | 151 | 929 | 779 | Chloroplast Chlamydomonas mexicana rrnL gene, exon 1 | blastn | 20407 | 268 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas mexicana | |
| 20375503 | 20375503 | PRJNA909412_P_NODE_12336_length_162_cov_1.845528_g12195_i0 | PRJNA909412 | 12336 | 162 | 1.845528 | 2.98975536 | Cladophora | 34125 | Plants | Plants | 300 | 4.36e-77 | NTclustered | gi|388883486|dbj|AB665583.1| | 34126 | g12195 | i0 | 100 | 100 | 162 | 0 | 100 | 0 | 1 | 162 | 581 | 742 | Cladophora albida gene for 18S rRNA, partial sequence, isolate: alb-6 | blastn | 16200 | 300 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Cladophorales | Cladophoraceae | Cladophora | Cladophora albida | |
| 21651408 | 21651408 | PRJNA909412_P_NODE_4037_length_262_cov_2.210762_g3896_i0 | PRJNA909412 | 4037 | 262 | 2.210762 | 5.79219644 | Hydrodictyaceae | 3103 | Plants | Plants | 342 | 1.2699999999999996e-89 | NTclustered | gi|21040380|gb|AF183479.2| | 3105 | g3896 | i0 | 90.698 | 68.5801526717557 | 258 | 23 | 98 | 1 | 6 | 262 | 2999 | 3256 | Pediastrum duplex strain UTEX LB 1364 28S ribosomal RNA gene, partial sequence | blastn | 17968 | 342 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Pediastrum | Pediastrum duplex | |
| 23842877 | 23842877 | PRJNA909412_P_NODE_11079_length_172_cov_1.248120_g10938_i0 | PRJNA909412 | 11079 | 172 | 1.24812 | 2.1467664 | Chlamydomonas chlamydogama | 225041 | Plants | Plants | 163 | 6.390000000000001e-36 | NTclustered | gi|66864258|gb|DQ015713.1| | 225041 | g10938 | i0 | 83.815 | 1.79651162790698 | 173 | 26 | 100 | 2 | 1 | 172 | 3207 | 3036 | Chlamydomonas chlamydogama strain UTEX 102 26S ribosomal RNA gene, partial sequence | blastn | 309 | 163 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas chlamydogama | |
| 23842881 | 23842881 | PRJNA909412_P_NODE_11779_length_166_cov_2.692913_g11638_i0 | PRJNA909412 | 11779 | 166 | 2.692913 | 4.47023558 | Paradoxia multiseta | 249350 | Plants | Plants | 222 | 1e-53 | NTclustered | gi|723457039|ref|NC_025540.1| | 249350 | g11638 | i0 | 90.964 | 119.861445783133 | 166 | 13 | 99 | 2 | 1 | 165 | 2789 | 2625 | Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome | blastn | 19897 | 222 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Paradoxia | Paradoxia multiseta | ||
| 23842939 | 23842939 | PRJNA909412_P_NODE_299_length_1005_cov_78.720497_g246_i0 | PRJNA909412 | 299 | 1005 | 78.720497 | 791.14099485 | Stigeoclonium helveticum | 55999 | Plants | Plants | 65.8 | 1.31e-5 | NTclustered | gi|162134275|gb|EU123958.1| | 55999 | g246 | i0 | 97.368 | 0.223880597014925 | 38 | 1 | 4 | 0 | 918 | 955 | 1821 | 1858 | Stigeoclonium helveticum strain UTEX 441 small-subunit ribosomal RNA (rns) gene, complete sequence; mitochondrial | blastn | 225 | 65.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chaetophorales | Chaetophoraceae | Stigeoclonium | Stigeoclonium helveticum | |
| 25116764 | 25116764 | PRJNA909412_P_NODE_6580_length_205_cov_1.313253_g6439_i0 | PRJNA909412 | 6580 | 205 | 1.313253 | 2.69216865 | Flechtneria rotunda | 269715 | Plants | Plants | 363 | 7.279999999999998e-96 | NTclustered | gi|523583541|gb|KC145438.1| | 269715 | g6439 | i0 | 98.537 | 99.6682926829268 | 205 | 3 | 100 | 0 | 1 | 205 | 356 | 560 | Scenedesmus rotundus strain BCP-SEV2VF49 28S ribosomal RNA gene, partial sequence | blastn | 20432 | 363 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Flechtneria | Flechtneria rotunda |
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);;