contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA195897" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1055327 | 1055327 | PRJNA195897_P_NODE_3281_length_270_cov_1.276018_g3248_i0 | PRJNA195897 | 3281 | 270 | 1.276018 | 3.4452486 | Eukaryota | 2759 | Plants | Plants | 147 | 1.1000000000000001e-30 | NTclustered | gi|552823017|ref|XM_005846187.1| | 554065 | g3248 | i0 | 79.71 | 11.6481481481481 | 207 | 39 | 76 | 3 | 8 | 213 | 2153 | 1949 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_36029) mRNA, complete cds | blastn | 3145 | 147 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 1640714 | 1640714 | PRJNA195897_P_NODE_10022_length_167_cov_0.881356_g9989_i0 | PRJNA195897 | 10022 | 167 | 0.881356 | 1.47186452 | Micromonas commoda | 296587 | Plants | Plants | 187 | 3.68e-43 | NTclustered | gi|255081109|ref|XM_002504075.1| | 296587 | g9989 | i0 | 88.961 | 31.6826347305389 | 154 | 13 | 91 | 4 | 9 | 160 | 152 | 1 | Micromonas commoda predicted protein partial mRNA | blastn | 5291 | 187 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 1640805 | 1640805 | PRJNA195897_P_NODE_9622_length_168_cov_0.873950_g9589_i0 | PRJNA195897 | 9622 | 168 | 0.87395 | 1.468236 | Pyramimonas sp. HV-2008 | 498058 | Plants | Plants | 121 | 3.8099999999999996e-23 | NTclustered | gi|166236044|gb|EU375499.1| | 498058 | g9589 | i0 | 80.357 | 1.98214285714286 | 168 | 25 | 99 | 8 | 1 | 167 | 686 | 846 | Pyramimonas sp. HV-2008 28S ribosomal RNA gene, partial sequence | blastn | 333 | 121 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Pyramimonas | Pyramimonas sp. HV-2008 | ||
| 9294105 | 9294105 | PRJNA195897_P_NODE_868_length_575_cov_2.296578_g838_i0 | PRJNA195897 | 868 | 575 | 2.296578 | 13.2053235 | Micromonas commoda | 296587 | Plants | Plants | 438 | 3.7299999999999996e-118 | NTclustered | gi|255088288|ref|XM_002506021.1| | 296587 | g838 | i0 | 81.579 | 91.8660869565217 | 532 | 96 | 92 | 2 | 1 | 531 | 376 | 906 | Micromonas commoda alpha tubulin 1 (TUA1), mRNA | blastn | 52823 | 438 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 11844539 | 11844539 | PRJNA195897_P_NODE_4130_length_235_cov_1.741935_g4097_i0 | PRJNA195897 | 4130 | 235 | 1.741935 | 4.09354725 | Mantoniella tinhauana | 3097027 | Plants | Plants | 84.2 | 7.47e-12 | NTclustered | gi|2735153282|gb|CP140067.1| | 3097027 | g4097 | i0 | 91.667 | 3.08510638297872 | 60 | 5 | 26 | 0 | 2 | 61 | 820518 | 820577 | Mantoniella tinhauana isolate LFS chromosome 6 | blastn | 725 | 84.2 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 15668810 | 15668810 | PRJNA195897_P_NODE_6473_length_194_cov_1.075862_g6440_i0 | PRJNA195897 | 6473 | 194 | 1.075862 | 2.08717228 | Chlamydomonas incerta | 51695 | Plants | Plants | 126 | 9.73e-25 | NTclustered | gi|74272616|gb|DQ122873.1| | 51695 | g6440 | i0 | 82.237 | 26.8814432989691 | 152 | 21 | 77 | 6 | 24 | 172 | 390 | 242 | Chlamydomonas incerta mitochondrial alternative oxidase (AOX1) mRNA, partial cds; nuclear gene for mitochondrial product | blastn | 5215 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 15668830 | 15668830 | PRJNA195897_P_NODE_8913_length_169_cov_1.300000_g8880_i0 | PRJNA195897 | 8913 | 169 | 1.3 | 2.197 | Micromonas commoda | 296587 | Plants | Plants | 54.7 | 0.004 | NTclustered | gi|255089317|ref|XM_002506535.1| | 296587 | g8880 | i0 | 100 | 0.171597633136095 | 29 | 0 | 17 | 0 | 43 | 71 | 366 | 338 | Micromonas commoda histone H2A partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 16357710 | 16357710 | PRJNA195897_P_NODE_2753_length_298_cov_9.421687_g2720_i0 | PRJNA195897 | 2753 | 298 | 9.421687 | 28.07662726 | Opisthokonta | 33154 | Plants | Plants | 99 | 3.51e-16 | NTclustered | gi|612395756|ref|XM_007513336.1| | 41875 | g2720 | i0 | 80.303 | 1.84228187919463 | 132 | 24 | 44 | 2 | 96 | 226 | 171 | 41 | Bathycoccus prasinos 40S ribosomal protein S29 (Bathy04g01450), partial mRNA | blastn | 549 | 100 | 0.99 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Bathycoccus | Bathycoccus prasinos | ||
| 19492012 | 19492012 | PRJNA195897_P_NODE_7056_length_187_cov_1.507246_g7023_i0 | PRJNA195897 | 7056 | 187 | 1.507246 | 2.81855002 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 119 | 1.56e-22 | NTclustered | gi|545360680|ref|XM_005645643.1| | 574566 | g7023 | i0 | 91.765 | 17.8502673796791 | 85 | 7 | 45 | 0 | 1 | 85 | 728 | 812 | Coccomyxa subellipsoidea C-169 14-3-3 protein mRNA | blastn | 3338 | 119 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 20767558 | 20767558 | PRJNA195897_P_NODE_8777_length_170_cov_1.289256_g8744_i0 | PRJNA195897 | 8777 | 170 | 1.289256 | 2.1917352 | Bathycoccus prasinos | 41875 | Plants | Plants | 128 | 2.3e-25 | NTclustered | gi|612392286|ref|XM_007511602.1| | 41875 | g8744 | i0 | 86.325 | 0.688235294117647 | 117 | 16 | 69 | 0 | 7 | 123 | 120 | 236 | Bathycoccus prasinos 40S ribosomal protein S17 (Bathy08g04660), partial mRNA | blastn | 117 | 128 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Bathycoccus | Bathycoccus prasinos | ||
| 23318082 | 23318082 | PRJNA195897_P_NODE_2859_length_292_cov_1.423868_g2826_i0 | PRJNA195897 | 2859 | 292 | 1.423868 | 4.15769456 | Volvox carteri | 3067 | Plants | Plants | 126 | 1.57e-24 | NTclustered | gi|302851385|ref|XM_002957171.1| | 3068 | g2826 | i0 | 91.304 | 3.69178082191781 | 92 | 8 | 32 | 0 | 165 | 256 | 590 | 499 | Volvox carteri f. nagariensis alpha tubulin (tubA1), mRNA | blastn | 1078 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 24007291 | 24007291 | PRJNA195897_P_NODE_9519_length_168_cov_0.873950_g9486_i0 | PRJNA195897 | 9519 | 168 | 0.87395 | 1.468236 | Eukaryota | 2759 | Plants | Plants | 300 | 4.56e-77 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g9486 | i0 | 98.81 | 61.6428571428571 | 168 | 2 | 100 | 0 | 1 | 168 | 564 | 731 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 10356 | 300 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa |
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);;