contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA942359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4751228 | 4751228 | PRJNA942359_P_NODE_11724_length_263_cov_8.157895_g11609_i0 | PRJNA942359 | 11724 | 263 | 8.157895 | 21.45526385 | Microglena reginae | 327066 | Plants | Plants | 134 | 8.34e-27 | NTclustered | gi|66864261|gb|DQ015716.1| | 327066 | g11609 | i0 | 95.238 | 31.0950570342205 | 84 | 4 | 32 | 0 | 1 | 84 | 1808 | 1891 | Microglena reginae strain SAG 17.89 26S ribosomal RNA gene, partial sequence | blastn | 8178 | 134 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Microglena | Microglena reginae | |
| 4751462 | 4751462 | PRJNA942359_P_NODE_4244_length_394_cov_1.763240_g4129_i0 | PRJNA942359 | 4244 | 394 | 1.76324 | 6.9471656 | Ulva prolifera | 3117 | Plants | Plants | 571 | 2.3399999999999996e-158 | NTclustered | gi|1915399071|gb|MN867372.1| | 3117 | g4129 | i0 | 100 | 70.0253807106599 | 309 | 0 | 78 | 0 | 86 | 394 | 1 | 309 | Ulva prolifera light-harvesting complex II protein (lhcbm-5) mRNA, partial cds | blastn | 27590 | 571 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva prolifera | |
| 4751532 | 4751532 | PRJNA942359_P_NODE_8584_length_296_cov_1.618834_g8469_i0 | PRJNA942359 | 8584 | 296 | 1.618834 | 4.79174864 | Tetradesmus obliquus | 3088 | Plants | Plants | 139 | 2.05e-28 | NTclustered | gi|87313206|gb|DQ370088.1| | 3088 | g8469 | i0 | 91.176 | 1.68243243243243 | 102 | 9 | 34 | 0 | 1 | 102 | 646 | 747 | Scenedesmus obliquus light-harvesting chlorophyll-a/b binding protein LhcbM3 mRNA, complete cds | blastn | 498 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 5087088 | 5087088 | PRJNA942359_P_NODE_12524_length_256_cov_1.393443_g12409_i0 | PRJNA942359 | 12524 | 256 | 1.393443 | 3.56721408 | Chloropyrula | 1305687 | Plants | Plants | 473 | 4.189999999999999e-129 | NTclustered | gi|425892310|gb|JX070625.1| | 1263455 | g12409 | i0 | 100 | 99.27734375 | 256 | 0 | 100 | 0 | 1 | 256 | 881 | 626 | Chloropyrula uraliensis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 25415 | 473 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chloropyrula | Chloropyrula uraliensis | |||
| 9851059 | 9851059 | PRJNA942359_P_NODE_3228_length_442_cov_0.964770_g3113_i0 | PRJNA942359 | 3228 | 442 | 0.96477 | 4.2642834 | Tetradesmus obliquus | 3088 | Plants | Plants | 608 | 2.019999999999999e-169 | NTclustered | gi|87313208|gb|DQ370089.1| | 3088 | g3113 | i0 | 91.61 | 101.02036199095 | 441 | 35 | 99 | 2 | 3 | 442 | 620 | 181 | Scenedesmus obliquus light-harvesting chlorophyll-a/b binding protein LhcbM4 mRNA, complete cds | blastn | 44651 | 608 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 14012740 | 14012740 | PRJNA942359_P_NODE_10311_length_278_cov_0.882927_g10196_i0 | PRJNA942359 | 10311 | 278 | 0.882927 | 2.45453706 | Desmochloris | 138596 | Plants | Plants | 425 | 1.31e-114 | NTclustered | gi|371782086|emb|HE610118.1| | 138176 | g10196 | i0 | 94.245 | 101.21582733813 | 278 | 16 | 100 | 0 | 1 | 278 | 765 | 1042 | Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 | blastn | 28138 | 425 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 14950910 | 14950910 | PRJNA942359_P_NODE_16952_length_247_cov_0.896552_g16837_i0 | PRJNA942359 | 16952 | 247 | 0.896552 | 2.21448344 | Volvox carteri | 3067 | Plants | Plants | 235 | 2.07e-57 | NTclustered | gi|302833642|ref|XM_002948339.1| | 3068 | g16837 | i0 | 84 | 29.6761133603239 | 250 | 34 | 100 | 5 | 1 | 247 | 374 | 128 | Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl30), mRNA | blastn | 7330 | 235 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 17836200 | 17836200 | PRJNA942359_P_NODE_11914_length_262_cov_1.238095_g11799_i0 | PRJNA942359 | 11914 | 262 | 1.238095 | 3.2438089 | Chlamydomonas | 3052 | Plants | Plants | 276 | 1.2999999999999998e-69 | NTclustered | gi|2082246856|ref|XM_001696559.2| | 3055 | g11799 | i0 | 85.769 | 11.7137404580153 | 260 | 37 | 99 | 0 | 1 | 260 | 560 | 301 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g257601v5), mRNA | blastn | 3069 | 276 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 18774882 | 18774882 | PRJNA942359_P_NODE_6775_length_326_cov_1.849802_g6660_i0 | PRJNA942359 | 6775 | 326 | 1.849802 | 6.03035452 | Ettlia sp. YC001 | 1191503 | Plants | Plants | 267 | 1.01e-66 | NTclustered | gi|1815409459|gb|MN184716.1| | 1191503 | g6660 | i0 | 88.94 | 4.39877300613497 | 217 | 22 | 66 | 2 | 110 | 325 | 49 | 264 | Ettlia sp. YC001 ribulose-1,5-bisphosphate carboxylase/oxygenase small subunit 2 (rbcS2) mRNA, complete cds; chloroplast | blastn | 1434 | 267 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Ettlia | Ettlia sp. YC001 | ||
| 20049521 | 20049521 | PRJNA942359_P_NODE_13936_length_252_cov_0.871508_g13821_i0 | PRJNA942359 | 13936 | 252 | 0.871508 | 2.19620016 | Coelastrella saipanensis | 152631 | Plants | Plants | 350 | 7.24e-92 | NTclustered | gi|1642520538|ref|NC_042181.1| | 152631 | g13821 | i0 | 91.765 | 154.444444444444 | 255 | 16 | 100 | 5 | 1 | 252 | 109673 | 109925 | Coelastrella saipanensis chloroplast, complete genome | blastn | 38920 | 350 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Coelastrella | Coelastrella saipanensis | |
| 23875349 | 23875349 | PRJNA942359_P_NODE_12419_length_257_cov_1.434783_g12304_i0 | PRJNA942359 | 12419 | 257 | 1.434783 | 3.68739231 | Desmochloris mollenhaueri | 578869 | Plants | Plants | 464 | 2.5299999999999998e-126 | NTclustered | gi|313476264|emb|FM882217.1| | 578869 | g12304 | i0 | 99.222 | 99.9922178988327 | 257 | 2 | 100 | 0 | 1 | 257 | 597 | 853 | Desmochloris sp. TP-2008 partial 18S rRNA gene, ITS1, 5.8S rRNA and ITS2, strain CCAP 6006/2 | blastn | 25698 | 464 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris mollenhaueri | |
| 23875429 | 23875429 | PRJNA942359_P_NODE_15879_length_248_cov_2.857143_g15764_i0 | PRJNA942359 | 15879 | 248 | 2.857143 | 7.08571464 | Desmochloris halophila | 138176 | Plants | Plants | 459 | 1.13e-124 | NTclustered | gi|371782086|emb|HE610118.1| | 138176 | g15764 | i0 | 100 | 98.625 | 248 | 0 | 100 | 0 | 1 | 248 | 2437 | 2190 | Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 | blastn | 24459 | 459 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 23875437 | 23875437 | PRJNA942359_P_NODE_16119_length_248_cov_0.891429_g16004_i0 | PRJNA942359 | 16119 | 248 | 0.891429 | 2.21074392 | Desmochloris halophila | 138176 | Plants | Plants | 396 | 9e-106 | NTclustered | gi|371782123|emb|HE610155.1| | 138176 | g16004 | i0 | 96.639 | 96.1693548387097 | 238 | 8 | 96 | 0 | 11 | 248 | 2938 | 2701 | Desmochloris halophila plastid 16S rRNA gene (partial), 23S rRNA gene (partial) and ITS1, strain UTEX 2073 | blastn | 23850 | 396 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 23875461 | 23875461 | PRJNA942359_P_NODE_17159_length_247_cov_0.896552_g17044_i0 | PRJNA942359 | 17159 | 247 | 0.896552 | 2.21448344 | Monoraphidium neglectum | 145388 | Plants | Plants | 226 | 1.2399999999999997e-54 | NTclustered | gi|926767437|ref|XM_014037317.1| | 145388 | g17044 | i0 | 83.539 | 47.165991902834 | 243 | 38 | 98 | 2 | 3 | 244 | 106 | 347 | Monoraphidium neglectum 60S ribosomal protein L23A mRNA | blastn | 11650 | 226 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 25149176 | 25149176 | PRJNA942359_P_NODE_16860_length_247_cov_0.896552_g16745_i0 | PRJNA942359 | 16860 | 247 | 0.896552 | 2.21448344 | Monoraphidium neglectum | 145388 | Plants | Plants | 206 | 1.6199999999999998e-48 | NTclustered | gi|926794116|ref|XM_014050078.1| | 145388 | g16745 | i0 | 83.796 | 28.1376518218623 | 216 | 35 | 87 | 0 | 1 | 216 | 216 | 1 | Monoraphidium neglectum 40S ribosomal protein S26 mRNA | blastn | 6950 | 206 | 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);;