contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA169559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1639798 | 1639798 | PRJNA169559_P_NODE_27642_length_278_cov_4.646586_g25566_i0 | PRJNA169559 | 27642 | 278 | 4.646586 | 12.91750908 | Haematococcus lacustris | 44745 | Plants | Plants | 446 | 9.999999999999998e-121 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g25566 | i0 | 97.683 | 307.863309352518 | 259 | 6 | 93 | 0 | 1 | 259 | 2820 | 3078 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 85586 | 446 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 1639892 | 1639892 | PRJNA169559_P_NODE_44822_length_217_cov_2.622340_g42745_i0 | PRJNA169559 | 44822 | 217 | 2.62234 | 5.6904778 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 62.1 | 3.18e-5 | NTclustered | gi|2082253574|ref|XM_043066114.1| | 3055 | g42745 | i0 | 97.222 | 2.03225806451613 | 36 | 1 | 17 | 0 | 57 | 92 | 2714 | 2679 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g403400v5), mRNA | blastn | 441 | 62.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 2330085 | 2330085 | PRJNA169559_P_NODE_22742_length_331_cov_74.844371_g20672_i0 | PRJNA169559 | 22742 | 331 | 74.844371 | 247.73486801 | Trebouxia | 13786 | Plants | Plants | 582 | 8.939999999999999e-162 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g20672 | i0 | 98.485 | 99.4018126888217 | 330 | 5 | 99 | 0 | 1 | 330 | 6304 | 6633 | Uncultured Trebouxia photobiont voucher Lendemer 46119 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 32902 | 582 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 4192134 | 4192134 | PRJNA169559_P_NODE_34204_length_249_cov_50.190909_g32127_i0 | PRJNA169559 | 34204 | 249 | 50.190909 | 124.97536341 | Haematococcus lacustris | 44745 | Plants | Plants | 416 | 6.939999999999999e-112 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g32127 | i0 | 96.787 | 288.971887550201 | 249 | 8 | 100 | 0 | 1 | 249 | 2252 | 2500 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 71954 | 416 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 4192190 | 4192190 | PRJNA169559_P_NODE_44124_length_222_cov_2.362694_g42047_i0 | PRJNA169559 | 44124 | 222 | 2.362694 | 5.24518068 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 141 | 4.09e-29 | NTclustered | gi|760445552|ref|XM_011401543.1| | 3075 | g42047 | i0 | 84.892 | 18.2387387387387 | 139 | 21 | 63 | 0 | 4 | 142 | 1293 | 1155 | Auxenochlorella protothecoides V-type proton ATPase catalytic subunit A isoform 1 partial mRNA | blastn | 4049 | 141 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 5468174 | 5468174 | PRJNA169559_P_NODE_13405_length_458_cov_3.480186_g11502_i0 | PRJNA169559 | 13405 | 458 | 3.480186 | 15.93925188 | Volvox carteri | 3067 | Plants | Plants | 56.5 | 0.003 | NTclustered | gi|302849719|ref|XM_002956343.1| | 3068 | g11502 | i0 | 100 | 0.37117903930131 | 30 | 0 | 7 | 0 | 316 | 345 | 666 | 637 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_97422), partial mRNA | blastn | 170 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 9292933 | 9292933 | PRJNA169559_P_NODE_12128_length_483_cov_5.658590_g4111_i1 | PRJNA169559 | 12128 | 483 | 5.65859 | 27.3309897 | Haematococcus lacustris | 44745 | Plants | Plants | 673 | 0 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g4111 | i1 | 96.333 | 117.728778467909 | 409 | 15 | 85 | 0 | 75 | 483 | 3311 | 3719 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 56863 | 673 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 10568931 | 10568931 | PRJNA169559_P_NODE_15889_length_424_cov_1.574684_g13926_i0 | PRJNA169559 | 15889 | 424 | 1.574684 | 6.67666016 | Chloropicon roscoffensis | 1461544 | Plants | Plants | 65.8 | 5.25e-6 | NTclustered | gi|2863410610|gb|CP145446.1| | 1461544 | g13926 | i0 | 97.368 | 0.42688679245283 | 38 | 1 | 9 | 0 | 375 | 412 | 172796 | 172759 | Chloropicon roscoffensis strain CCMP1998 chromosome 6 | blastn | 181 | 65.8 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon roscoffensis | ||
| 10569077 | 10569077 | PRJNA169559_P_NODE_29569_length_267_cov_1.651261_g27493_i0 | PRJNA169559 | 29569 | 267 | 1.651261 | 4.40886687 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 132 | 3.05e-26 | NTclustered | gi|2082247365|ref|XM_043062922.1| | 3055 | g27493 | i0 | 87.611 | 7.08614232209738 | 113 | 14 | 42 | 0 | 1 | 113 | 1137 | 1249 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g269950v5), mRNA | blastn | 1892 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 10569177 | 10569177 | PRJNA169559_P_NODE_45969_length_201_cov_8.343023_g43892_i0 | PRJNA169559 | 45969 | 201 | 8.343023 | 16.76947623 | Haematococcus lacustris | 44745 | Plants | Plants | 350 | 5.539999999999999e-92 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g43892 | i0 | 100 | 401.278606965174 | 189 | 0 | 94 | 0 | 1 | 189 | 4197 | 4009 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 80657 | 350 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 10569195 | 10569195 | PRJNA169559_P_NODE_47009_length_185_cov_3.442308_g44932_i0 | PRJNA169559 | 47009 | 185 | 3.442308 | 6.3682698 | Mantoniella tinhauana | 3097027 | Plants | Plants | 93.5 | 9.31e-15 | NTclustered | gi|2735153278|gb|CP140063.1| | 3097027 | g44932 | i0 | 93.651 | 24.8054054054054 | 63 | 2 | 34 | 2 | 1 | 62 | 206207 | 206268 | Mantoniella tinhauana isolate LFS chromosome 2 | blastn | 4589 | 93.5 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 15667754 | 15667754 | PRJNA169559_P_NODE_19933_length_374_cov_11.330435_g17894_i0 | PRJNA169559 | 19933 | 374 | 11.330435 | 42.3758269 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 62.1 | 5.91e-5 | NTclustered | gi|545365919|ref|XM_005647835.1| | 574566 | g17894 | i0 | 95 | 1.58021390374332 | 40 | 1 | 10 | 1 | 295 | 333 | 408 | 447 | Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA | blastn | 591 | 62.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 15668028 | 15668028 | PRJNA169559_P_NODE_5493_length_724_cov_116.759712_g4111_i0 | PRJNA169559 | 5493 | 724 | 116.759712 | 845.34031488 | Haematococcus lacustris | 44745 | Plants | Plants | 669 | 0 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g4111 | i0 | 97.215 | 269.270718232044 | 395 | 11 | 55 | 0 | 330 | 724 | 3325 | 3719 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 194952 | 669 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 23317151 | 23317151 | PRJNA169559_P_NODE_32159_length_256_cov_1.748899_g30083_i0 | PRJNA169559 | 32159 | 256 | 1.748899 | 4.47718144 | Mantoniella tinhauana | 3097027 | Plants | Plants | 87.9 | 6.38e-13 | NTclustered | gi|2735153285|gb|CP140070.1| | 3097027 | g30083 | i0 | 83.333 | 1.16015625 | 96 | 14 | 37 | 2 | 162 | 256 | 844536 | 844630 | Mantoniella tinhauana isolate LFS chromosome 9 | blastn | 297 | 87.9 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 23317181 | 23317181 | PRJNA169559_P_NODE_3859_length_854_cov_3.212121_g2708_i0 | PRJNA169559 | 3859 | 854 | 3.212121 | 27.43151334 | Chloropicon roscoffensis | 1461544 | Plants | Plants | 281 | 1.01e-70 | NTclustered | gi|2863409343|gb|CP145444.1| | 1461544 | g2708 | i0 | 80.833 | 28.1007025761124 | 360 | 67 | 42 | 2 | 1 | 359 | 988180 | 988538 | Chloropicon roscoffensis strain CCMP1998 chromosome 4 | blastn | 23998 | 281 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon roscoffensis | ||
| 24591416 | 24591416 | PRJNA169559_P_NODE_46840_length_188_cov_1.849057_g44763_i0 | PRJNA169559 | 46840 | 188 | 1.849057 | 3.47622716 | Mantoniella tinhauana | 3097027 | Plants | Plants | 97.1 | 7.34e-16 | NTclustered | gi|2735153287|gb|CP140072.1| | 3097027 | g44763 | i0 | 83.495 | 1.32978723404255 | 103 | 17 | 55 | 0 | 12 | 114 | 972499 | 972601 | Mantoniella tinhauana isolate LFS chromosome 11 | blastn | 250 | 97.1 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 25280863 | 25280863 | PRJNA169559_P_NODE_21540_length_350_cov_1.844237_g19477_i0 | PRJNA169559 | 21540 | 350 | 1.844237 | 6.4548295 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.033 | NTclustered | gi|2082262198|ref|XM_043068965.1| | 3055 | g19477 | i0 | 100 | 0.248571428571429 | 28 | 0 | 8 | 0 | 44 | 71 | 1699 | 1672 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g550000v5), mRNA | blastn | 87 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii |
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);;