contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA533623" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1118026 | 1118026 | PRJNA533623_P_NODE_67801_length_227_cov_1.566265_g66020_i0 | PRJNA533623 | 67801 | 227 | 1.566265 | 3.55542155 | Trebouxiophyceae | 75966 | Plants | Plants | 331 | 2.32e-86 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g66020 | i0 | 92.952 | 99.273127753304 | 227 | 16 | 100 | 0 | 1 | 227 | 296 | 70 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 22535 | 331 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 4333967 | 4333967 | PRJNA533623_P_NODE_63824_length_240_cov_2.905028_g62043_i0 | PRJNA533623 | 63824 | 240 | 2.905028 | 6.9720672 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 267 | 7.08e-67 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g62043 | i0 | 88.636 | 94.2916666666667 | 220 | 23 | 91 | 2 | 1 | 218 | 2554 | 2335 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 22630 | 267 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 8159400 | 8159400 | PRJNA533623_P_NODE_43947_length_323_cov_10.515267_g42173_i0 | PRJNA533623 | 43947 | 323 | 10.515267 | 33.96431241 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 147 | 1.35e-30 | NTclustered | gi|2082266873|ref|XM_043070842.1| | 3055 | g42173 | i0 | 91.509 | 0.656346749226006 | 106 | 9 | 33 | 0 | 8 | 113 | 1426 | 1531 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_16g653300v5), mRNA | blastn | 212 | 147 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 10046685 | 10046685 | PRJNA533623_P_NODE_9428_length_762_cov_54.711840_g7897_i0 | PRJNA533623 | 9428 | 762 | 54.71184 | 416.9042208 | Coccomyxa | 41891 | Plants | Plants | 821 | 0 | NTclustered | gi|1360638129|gb|AC277064.1| | 574566 | g7897 | i0 | 86.957 | 96.6049868766404 | 736 | 88 | 96 | 7 | 30 | 762 | 1551 | 821 | Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence | blastn | 73613 | 821 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 11985866 | 11985866 | PRJNA533623_P_NODE_69450_length_221_cov_13.012500_g67669_i0 | PRJNA533623 | 69450 | 221 | 13.0125 | 28.757625 | Chlorella variabilis | 554065 | Plants | Plants | 87.9 | 5.37e-13 | NTclustered | gi|237648547|dbj|AB437257.1| | 554065 | g67669 | i0 | 87.013 | 23.1764705882353 | 77 | 10 | 35 | 0 | 145 | 221 | 3785 | 3709 | Chlorella variabilis gene for 28S ribosomal RNA, partial sequence, strain: OK1-ZK | blastn | 5122 | 87.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 11985884 | 11985884 | PRJNA533623_P_NODE_70430_length_218_cov_58.197452_g68649_i0 | PRJNA533623 | 70430 | 218 | 58.197452 | 126.87044536 | Cephaleuros sp. BN20 | 2738536 | Plants | Plants | 102 | 1.89e-17 | NTclustered | gi|1844674982|gb|MT508724.1| | 2738536 | g68649 | i0 | 98.276 | 30.4311926605505 | 58 | 1 | 27 | 0 | 58 | 115 | 36 | 93 | Cephaleuros sp. BN20 large subunit ribosomal RNA gene, partial sequence | blastn | 6634 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Trentepohliales | Trentepohliaceae | Cephaleuros | Cephaleuros sp. BN20 | |
| 13260193 | 13260193 | PRJNA533623_P_NODE_34951_length_376_cov_3.285714_g33179_i0 | PRJNA533623 | 34951 | 376 | 3.285714 | 12.35428464 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 141 | 7.43e-29 | NTclustered | gi|760448344|ref|XM_011402939.1| | 3075 | g33179 | i0 | 83.553 | 13.4228723404255 | 152 | 23 | 40 | 2 | 101 | 251 | 345 | 495 | Auxenochlorella protothecoides 60S ribosomal protein L15 partial mRNA | blastn | 5047 | 141 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 14535532 | 14535532 | PRJNA533623_P_NODE_5052_length_1011_cov_8.704211_g3844_i0 | PRJNA533623 | 5052 | 1011 | 8.704211 | 87.99957321 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 56.5 | 0.008 | NTclustered | gi|2082260707|ref|XM_043068341.1| | 3055 | g3844 | i0 | 96.97 | 0.0326409495548961 | 33 | 1 | 3 | 0 | 710 | 742 | 1145 | 1177 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g518107v5), mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17696178 | 17696178 | PRJNA533623_P_NODE_9554_length_758_cov_4.208034_g8021_i0 | PRJNA533623 | 9554 | 758 | 4.208034 | 31.89689772 | Trebouxia | 13786 | Plants | Plants | 1057 | 0 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g8021 | i0 | 92.154 | 99.2361477572559 | 752 | 53 | 99 | 6 | 1 | 749 | 6138 | 6886 | 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 | 75221 | 1057 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 19632780 | 19632780 | PRJNA533623_P_NODE_48496_length_301_cov_2.566667_g46717_i0 | PRJNA533623 | 48496 | 301 | 2.566667 | 7.72566767 | uncultured Trebouxia photobiont | 285713 | Plants | Plants | 540 | 4.899999999999999e-149 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g46717 | i0 | 99.003 | 99.9169435215947 | 301 | 3 | 100 | 0 | 1 | 301 | 6581 | 6281 | 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 | 30075 | 540 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 21519794 | 21519794 | PRJNA533623_P_NODE_21137_length_506_cov_13.651685_g19389_i0 | PRJNA533623 | 21137 | 506 | 13.651685 | 69.0775261 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.049 | NTclustered | gi|363992285|gb|JN543393.1| | 63409 | g19389 | i0 | 94.286 | 0.124505928853755 | 35 | 1 | 7 | 1 | 101 | 134 | 82 | 116 | Ulva linza polyubiquitin (UBQ) mRNA, partial cds | blastn | 63 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva linza | |
| 22184025 | 22184025 | PRJNA533623_P_NODE_74738_length_207_cov_2.746575_g72957_i0 | PRJNA533623 | 74738 | 207 | 2.746575 | 5.68541025 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 63.9 | 8.37e-6 | NTclustered | gi|9408024|emb|AJ242525.1| | 3055 | g72957 | i0 | 87.273 | 0.531400966183575 | 55 | 7 | 27 | 0 | 111 | 165 | 15734 | 15788 | Chlamydomonas reinhardtii partial dhc10 gene for 1 beta dynein heavy chain, exons 16-53 | blastn | 110 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 24732433 | 24732433 | PRJNA533623_P_NODE_40860_length_339_cov_109.967626_g39086_i0 | PRJNA533623 | 40860 | 339 | 109.967626 | 372.79025214 | Cephaleuros sp. BN20 | 2738536 | Plants | Plants | 100 | 1.13e-16 | NTclustered | gi|1844674982|gb|MT508724.1| | 2738536 | g39086 | i0 | 96.667 | 19.2182890855457 | 60 | 2 | 18 | 0 | 280 | 339 | 92 | 33 | Cephaleuros sp. BN20 large subunit ribosomal RNA gene, partial sequence | blastn | 6515 | 100 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Trentepohliales | Trentepohliaceae | Cephaleuros | Cephaleuros sp. BN20 | |
| 24732610 | 24732610 | PRJNA533623_P_NODE_48480_length_301_cov_3.091667_g46701_i0 | PRJNA533623 | 48480 | 301 | 3.091667 | 9.30591767 | Nannochloris normandinae | 926285 | Plants | Plants | 529 | 1.0599999999999996e-145 | NTclustered | gi|922575245|gb|JQ921007.1| | 926285 | g46701 | i0 | 99.317 | 104.744186046512 | 293 | 1 | 97 | 1 | 1 | 292 | 799 | 507 | Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 31528 | 529 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris normandinae | |
| 24733168 | 24733168 | PRJNA533623_P_NODE_74340_length_208_cov_1.768707_g72559_i0 | PRJNA533623 | 74340 | 208 | 1.768707 | 3.67891056 | Bryopsis hypnoides | 222885 | Plants | Plants | 63.9 | 8.42e-6 | NTclustered | gi|260780633|ref|NC_013359.1| | 222885 | g72559 | i0 | 97.368 | 8.02884615384615 | 38 | 0 | 18 | 1 | 14 | 50 | 130452 | 130489 | Bryopsis hypnoides chloroplast, complete genome | blastn | 1670 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis hypnoides |
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);;