contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA562549" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3096766 | 3096766 | PRJNA562549_P_NODE_36523_length_202_cov_0.921986_g36290_i0 | PRJNA562549 | 36523 | 202 | 0.921986 | 1.86241172 | Eukaryota | 2759 | Plants | Plants | 120 | 9.55e-30 | NR | RMZ54688.1 | 3075 | g36290 | i0 | 74.6 | 5.97029702970297 | 67 | 17 | 99.5 | 0 | 2 | 202 | 447 | 513 | RMZ54688.1 hypothetical protein APUTEX25_003066 [Auxenochlorella protothecoides] | diamond | 1206 | 120 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 6923677 | 6923677 | PRJNA562549_P_NODE_13126_length_317_cov_1.015625_g12893_i0 | PRJNA562549 | 13126 | 317 | 1.015625 | 3.21953125 | Eukaryota | 2759 | Plants | Plants | 172 | 2.4799999999999994e-48 | NR | KAK2079209.1 | 3111 | g12893 | i0 | 87.2 | 16.8264984227129 | 94 | 12 | 89 | 0 | 1 | 282 | 240 | 333 | KAK2079209.1 Succinate dehydrogenase [ubiquinone] flavoprotein subunit 1, mitochondrial [Prototheca wickerhamii] | diamond | 5334 | 172 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 27995254 | 27995254 | PRJNA562549_P_NODE_9985_length_364_cov_1.795380_g9752_i0 | PRJNA562549 | 9985 | 364 | 1.79538 | 6.5351832 | Haematococcus lacustris | 44745 | Plants | Plants | 99.4 | 4.24e-22 | NR | KAJ9532284.1 | 44745 | g9752 | i0 | 54.1 | 5.95879120879121 | 98 | 45 | 80.8 | 0 | 362 | 69 | 239 | 336 | KAJ9532284.1 hypothetical protein QJQ45_010414 [Haematococcus lacustris] | diamond | 2169 | 99.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 28942599 | 28942599 | PRJNA562549_P_NODE_27048_length_226_cov_2.636364_g26815_i0 | PRJNA562549 | 27048 | 226 | 2.636364 | 5.95818264 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 68.9 | 6.45e-12 | NR | KAL4522098.1 | 1650286 | g26815 | i0 | 45.3 | 0.995575221238938 | 75 | 39 | 98.2 | 2 | 226 | 5 | 4 | 77 | KAL4522098.1 hypothetical protein Ndes2437B_g07849 [Chlorella desiccata (nom. nud.)] | diamond | 225 | 68.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 30029946 | 30029946 | PRJNA562549_P_NODE_23971_length_239_cov_2.247191_g23738_i0 | PRJNA562549 | 23971 | 239 | 2.247191 | 5.37078649 | Eukaryota | 2759 | Plants | Plants | 99 | 3.94e-24 | NR | KAK2077587.1 | 3111 | g23738 | i0 | 56 | 3.76569037656904 | 75 | 33 | 94.1 | 0 | 7 | 231 | 6 | 80 | KAK2077587.1 60S ribosomal protein L21A [Prototheca wickerhamii] | diamond | 900 | 99.4 | 0.995975855130785 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 30363901 | 30363901 | PRJNA562549_P_NODE_13632_length_311_cov_3.224000_g13399_i0 | PRJNA562549 | 13632 | 311 | 3.224 | 10.02664 | Volvox africanus | 51714 | Plants | Plants | 99 | 7.059999999999999e-23 | NR | GLI69515.1 | 51714 | g13399 | i0 | 51.8 | 1.60128617363344 | 83 | 40 | 80.1 | 0 | 56 | 304 | 47 | 129 | GLI69515.1 hypothetical protein VaNZ11_014151 [Volvox africanus] | diamond | 498 | 99 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 30616165 | 30616165 | PRJNA562549_P_NODE_27373_length_225_cov_1.987805_g27140_i0 | PRJNA562549 | 27373 | 225 | 1.987805 | 4.47256125 | Polytomella sp. Pringsheim 198.8 | 37502 | Plants | Plants | 124 | 5.72e-35 | NR | CBV76072.1 | 37502 | g27140 | i0 | 76 | 13 | 75 | 18 | 100 | 0 | 225 | 1 | 7 | 81 | CBV76072.1 60S ribosomal protein L37 [Polytomella sp. Pringsheim 198.80] | diamond | 2925 | 124 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 30900738 | 30900738 | PRJNA562549_P_NODE_19474_length_263_cov_1.990099_g19241_i0 | PRJNA562549 | 19474 | 263 | 1.990099 | 5.23396037 | Micractinium tetrahymenae | 2728915 | Plants | Plants | 99 | 3.46e-24 | NR | KAL4428010.1 | 2728915 | g19241 | i0 | 58.1 | 0.980988593155893 | 86 | 36 | 98.1 | 0 | 258 | 1 | 32 | 117 | KAL4428010.1 hypothetical protein ABPG75_002099 [Micractinium tetrahymenae] | diamond | 258 | 99 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium tetrahymenae | |
| 31452044 | 31452044 | PRJNA562549_P_NODE_13656_length_311_cov_2.080000_g13423_i0 | PRJNA562549 | 13656 | 311 | 2.08 | 6.4688 | Chlorophyta | 3041 | Plants | Plants | 99 | 1.99e-23 | NR | WIA10393.1 | 3088 | g13423 | i0 | 58.9 | 3.66559485530547 | 95 | 38 | 91.6 | 1 | 286 | 2 | 1 | 94 | WIA10393.1 hypothetical protein OEZ85_010585 [Tetradesmus obliquus] | diamond | 1140 | 100 | 0.99 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 31659225 | 31659225 | PRJNA562549_P_NODE_29477_length_217_cov_2.076923_g29244_i0 | PRJNA562549 | 29477 | 217 | 2.076923 | 4.50692291 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 68.9 | 1.43e-11 | NR | XP_011401591.1 | 3075 | g29244 | i0 | 43.7 | 1.963133640553 | 71 | 39 | 98.2 | 1 | 216 | 4 | 256 | 325 | XP_011401591.1 Peroxiredoxin-2 [Auxenochlorella protothecoides] | diamond | 426 | 68.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 32211178 | 32211178 | PRJNA562549_P_NODE_26178_length_230_cov_0.988166_g25945_i0 | PRJNA562549 | 26178 | 230 | 0.988166 | 2.2727818 | Chlamydomonadales | 3042 | Plants | Plants | 112 | 1.39e-28 | NR | KAF5829881.1 | 3046 | g25945 | i0 | 74.3 | 27.1695652173913 | 74 | 19 | 96.5 | 0 | 8 | 229 | 1 | 74 | KAF5829881.1 40S ribosomal protein S3 [Dunaliella salina] | diamond | 6249 | 113 | 0.991150442477876 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 32306346 | 32306346 | PRJNA562549_P_NODE_19499_length_263_cov_1.737624_g19266_i0 | PRJNA562549 | 19499 | 263 | 1.737624 | 4.56995112 | root | 1 | Root_unresolved | Root_unresolved | 90.5 | 7.02e-19 | NR | KAG2489876.1 | 47281 | g19266 | i0 | 54 | 2.97718631178707 | 87 | 39 | 99.2 | 1 | 3 | 263 | 244 | 329 | KAG2489876.1 hypothetical protein HYH03_011678 [Edaphochlamys debaryana] | diamond | 783 | 91.3 | 0.991237677984666 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 32369533 | 32369533 | PRJNA562549_P_NODE_32079_length_210_cov_0.872483_g31846_i0 | PRJNA562549 | 32079 | 210 | 0.872483 | 1.8322143 | root | 1 | Root_unresolved | Root_unresolved | 69.3 | 1.02e-11 | NR | WPT11189.1 | 1470871 | g31846 | i0 | 50.7 | 5.58571428571429 | 69 | 32 | 98.6 | 1 | 3 | 209 | 130 | 196 | WPT11189.1 hypothetical protein PSENEW3n2_00000629 [Picochlorum sp. SENEW3] | diamond | 1173 | 69.7 | 0.994261119081779 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Picochlorum | Picochlorum sp. SENEW3 | |||
| 32608374 | 32608374 | PRJNA562549_P_NODE_32420_length_209_cov_1.648649_g32187_i0 | PRJNA562549 | 32420 | 209 | 1.648649 | 3.44567641 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 45.1 | 0.00365 | NR | GAX78013.1 | 1157962 | g32187 | i0 | 37.1 | 0.889952153110048 | 62 | 30 | 83.3 | 2 | 176 | 3 | 307 | 363 | GAX78013.1 hypothetical protein CEUSTIGMA_g5455.t1 [Chlamydomonas eustigma] | diamond | 186 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 32891573 | 32891573 | PRJNA562549_P_NODE_15040_length_297_cov_1.101695_g14807_i0 | PRJNA562549 | 15040 | 297 | 1.101695 | 3.27203415 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 48.5 | 6.71e-4 | NR | BDA51182.1 | 2315456 | g14807 | i0 | 36.2 | 1.8989898989899 | 94 | 56 | 90.9 | 3 | 287 | 18 | 591 | 684 | BDA51182.1 Xanthine dehydrogenase [Coccomyxa sp. Obi] | diamond | 564 | 48.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi |
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);;