contig_metadata
21 rows where bioproject = "PRJNA789095", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3322527 | 3322527 | PRJNA789095_P_NODE_62963_length_257_cov_1.288043_g61629_i0 | PRJNA789095 | 62963 | 257 | 1.288043 | 3.31027051 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 337 | 5.759999999999998e-88 | NTclustered | gi|402761741|gb|JX184002.1| | 104786 | g61629 | i0 | 90.837 | 96.8093385214008 | 251 | 23 | 98 | 0 | 7 | 257 | 1301 | 1051 | Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 24880 | 337 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 26800490 | 26800490 | PRJNA789095_P_NODE_68301_length_248_cov_3.880000_g66967_i0 | PRJNA789095 | 68301 | 248 | 3.88 | 9.6224 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 112 | 1.23e-26 | NR | KAI3386578.1 | 104778 | g66967 | i0 | 59.8 | 4.86290322580645 | 82 | 33 | 99.2 | 0 | 246 | 1 | 681 | 762 | KAI3386578.1 hypothetical protein SNEBB_007980, partial [Seison nebaliae] | diamond | 1206 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 26864181 | 26864181 | PRJNA789095_P_NODE_37461_length_330_cov_9.151751_g36127_i0 | PRJNA789095 | 37461 | 330 | 9.151751 | 30.2007783 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 66.6 | 4.28e-10 | NR | CAF2116601.1 | 392030 | g36127 | i0 | 47.5 | 0.554545454545455 | 61 | 32 | 55.5 | 0 | 314 | 132 | 851 | 911 | CAF2116601.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 183 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 27568351 | 27568351 | PRJNA789095_P_NODE_71924_length_245_cov_0.895349_g70590_i0 | PRJNA789095 | 71924 | 245 | 0.895349 | 2.19360505 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 160 | 1.0199999999999999e-43 | NR | UJR25051.1 | 104782 | g70590 | i0 | 90.1 | 13.8857142857143 | 81 | 8 | 99.2 | 0 | 244 | 2 | 414 | 494 | UJR25051.1 hypothetical protein I4U23_006411 [Adineta vaga] | diamond | 3402 | 161 | 0.993788819875776 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27843248 | 27843248 | PRJNA789095_P_NODE_51024_length_283_cov_2.485714_g49690_i0 | PRJNA789095 | 51024 | 283 | 2.485714 | 7.03457062 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 126 | 2.36e-33 | NR | CAF0721616.1 | 433720 | g49690 | i0 | 64.7 | 1.84452296819788 | 85 | 30 | 90.1 | 0 | 258 | 4 | 169 | 253 | CAF0721616.1 unnamed protein product [Adineta steineri] | diamond | 522 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28159391 | 28159391 | PRJNA789095_P_NODE_40185_length_314_cov_4.456432_g38851_i0 | PRJNA789095 | 40185 | 314 | 4.456432 | 13.99319648 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 90.9 | 1.1e-18 | NR | CAF4043758.1 | 392030 | g38851 | i0 | 42.5 | 1.01273885350318 | 106 | 56 | 96.5 | 1 | 310 | 8 | 883 | 988 | CAF4043758.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 318 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28317108 | 28317108 | PRJNA789095_P_NODE_70326_length_246_cov_2.670520_g68992_i0 | PRJNA789095 | 70326 | 246 | 2.67052 | 6.5694792 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 90.9 | 2.4e-20 | NR | KAI3385762.1 | 104778 | g68992 | i0 | 60.3 | 0.951219512195122 | 78 | 31 | 95.1 | 0 | 244 | 11 | 20 | 97 | KAI3385762.1 hypothetical protein SNEBB_006624 [Seison nebaliae] | diamond | 234 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 28443538 | 28443538 | PRJNA789095_P_NODE_58606_length_266_cov_3.502591_g57272_i0 | PRJNA789095 | 58606 | 266 | 3.502591 | 9.31689206 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 79.3 | 6.78e-17 | NR | CAF4406545.1 | 392030 | g57272 | i0 | 60.3 | 1.42105263157895 | 63 | 25 | 71.1 | 0 | 6 | 194 | 7 | 69 | CAF4406545.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 378 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28799631 | 28799631 | PRJNA789095_P_NODE_71867_length_245_cov_0.895349_g70533_i0 | PRJNA789095 | 71867 | 245 | 0.895349 | 2.19360505 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 137 | 2.24e-39 | NR | CAF0892191.1 | 392033 | g70533 | i0 | 92.6 | 7.7265306122449 | 81 | 4 | 96.7 | 1 | 244 | 8 | 37 | 117 | CAF0892191.1 unnamed protein product [Rotaria sordida] | diamond | 1893 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 29232827 | 29232827 | PRJNA789095_P_NODE_66069_length_251_cov_0.865169_g64735_i0 | PRJNA789095 | 66069 | 251 | 0.865169 | 2.17157419 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 152 | 1.79e-45 | NR | CAF4391454.1 | 433720 | g64735 | i0 | 85.5 | 6.94422310756972 | 83 | 12 | 99.2 | 0 | 249 | 1 | 53 | 135 | CAF4391454.1 unnamed protein product, partial [Adineta steineri] | diamond | 1743 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29295829 | 29295829 | PRJNA789095_P_NODE_68829_length_248_cov_0.880000_g67495_i0 | PRJNA789095 | 68829 | 248 | 0.88 | 2.1824 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 126 | 6.750000000000001e-33 | NR | CAF1369084.1 | 249248 | g67495 | i0 | 70.7 | 0.991935483870968 | 82 | 24 | 99.2 | 0 | 248 | 3 | 84 | 165 | CAF1369084.1 unnamed protein product [Adineta ricciae] | diamond | 246 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29548227 | 29548227 | PRJNA789095_P_NODE_41170_length_310_cov_4.611814_g39836_i0 | PRJNA789095 | 41170 | 310 | 4.611814 | 14.2966234 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 71.6 | 5.83e-12 | NR | CAF4899656.1 | 392032 | g39836 | i0 | 66 | 5.43870967741935 | 50 | 17 | 48.4 | 0 | 309 | 160 | 368 | 417 | CAF4899656.1 unnamed protein product, partial [Rotaria socialis] | diamond | 1686 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 30338544 | 30338544 | PRJNA789095_P_NODE_68872_length_248_cov_0.880000_g67538_i0 | PRJNA789095 | 68872 | 248 | 0.88 | 2.1824 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 53.9 | 4.52e-6 | NR | CAF2039467.1 | 392030 | g67538 | i0 | 36.6 | 3.96774193548387 | 82 | 49 | 95.6 | 1 | 247 | 11 | 160 | 241 | CAF2039467.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 984 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 31096288 | 31096288 | PRJNA789095_P_NODE_68835_length_248_cov_0.880000_g67501_i0 | PRJNA789095 | 68835 | 248 | 0.88 | 2.1824 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 85.9 | 8.28e-19 | NR | CAF4948185.1 | 392032 | g67501 | i0 | 60.3 | 1.40322580645161 | 58 | 23 | 70.2 | 0 | 3 | 176 | 115 | 172 | CAF4948185.1 unnamed protein product, partial [Rotaria socialis] | diamond | 348 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 31105450 | 31105450 | PRJNA789095_P_NODE_49195_length_287_cov_3.892523_g47861_i0 | PRJNA789095 | 49195 | 287 | 3.892523 | 11.17154101 | Rotaria | 231623 | Rotifera | other_Eukaryota | 79.7 | 6.41e-15 | NR | CAF2116601.1 | 392030 | g47861 | i0 | 43.4 | 3.4808362369338 | 83 | 47 | 86.8 | 0 | 286 | 38 | 793 | 875 | CAF2116601.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 999 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 31295214 | 31295214 | PRJNA789095_P_NODE_16855_length_634_cov_5.028520_g15548_i0 | PRJNA789095 | 16855 | 634 | 5.02852 | 31.8808168 | root | 1 | Root_unresolved | Root_unresolved | 116 | 1.44e-26 | NR | CAF4310248.1 | 392030 | g15548 | i0 | 35.2 | 4.58044164037855 | 193 | 122 | 91.3 | 1 | 56 | 634 | 166 | 355 | CAF4310248.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 2904 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 31981836 | 31981836 | PRJNA789095_P_NODE_70578_length_246_cov_1.341040_g69244_i0 | PRJNA789095 | 70578 | 246 | 1.34104 | 3.2989584 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 138 | 1.07e-35 | NR | CAF3880986.1 | 392030 | g69244 | i0 | 98.8 | 5.85365853658537 | 81 | 1 | 98.8 | 0 | 244 | 2 | 700 | 780 | CAF3880986.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 1440 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 32022833 | 32022833 | PRJNA789095_P_NODE_61778_length_259_cov_3.026882_g60444_i0 | PRJNA789095 | 61778 | 259 | 3.026882 | 7.83962438 | Rotaria | 231623 | Rotifera | other_Eukaryota | 55.8 | 1.08e-6 | NR | CAF2088983.1 | 392030 | g60444 | i0 | 40 | 6.94980694980695 | 85 | 51 | 98.5 | 0 | 257 | 3 | 183 | 267 | CAF2088983.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1800 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 32424954 | 32424954 | PRJNA789095_P_NODE_71859_length_245_cov_0.895349_g70525_i0 | PRJNA789095 | 71859 | 245 | 0.895349 | 2.19360505 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 128 | 2.66e-36 | NR | CAF1283436.1 | 392033 | g70525 | i0 | 79 | 1.98367346938776 | 81 | 17 | 99.2 | 0 | 3 | 245 | 16 | 96 | CAF1283436.1 unnamed protein product [Rotaria sordida] | diamond | 486 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32592310 | 32592310 | PRJNA789095_P_NODE_72639_length_244_cov_0.900585_g71305_i0 | PRJNA789095 | 72639 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 47.4 | 8.58e-4 | NR | CAF1994864.1 | 392030 | g71305 | i0 | 38.3 | 4.11885245901639 | 47 | 27 | 57.8 | 1 | 243 | 103 | 93 | 137 | CAF1994864.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1005 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 32614520 | 32614520 | PRJNA789095_P_NODE_36480_length_337_cov_0.856061_g35146_i0 | PRJNA789095 | 36480 | 337 | 0.856061 | 2.88492557 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 85.5 | 1.12e-16 | NR | CAF3624804.1 | 392032 | g35146 | i0 | 47.7 | 2.40356083086053 | 86 | 44 | 76.6 | 1 | 46 | 303 | 495 | 579 | CAF3624804.1 unnamed protein product [Rotaria socialis] | diamond | 810 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis |
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);;