contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA734348" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1993354 | 1993354 | PRJNA734348_P_NODE_133382_length_241_cov_0.916667_g132684_i0 | PRJNA734348 | 133382 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | Plants | Plants | 70.9 | 3.9e-12 | NR | GLI67100.1 | 51714 | g132684 | i0 | 52.6 | 6.82157676348548 | 78 | 23 | 97.1 | 2 | 240 | 7 | 210 | 273 | GLI67100.1 hypothetical protein VaNZ11_011305, partial [Volvox africanus] | diamond | 1644 | 70.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 28767892 | 28767892 | PRJNA734348_P_NODE_148107_length_206_cov_4.774436_g147409_i0 | PRJNA734348 | 148107 | 206 | 4.774436 | 9.83533816 | Chlorellaceae | 35461 | Plants | Plants | 48.9 | 1.54e-4 | NR | PRW39098.1 | 3076 | g147409 | i0 | 88 | 2.18446601941748 | 25 | 3 | 36.4 | 0 | 76 | 2 | 619 | 643 | PRW39098.1 glycerol-3-phosphate dehydrogenase mitochondrial-like isoform A [Chlorella sorokiniana] | diamond | 450 | 48.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 28915342 | 28915342 | PRJNA734348_P_NODE_124528_length_243_cov_0.905882_g123830_i0 | PRJNA734348 | 124528 | 243 | 0.905882 | 2.20129326 | [Myrmecia] bisecta | 41462 | Plants | Plants | 66.2 | 1.96e-10 | NR | KAK9815325.1 | 41462 | g123830 | i0 | 46.7 | 0.740740740740741 | 60 | 32 | 74.1 | 0 | 242 | 63 | 1123 | 1182 | KAK9815325.1 hypothetical protein WJX72_001813 [[Myrmecia] bisecta] | diamond | 180 | 66.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 29736317 | 29736317 | PRJNA734348_P_NODE_116190_length_245_cov_0.895349_g115492_i0 | PRJNA734348 | 116190 | 245 | 0.895349 | 2.19360505 | [Myrmecia] bisecta | 41462 | Plants | Plants | 57.8 | 1.84e-7 | NR | KAK9814278.1 | 41462 | g115492 | i0 | 45.5 | 0.673469387755102 | 55 | 28 | 66.1 | 2 | 164 | 3 | 125 | 178 | KAK9814278.1 hypothetical protein WJX72_003319 [[Myrmecia] bisecta] | diamond | 165 | 57.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 31632559 | 31632559 | PRJNA734348_P_NODE_105236_length_248_cov_0.880000_g104538_i0 | PRJNA734348 | 105236 | 248 | 0.88 | 2.1824 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 62 | 3.34e-9 | NR | KAG1656550.1 | 1653778 | g104538 | i0 | 45.8 | 0.713709677419355 | 59 | 32 | 71.4 | 0 | 181 | 5 | 84 | 142 | KAG1656550.1 hypothetical protein FOA52_011502 [Chlamydomonas sp. UWO 241] | diamond | 177 | 62 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 | |
| 31948863 | 31948863 | PRJNA734348_P_NODE_125777_length_243_cov_0.905882_g125079_i0 | PRJNA734348 | 125777 | 243 | 0.905882 | 2.20129326 | Prototheca wickerhamii | 3111 | Plants | Plants | 138 | 2.56e-36 | NR | KAK2079342.1 | 3111 | g125079 | i0 | 98.4 | 0.765432098765432 | 62 | 1 | 76.5 | 0 | 242 | 57 | 78 | 139 | KAK2079342.1 hypothetical protein QBZ16_003033 [Prototheca wickerhamii] | diamond | 186 | 138 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 32244328 | 32244328 | PRJNA734348_P_NODE_83098_length_258_cov_1.389189_g82400_i0 | PRJNA734348 | 83098 | 258 | 1.389189 | 3.58410762 | Trebouxiaceae | 2507902 | Plants | Plants | 59.7 | 3.24e-8 | NR | KAK9806435.1 | 706552 | g82400 | i0 | 69.2 | 2.26744186046512 | 39 | 12 | 45.3 | 0 | 83 | 199 | 178 | 216 | KAK9806435.1 hypothetical protein WJX73_007252 [Symbiochloris irregularis] | diamond | 585 | 59.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis |
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);;