contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA382357" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13157304 | 13157304 | PRJNA382357_P_NODE_27271_length_430_cov_3.585366_g26533_i0 | PRJNA382357 | 27271 | 430 | 3.585366 | 15.4170738 | Gloeotilopsis planctonica | 34157 | Plants | Plants | 169 | 3.11e-47 | NR | AOC61595.1 | 34157 | g26533 | i0 | 95.2 | 0.57906976744186 | 83 | 4 | 57.9 | 0 | 1 | 249 | 423 | 505 | AOC61595.1 CP47 chlorophyll apoprotein of photosystem II [Gloeotilopsis planctonica] | diamond | 249 | 169 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Ulotrichaceae | Gloeotilopsis | Gloeotilopsis planctonica | |
| 27391379 | 27391379 | PRJNA382357_P_NODE_91743_length_251_cov_11.478947_g91004_i0 | PRJNA382357 | 91743 | 251 | 11.478947 | 28.81215697 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 47.8 | 7.12e-4 | NR | KAF6265106.1 | 2650976 | g91004 | i0 | 80.8 | 0.621513944223108 | 26 | 5 | 31.1 | 0 | 2 | 79 | 893 | 918 | KAF6265106.1 WD40 repeat-like protein [Scenedesmus sp. NREL 46B-D3] | diamond | 156 | 47.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 27629320 | 27629320 | PRJNA382357_P_NODE_65724_length_291_cov_1.573913_g64985_i0 | PRJNA382357 | 65724 | 291 | 1.573913 | 4.58008683 | Trebouxia | 13786 | Plants | Plants | 44.7 | 0.0133 | NR | KAA6424970.1 | 2608996 | g64985 | i0 | 29.7 | 1.87628865979381 | 91 | 60 | 93.8 | 1 | 3 | 275 | 1 | 87 | KAA6424970.1 MAG: hypothetical protein FRX49_05144 [Trebouxia sp. A1-2] | diamond | 546 | 44.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 27801715 | 27801715 | PRJNA382357_P_NODE_12904_length_591_cov_7.247170_g12183_i0 | PRJNA382357 | 12904 | 591 | 7.24717 | 42.8307747 | [Myrmecia] bisecta | 41462 | Plants | Plants | 137 | 1.84e-33 | NR | KAK9819964.1 | 41462 | g12183 | i0 | 47 | 1.7005076142132 | 164 | 81 | 83.2 | 1 | 4 | 495 | 3504 | 3661 | KAK9819964.1 hypothetical protein WJX72_004515 [[Myrmecia] bisecta] | diamond | 1005 | 137 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 28639703 | 28639703 | PRJNA382357_P_NODE_76747_length_272_cov_1.232227_g76008_i0 | PRJNA382357 | 76747 | 272 | 1.232227 | 3.35165744 | Chlamydomonas | 3052 | Plants | Plants | 92.8 | 1.02e-19 | NR | XP_042927327.1 | 3055 | g76008 | i0 | 81.5 | 1.19117647058824 | 54 | 10 | 59.6 | 0 | 90 | 251 | 331 | 384 | XP_042927327.1 uncharacterized protein CHLRE_02g099850v5 [Chlamydomonas reinhardtii] | diamond | 324 | 92.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 28654135 | 28654135 | PRJNA382357_P_NODE_28207_length_424_cov_1.432507_g27469_i0 | PRJNA382357 | 28207 | 424 | 1.432507 | 6.07382968 | Trebouxia sp. C | 2796353 | Plants | Plants | 133 | 7.09e-34 | NR | KAL3135728.1 | 3373144 | g27469 | i0 | 71.3 | 0.615566037735849 | 87 | 25 | 61.6 | 0 | 391 | 131 | 1 | 87 | KAL3135728.1 hypothetical protein ABBQ38_006196 [Trebouxia sp. C0009 RCD-2024] | diamond | 261 | 133 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0009 RCD-2024 | |
| 28780207 | 28780207 | PRJNA382357_P_NODE_107947_length_234_cov_1.502890_g107208_i0 | PRJNA382357 | 107947 | 234 | 1.50289 | 3.5167626 | Coelastrella saipanensis | 152631 | Plants | Plants | 43.5 | 0.0186 | NR | YP_009629506.1 | 152631 | g107208 | i0 | 57.4 | 0.602564102564103 | 47 | 13 | 52.6 | 2 | 109 | 231 | 831 | 876 | YP_009629506.1 group II intron reverse transcriptase/maturase [Coelastrella saipanensis] | diamond | 141 | 43.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Coelastrella | Coelastrella saipanensis | |
| 29348843 | 29348843 | PRJNA382357_P_NODE_28269_length_423_cov_4.533149_g27531_i0 | PRJNA382357 | 28269 | 423 | 4.533149 | 19.17522027 | Apatococcus lobatus | 904363 | Plants | Plants | 55.1 | 1.21e-5 | NR | KAK9818577.1 | 904363 | g27531 | i0 | 92.3 | 0.184397163120567 | 26 | 2 | 18.4 | 0 | 423 | 346 | 360 | 385 | KAK9818577.1 hypothetical protein WJX74_001807 [Apatococcus lobatus] | diamond | 78 | 55.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Apatococcus | Apatococcus lobatus | |
| 31117523 | 31117523 | PRJNA382357_P_NODE_73275_length_277_cov_3.722222_g72536_i0 | PRJNA382357 | 73275 | 277 | 3.722222 | 10.31055494 | Chlorella variabilis | 554065 | Plants | Plants | 54.7 | 2.54e-6 | NR | XP_005848062.1 | 554065 | g72536 | i0 | 60.4 | 0.51985559566787 | 48 | 19 | 52 | 0 | 199 | 56 | 170 | 217 | XP_005848062.1 hypothetical protein CHLNCDRAFT_10741, partial [Chlorella variabilis] | diamond | 144 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 31387833 | 31387833 | PRJNA382357_P_NODE_33056_length_394_cov_28.198198_g32317_i0 | PRJNA382357 | 33056 | 394 | 28.198198 | 111.10090012 | Ulva | 3118 | Plants | Plants | 75.1 | 4.17e-13 | NR | AZP40189.1 | 63659 | g32317 | i0 | 60 | 3.22081218274112 | 55 | 22 | 41.9 | 0 | 384 | 220 | 177 | 231 | AZP40189.1 hypothetical protein [Ulva compressa] | diamond | 1269 | 75.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva compressa | |
| 31560636 | 31560636 | PRJNA382357_P_NODE_148376_length_205_cov_0.902778_g147637_i0 | PRJNA382357 | 148376 | 205 | 0.902778 | 1.8506949 | Trebouxia sp. C | 2796353 | Plants | Plants | 42.4 | 0.0281 | NR | KAL3143431.1 | 3373144 | g147637 | i0 | 40.8 | 1.43414634146341 | 49 | 29 | 71.7 | 0 | 186 | 40 | 150 | 198 | KAL3143431.1 hypothetical protein ABBQ38_15531 [Trebouxia sp. C0009 RCD-2024] | diamond | 294 | 42.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0009 RCD-2024 | |
| 31908436 | 31908436 | PRJNA382357_P_NODE_84917_length_260_cov_1.497487_g84178_i0 | PRJNA382357 | 84917 | 260 | 1.497487 | 3.8934662 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 73.9 | 1.55e-13 | NR | KAA6418901.1 | 2608996 | g84178 | i0 | 45.3 | 4.8 | 86 | 45 | 96.9 | 1 | 9 | 260 | 52 | 137 | KAA6418901.1 MAG: hypothetical protein FRX49_11127 [Trebouxia sp. A1-2] | diamond | 1248 | 73.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 32446579 | 32446579 | PRJNA382357_P_NODE_95479_length_247_cov_1.467742_g94740_i0 | PRJNA382357 | 95479 | 247 | 1.467742 | 3.62532274 | Micractinium sp. CCAP 211/92 | 554058 | Plants | Plants | 59.3 | 5.64e-8 | NR | KAL4451223.1 | 554058 | g94740 | i0 | 64.6 | 1.65182186234818 | 48 | 14 | 58.3 | 1 | 247 | 104 | 157 | 201 | KAL4451223.1 hypothetical protein ABPG77_009295 [Micractinium sp. CCAP 211/92] | diamond | 408 | 59.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium sp. CCAP 211/92 |
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);;