contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1195551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5425785 | 5425785 | PRJNA1195551_S_NODE_40665_length_162_cov_1.672566_g40312_i0 | PRJNA1195551 | 40665 | 162 | 1.672566 | 2.70955692 | Trebouxia asymmetrica | 13787 | Plants | Plants | 283 | 4.39e-72 | NTclustered | gi|189909382|gb|EU725860.1| | 13787 | g40312 | i0 | 98.148 | 133.265432098765 | 162 | 3 | 100 | 0 | 1 | 162 | 1487 | 1326 | Trebouxia asymmetrica strain SAG 48.88 23S large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 21589 | 283 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia asymmetrica | |
| 5425808 | 5425808 | PRJNA1195551_S_NODE_8925_length_307_cov_2.472868_g8572_i0 | PRJNA1195551 | 8925 | 307 | 2.472868 | 7.59170476 | Volvox carteri | 3067 | Plants | Plants | 95.3 | 4.69e-15 | NTclustered | gi|302850129|ref|XM_002956547.1| | 3068 | g8572 | i0 | 86.207 | 0.283387622149837 | 87 | 12 | 28 | 0 | 218 | 304 | 399 | 313 | Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl27A), mRNA | blastn | 87 | 95.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 6700469 | 6700469 | PRJNA1195551_S_NODE_26846_length_195_cov_3.020548_g26493_i0 | PRJNA1195551 | 26846 | 195 | 3.020548 | 5.8900686 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 305 | 1.17e-78 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g26493 | i0 | 94.872 | 101.066666666667 | 195 | 10 | 100 | 0 | 1 | 195 | 3029 | 2835 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 19708 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 7975975 | 7975975 | PRJNA1195551_S_NODE_8047_length_319_cov_4.200000_g7694_i0 | PRJNA1195551 | 8047 | 319 | 4.2 | 13.398 | Nannochloris normandinae | 926285 | Plants | Plants | 584 | 2.38e-162 | NTclustered | gi|922575245|gb|JQ921007.1| | 926285 | g7694 | i0 | 99.687 | 123.520376175549 | 319 | 1 | 100 | 0 | 1 | 319 | 36 | 354 | Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 39403 | 584 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris normandinae | |
| 10526379 | 10526379 | PRJNA1195551_S_NODE_7849_length_322_cov_5.256410_g7496_i0 | PRJNA1195551 | 7849 | 322 | 5.25641 | 16.9256402 | Pseudochlorella signiensis | 173497 | Plants | Plants | 294 | 4.55e-75 | NTclustered | gi|725650714|ref|NC_025529.1| | 173497 | g7496 | i0 | 94.271 | 61.4937888198758 | 192 | 11 | 60 | 0 | 131 | 322 | 150006 | 150197 | Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome | blastn | 19801 | 294 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 12521789 | 12521789 | PRJNA1195551_S_NODE_8450_length_313_cov_7.893939_g8097_i0 | PRJNA1195551 | 8450 | 313 | 7.893939 | 24.70802907 | Eukaryota | 2759 | Plants | Plants | 139 | 2.18e-28 | NTclustered | gi|2082244743|ref|XM_001698671.2| | 3055 | g8097 | i0 | 78.774 | 8.69009584664537 | 212 | 41 | 67 | 4 | 101 | 310 | 751 | 542 | Chlamydomonas reinhardtii ribosomal protein L23 (CHLRE_04g211800v5), mRNA | blastn | 2720 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 14351614 | 14351614 | PRJNA1195551_S_NODE_38312_length_166_cov_1.333333_g37959_i0 | PRJNA1195551 | 38312 | 166 | 1.333333 | 2.21333278 | Trebouxia aggregata | 160068 | Plants | Plants | 274 | 2.73e-69 | NTclustered | gi|162134245|gb|EU123948.1| | 160068 | g37959 | i0 | 96.407 | 93.3734939759036 | 167 | 4 | 100 | 2 | 1 | 166 | 14873 | 15038 | Trebouxia aggregata strain SAG 219-1d ribosomal protein S2 (rps2) gene, complete cds; tRNA-Met (trnMe(cau)) and large subunit ribosomal RNA (rnl) genes, complete sequence; putative site-specific DNA endonuclease (orf365) gene, complete cds; small subunit ribosomal RNA (rns) and tRNA-Met (trnMf(cau)) genes, complete sequence; cytochrome c oxidase subunit 1 (cox1), putative site-specific DNA endonuclease (orf335), and putative site-specific DNA endonuclease (orf256) genes, complete cds; tRNA-Phe (trnF(gaa)) and tRNA-Lys (trnK(uuu)) genes, complete sequence; and apocytochrome b (cob) and putative site-specific DNA endonuclease (orf334) genes, complete cds; mitochondrial | blastn | 15500 | 274 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 16899690 | 16899690 | PRJNA1195551_S_NODE_30054_length_185_cov_2.029412_g29701_i0 | PRJNA1195551 | 30054 | 185 | 2.029412 | 3.7544122 | Nannochloris normandinae | 926285 | Plants | Plants | 322 | 1.09e-83 | NTclustered | gi|922575245|gb|JQ921007.1| | 926285 | g29701 | i0 | 100 | 106.210810810811 | 174 | 0 | 94 | 0 | 1 | 174 | 680 | 507 | Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 19649 | 322 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris normandinae | |
| 16899717 | 16899717 | PRJNA1195551_S_NODE_43074_length_156_cov_2.915888_g42721_i0 | PRJNA1195551 | 43074 | 156 | 2.915888 | 4.54878528 | Aegagropila linnaei | 162062 | Plants | Plants | 86.1 | 1.27e-12 | NTclustered | gi|1279575452|gb|MF683076.1| | 162062 | g42721 | i0 | 93.103 | 0.724358974358974 | 58 | 4 | 37 | 0 | 98 | 155 | 3742 | 3685 | Aegagropila linnaei 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 113 | 86.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Cladophorales | Pithophoraceae | Aegagropila | Aegagropila linnaei | |
| 18894522 | 18894522 | PRJNA1195551_S_NODE_23135_length_209_cov_5.343750_g22782_i0 | PRJNA1195551 | 23135 | 209 | 5.34375 | 11.1684375 | Chlorophyta | 3041 | Plants | Plants | 158 | 3.77e-34 | NTclustered | gi|1016470590|ref|NC_029807.1| | 3190 | g22782 | i0 | 81.193 | 78.799043062201 | 218 | 22 | 99 | 15 | 1 | 208 | 93649 | 93441 | Scherffelia dubia culture-collection SAG:17.86 plastid, complete genome | blastn | 16469 | 159 | 0.993710691823899 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Scherffelia | Scherffelia dubia | |
| 21999299 | 21999299 | PRJNA1195551_S_NODE_15978_length_246_cov_5.274112_g15625_i0 | PRJNA1195551 | 15978 | 246 | 5.274112 | 12.97431552 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2082253788|ref|XM_043065912.1| | 3055 | g15625 | i0 | 96.97 | 0.268292682926829 | 33 | 1 | 13 | 0 | 202 | 234 | 373 | 341 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g398900v5), mRNA | blastn | 66 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 21999329 | 21999329 | PRJNA1195551_S_NODE_21158_length_218_cov_2.153846_g20805_i0 | PRJNA1195551 | 21158 | 218 | 2.153846 | 4.69538428 | Nannochloris normandinae | 926285 | Plants | Plants | 403 | 4.62e-108 | NTclustered | gi|922575245|gb|JQ921007.1| | 926285 | g20805 | i0 | 100 | 122.220183486239 | 218 | 0 | 100 | 0 | 1 | 218 | 1507 | 1290 | Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 26644 | 403 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris normandinae |
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);;