contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA715462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1982376 | 1982376 | PRJNA715462_P_NODE_63562_length_244_cov_0.900585_g62766_i0 | PRJNA715462 | 63562 | 244 | 0.900585 | 2.1974274 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|760446266|ref|XM_011401900.1| | 3075 | g62766 | i0 | 96.97 | 0.135245901639344 | 33 | 1 | 14 | 0 | 117 | 149 | 955 | 923 | Auxenochlorella protothecoides Nicotinamide mononucleotide adenylyltransferase 1 partial mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 3256849 | 3256849 | PRJNA715462_P_NODE_21243_length_399_cov_1.180982_g20447_i0 | PRJNA715462 | 21243 | 399 | 1.180982 | 4.71211818 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 58.4 | 8.22e-4 | NTclustered | gi|2082256647|ref|XM_043066703.1| | 3055 | g20447 | i0 | 94.595 | 0.709273182957393 | 37 | 2 | 9 | 0 | 219 | 255 | 448 | 412 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_10g434967v5), mRNA | blastn | 283 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 3256892 | 3256892 | PRJNA715462_P_NODE_23323_length_376_cov_1.402640_g22527_i0 | PRJNA715462 | 23323 | 376 | 1.40264 | 5.2739264 | Ignatius tetrasporus | 231078 | Plants | Plants | 139 | 2.67e-28 | NTclustered | gi|371782089|emb|HE610121.1| | 231078 | g22527 | i0 | 89.381 | 28.5478723404255 | 113 | 8 | 30 | 4 | 1 | 111 | 3188 | 3078 | Ignatius tetrasporus 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2012 | blastn | 10734 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ignatiales | Ignatiaceae | Ignatius | Ignatius tetrasporus | |
| 4534216 | 4534216 | PRJNA715462_P_NODE_35864_length_294_cov_1.995475_g35068_i0 | PRJNA715462 | 35864 | 294 | 1.995475 | 5.8666965 | Medakamo hakoo | 3113649 | Plants | Plants | 224 | 5.459999999999999e-54 | NTclustered | gi|2083529837|dbj|LC604817.1| | 3113649 | g35068 | i0 | 80.612 | 38.5476190476191 | 294 | 53 | 99 | 4 | 1 | 292 | 5213 | 4922 | Medakamo hakoo NIES-4000 mitochondrial DNA, complete genome | blastn | 11333 | 224 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Medakamo | Medakamo hakoo | ||
| 14734974 | 14734974 | PRJNA715462_P_NODE_42812_length_272_cov_1.839196_g42016_i0 | PRJNA715462 | 42812 | 272 | 1.839196 | 5.00261312 | Prototheca bovis | 2509265 | Plants | Plants | 104 | 6.79e-18 | NTclustered | gi|1159431146|gb|KX389286.1| | 2509265 | g42016 | i0 | 83.784 | 21.1617647058824 | 111 | 17 | 41 | 1 | 63 | 173 | 168 | 59 | Prototheca bovis isolate SAG-2021 alpha tubulin (TUA1) mRNA, complete cds | blastn | 5756 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca bovis | |
| 14735209 | 14735209 | PRJNA715462_P_NODE_55012_length_249_cov_0.875000_g54216_i0 | PRJNA715462 | 55012 | 249 | 0.875 | 2.17875 | Volvox carteri | 3067 | Plants | Plants | 52.8 | 0.023 | NTclustered | gi|302847324|ref|XM_002955151.1| | 3068 | g54216 | i0 | 94.286 | 0.140562248995984 | 35 | 1 | 14 | 1 | 100 | 133 | 3315 | 3349 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_96120), partial mRNA | blastn | 35 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 16008630 | 16008630 | PRJNA715462_P_NODE_45473_length_265_cov_0.906250_g44677_i0 | PRJNA715462 | 45473 | 265 | 0.90625 | 2.4015625 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 250 | 8e-62 | NTclustered | gi|2082260397|ref|XM_043068042.1| | 3055 | g44677 | i0 | 83.969 | 24.6075471698113 | 262 | 40 | 98 | 2 | 5 | 265 | 241 | 501 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g498600v5), mRNA | blastn | 6521 | 250 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17284256 | 17284256 | PRJNA715462_P_NODE_52854_length_250_cov_0.870056_g52058_i0 | PRJNA715462 | 52854 | 250 | 0.870056 | 2.17514 | Polytomella parva | 51329 | Plants | Plants | 230 | 9.75e-56 | NTclustered | gi|1861356433|gb|MT377444.1| | 51329 | g52058 | i0 | 83.2 | 92.892 | 250 | 42 | 100 | 0 | 1 | 250 | 492 | 741 | Polytomella parva clone 0016312155 luminal-binding protein (BIP1) mRNA, complete cds; plastid | blastn | 23223 | 230 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 17284522 | 17284522 | PRJNA715462_P_NODE_67894_length_241_cov_3.648810_g67098_i0 | PRJNA715462 | 67894 | 241 | 3.64881 | 8.7936321 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 191 | 4.41e-44 | NTclustered | gi|2082253475|ref|XM_001695212.2| | 3055 | g67098 | i0 | 83.902 | 4.37344398340249 | 205 | 28 | 85 | 5 | 38 | 241 | 961 | 761 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g386750v5), mRNA | blastn | 1054 | 191 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 19833004 | 19833004 | PRJNA715462_P_NODE_46776_length_261_cov_1.255319_g45980_i0 | PRJNA715462 | 46776 | 261 | 1.255319 | 3.27638259 | Tetraselmis sp. CCMP 881 | 1812852 | Plants | Plants | 91.6 | 5.04e-14 | NTclustered | gi|1778428824|gb|MN642087.1| | 1812852 | g45980 | i0 | 93.443 | 24.6973180076628 | 61 | 4 | 23 | 0 | 72 | 132 | 39708 | 39768 | Tetraselmis sp. CCMP 881 mitochondrion, complete genome | blastn | 6446 | 91.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Tetraselmis | Tetraselmis sp. CCMP 881 | |
| 22383089 | 22383089 | PRJNA715462_P_NODE_22958_length_380_cov_0.980456_g22162_i0 | PRJNA715462 | 22958 | 380 | 0.980456 | 3.7257328 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 117 | 1.27e-21 | NTclustered | gi|2082253493|ref|XM_043066154.1| | 3055 | g22162 | i0 | 86.667 | 1.18684210526316 | 105 | 14 | 28 | 0 | 206 | 310 | 756 | 652 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g405106v5), mRNA | blastn | 451 | 117 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 22869782 | 22869782 | PRJNA715462_P_NODE_60558_length_246_cov_0.890173_g59762_i0 | PRJNA715462 | 60558 | 246 | 0.890173 | 2.18982558 | Chlorophyta | 3041 | Plants | Plants | 230 | 9.56e-56 | NTclustered | gi|926790540|ref|XM_014048290.1| | 145388 | g59762 | i0 | 84.783 | 81.7276422764228 | 230 | 33 | 93 | 2 | 16 | 244 | 635 | 863 | Monoraphidium neglectum aurora kinase A mRNA | blastn | 20105 | 231 | 0.995670995670996 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 23658918 | 23658918 | PRJNA715462_P_NODE_37279_length_289_cov_1.324074_g36483_i0 | PRJNA715462 | 37279 | 289 | 1.324074 | 3.82657386 | Chlorella variabilis | 554065 | Plants | Plants | 143 | 1.54e-29 | NTclustered | gi|552822108|ref|XM_005845964.1| | 554065 | g36483 | i0 | 81.111 | 6.18339100346021 | 180 | 32 | 62 | 2 | 2 | 180 | 259 | 437 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_53431) mRNA, complete cds | blastn | 1787 | 143 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 24932624 | 24932624 | PRJNA715462_P_NODE_46240_length_262_cov_1.883598_g45444_i0 | PRJNA715462 | 46240 | 262 | 1.883598 | 4.93502676 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 63.9 | 1.1e-5 | NTclustered | gi|2082238366|ref|XM_043059241.1| | 3055 | g45444 | i0 | 91.304 | 0.282442748091603 | 46 | 4 | 18 | 0 | 20 | 65 | 1511 | 1556 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g081250v5), mRNA | blastn | 74 | 63.9 | 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);;