contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJEB12237" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20654 | 20654 | PRJEB12237_P_NODE_1061_length_712_cov_3.292467_g907_i0 | PRJEB12237 | 1061 | 712 | 3.292467 | 23.44236504 | Micromonas commoda | 296587 | Plants | Plants | 479 | 2.7599999999999993e-130 | NTclustered | gi|255078509|ref|XM_002502789.1| | 296587 | g907 | i0 | 80.308 | 71.2387640449438 | 650 | 114 | 90 | 12 | 73 | 712 | 58 | 703 | Micromonas commoda predicted protein mRNA | blastn | 50722 | 479 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 1294902 | 1294902 | PRJEB12237_P_NODE_3042_length_392_cov_2.106443_g2846_i0 | PRJEB12237 | 3042 | 392 | 2.106443 | 8.25725656 | Micromonas commoda | 296587 | Plants | Plants | 364 | 4.239999999999998e-96 | NTclustered | gi|255087992|ref|XM_002505873.1| | 296587 | g2846 | i0 | 84.367 | 83.0663265306122 | 371 | 58 | 95 | 0 | 22 | 392 | 1640 | 1270 | Micromonas commoda heat shock protein 70, mitochondrial precursor partial mRNA | blastn | 32562 | 364 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 1294943 | 1294943 | PRJEB12237_P_NODE_9942_length_169_cov_1.492537_g9746_i0 | PRJEB12237 | 9942 | 169 | 1.492537 | 2.52238753 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 126 | 8.2e-25 | NTclustered | gi|760448344|ref|XM_011402939.1| | 3075 | g9746 | i0 | 85.714 | 49.6213017751479 | 119 | 17 | 70 | 0 | 44 | 162 | 119 | 1 | Auxenochlorella protothecoides 60S ribosomal protein L15 partial mRNA | blastn | 8386 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 2570565 | 2570565 | PRJEB12237_P_NODE_2083_length_494_cov_7.385621_g1895_i0 | PRJEB12237 | 2083 | 494 | 7.385621 | 36.48496774 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 106 | 3.65e-18 | NTclustered | gi|2082260798|ref|XM_001697008.2| | 3055 | g1895 | i0 | 92 | 1.12348178137652 | 75 | 6 | 15 | 0 | 281 | 355 | 957 | 1031 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g520500v5), mRNA | blastn | 555 | 106 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 3846907 | 3846907 | PRJEB12237_P_NODE_4944_length_278_cov_1.423868_g4748_i0 | PRJEB12237 | 4944 | 278 | 1.423868 | 3.95835304 | Pseudoscourfieldia marina | 41886 | Plants | Plants | 300 | 8.280000000000001e-77 | NTclustered | gi|308035576|dbj|AB491630.1| | 41886 | g4748 | i0 | 86.331 | 94.3920863309353 | 278 | 35 | 99 | 3 | 1 | 276 | 481 | 205 | Pseudoscourfieldia marina Btub gene for beta-tubulin, partial cds, strain: NIES-1419 | blastn | 26241 | 300 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pseudoscourfieldiophyceae | Pseudoscourfieldiales | Pseudoscourfieldiaceae | Pseudoscourfieldia | Pseudoscourfieldia marina | ||
| 3846908 | 3846908 | PRJEB12237_P_NODE_5024_length_274_cov_2.025105_g4828_i0 | PRJEB12237 | 5024 | 274 | 2.025105 | 5.5487877 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 496 | 9.67e-136 | NTclustered | gi|1360638125|gb|AC277041.1| | 574566 | g4828 | i0 | 99.27 | 16.6532846715328 | 274 | 2 | 100 | 0 | 1 | 274 | 39822 | 39549 | Coccomyxa subellipsoidea C-169 clone FAHX05-A01, complete sequence | blastn | 4563 | 496 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 5123059 | 5123059 | PRJEB12237_P_NODE_3045_length_391_cov_7.365169_g2849_i0 | PRJEB12237 | 3045 | 391 | 7.365169 | 28.79781079 | Micromonas commoda | 296587 | Plants | Plants | 158 | 7.7e-34 | NTclustered | gi|255080797|ref|XM_002503926.1| | 296587 | g2849 | i0 | 81.218 | 5.65984654731458 | 197 | 35 | 50 | 2 | 168 | 363 | 371 | 176 | Micromonas commoda predicted protein mRNA | blastn | 2213 | 158 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 5123107 | 5123107 | PRJEB12237_P_NODE_9665_length_172_cov_1.781022_g9469_i0 | PRJEB12237 | 9665 | 172 | 1.781022 | 3.06335784 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 318 | 1.2899999999999999e-82 | NTclustered | gi|1360638129|gb|AC277064.1| | 574566 | g9469 | i0 | 100 | 99.5116279069767 | 172 | 0 | 100 | 0 | 1 | 172 | 2595 | 2766 | Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence | blastn | 17116 | 318 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 7363271 | 7363271 | PRJEB12237_P_NODE_1146_length_680_cov_4.031008_g987_i0 | PRJEB12237 | 1146 | 680 | 4.031008 | 27.4108544 | Eukaryota | 2759 | Plants | Plants | 324 | 1.3e-83 | NTclustered | gi|552825417|ref|XM_005846759.1| | 554065 | g987 | i0 | 81.818 | 29.7205882352941 | 385 | 70 | 57 | 0 | 132 | 516 | 13 | 397 | Chlorella variabilis 40S ribosomal protein S14 (CHLNCDRAFT_135401) mRNA, complete cds | blastn | 20210 | 327 | 0.990825688073395 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 7672893 | 7672893 | PRJEB12237_P_NODE_4407_length_303_cov_1.791045_g4211_i0 | PRJEB12237 | 4407 | 303 | 1.791045 | 5.42686635 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 134 | 9.8e-27 | NTclustered | gi|402244316|emb|FR686759.1| | 37502 | g4211 | i0 | 80.702 | 0.564356435643564 | 171 | 33 | 56 | 0 | 2 | 172 | 989 | 1159 | Polytomella sp. Pringsheim 198.80 mRNA for 40S ribosomal protein L3 (rpl3 gene) | blastn | 171 | 134 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 7672906 | 7672906 | PRJEB12237_P_NODE_6487_length_226_cov_1.675393_g6291_i0 | PRJEB12237 | 6487 | 226 | 1.675393 | 3.78638818 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 405 | 1.34e-108 | NTclustered | gi|1360638129|gb|AC277064.1| | 574566 | g6291 | i0 | 99.111 | 99.4159292035398 | 225 | 2 | 99 | 0 | 1 | 225 | 1715 | 1491 | Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence | blastn | 22468 | 405 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 8947654 | 8947654 | PRJEB12237_P_NODE_1768_length_541_cov_1.818182_g1585_i0 | PRJEB12237 | 1768 | 541 | 1.818182 | 9.83636462 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 307 | 1.03e-78 | NTclustered | gi|635557420|emb|FN984965.1| | 37502 | g1585 | i0 | 79.545 | 32.9611829944547 | 440 | 82 | 81 | 8 | 50 | 485 | 1019 | 1454 | Polytomella sp. Pringsheim 198.80 mRNA for S-Adenosyl homocysteine hydrolase (sah1 gene) | blastn | 17832 | 307 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 8947655 | 8947655 | PRJEB12237_P_NODE_2108_length_490_cov_3.015385_g1920_i0 | PRJEB12237 | 2108 | 490 | 3.015385 | 14.7753865 | Monoraphidium neglectum | 145388 | Plants | Plants | 231 | 5.719999999999999e-56 | NTclustered | gi|926795717|ref|XM_014050538.1| | 145388 | g1920 | i0 | 80.192 | 31.7387755102041 | 313 | 58 | 63 | 4 | 109 | 419 | 365 | 55 | Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA | blastn | 15552 | 231 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 10223403 | 10223403 | PRJEB12237_P_NODE_10809_length_161_cov_1.166667_g10613_i0 | PRJEB12237 | 10809 | 161 | 1.166667 | 1.87833387 | Pedinomonas sp. M2079/1 | 1108796 | Plants | Plants | 165 | 1.65e-36 | NTclustered | gi|371782103|emb|HE610135.1| | 1108796 | g10613 | i0 | 85.897 | 4.47204968944099 | 156 | 20 | 96 | 2 | 1 | 155 | 4008 | 4162 | Pedinomonas sp. M2079/1 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M2079/1 | blastn | 720 | 165 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinomonadales | Pedinomonadaceae | Pedinomonas | Pedinomonas sp. M2079/1 | |
| 10223434 | 10223434 | PRJEB12237_P_NODE_2929_length_403_cov_2.880435_g2733_i0 | PRJEB12237 | 2929 | 403 | 2.880435 | 11.60815305 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 141 | 8.02e-29 | NTclustered | gi|2082244743|ref|XM_001698671.2| | 3055 | g2733 | i0 | 79.397 | 1.84863523573201 | 199 | 41 | 49 | 0 | 1 | 199 | 556 | 754 | Chlamydomonas reinhardtii ribosomal protein L23 (CHLRE_04g211800v5), mRNA | blastn | 745 | 141 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 11498671 | 11498671 | PRJEB12237_P_NODE_11130_length_158_cov_1.276423_g10934_i0 | PRJEB12237 | 11130 | 158 | 1.276423 | 2.01674834 | Mantoniella tinhauana | 3097027 | Plants | Plants | 56.5 | 0.001 | NTclustered | gi|2735153291|gb|CP140076.1| | 3097027 | g10934 | i0 | 100 | 0.550632911392405 | 30 | 0 | 19 | 0 | 38 | 67 | 41747 | 41718 | Mantoniella tinhauana isolate LFS chromosome 15 | blastn | 87 | 56.5 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 12464755 | 12464755 | PRJEB12237_P_NODE_8350_length_189_cov_3.623377_g8154_i0 | PRJEB12237 | 8350 | 189 | 3.623377 | 6.84818253 | Coccomyxa | 41891 | Plants | Plants | 350 | 5.14e-92 | NTclustered | gi|2916178960|gb|PV156797.1| | 248742 | g8154 | i0 | 100 | 99.984126984127 | 189 | 0 | 100 | 0 | 1 | 189 | 862 | 674 | Coccomyxa subellipsoidea small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 18897 | 350 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 17563479 | 17563479 | PRJEB12237_P_NODE_9134_length_179_cov_1.111111_g8938_i0 | PRJEB12237 | 9134 | 179 | 1.111111 | 1.98888869 | Chlorophyta | 3041 | Plants | Plants | 158 | 3.12e-34 | NTclustered | gi|2082236323|ref|XM_001689445.2| | 3055 | g8938 | i0 | 85.897 | 14.4692737430168 | 156 | 13 | 87 | 6 | 13 | 168 | 656 | 802 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g019250v5), mRNA | blastn | 2590 | 159 | 0.993710691823899 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 19146204 | 19146204 | PRJEB12237_P_NODE_8456_length_188_cov_1.398693_g8260_i0 | PRJEB12237 | 8456 | 188 | 1.398693 | 2.62954284 | Micromonas commoda | 296587 | Plants | Plants | 141 | 3.34e-29 | NTclustered | gi|255074984|ref|XM_002501121.1| | 296587 | g8260 | i0 | 87.2 | 1.07978723404255 | 125 | 14 | 66 | 2 | 25 | 148 | 306 | 429 | Micromonas commoda mitochondrial carrier family partial mRNA | blastn | 203 | 141 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 20112168 | 20112168 | PRJEB12237_P_NODE_3436_length_359_cov_1.413580_g3240_i0 | PRJEB12237 | 3436 | 359 | 1.41358 | 5.0747522 | Eukaryota | 2759 | Plants | Plants | 111 | 5.53e-20 | NTclustered | gi|760450068|ref|XM_011403801.1| | 3075 | g3240 | i0 | 90.476 | 24.1281337047354 | 84 | 8 | 23 | 0 | 276 | 359 | 404 | 321 | Auxenochlorella protothecoides Peptidyl-prolyl cis-trans isomerase CYP18-4 partial mRNA | blastn | 8662 | 111 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 20421342 | 20421342 | PRJEB12237_P_NODE_3597_length_348_cov_4.047923_g3401_i0 | PRJEB12237 | 3597 | 348 | 4.047923 | 14.08677204 | Micromonas commoda | 296587 | Plants | Plants | 169 | 3.14e-37 | NTclustered | gi|255072468|ref|XM_002499863.1| | 296587 | g3401 | i0 | 85.625 | 35.4683908045977 | 160 | 23 | 46 | 0 | 164 | 323 | 191 | 32 | Micromonas commoda predicted protein mRNA | blastn | 12343 | 169 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 21697385 | 21697385 | PRJEB12237_P_NODE_11578_length_154_cov_2.336134_g11382_i0 | PRJEB12237 | 11578 | 154 | 2.336134 | 3.59764636 | Mantoniella tinhauana | 3097027 | Plants | Plants | 126 | 7.34e-25 | NTclustered | gi|2735153286|gb|CP140071.1| | 3097027 | g11382 | i0 | 84.496 | 57.7987012987013 | 129 | 18 | 83 | 2 | 25 | 152 | 1556013 | 1556140 | Mantoniella tinhauana isolate LFS chromosome 10 | blastn | 8901 | 126 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 22972634 | 22972634 | PRJEB12237_P_NODE_1079_length_704_cov_5.301943_g924_i0 | PRJEB12237 | 1079 | 704 | 5.301943 | 37.32567872 | Micromonas commoda | 296587 | Plants | Plants | 660 | 0 | NTclustered | gi|255081912|ref|XM_002508129.1| | 296587 | g924 | i0 | 87.993 | 292.859375 | 558 | 67 | 79 | 0 | 1 | 558 | 165 | 722 | Micromonas commoda ubiquitin mRNA | blastn | 206173 | 660 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 22972664 | 22972664 | PRJEB12237_P_NODE_3379_length_363_cov_1.463415_g3183_i0 | PRJEB12237 | 3379 | 363 | 1.463415 | 5.31219645 | Mantoniella tinhauana | 3097027 | Plants | Plants | 219 | 3.21e-52 | NTclustered | gi|2735153277|gb|CP140062.1| | 3097027 | g3183 | i0 | 89.535 | 31.2093663911846 | 172 | 18 | 47 | 0 | 137 | 308 | 5607109 | 5606938 | Mantoniella tinhauana isolate LFS chromosome 1 | blastn | 11329 | 219 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 22972688 | 22972688 | PRJEB12237_P_NODE_8059_length_194_cov_2.012579_g7863_i0 | PRJEB12237 | 8059 | 194 | 2.012579 | 3.90440326 | Monoraphidium neglectum | 145388 | Plants | Plants | 159 | 9.589999999999999e-35 | NTclustered | gi|926781159|ref|XM_014043600.1| | 145388 | g7863 | i0 | 86.806 | 24.5154639175258 | 144 | 17 | 74 | 2 | 3 | 145 | 2660 | 2802 | Monoraphidium neglectum hypothetical protein mRNA | blastn | 4756 | 159 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum |
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);;