contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA287283" and tax_kingdom = "Viridiplantae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26757496 | 26757496 | PRJNA287283_P_NODE_7861_length_191_cov_1.623188_g7637_i0 | PRJNA287283 | 7861 | 191 | 1.623188 | 3.10028908 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 50.1 | 4.8e-5 | NR | KAK3260788.1 | 36881 | g7637 | i0 | 75.9 | 0.910994764397906 | 29 | 7 | 45.5 | 0 | 190 | 104 | 396 | 424 | KAK3260788.1 hypothetical protein CYMTET_30267 [Cymbomonas tetramitiformis] | diamond | 174 | 50.1 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 28148151 | 28148151 | PRJNA287283_P_NODE_8925_length_181_cov_0.875000_g8701_i0 | PRJNA287283 | 8925 | 181 | 0.875 | 1.58375 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 48.1 | 2.04e-4 | NR | GMH39996.1 | 3041901 | g8701 | i0 | 55 | 0.662983425414365 | 40 | 18 | 66.3 | 0 | 124 | 5 | 4 | 43 | GMH39996.1 hypothetical protein BSKO_07900 [Bryopsis sp. KO-2023] | diamond | 120 | 48.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 28305852 | 28305852 | PRJNA287283_P_NODE_6086_length_234_cov_1.187845_g5862_i0 | PRJNA287283 | 6086 | 234 | 1.187845 | 2.7795573 | Rhododendron williamsianum | 262921 | Plants | Plants | 43.5 | 0.011 | NR | KAE9449397.1 | 262921 | g5862 | i0 | 36.4 | 2.43589743589744 | 66 | 38 | 84.6 | 3 | 32 | 229 | 83 | 144 | KAE9449397.1 hypothetical protein C3L33_18702, partial [Rhododendron williamsianum] | diamond | 570 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Rhododendron | Rhododendron williamsianum | |
| 28368932 | 28368932 | PRJNA287283_P_NODE_4306_length_301_cov_2.592742_g4082_i0 | PRJNA287283 | 4306 | 301 | 2.592742 | 7.80415342 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 58.5 | 1.94e-7 | NR | GAX78925.1 | 1157962 | g4082 | i0 | 49.1 | 0.568106312292359 | 57 | 26 | 53.8 | 1 | 138 | 299 | 170 | 226 | GAX78925.1 hypothetical protein CEUSTIGMA_g6364.t1 [Chlamydomonas eustigma] | diamond | 171 | 58.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 28734045 | 28734045 | PRJNA287283_P_NODE_8747_length_182_cov_0.868217_g8523_i0 | PRJNA287283 | 8747 | 182 | 0.868217 | 1.58015494 | Streptophyta | 35493 | Plants | Plants | 99.4 | 1.46e-22 | NR | XP_024402545.1 | 3218 | g8523 | i0 | 78 | 15.5604395604396 | 59 | 13 | 97.3 | 0 | 181 | 5 | 362 | 420 | XP_024402545.1 fructose-bisphosphate aldolase 1, chloroplastic-like [Physcomitrium patens] | diamond | 2832 | 100 | 0.994 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Funariales | Funariaceae | Physcomitrium | Physcomitrium patens | |
| 29758167 | 29758167 | PRJNA287283_P_NODE_1491_length_577_cov_1.444656_g1275_i0 | PRJNA287283 | 1491 | 577 | 1.444656 | 8.33566512 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 63.2 | 6.76e-8 | NR | GAX78925.1 | 1157962 | g1275 | i0 | 27.7 | 0.805892547660312 | 155 | 92 | 75.4 | 5 | 575 | 141 | 306 | 450 | GAX78925.1 hypothetical protein CEUSTIGMA_g6364.t1 [Chlamydomonas eustigma] | diamond | 465 | 63.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 29979368 | 29979368 | PRJNA287283_P_NODE_5971_length_237_cov_1.092391_g5747_i0 | PRJNA287283 | 5971 | 237 | 1.092391 | 2.58896667 | Melia azedarach | 155640 | Plants | Plants | 43.5 | 0.0176 | NR | KAJ4713975.1 | 155640 | g5747 | i0 | 32.2 | 1.10126582278481 | 87 | 47 | 98.7 | 3 | 236 | 3 | 165 | 248 | KAJ4713975.1 F-box protein [Melia azedarach] | diamond | 261 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Meliaceae | Melia | Melia azedarach | |
| 30105631 | 30105631 | PRJNA287283_P_NODE_1492_length_577_cov_1.179389_g1276_i0 | PRJNA287283 | 1492 | 577 | 1.179389 | 6.80507453 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 68.2 | 1.28e-9 | NR | GAX78925.1 | 1157962 | g1276 | i0 | 28.8 | 0.811091854419411 | 156 | 89 | 75.4 | 6 | 3 | 437 | 306 | 450 | GAX78925.1 hypothetical protein CEUSTIGMA_g6364.t1 [Chlamydomonas eustigma] | diamond | 468 | 68.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 30579426 | 30579426 | PRJNA287283_P_NODE_10193_length_176_cov_0.910569_g9969_i0 | PRJNA287283 | 10193 | 176 | 0.910569 | 1.60260144 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 70.5 | 2.48e-12 | NR | BDA40807.1 | 2315456 | g9969 | i0 | 64.8 | 0.920454545454545 | 54 | 19 | 92 | 0 | 14 | 175 | 413 | 466 | BDA40807.1 Vitamin B12 transport ATP-binding protein BacA [Coccomyxa sp. Obi] | diamond | 162 | 70.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 31482578 | 31482578 | PRJNA287283_P_NODE_6716_length_216_cov_1.018405_g6492_i0 | PRJNA287283 | 6716 | 216 | 1.018405 | 2.1997548 | Closterium | 34145 | Plants | Plants | 50.1 | 5.81e-5 | NR | CAI5488445.1 | 2996811 | g6492 | i0 | 51.2 | 2.38888888888889 | 43 | 21 | 59.7 | 0 | 86 | 214 | 83 | 125 | CAI5488445.1 unnamed protein product [Closterium sp. Naga37s-1] | diamond | 516 | 50.4 | 0.994047619047619 | Eukaryota | Viridiplantae | Streptophyta | Zygnematophyceae | Desmidiales | Closteriaceae | Closterium | Closterium sp. Naga37s-1 | ||
| 31861692 | 31861692 | PRJNA287283_P_NODE_8777_length_182_cov_0.868217_g8553_i0 | PRJNA287283 | 8777 | 182 | 0.868217 | 1.58015494 | Eukaryota | 2759 | Plants | Plants | 48.9 | 5.01e-5 | NR | XP_058729145.1 | 3911 | g8553 | i0 | 39 | 1.94505494505495 | 59 | 35 | 97.3 | 1 | 182 | 6 | 16 | 73 | XP_058729145.1 SKP1-like protein 1A isoform X1 [Vicia villosa] | diamond | 354 | 49.3 | 0.991886409736308 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vicia | Vicia villosa | |
| 32020063 | 32020063 | PRJNA287283_P_NODE_3838_length_324_cov_1.214022_g3614_i0 | PRJNA287283 | 3838 | 324 | 1.214022 | 3.93343128 | Eukaryota | 2759 | Plants | Plants | 123 | 2.69e-30 | NR | KAJ8622128.1 | 3435 | g3614 | i0 | 58 | 26.7037037037037 | 100 | 42 | 92.6 | 0 | 19 | 318 | 65 | 164 | KAJ8622128.1 hypothetical protein MRB53_030657 [Persea americana] | diamond | 8652 | 124 | 0.991935483870968 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Laurales | Lauraceae | Persea | Persea americana | |
| 32603407 | 32603407 | PRJNA287283_P_NODE_2640_length_402_cov_1.796562_g2416_i0 | PRJNA287283 | 2640 | 402 | 1.796562 | 7.22217924 | Lactuca saligna | 75948 | Plants | Plants | 45.4 | 0.0231 | NR | CAI9278555.1 | 75948 | g2416 | i0 | 33.7 | 0.686567164179104 | 92 | 60 | 68.7 | 1 | 55 | 330 | 92 | 182 | CAI9278555.1 unnamed protein product [Lactuca saligna] | diamond | 276 | 45.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Lactuca | Lactuca saligna |
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);;