contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA670521" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1164897 | 1164897 | PRJNA670521_P_NODE_26901_length_375_cov_1.867550_g26157_i0 | PRJNA670521 | 26901 | 375 | 1.86755 | 7.0033125 | Bryopsis | 3128 | Plants | Plants | 327 | 5.3e-85 | NTclustered | gi|969822372|gb|KT950953.1| | 3129 | g26157 | i0 | 82.749 | 91.504 | 371 | 60 | 98 | 4 | 1 | 369 | 720 | 352 | Bryopsis maxima actin gene, partial cds | blastn | 34314 | 327 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis maxima | |
| 2440189 | 2440189 | PRJNA670521_P_NODE_10322_length_557_cov_5.278926_g9589_i0 | PRJNA670521 | 10322 | 557 | 5.278926 | 29.40361782 | Eukaryota | 2759 | Plants | Plants | 316 | 1.76e-81 | NTclustered | gi|2082259086|ref|XM_001697336.2| | 3055 | g9589 | i0 | 81.654 | 63.2226211849192 | 387 | 65 | 69 | 6 | 124 | 507 | 127 | 510 | Chlamydomonas reinhardtii ribosomal protein S14 (CHLRE_11g480150v5), mRNA | blastn | 35215 | 318 | 0.993710691823899 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 3189152 | 3189152 | PRJNA670521_P_NODE_68603_length_254_cov_1.276243_g67858_i0 | PRJNA670521 | 68603 | 254 | 1.276243 | 3.24165722 | Pseudochloris wilhelmii | 1418016 | Plants | Plants | 82.4 | 2.94e-11 | NTclustered | gi|723457419|ref|NC_025547.1| | 1418016 | g67858 | i0 | 83.516 | 45.2716535433071 | 91 | 12 | 36 | 2 | 164 | 251 | 75852 | 75942 | Pseudochloris wilhelmii culture-collection SAG:1.80 chloroplast, complete genome | blastn | 11499 | 82.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochloris | Pseudochloris wilhelmii | |
| 4466117 | 4466117 | PRJNA670521_P_NODE_47364_length_302_cov_2.227074_g46619_i0 | PRJNA670521 | 47364 | 302 | 2.227074 | 6.72576348 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 169 | 2.68e-37 | NTclustered | gi|760449124|ref|XM_011403329.1| | 3075 | g46619 | i0 | 86.538 | 1.72847682119205 | 156 | 18 | 51 | 3 | 11 | 165 | 398 | 245 | Auxenochlorella protothecoides Aconitate hydratase, mitochondrial partial mRNA | blastn | 522 | 169 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 5741597 | 5741597 | PRJNA670521_P_NODE_33005_length_347_cov_2.529197_g32260_i0 | PRJNA670521 | 33005 | 347 | 2.529197 | 8.7763135900000009 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 217 | 1.1e-51 | NTclustered | gi|760437614|ref|XM_011397574.1| | 3075 | g32260 | i0 | 79.365 | 66.5821325648415 | 315 | 59 | 90 | 6 | 13 | 324 | 324 | 13 | Auxenochlorella protothecoides GTP-binding protein YPTC1 partial mRNA | blastn | 23104 | 217 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 7016729 | 7016729 | PRJNA670521_P_NODE_46586_length_304_cov_2.645022_g45841_i0 | PRJNA670521 | 46586 | 304 | 2.645022 | 8.04086688 | Monoraphidium neglectum | 145388 | Plants | Plants | 128 | 4.58e-25 | NTclustered | gi|926789524|ref|XM_014047782.1| | 145388 | g45841 | i0 | 79.474 | 6.35855263157895 | 190 | 31 | 61 | 5 | 8 | 193 | 1 | 186 | Monoraphidium neglectum 60S ribosomal protein L38 mRNA | blastn | 1933 | 128 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 8291420 | 8291420 | PRJNA670521_P_NODE_53767_length_287_cov_1.079439_g53022_i0 | PRJNA670521 | 53767 | 287 | 1.079439 | 3.09798993 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 206 | 1.92e-48 | NTclustered | gi|2082270260|ref|XM_043072311.1| | 3055 | g53022 | i0 | 80.843 | 18.5749128919861 | 261 | 50 | 91 | 0 | 27 | 287 | 934 | 674 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_17g724150v5), mRNA | blastn | 5331 | 206 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 8817943 | 8817943 | PRJNA670521_P_NODE_2907_length_1027_cov_30.492662_g2378_i0 | PRJNA670521 | 2907 | 1027 | 30.492662 | 313.15963874 | Tetradesmus | 91192 | Plants | Plants | 475 | 5.219999999999998e-129 | NTclustered | gi|2576955161|gb|OR551483.1| | 269609 | g2378 | i0 | 80.556 | 59.744888023369 | 684 | 78 | 65 | 35 | 1 | 665 | 4666 | 5313 | Tetradesmus bajacalifornicus culture SAG:3.99 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 61358 | 475 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus bajacalifornicus | |
| 9566687 | 9566687 | PRJNA670521_P_NODE_36748_length_334_cov_1.547893_g36003_i0 | PRJNA670521 | 36748 | 334 | 1.547893 | 5.16996262 | Monoraphidium neglectum | 145388 | Plants | Plants | 134 | 1.09e-26 | NTclustered | gi|926774671|ref|XM_014040356.1| | 145388 | g36003 | i0 | 84.444 | 1.82035928143713 | 135 | 21 | 40 | 0 | 97 | 231 | 7 | 141 | Monoraphidium neglectum molecular chaperone HtpG mRNA | blastn | 608 | 134 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 11368460 | 11368460 | PRJNA670521_P_NODE_3529_length_930_cov_26.326721_g2378_i1 | PRJNA670521 | 3529 | 930 | 26.326721 | 244.8385053 | Tetradesmus | 91192 | Plants | Plants | 475 | 4.709999999999999e-129 | NTclustered | gi|2576955161|gb|OR551483.1| | 269609 | g2378 | i1 | 80.556 | 65.4150537634409 | 684 | 78 | 72 | 35 | 266 | 930 | 5313 | 4666 | Tetradesmus bajacalifornicus culture SAG:3.99 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 60836 | 475 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus bajacalifornicus | |
| 11368469 | 11368469 | PRJNA670521_P_NODE_4329_length_844_cov_4.712062_g3695_i0 | PRJNA670521 | 4329 | 844 | 4.712062 | 39.76980328 | Eukaryota | 2759 | Plants | Plants | 433 | 2.6e-116 | NTclustered | gi|2082237163|ref|XM_043058766.1| | 3055 | g3695 | i0 | 79.835 | 67.7997630331754 | 605 | 112 | 71 | 8 | 78 | 677 | 790 | 191 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g039250v5), mRNA | blastn | 57223 | 433 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 15940887 | 15940887 | PRJNA670521_P_NODE_27613_length_372_cov_1.110368_g26869_i0 | PRJNA670521 | 27613 | 372 | 1.110368 | 4.13056896 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 254 | 9.04e-63 | NTclustered | gi|2082248650|ref|XM_043063418.1| | 3055 | g26869 | i0 | 79.718 | 5.68279569892473 | 355 | 68 | 95 | 4 | 3 | 355 | 338 | 690 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA | blastn | 2114 | 254 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 18490540 | 18490540 | PRJNA670521_P_NODE_34815_length_341_cov_1.283582_g34070_i0 | PRJNA670521 | 34815 | 341 | 1.283582 | 4.37701462 | Volvox carteri | 3067 | Plants | Plants | 58.4 | 6.93e-4 | NTclustered | gi|302847288|ref|XM_002955133.1| | 3068 | g34070 | i0 | 97.059 | 0.196480938416422 | 34 | 1 | 10 | 0 | 141 | 174 | 867 | 834 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_83092), mRNA | blastn | 67 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 18490627 | 18490627 | PRJNA670521_P_NODE_58695_length_276_cov_1.083744_g57950_i0 | PRJNA670521 | 58695 | 276 | 1.083744 | 2.99113344 | Astrephomene perforata | 47776 | Plants | Plants | 62.1 | 4.22e-5 | NTclustered | gi|2089721439|gb|MZ445389.1| | 47776 | g57950 | i0 | 95 | 0.144927536231884 | 40 | 1 | 14 | 1 | 204 | 243 | 154 | 192 | Astrephomene perforata strain NIES-564 hypothetical protein mRNA, partial cds | blastn | 40 | 62.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene perforata | |
| 19764945 | 19764945 | PRJNA670521_P_NODE_11976_length_521_cov_1.861607_g11241_i0 | PRJNA670521 | 11976 | 521 | 1.861607 | 9.69897247 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 311 | 7.63e-80 | NTclustered | gi|28193497|emb|AJ439528.1| | 37502 | g11241 | i0 | 78.814 | 86.3301343570058 | 472 | 92 | 90 | 8 | 2 | 469 | 128 | 595 | Polytomella sp. 'Pringsheim 198.80' mRNA for 40S ribosomal protein s5 (rs5 gene) | blastn | 44978 | 311 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 24864222 | 24864222 | PRJNA670521_P_NODE_23700_length_394_cov_1.196262_g22956_i0 | PRJNA670521 | 23700 | 394 | 1.196262 | 4.71327228 | Monoraphidium neglectum | 145388 | Plants | Plants | 263 | 1.6000000000000004e-65 | NTclustered | gi|926789920|ref|XM_014047980.1| | 145388 | g22956 | i0 | 84 | 65.8629441624365 | 275 | 42 | 70 | 2 | 100 | 373 | 103 | 376 | Monoraphidium neglectum peptidyl-prolyl cis-trans isomerase, cyclophilin-type mRNA | blastn | 25950 | 263 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum |
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);;