contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJEB6584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25523772 | 25523772 | PRJEB6584f_S_NODE_1769_length_214_cov_2.206704_g1763_i0 | PRJEB6584 | 1769 | 214 | 2.206704 | 4.72234656 | Chlorellaceae | 35461 | Plants | Plants | 103 | 4.11e-25 | NR | KAK9818650.1 | 904363 | g1763 | i0 | 68.3 | 14.8317757009346 | 63 | 20 | 88.3 | 0 | 1 | 189 | 180 | 242 | KAK9818650.1 hypothetical protein WJX74_008699 [Apatococcus lobatus] | diamond | 3174 | 103 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Apatococcus | Apatococcus lobatus | |
| 25616264 | 25616264 | PRJEB6584o_S_NODE_8105_length_301_cov_176.308271_g7997_i0 | PRJEB6584 | 8105 | 301 | 176.308271 | 530.68789571 | Chlamydomonadales | 3042 | Plants | Plants | 69.3 | 2.63e-12 | NR | GFR51299.1 | 47775 | g7997 | i0 | 55.6 | 2.9202657807309 | 63 | 25 | 59.8 | 1 | 294 | 115 | 45 | 107 | GFR51299.1 hypothetical protein Agub_g13661 [Astrephomene gubernaculifera] | diamond | 879 | 69.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera | |
| 26068835 | 26068835 | PRJEB6584o_S_NODE_18837_length_207_cov_4.901163_g18729_i0 | PRJEB6584 | 18837 | 207 | 4.901163 | 10.14540741 | Eukaryota | 2759 | Plants | Plants | 101 | 1.19e-25 | NR | PRW57710.1 | 3076 | g18729 | i0 | 65.2 | 2.98550724637681 | 69 | 24 | 100 | 0 | 207 | 1 | 58 | 126 | PRW57710.1 translation factor SUI1-like protein 2 [Chlorella sorokiniana] | diamond | 618 | 101 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 26432042 | 26432042 | PRJEB6584f_S_NODE_871_length_260_cov_3.137778_g865_i0 | PRJEB6584 | 871 | 260 | 3.137778 | 8.1582228 | Helicosporidium sp. ATCC 5 | 1907511 | Plants | Plants | 122 | 3.2100000000000004e-33 | NR | KDD76983.1 | 1291522 | g865 | i0 | 74.1 | 0.934615384615385 | 81 | 21 | 93.5 | 0 | 258 | 16 | 86 | 166 | KDD76983.1 hypothetical protein H632_c48p1 [Helicosporidium sp. ATCC 50920] | diamond | 243 | 122 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ATCC 50920 | |
| 32929507 | 32929507 | PRJEB6584o_S_NODE_2985_length_422_cov_8.925065_g2878_i0 | PRJEB6584 | 2985 | 422 | 8.925065 | 37.6637743 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 55.5 | 2.5e-7 | NR | KAA6429663.1 | 2608996 | g2878 | i0 | 56.1 | 0.40521327014218 | 57 | 25 | 40.5 | 0 | 201 | 371 | 1 | 57 | KAA6429663.1 MAG: hypothetical protein FRX49_00097 [Trebouxia sp. A1-2] | diamond | 171 | 55.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 32963623 | 32963623 | PRJEB6584o_S_NODE_13762_length_237_cov_20.391089_g13654_i0 | PRJEB6584 | 13762 | 237 | 20.391089 | 48.32688093 | Dunaliella salina | 3046 | Plants | Plants | 65.5 | 1.02e-11 | NR | KAF5829190.1 | 3046 | g13654 | i0 | 60 | 3.0506329113924 | 50 | 20 | 63.3 | 0 | 223 | 74 | 49 | 98 | KAF5829190.1 component of cytosolic 80S ribosome and 40S small subunit [Dunaliella salina] | diamond | 723 | 65.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 32997606 | 32997606 | PRJEB6584o_S_NODE_13131_length_243_cov_2.225962_g13023_i0 | PRJEB6584 | 13131 | 243 | 2.225962 | 5.40908766 | Leontynka pallida | 2912034 | Plants | Plants | 47 | 3.52e-4 | NR | YP_010388691.1 | 2912034 | g13023 | i0 | 41.4 | 1.27160493827161 | 58 | 34 | 71.6 | 0 | 53 | 226 | 31 | 88 | YP_010388691.1 ribosomal protein S11 [Leontynka pallida] | diamond | 309 | 47 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Leontynka | Leontynka pallida | ||
| 32998064 | 32998064 | PRJEB6584o_S_NODE_8395_length_297_cov_2.629771_g8287_i0 | PRJEB6584 | 8395 | 297 | 2.629771 | 7.81041987 | Micractinium conductrix | 554055 | Plants | Plants | 45.8 | 0.00344 | NR | PSC76047.1 | 554055 | g8287 | i0 | 33.3 | 1.41414141414141 | 81 | 53 | 80.8 | 1 | 1 | 240 | 101 | 181 | PSC76047.1 ATP synthase subunit mitochondrial [Micractinium conductrix] | diamond | 420 | 45.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 33014713 | 33014713 | PRJEB6584o_S_NODE_16268_length_220_cov_3.475676_g16160_i0 | PRJEB6584 | 16268 | 220 | 3.475676 | 7.6464872 | Volvox reticuliferus | 1737510 | Plants | Plants | 53.1 | 8.24e-7 | NR | GIL81802.1 | 1737510 | g16160 | i0 | 47.8 | 1.21363636363636 | 46 | 24 | 62.7 | 0 | 4 | 141 | 69 | 114 | GIL81802.1 hypothetical protein Vretifemale_10800 [Volvox reticuliferus] | diamond | 267 | 53.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox reticuliferus | |
| 33082720 | 33082720 | PRJEB6584d_S_NODE_7262_length_222_cov_2.149733_g7194_i0 | PRJEB6584 | 7262 | 222 | 2.149733 | 4.77240726 | Helicosporidium sp. ATCC 5 | 1907511 | Plants | Plants | 40.8 | 0.0443 | NR | KDD77150.1 | 1291522 | g7194 | i0 | 75 | 0.324324324324324 | 24 | 6 | 32.4 | 0 | 220 | 149 | 85 | 108 | KDD77150.1 ribosomal protein L35Ae [Helicosporidium sp. ATCC 50920] | diamond | 72 | 40.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ATCC 50920 | |
| 33116806 | 33116806 | PRJEB6584e_S_NODE_1927_length_205_cov_5.294118_g1912_i0 | PRJEB6584 | 1927 | 205 | 5.294118 | 10.8529419 | Boodleopsis sp. H. | 2320802 | Plants | Plants | 43.1 | 0.00835 | NR | YP_009518971.1 | 2320802 | g1912 | i0 | 44.4 | 3.71707317073171 | 45 | 25 | 65.9 | 0 | 38 | 172 | 29 | 73 | YP_009518971.1 ribosomal protein S11 [Boodleopsis sp. H.0758] | diamond | 762 | 43.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Halimedaceae | Boodleopsis | Boodleopsis sp. H.0758 | |
| 33128000 | 33128000 | PRJEB6584o_S_NODE_4551_length_371_cov_8.366071_g4443_i0 | PRJEB6584 | 4551 | 371 | 8.366071 | 31.03812341 | Chlorophyceae | 3166 | Plants | Plants | 90.1 | 3.92e-18 | NR | GBF96991.1 | 307507 | g4443 | i0 | 73.7 | 2.30458221024259 | 57 | 15 | 46.1 | 0 | 371 | 201 | 457 | 513 | GBF96991.1 ATP synthase beta mitochondrial precursor [Raphidocelis subcapitata] | diamond | 855 | 90.5 | 0.995580110497237 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata |
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);;