contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA169559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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);;