contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1057075" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 176592 | 176592 | PRJNA1057075_S_NODE_1901_length_288_cov_150.577406_g1802_i0 | PRJNA1057075 | 1901 | 288 | 150.577406 | 433.66292928 | Desmodesmus abundans | 77547 | Plants | Plants | 357 | 5.04e-94 | NTclustered | gi|2312613210|ref|NC_066651.1| | 77547 | g1802 | i0 | 97.156 | 105.361111111111 | 211 | 6 | 75 | 0 | 1 | 211 | 74023 | 74233 | Desmodesmus abundans strain FBCC-A1277 chloroplast, complete genome | blastn | 30344 | 357 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Desmodesmus | Desmodesmus abundans | |
| 3562015 | 3562015 | PRJNA1057075_S_NODE_683_length_387_cov_31797.115385_g585_i0 | PRJNA1057075 | 683 | 387 | 31797.115385 | 123054.83653995 | Eukaryota | 2759 | Plants | Plants | 621 | 2.2499999999999994e-173 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g585 | i0 | 100 | 86.4651162790698 | 336 | 0 | 87 | 0 | 51 | 386 | 872 | 537 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 33462 | 621 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 6554549 | 6554549 | PRJNA1057075_S_NODE_9846_length_158_cov_2.422018_g9747_i0 | PRJNA1057075 | 9846 | 158 | 2.422018 | 3.82678844 | Dicloster acuatus | 91190 | Plants | Plants | 102 | 1.28e-17 | NTclustered | gi|2724824305|gb|PP746556.1| | 91190 | g9747 | i0 | 79.452 | 2.84810126582278 | 146 | 29 | 92 | 1 | 2 | 147 | 85839 | 85983 | Dicloster acuatus culture SAG:41.98 mitochondrion, complete genome | blastn | 450 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 12490189 | 12490189 | PRJNA1057075_S_NODE_1750_length_296_cov_8.712551_g1651_i0 | PRJNA1057075 | 1750 | 296 | 8.712551 | 25.78915096 | Scenedesmaceae | 3086 | Plants | Plants | 542 | 1.34e-149 | NTclustered | gi|955395807|gb|KR904903.1| | 77547 | g1651 | i0 | 100 | 98.9966216216216 | 293 | 0 | 99 | 0 | 1 | 293 | 367 | 75 | Desmodesmus abundans strain LRB-CO801 18S ribosomal RNA gene, partial sequence | blastn | 29303 | 542 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Desmodesmus | Desmodesmus abundans | |
| 17589091 | 17589091 | PRJNA1057075_S_NODE_274_length_489_cov_17851.543182_g210_i0 | PRJNA1057075 | 274 | 489 | 17851.543182 | 87294.04615998 | Scenedesmaceae | 3086 | Plants | Plants | 483 | 1.43e-131 | NTclustered | gi|2312613210|ref|NC_066651.1| | 77547 | g210 | i0 | 91.944 | 99.6625766871166 | 360 | 5 | 76 | 6 | 77 | 436 | 76727 | 77062 | Desmodesmus abundans strain FBCC-A1277 chloroplast, complete genome | blastn | 48735 | 484 | 0.997933884297521 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Desmodesmus | Desmodesmus abundans | |
| 18028403 | 18028403 | PRJNA1057075_S_NODE_4195_length_219_cov_2.111765_g4096_i0 | PRJNA1057075 | 4195 | 219 | 2.111765 | 4.62476535 | Monoraphidium neglectum | 145388 | Plants | Plants | 99 | 2.45e-16 | NTclustered | gi|926774775|ref|XM_014040408.1| | 145388 | g4096 | i0 | 80.451 | 11 | 133 | 22 | 60 | 4 | 86 | 216 | 539 | 409 | Monoraphidium neglectum 60S ribosomal protein L10 mRNA | blastn | 2409 | 99 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 24402599 | 24402599 | PRJNA1057075_S_NODE_960_length_358_cov_13883.359223_g861_i0 | PRJNA1057075 | 960 | 358 | 13883.359223 | 49702.42601834 | Crucigenia quadrata | 2782530 | Plants | Plants | 473 | 6.11e-129 | NTclustered | gi|2875298507|gb|PQ301446.1| | 2782530 | g861 | i0 | 93.73 | 133.435754189944 | 319 | 15 | 88 | 2 | 43 | 356 | 102919 | 102601 | Crucigenia quadrata strain FACHB-1904 chloroplast, complete genome | blastn | 47770 | 473 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Crucigenia | Crucigenia quadrata |
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);;