contig_metadata
17 rows where bioproject = "PRJNA983848", tax_kingdom = "Metazoa" and tax_phylum = "Hemichordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2243513 | 2243513 | PRJNA983848_P_NODE_162202_length_237_cov_3.195122_g156319_i0 | PRJNA983848 | 162202 | 237 | 3.195122 | 7.57243914 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 94.7 | 4.25e-23 | NR | XP_006816861.1 | 10224 | g156319 | i0 | 62.5 | 0.911392405063291 | 72 | 27 | 91.1 | 0 | 1 | 216 | 17 | 88 | XP_006816861.1 PREDICTED: uncharacterized protein LOC102805581 [Saccoglossus kowalevskii] | diamond | 216 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 7347176 | 7347176 | PRJNA983848_P_NODE_43526_length_555_cov_392.699170_g37670_i0 | PRJNA983848 | 43526 | 555 | 392.69917 | 2179.4803935 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 91.6 | 1.16e-13 | NTclustered | gi|2875658255|ref|XR_011554631.1| | 63121 | g37670 | i0 | 87.342 | 0.610810810810811 | 79 | 10 | 14 | 0 | 57 | 135 | 94 | 172 | PREDICTED: Ptychodera flava uncharacterized lncRNA (LOC139143557), ncRNA | blastn | 339 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 12446277 | 12446277 | PRJNA983848_P_NODE_127770_length_264_cov_1.523560_g121887_i0 | PRJNA983848 | 127770 | 264 | 1.52356 | 4.0221984 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 115 | 2.27e-30 | NR | XP_006813171.1 | 10224 | g121887 | i0 | 61.7 | 0.920454545454545 | 81 | 31 | 92 | 0 | 20 | 262 | 1 | 81 | XP_006813171.1 PREDICTED: uncharacterized protein LOC102806937 [Saccoglossus kowalevskii] | diamond | 243 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 21370688 | 21370688 | PRJNA983848_P_NODE_17717_length_1397_cov_3.769637_g13597_i0 | PRJNA983848 | 17717 | 1397 | 3.769637 | 52.66182889 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 256 | 1.25e-78 | NR | XP_006819864.1 | 10224 | g13597 | i0 | 62.1 | 1.35719398711525 | 219 | 68 | 43.8 | 2 | 977 | 366 | 4 | 222 | XP_006819864.1 PREDICTED: uncharacterized protein LOC102808533, partial [Saccoglossus kowalevskii] | diamond | 1896 | 256 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 26804751 | 26804751 | PRJNA983848_P_NODE_61281_length_415_cov_2.426901_g55399_i0 | PRJNA983848 | 61281 | 415 | 2.426901 | 10.07163915 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 77.4 | 3.36e-14 | NR | XP_006818253.1 | 10224 | g55399 | i0 | 58.3 | 3.91807228915663 | 60 | 25 | 43.4 | 0 | 125 | 304 | 173 | 232 | XP_006818253.1 PREDICTED: uncharacterized protein LOC102805543, partial [Saccoglossus kowalevskii] | diamond | 1626 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 26836613 | 26836613 | PRJNA983848_P_NODE_121861_length_271_cov_1.575758_g115978_i0 | PRJNA983848 | 121861 | 271 | 1.575758 | 4.27030418 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 42 | 0.0288 | NR | XP_006816861.1 | 10224 | g115978 | i0 | 46.2 | 0.431734317343173 | 39 | 21 | 43.2 | 0 | 187 | 71 | 72 | 110 | XP_006816861.1 PREDICTED: uncharacterized protein LOC102805581 [Saccoglossus kowalevskii] | diamond | 117 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 28447737 | 28447737 | PRJNA983848_P_NODE_85046_length_333_cov_3.211538_g79163_i0 | PRJNA983848 | 85046 | 333 | 3.211538 | 10.69442154 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 75.1 | 3.03e-13 | NR | XP_006818036.1 | 10224 | g79163 | i0 | 59.3 | 0.531531531531532 | 59 | 23 | 52.3 | 1 | 133 | 306 | 239 | 297 | XP_006818036.1 PREDICTED: uncharacterized protein LOC102807970, partial [Saccoglossus kowalevskii] | diamond | 177 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 28826221 | 28826221 | PRJNA983848_P_NODE_161668_length_239_cov_2.337349_g155785_i0 | PRJNA983848 | 161668 | 239 | 2.337349 | 5.58626411 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 64.7 | 2.86e-11 | NR | XP_006816861.1 | 10224 | g155785 | i0 | 60 | 1.69456066945607 | 45 | 18 | 56.5 | 0 | 160 | 26 | 22 | 66 | XP_006816861.1 PREDICTED: uncharacterized protein LOC102805581 [Saccoglossus kowalevskii] | diamond | 405 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 30437367 | 30437367 | PRJNA983848_P_NODE_116713_length_277_cov_3.514706_g110830_i0 | PRJNA983848 | 116713 | 277 | 3.514706 | 9.73573562 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 113 | 2.4199999999999997e-30 | NR | XP_006816861.1 | 10224 | g110830 | i0 | 57.1 | 3.94223826714801 | 91 | 39 | 98.6 | 0 | 3 | 275 | 8 | 98 | XP_006816861.1 PREDICTED: uncharacterized protein LOC102805581 [Saccoglossus kowalevskii] | diamond | 1092 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 30563143 | 30563143 | PRJNA983848_P_NODE_105873_length_293_cov_1.418182_g99990_i0 | PRJNA983848 | 105873 | 293 | 1.418182 | 4.15527326 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 158 | 1.08e-45 | NR | XP_006814613.1 | 10224 | g99990 | i0 | 77.2 | 0.9419795221843 | 92 | 21 | 94.2 | 0 | 291 | 16 | 56 | 147 | XP_006814613.1 PREDICTED: craniofacial development protein 2-like [Saccoglossus kowalevskii] | diamond | 276 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 30727364 | 30727364 | PRJNA983848_P_NODE_114334_length_281_cov_1.355769_g108451_i0 | PRJNA983848 | 114334 | 281 | 1.355769 | 3.80971089 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 50.4 | 9.05e-5 | NR | XP_006825929.1 | 10224 | g108451 | i0 | 40.9 | 2.81850533807829 | 66 | 35 | 66.2 | 1 | 96 | 281 | 177 | 242 | XP_006825929.1 PREDICTED: uncharacterized protein LOC102800921, partial [Saccoglossus kowalevskii] | diamond | 792 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 30784654 | 30784654 | PRJNA983848_P_NODE_66654_length_391_cov_1.276730_g60771_i0 | PRJNA983848 | 66654 | 391 | 1.27673 | 4.9920143 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 171 | 5.33e-51 | NR | XP_006818253.1 | 10224 | g60771 | i0 | 67.5 | 3.68286445012788 | 120 | 39 | 92.1 | 0 | 3 | 362 | 116 | 235 | XP_006818253.1 PREDICTED: uncharacterized protein LOC102805543, partial [Saccoglossus kowalevskii] | diamond | 1440 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 31802132 | 31802132 | PRJNA983848_P_NODE_112577_length_283_cov_1.895238_g106694_i0 | PRJNA983848 | 112577 | 283 | 1.895238 | 5.36352354 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 132 | 1.56e-34 | NR | XP_006813953.1 | 10224 | g106694 | i0 | 73.4 | 1.99293286219081 | 94 | 25 | 99.6 | 0 | 2 | 283 | 73 | 166 | XP_006813953.1 PREDICTED: uncharacterized protein LOC102807557, partial [Saccoglossus kowalevskii] | diamond | 564 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 31802137 | 31802137 | PRJNA983848_P_NODE_85577_length_332_cov_2.262548_g79694_i0 | PRJNA983848 | 85577 | 332 | 2.262548 | 7.51165936 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 124 | 3.869999999999999e-32 | NR | XP_006814613.1 | 10224 | g79694 | i0 | 68.5 | 1.60843373493976 | 89 | 23 | 75.9 | 2 | 1 | 252 | 79 | 167 | XP_006814613.1 PREDICTED: craniofacial development protein 2-like [Saccoglossus kowalevskii] | diamond | 534 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 31891211 | 31891211 | PRJNA983848_P_NODE_151797_length_246_cov_0.901734_g145914_i0 | PRJNA983848 | 151797 | 246 | 0.901734 | 2.21826564 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 49.7 | 1.38e-4 | NR | XP_006813674.1 | 10224 | g145914 | i0 | 41 | 4.28048780487805 | 61 | 33 | 74.4 | 1 | 206 | 24 | 378 | 435 | XP_006813674.1 PREDICTED: WD repeat-containing protein 3 [Saccoglossus kowalevskii] | diamond | 1053 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 31891212 | 31891212 | PRJNA983848_P_NODE_157417_length_243_cov_1.376471_g151534_i0 | PRJNA983848 | 157417 | 243 | 1.376471 | 3.34482453 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 119 | 5.5399999999999995e-30 | NR | XP_006813953.1 | 10224 | g151534 | i0 | 71.3 | 1.97530864197531 | 80 | 23 | 98.8 | 0 | 241 | 2 | 31 | 110 | XP_006813953.1 PREDICTED: uncharacterized protein LOC102807557, partial [Saccoglossus kowalevskii] | diamond | 480 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 32081006 | 32081006 | PRJNA983848_P_NODE_106278_length_292_cov_2.000000_g100395_i0 | PRJNA983848 | 106278 | 292 | 2 | 5.84 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 94 | 1.73e-22 | NR | XP_006816861.1 | 10224 | g100395 | i0 | 57.3 | 0.770547945205479 | 75 | 32 | 77.1 | 0 | 292 | 68 | 17 | 91 | XP_006816861.1 PREDICTED: uncharacterized protein LOC102805581 [Saccoglossus kowalevskii] | diamond | 225 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii |
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);;