contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA533114" and tax_phylum = "Placozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 504936 | 504936 | PRJNA533114_P_NODE_26901_length_439_cov_2.177596_g26649_i0 | PRJNA533114 | 26901 | 439 | 2.177596 | 9.55964644 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 178 | 8.54e-53 | NR | XP_002109553.1 | 10228 | g26649 | i0 | 60.7 | 5.94533029612756 | 145 | 52 | 99.1 | 1 | 2 | 436 | 13 | 152 | XP_002109553.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 2610 | 179 | 0.994413407821229 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 505549 | 505549 | PRJNA533114_P_NODE_74201_length_280_cov_1.526570_g73949_i0 | PRJNA533114 | 74201 | 280 | 1.52657 | 4.274396 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 102 | 7.229999999999999e-23 | NR | XP_002115261.1 | 10228 | g73949 | i0 | 59.8 | 2.87142857142857 | 87 | 32 | 90 | 2 | 262 | 11 | 77 | 163 | XP_002115261.1 uncharacterized protein TRIADDRAFT_59261 [Trichoplax adhaerens] | diamond | 804 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 5608344 | 5608344 | PRJNA533114_P_NODE_121245_length_241_cov_0.916667_g120993_i0 | PRJNA533114 | 121245 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 136 | 1.74e-37 | NR | XP_002110080.1 | 10228 | g120993 | i0 | 80.8 | 22.5435684647303 | 78 | 15 | 97.1 | 0 | 235 | 2 | 144 | 221 | XP_002110080.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 5433 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 18356083 | 18356083 | PRJNA533114_P_NODE_15635_length_572_cov_1.535070_g15388_i0 | PRJNA533114 | 15635 | 572 | 1.53507 | 8.7806004 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 179 | 7.52e-51 | NR | RDD41492.1 | 287889 | g15388 | i0 | 51.6 | 14.2814685314685 | 182 | 84 | 93.4 | 3 | 9 | 542 | 132 | 313 | RDD41492.1 Phosphatidate cytidylyltransferase 2 [Trichoplax sp. H2] | diamond | 8169 | 179 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 26649388 | 26649388 | PRJNA533114_P_NODE_86721_length_261_cov_1.228723_g86469_i0 | PRJNA533114 | 86721 | 261 | 1.228723 | 3.20696703 | Metazoa | 33208 | Placozoa | other_Eukaryota | 61.6 | 1.04e-8 | NR | XP_002117975.1 | 10228 | g86469 | i0 | 50.9 | 10.3333333333333 | 55 | 27 | 63.2 | 0 | 165 | 1 | 5 | 59 | XP_002117975.1 uncharacterized protein TRIADDRAFT_33326 [Trichoplax adhaerens] | diamond | 2697 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 27787784 | 27787784 | PRJNA533114_P_NODE_114044_length_243_cov_1.358824_g113792_i0 | PRJNA533114 | 114044 | 243 | 1.358824 | 3.30194232 | Metazoa | 33208 | Placozoa | other_Eukaryota | 58.2 | 1.34e-7 | NR | RDD43993.1 | 287889 | g113792 | i0 | 43.5 | 1.49382716049383 | 62 | 35 | 76.5 | 0 | 3 | 188 | 420 | 481 | RDD43993.1 Polycomb protein suz12 [Trichoplax sp. H2] | diamond | 363 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 28387482 | 28387482 | PRJNA533114_P_NODE_104306_length_247_cov_0.885057_g104054_i0 | PRJNA533114 | 104306 | 247 | 0.885057 | 2.18609079 | Metazoa | 33208 | Placozoa | other_Eukaryota | 97.1 | 1.8499999999999998e-23 | NR | XP_002115727.1 | 10228 | g104054 | i0 | 65.3 | 9.32793522267206 | 75 | 26 | 91.1 | 0 | 225 | 1 | 16 | 90 | XP_002115727.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 2304 | 97.8 | 0.992842535787321 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 28513837 | 28513837 | PRJNA533114_P_NODE_116227_length_242_cov_1.994083_g115975_i0 | PRJNA533114 | 116227 | 242 | 1.994083 | 4.82568086 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 107 | 6.27e-28 | NR | XP_002118685.1 | 10228 | g115975 | i0 | 66.2 | 5.91322314049587 | 71 | 24 | 88 | 0 | 28 | 240 | 28 | 98 | XP_002118685.1 uncharacterized protein TRIADDRAFT_62704, partial [Trichoplax adhaerens] | diamond | 1431 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 28703394 | 28703394 | PRJNA533114_P_NODE_52567_length_326_cov_1.217391_g52315_i0 | PRJNA533114 | 52567 | 326 | 1.217391 | 3.96869466 | Metazoa | 33208 | Placozoa | other_Eukaryota | 57 | 9.96e-7 | NR | RDD43175.1 | 287889 | g52315 | i0 | 35 | 1.5920245398773 | 103 | 43 | 93.9 | 4 | 18 | 323 | 604 | 683 | RDD43175.1 DBH-like monooxygenase protein 1-like protein [Trichoplax sp. H2] | diamond | 519 | 57.4 | 0.993031358885017 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 29113833 | 29113833 | PRJNA533114_P_NODE_19728_length_509_cov_1.954128_g19479_i0 | PRJNA533114 | 19728 | 509 | 1.954128 | 9.94651152 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67.4 | 1.77e-11 | NR | RDD47136.1 | 287889 | g19479 | i0 | 60.8 | 0.960707269155206 | 51 | 20 | 30.1 | 0 | 455 | 303 | 14 | 64 | RDD47136.1 putative protein BRICK1-A [Trichoplax sp. H2] | diamond | 489 | 67.8 | 0.994100294985251 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 29572216 | 29572216 | PRJNA533114_P_NODE_4330_length_1040_cov_2.952430_g4174_i0 | PRJNA533114 | 4330 | 1040 | 2.95243 | 30.705272 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 147 | 5.6899999999999995e-37 | NR | RDD38308.1 | 287889 | g4174 | i0 | 34.2 | 3.17019230769231 | 240 | 150 | 69.2 | 3 | 127 | 846 | 7 | 238 | RDD38308.1 Sec14 cytosolic factor [Trichoplax sp. H2] | diamond | 3297 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 29618583 | 29618583 | PRJNA533114_P_NODE_96430_length_250_cov_0.870056_g96178_i0 | PRJNA533114 | 96430 | 250 | 0.870056 | 2.17514 | root | 1 | Root_unresolved | Root_unresolved | 84.7 | 6.45e-17 | NR | RDD46774.1 | 287889 | g96178 | i0 | 55.3 | 4.044 | 85 | 36 | 99.6 | 2 | 2 | 250 | 240 | 324 | RDD46774.1 Dihydrolipoyl dehydrogenase, mitochondrial [Trichoplax sp. H2] | diamond | 1011 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 30060902 | 30060902 | PRJNA533114_P_NODE_10551_length_695_cov_1.768489_g10320_i0 | PRJNA533114 | 10551 | 695 | 1.768489 | 12.29099855 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 231 | 3.33e-71 | NR | XP_002113186.1 | 10228 | g10320 | i0 | 54.8 | 6.57841726618705 | 219 | 96 | 93.7 | 2 | 679 | 29 | 135 | 352 | XP_002113186.1 uncharacterized protein TRIADDRAFT_50357 [Trichoplax adhaerens] | diamond | 4572 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30060944 | 30060944 | PRJNA533114_P_NODE_76471_length_277_cov_1.112745_g76219_i0 | PRJNA533114 | 76471 | 277 | 1.112745 | 3.08230365 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 45.8 | 0.00416 | NR | XP_002115183.1 | 10228 | g76219 | i0 | 34.4 | 2.07942238267148 | 96 | 41 | 86.6 | 3 | 36 | 275 | 168 | 257 | XP_002115183.1 uncharacterized protein TRIADDRAFT_28800 [Trichoplax adhaerens] | diamond | 576 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30377460 | 30377460 | PRJNA533114_P_NODE_81732_length_268_cov_2.533333_g81480_i0 | PRJNA533114 | 81732 | 268 | 2.533333 | 6.78933244 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 42 | 0.0279 | NR | XP_002109530.1 | 10228 | g81480 | i0 | 60.6 | 0.738805970149254 | 33 | 12 | 36.9 | 1 | 100 | 2 | 21 | 52 | XP_002109530.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 198 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30787819 | 30787819 | PRJNA533114_P_NODE_29074_length_423_cov_2.002857_g28822_i0 | PRJNA533114 | 29074 | 423 | 2.002857 | 8.47208511 | Metazoa | 33208 | Placozoa | other_Eukaryota | 144 | 1.15e-37 | NR | XP_002117426.1 | 10228 | g28822 | i0 | 58.5 | 5.63829787234043 | 130 | 45 | 91.5 | 3 | 30 | 416 | 7 | 128 | XP_002117426.1 uncharacterized protein TRIADDRAFT_32533 [Trichoplax adhaerens] | diamond | 2385 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31135025 | 31135025 | PRJNA533114_P_NODE_111155_length_244_cov_1.771930_g110903_i0 | PRJNA533114 | 111155 | 244 | 1.77193 | 4.3235092 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 59.7 | 7.4e-9 | NR | XP_002111990.1 | 10228 | g110903 | i0 | 57.7 | 1.27868852459016 | 52 | 21 | 63.9 | 1 | 2 | 157 | 107 | 157 | XP_002111990.1 uncharacterized protein TRIADDRAFT_55579 [Trichoplax adhaerens] | diamond | 312 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31546634 | 31546634 | PRJNA533114_P_NODE_99616_length_249_cov_0.875000_g99364_i0 | PRJNA533114 | 99616 | 249 | 0.875 | 2.17875 | Metazoa | 33208 | Placozoa | other_Eukaryota | 52.4 | 1.53e-5 | NR | XP_002108931.1 | 10228 | g99364 | i0 | 40.5 | 19.0361445783133 | 79 | 47 | 95.2 | 0 | 239 | 3 | 110 | 188 | XP_002108931.1 uncharacterized protein TRIADDRAFT_2504, partial [Trichoplax adhaerens] | diamond | 4740 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32306004 | 32306004 | PRJNA533114_P_NODE_18739_length_522_cov_3.358575_g18490_i0 | PRJNA533114 | 18739 | 522 | 3.358575 | 17.531761500000002 | Metazoa | 33208 | Placozoa | other_Eukaryota | 87 | 4.04e-18 | NR | XP_002110159.1 | 10228 | g18490 | i0 | 39.3 | 3.07471264367816 | 122 | 74 | 70.1 | 0 | 464 | 99 | 3 | 124 | XP_002110159.1 uncharacterized protein TRIADDRAFT_53868 [Trichoplax adhaerens] | diamond | 1605 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32575569 | 32575569 | PRJNA533114_P_NODE_13099_length_625_cov_2.458333_g12855_i0 | PRJNA533114 | 13099 | 625 | 2.458333 | 15.36458125 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 132 | 1.06e-33 | NR | XP_002109654.1 | 10228 | g12855 | i0 | 45.6 | 5.04 | 158 | 80 | 73.9 | 2 | 464 | 3 | 11 | 166 | XP_002109654.1 uncharacterized protein TRIADDRAFT_53886 [Trichoplax adhaerens] | diamond | 3150 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens |
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);;