contig_metadata
24 rows where bioproject = "PRJNA492406", tax_clade = "Opisthokonta" and tax_phylum = "Rotifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5556176 | 5556176 | PRJNA492406_P_NODE_28945_length_247_cov_0.885057_g28646_i0 | PRJNA492406 | 28945 | 247 | 0.885057 | 2.18609079 | Asplanchna sp. | 3231738 | Rotifera | other_Eukaryota | 148 | 2.77e-31 | NTclustered | gi|2778092479|gb|PP988071.1| | 3231738 | g28646 | i0 | 77.823 | 6.57894736842105 | 248 | 49 | 99 | 5 | 1 | 245 | 5883 | 6127 | Asplanchna sp. chromosome I mitochondrion, complete sequence | blastn | 1625 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sp. | |
| 9380062 | 9380062 | PRJNA492406_P_NODE_10488_length_381_cov_1.240260_g10189_i0 | PRJNA492406 | 10488 | 381 | 1.24026 | 4.7253906 | Brachionus angularis | 396692 | Rotifera | other_Eukaryota | 82.4 | 4.63e-11 | NTclustered | gi|1999716433|gb|MT875425.1| | 396692 | g10189 | i0 | 76.543 | 8.84514435695538 | 162 | 31 | 42 | 7 | 221 | 380 | 6208 | 6364 | Brachionus angularis chromosome I mitochondrion, complete sequence | blastn | 3370 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus angularis | |
| 15127270 | 15127270 | PRJNA492406_P_NODE_23832_length_264_cov_1.612565_g23533_i0 | PRJNA492406 | 23832 | 264 | 1.612565 | 4.2571716 | Rotaria | 231623 | Rotifera | other_Eukaryota | 141 | 2.2899999999999998e-38 | NR | CAF4522565.1 | 392032 | g23533 | i0 | 76.7 | 11.5909090909091 | 86 | 20 | 97.7 | 0 | 262 | 5 | 1 | 86 | CAF4522565.1 unnamed protein product [Rotaria socialis] | diamond | 3060 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 23404858 | 23404858 | PRJNA492406_P_NODE_25459_length_256_cov_1.622951_g25160_i0 | PRJNA492406 | 25459 | 256 | 1.622951 | 4.15475456 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 350 | 7.37e-92 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g25160 | i0 | 91.44 | 1.00390625 | 257 | 18 | 99 | 4 | 1 | 254 | 376 | 631 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 257 | 350 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 27123708 | 27123708 | PRJNA492406_P_NODE_15842_length_315_cov_1.599174_g15543_i0 | PRJNA492406 | 15842 | 315 | 1.599174 | 5.0373981 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 69.7 | 2.59e-12 | NR | RNA41367.1 | 10195 | g15543 | i0 | 53.6 | 4.41904761904762 | 56 | 26 | 53.3 | 0 | 137 | 304 | 23 | 78 | RNA41367.1 eukaryotic translation initiation factor 5A [Brachionus plicatilis] | diamond | 1392 | 70.1 | 0.994293865905849 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27329405 | 27329405 | PRJNA492406_P_NODE_16723_length_306_cov_1.652361_g16424_i0 | PRJNA492406 | 16723 | 306 | 1.652361 | 5.05622466 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 61.2 | 2.02e-8 | NR | UJR15272.1 | 104782 | g16424 | i0 | 38.8 | 0.833333333333333 | 85 | 51 | 82.4 | 1 | 10 | 261 | 55 | 139 | UJR15272.1 hypothetical protein I4U23_002226 [Adineta vaga] | diamond | 255 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27329420 | 27329420 | PRJNA492406_P_NODE_27943_length_248_cov_2.577143_g27644_i0 | PRJNA492406 | 27943 | 248 | 2.577143 | 6.39131464 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 90.1 | 4.8e-21 | NR | CAF3320554.1 | 392032 | g27644 | i0 | 48.8 | 5.73387096774194 | 80 | 41 | 96.8 | 0 | 3 | 242 | 22 | 101 | CAF3320554.1 unnamed protein product [Rotaria socialis] | diamond | 1422 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 27424290 | 27424290 | PRJNA492406_P_NODE_25303_length_257_cov_1.342391_g25004_i0 | PRJNA492406 | 25303 | 257 | 1.342391 | 3.44994487 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 57 | 3.97e-7 | NR | CAF0983745.1 | 392033 | g25004 | i0 | 50 | 1.79766536964981 | 52 | 25 | 60.7 | 1 | 101 | 256 | 309 | 359 | CAF0983745.1 unnamed protein product [Rotaria sordida] | diamond | 462 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 27945287 | 27945287 | PRJNA492406_P_NODE_30185_length_244_cov_1.467836_g29886_i0 | PRJNA492406 | 30185 | 244 | 1.467836 | 3.58151984 | Metazoa | 33208 | Rotifera | other_Eukaryota | 99 | 1.69e-23 | NR | CAF1558236.1 | 249248 | g29886 | i0 | 57.8 | 4.29098360655738 | 90 | 22 | 95.9 | 3 | 236 | 3 | 12 | 97 | CAF1558236.1 unnamed protein product, partial [Adineta ricciae] | diamond | 1047 | 99.4 | 0.995975855130785 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28024073 | 28024073 | PRJNA492406_P_NODE_25685_length_255_cov_1.439560_g25386_i0 | PRJNA492406 | 25685 | 255 | 1.43956 | 3.670878 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 63.2 | 2.95e-9 | NR | CAF0876681.1 | 392033 | g25386 | i0 | 43.8 | 6.35294117647059 | 80 | 31 | 77.6 | 2 | 58 | 255 | 839 | 918 | CAF0876681.1 unnamed protein product [Rotaria sordida] | diamond | 1620 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28086993 | 28086993 | PRJNA492406_P_NODE_1365_length_1037_cov_5.645228_g1148_i0 | PRJNA492406 | 1365 | 1037 | 5.645228 | 58.54101436 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 74.7 | 6.02e-11 | NR | CAF0983950.1 | 392033 | g1148 | i0 | 25.3 | 2.29122468659595 | 198 | 140 | 57.3 | 2 | 595 | 2 | 143 | 332 | CAF0983950.1 unnamed protein product [Rotaria sordida] | diamond | 2376 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28244788 | 28244788 | PRJNA492406_P_NODE_19226_length_287_cov_1.303738_g18927_i0 | PRJNA492406 | 19226 | 287 | 1.303738 | 3.74172806 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 103 | 3.61e-23 | NR | KAI3390119.1 | 104778 | g18927 | i0 | 73 | 5.31010452961672 | 63 | 17 | 65.9 | 0 | 2 | 190 | 666 | 728 | KAI3390119.1 hypothetical protein SNEBB_010160 [Seison nebaliae] | diamond | 1524 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 28339692 | 28339692 | PRJNA492406_P_NODE_13386_length_342_cov_2.434944_g13087_i0 | PRJNA492406 | 13386 | 342 | 2.434944 | 8.32750848 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 67 | 3.7e-10 | NR | CAF2683919.1 | 2762512 | g13087 | i0 | 32.8 | 7.6140350877193 | 116 | 69 | 98.2 | 2 | 3 | 338 | 194 | 304 | CAF2683919.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 2604 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 29097602 | 29097602 | PRJNA492406_P_NODE_268_length_2074_cov_6.917041_g200_i0 | PRJNA492406 | 268 | 2074 | 6.917041 | 143.45943034 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 82.8 | 3.42e-12 | NR | CAF4249483.1 | 2762512 | g200 | i0 | 27.2 | 0.483124397299904 | 334 | 179 | 41.2 | 12 | 1294 | 440 | 490 | 808 | CAF4249483.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 1002 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 29381668 | 29381668 | PRJNA492406_P_NODE_32049_length_241_cov_0.916667_g31750_i0 | PRJNA492406 | 32049 | 241 | 0.916667 | 2.20916747 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 105 | 1.59e-26 | NR | CAF1060093.1 | 104777 | g31750 | i0 | 95.4 | 2.40248962655602 | 65 | 3 | 80.9 | 0 | 239 | 45 | 12 | 76 | CAF1060093.1 unnamed protein product, partial [Brachionus calyciflorus] | diamond | 579 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29681452 | 29681452 | PRJNA492406_P_NODE_23290_length_267_cov_1.391753_g22991_i0 | PRJNA492406 | 23290 | 267 | 1.391753 | 3.71598051 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 87.8 | 6.86e-18 | NR | UJR25328.1 | 104782 | g22991 | i0 | 51.7 | 12.7415730337079 | 87 | 39 | 95.5 | 3 | 1 | 255 | 137 | 222 | UJR25328.1 hypothetical protein I4U23_006679 [Adineta vaga] | diamond | 3402 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29697009 | 29697009 | PRJNA492406_P_NODE_31530_length_242_cov_0.911243_g31231_i0 | PRJNA492406 | 31530 | 242 | 0.911243 | 2.20520806 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 147 | 9.5e-44 | NR | CAF0711365.1 | 104777 | g31231 | i0 | 85 | 0.991735537190083 | 80 | 12 | 99.2 | 0 | 1 | 240 | 25 | 104 | CAF0711365.1 unnamed protein product [Brachionus calyciflorus] | diamond | 240 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29950085 | 29950085 | PRJNA492406_P_NODE_2391_length_778_cov_1.069504_g2112_i0 | PRJNA492406 | 2391 | 778 | 1.069504 | 8.32074112 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 65.5 | 4.88e-8 | NR | CAF1390506.1 | 2762511 | g2112 | i0 | 27.9 | 0.690231362467866 | 179 | 120 | 69 | 3 | 540 | 4 | 475 | 644 | CAF1390506.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 537 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 30092220 | 30092220 | PRJNA492406_P_NODE_7652_length_438_cov_1.901370_g7353_i0 | PRJNA492406 | 7652 | 438 | 1.90137 | 8.3280006 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 120 | 4.219999999999999e-31 | NR | CAF0973539.1 | 249248 | g7353 | i0 | 43.4 | 3.00684931506849 | 145 | 74 | 95.9 | 5 | 425 | 6 | 34 | 175 | CAF0973539.1 unnamed protein product [Adineta ricciae] | diamond | 1317 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30107915 | 30107915 | PRJNA492406_P_NODE_22332_length_272_cov_1.346734_g22033_i0 | PRJNA492406 | 22332 | 272 | 1.346734 | 3.66311648 | Brachionus angularis | 396692 | Rotifera | other_Eukaryota | 95.9 | 1.12e-20 | NR | QUF59428.1 | 396692 | g22033 | i0 | 60.6 | 0.783088235294118 | 71 | 28 | 78.3 | 0 | 27 | 239 | 765 | 835 | QUF59428.1 ATP-binding cassette transporter Abca3-2 [Brachionus angularis] | diamond | 213 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus angularis | |
| 30471688 | 30471688 | PRJNA492406_P_NODE_27333_length_250_cov_0.870056_g27034_i0 | PRJNA492406 | 27333 | 250 | 0.870056 | 2.17514 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 45.4 | 0.0043 | NR | CAF1266594.1 | 1234261 | g27034 | i0 | 51.4 | 2.196 | 35 | 17 | 42 | 0 | 146 | 250 | 3 | 37 | CAF1266594.1 unnamed protein product [Didymodactylos carnosus] | diamond | 549 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 30850657 | 30850657 | PRJNA492406_P_NODE_28394_length_248_cov_0.880000_g28095_i0 | PRJNA492406 | 28394 | 248 | 0.88 | 2.1824 | Rotaria | 231623 | Rotifera | other_Eukaryota | 46.6 | 0.00172 | NR | CAF3756846.1 | 392032 | g28095 | i0 | 29.6 | 7.8508064516129 | 81 | 57 | 98 | 0 | 3 | 245 | 498 | 578 | CAF3756846.1 unnamed protein product [Rotaria socialis] | diamond | 1947 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 32321372 | 32321372 | PRJNA492406_P_NODE_18639_length_289_cov_2.263889_g18340_i0 | PRJNA492406 | 18639 | 289 | 2.263889 | 6.54263921 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 49.7 | 2.36e-4 | NR | CAF1411793.1 | 433720 | g18340 | i0 | 29.7 | 0.944636678200692 | 91 | 64 | 94.5 | 0 | 16 | 288 | 581 | 671 | CAF1411793.1 unnamed protein product [Adineta steineri] | diamond | 273 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32605612 | 32605612 | PRJNA492406_P_NODE_18600_length_290_cov_0.986175_g18301_i0 | PRJNA492406 | 18600 | 290 | 0.986175 | 2.8599075 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 86.3 | 6.57e-19 | NR | CAF4279988.1 | 433720 | g18301 | i0 | 50 | 7.62413793103448 | 80 | 39 | 81.7 | 1 | 243 | 7 | 21 | 100 | CAF4279988.1 unnamed protein product [Adineta steineri] | diamond | 2211 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri |
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);;