contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA669701" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21038375 | 21038375 | PRJNA669701_P_NODE_49077_length_342_cov_3.420074_g48682_i0 | PRJNA669701 | 49077 | 342 | 3.420074 | 11.69665308 | Trebouxia sp. C | 2796353 | Plants | Plants | 73.9 | 2.52e-14 | NR | KAL0042167.1 | 2905653 | g48682 | i0 | 55.7 | 1.10526315789474 | 61 | 26 | 52.6 | 1 | 4 | 183 | 5 | 65 | KAL0042167.1 hypothetical protein WJX77_005300 [Trebouxia sp. C0004] | diamond | 378 | 73.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 | |
| 27536103 | 27536103 | PRJNA669701_P_NODE_92763_length_267_cov_1.242268_g92368_i0 | PRJNA669701 | 92763 | 267 | 1.242268 | 3.31685556 | Eukaryota | 2759 | Plants | Plants | 132 | 7.229999999999999e-35 | NR | GFH26214.1 | 44745 | g92368 | i0 | 69 | 21.4719101123596 | 87 | 27 | 97.8 | 0 | 262 | 2 | 178 | 264 | GFH26214.1 ribosomal protein L3, partial [Haematococcus lacustris] | diamond | 5733 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 27808414 | 27808414 | PRJNA669701_P_NODE_49444_length_341_cov_3.988806_g49049_i0 | PRJNA669701 | 49444 | 341 | 3.988806 | 13.60182846 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 153 | 1.5e-44 | NR | GAX77325.1 | 1157962 | g49049 | i0 | 70.8 | 0.932551319648094 | 106 | 31 | 93.3 | 0 | 5 | 322 | 99 | 204 | GAX77325.1 hypothetical protein CEUSTIGMA_g4771.t1 [Chlamydomonas eustigma] | diamond | 318 | 153 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 27946484 | 27946484 | PRJNA669701_P_NODE_17925_length_556_cov_2.614907_g17533_i0 | PRJNA669701 | 17925 | 556 | 2.614907 | 14.53888292 | Viridiplantae | 33090 | Plants | Plants | 87 | 3.87e-16 | NR | XP_042918674.1 | 3055 | g17533 | i0 | 45.1 | 0.901079136690647 | 82 | 45 | 44.2 | 0 | 232 | 477 | 803 | 884 | XP_042918674.1 uncharacterized protein CHLRE_12g532050v5 [Chlamydomonas reinhardtii] | diamond | 501 | 87 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 28281572 | 28281572 | PRJNA669701_P_NODE_76166_length_286_cov_8.901408_g75771_i0 | PRJNA669701 | 76166 | 286 | 8.901408 | 25.45802688 | Chlorella sorokiniana | 3076 | Plants | Plants | 78.6 | 1.32e-14 | NR | PRW56556.1 | 3076 | g75771 | i0 | 68.3 | 2.65384615384615 | 63 | 19 | 65 | 1 | 249 | 64 | 1 | 63 | PRW56556.1 Phosphoenolpyruvate phosphate translocator chloroplastic [Chlorella sorokiniana] | diamond | 759 | 78.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 29102827 | 29102827 | PRJNA669701_P_NODE_27608_length_447_cov_1.636364_g27213_i0 | PRJNA669701 | 27608 | 447 | 1.636364 | 7.31454708 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 139 | 5.469999999999999e-38 | NR | GAX84228.1 | 1157962 | g27213 | i0 | 42.8 | 3.75167785234899 | 145 | 82 | 97.3 | 1 | 12 | 446 | 80 | 223 | GAX84228.1 hypothetical protein CEUSTIGMA_g11651.t1 [Chlamydomonas eustigma] | diamond | 1677 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 29166081 | 29166081 | PRJNA669701_P_NODE_88829_length_271_cov_2.277778_g88434_i0 | PRJNA669701 | 88829 | 271 | 2.277778 | 6.17277838 | Picochlorum sp. BPE23 | 2696299 | Plants | Plants | 122 | 5.600000000000001e-30 | NR | KAI8106192.1 | 2696299 | g88434 | i0 | 88.1 | 0.74169741697417 | 67 | 7 | 74.2 | 1 | 1 | 201 | 555 | 620 | KAI8106192.1 hypothetical protein M9435_000739 [Picochlorum sp. BPE23] | diamond | 201 | 122 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Picochlorum | Picochlorum sp. BPE23 | |||
| 29387013 | 29387013 | PRJNA669701_P_NODE_148789_length_213_cov_6.592857_g148394_i0 | PRJNA669701 | 148789 | 213 | 6.592857 | 14.04278541 | Ostreobium quekettii | 121088 | Plants | Plants | 64.7 | 5.43e-11 | NR | CAD7701882.1 | 121088 | g148394 | i0 | 45.7 | 0.985915492957746 | 70 | 38 | 98.6 | 0 | 211 | 2 | 8 | 77 | CAD7701882.1 unnamed protein product [Ostreobium quekettii] | diamond | 210 | 64.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 30587002 | 30587002 | PRJNA669701_P_NODE_51613_length_335_cov_3.282443_g51218_i0 | PRJNA669701 | 51613 | 335 | 3.2824430000000002 | 10.99618405 | Helicosporidium sp. ATCC 5 | 1907511 | Plants | Plants | 53.9 | 1.2e-5 | NR | KDD75681.1 | 1291522 | g51218 | i0 | 42.9 | 0.564179104477612 | 63 | 36 | 56.4 | 0 | 321 | 133 | 18 | 80 | KDD75681.1 hypothetical protein H632_c552p0, partial [Helicosporidium sp. ATCC 50920] | diamond | 189 | 53.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ATCC 50920 | |
| 31357734 | 31357734 | PRJNA669701_P_NODE_87856_length_272_cov_4.693467_g87461_i0 | PRJNA669701 | 87856 | 272 | 4.693467 | 12.76623024 | Eukaryota | 2759 | Plants | Plants | 80.1 | 3.02e-17 | NR | KAI3429298.1 | 3077 | g87461 | i0 | 73.9 | 3.55147058823529 | 46 | 12 | 50.7 | 0 | 271 | 134 | 56 | 101 | KAI3429298.1 hypothetical protein D9Q98_005394 [Chlorella vulgaris] | diamond | 966 | 80.5 | 0.995031055900621 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 31990176 | 31990176 | PRJNA669701_P_NODE_92678_length_267_cov_1.391753_g92283_i0 | PRJNA669701 | 92678 | 267 | 1.391753 | 3.71598051 | Eukaryota | 2759 | Plants | Plants | 103 | 2.15e-25 | NR | PNH00711.1 | 47790 | g92283 | i0 | 66.3 | 86.9213483146067 | 83 | 26 | 93.3 | 1 | 267 | 19 | 98 | 178 | PNH00711.1 26S proteasome non-ATPase regulatory subunit 14, partial [Tetrabaena socialis] | diamond | 23208 | 104 | 0.990384615384615 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Tetrabaenaceae | Tetrabaena | Tetrabaena socialis | |
| 32136516 | 32136516 | PRJNA669701_P_NODE_113158_length_249_cov_3.318182_g112763_i0 | PRJNA669701 | 113158 | 249 | 3.318182 | 8.26227318 | Astrephomene gubernaculifera | 47775 | Plants | Plants | 61.2 | 1.22e-8 | NR | GFR42849.1 | 47775 | g112763 | i0 | 39.1 | 2.46987951807229 | 69 | 42 | 83.1 | 0 | 207 | 1 | 373 | 441 | GFR42849.1 hypothetical protein Agub_g3807 [Astrephomene gubernaculifera] | diamond | 615 | 61.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera |
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);;