contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA577580" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1839459 | 1839459 | PRJNA577580_P_NODE_11022_length_277_cov_1.754902_g10944_i0 | PRJNA577580 | 11022 | 277 | 1.754902 | 4.86107854 | Dicloster acuatus | 91190 | Plants | Plants | 309 | 1.3700000000000003e-79 | NTclustered | gi|2724824305|gb|PP746556.1| | 91190 | g10944 | i0 | 87.591 | 64.2202166064982 | 274 | 24 | 99 | 5 | 3 | 276 | 2142 | 1879 | Dicloster acuatus culture SAG:41.98 mitochondrion, complete genome | blastn | 17789 | 309 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 5667779 | 5667779 | PRJNA577580_P_NODE_6025_length_366_cov_1.539249_g5947_i0 | PRJNA577580 | 6025 | 366 | 1.539249 | 5.63365134 | Polytoma uvella | 40532 | Plants | Plants | 54.7 | 0.01 | NTclustered | gi|1108488083|gb|KX828177.1| | 40532 | g5947 | i0 | 96.875 | 0.262295081967213 | 32 | 1 | 9 | 0 | 53 | 84 | 52182 | 52213 | Polytoma uvella strain UTEX 964 plastid, partial genome | blastn | 96 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytoma | Polytoma uvella | |
| 5667819 | 5667819 | PRJNA577580_P_NODE_9585_length_295_cov_1.675676_g9507_i0 | PRJNA577580 | 9585 | 295 | 1.675676 | 4.9432442 | Dicloster acuatus | 91190 | Plants | Plants | 414 | 3.0299999999999998e-111 | NTclustered | gi|2724824305|gb|PP746556.1| | 91190 | g9507 | i0 | 92.491 | 90.1762711864407 | 293 | 17 | 98 | 4 | 1 | 290 | 1389 | 1679 | Dicloster acuatus culture SAG:41.98 mitochondrion, complete genome | blastn | 26602 | 414 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 9492407 | 9492407 | PRJNA577580_P_NODE_14128_length_250_cov_4.994350_g14050_i0 | PRJNA577580 | 14128 | 250 | 4.99435 | 12.485875 | Chlorella vulgaris | 3077 | Plants | Plants | 385 | 1.97e-102 | NTclustered | gi|77627727|dbj|AB237642.1| | 3077 | g14050 | i0 | 94.444 | 101.816 | 252 | 10 | 100 | 4 | 1 | 250 | 2091 | 1842 | Chlorella vulgaris NIES:227 gene for 28S ribosomal RNA, partial sequence | blastn | 25454 | 385 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 13892175 | 13892175 | PRJNA577580_P_NODE_5971_length_367_cov_2.353741_g5893_i0 | PRJNA577580 | 5971 | 367 | 2.353741 | 8.63822947 | Eukaryota | 2759 | Plants | Plants | 673 | 0 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g5893 | i0 | 99.728 | 99.8773841961853 | 367 | 1 | 100 | 0 | 1 | 367 | 864 | 498 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 36655 | 673 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 14592838 | 14592838 | PRJNA577580_P_NODE_10792_length_280_cov_1.294686_g10714_i0 | PRJNA577580 | 10792 | 280 | 1.294686 | 3.6251208 | Tetraselmis marina | 41888 | Plants | Plants | 128 | 4.17e-25 | NTclustered | gi|2301280732|ref|NC_066039.1| | 41888 | g10714 | i0 | 86.441 | 38.125 | 118 | 15 | 42 | 1 | 109 | 226 | 5509 | 5625 | Tetraselmis marina mitochondrion, complete genome | blastn | 10675 | 128 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Tetraselmis | Tetraselmis marina | |
| 17141698 | 17141698 | PRJNA577580_P_NODE_5334_length_387_cov_1.719745_g5256_i0 | PRJNA577580 | 5334 | 387 | 1.719745 | 6.65541315 | Monoraphidium neglectum | 145388 | Plants | Plants | 143 | 2.13e-29 | NTclustered | gi|926778745|ref|XM_014042393.1| | 145388 | g5256 | i0 | 86.26 | 0.338501291989664 | 131 | 18 | 34 | 0 | 203 | 333 | 267 | 137 | Monoraphidium neglectum 40S ribosomal protein S17-4 mRNA | blastn | 131 | 143 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 18989500 | 18989500 | PRJNA577580_P_NODE_5635_length_377_cov_2.309211_g5557_i0 | PRJNA577580 | 5635 | 377 | 2.309211 | 8.70572547 | Chlorellales | 35460 | Plants | Plants | 172 | 2.64e-38 | NTclustered | gi|404276808|gb|JQ655149.1| | 3077 | g5557 | i0 | 77.627 | 45.9045092838196 | 295 | 58 | 77 | 5 | 1 | 291 | 1845 | 2135 | Chlorella vulgaris heat shock protein 90 mRNA, complete cds | blastn | 17306 | 172 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 19690439 | 19690439 | PRJNA577580_P_NODE_13876_length_252_cov_0.871508_g13798_i0 | PRJNA577580 | 13876 | 252 | 0.871508 | 2.19620016 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 182 | 2.79e-41 | NTclustered | gi|760445552|ref|XM_011401543.1| | 3075 | g13798 | i0 | 80.242 | 5.45634920634921 | 248 | 43 | 97 | 5 | 1 | 245 | 1307 | 1551 | Auxenochlorella protothecoides V-type proton ATPase catalytic subunit A isoform 1 partial mRNA | blastn | 1375 | 182 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 20966194 | 20966194 | PRJNA577580_P_NODE_1577_length_722_cov_2.596302_g1503_i0 | PRJNA577580 | 1577 | 722 | 2.596302 | 18.74530044 | Helicosporidium sp. ex Simulium jonesi | 145475 | Plants | Plants | 444 | 1.0199999999999994e-119 | NTclustered | gi|54399515|gb|AY729488.1| | 145475 | g1503 | i0 | 79.294 | 47.0941828254848 | 652 | 121 | 89 | 13 | 70 | 714 | 1431 | 787 | Helicosporidium sp. ex Simulium jonesii EF-1 alpha-like protein (efl) mRNA, complete cds | blastn | 34002 | 444 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ex Simulium jonesi | |
| 24090024 | 24090024 | PRJNA577580_P_NODE_9019_length_303_cov_1.321739_g8941_i0 | PRJNA577580 | 9019 | 303 | 1.321739 | 4.00486917 | Ulvophyceae | 33103 | Plants | Plants | 320 | 7.01e-83 | NTclustered | gi|969822368|gb|KT950951.1| | 325651 | g8941 | i0 | 89.641 | 84.3630363036304 | 251 | 26 | 83 | 0 | 53 | 303 | 1 | 251 | Bryopsis corticulans actin gene, partial cds | blastn | 25562 | 320 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis corticulans |
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);;