contig_metadata
14 rows where bioproject = "PRJNA597223", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3120038 | 3120038 | PRJNA597223_P_NODE_34963_length_247_cov_2.580189_g33117_i0 | PRJNA597223 | 34963 | 247 | 2.580189 | 6.37306683 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 455 | 1.4600000000000002e-123 | NTclustered | gi|83285086|gb|DQ297698.1| | 96446 | g33117 | i0 | 100 | 99.5991902834008 | 246 | 0 | 99 | 0 | 2 | 247 | 866 | 621 | Lecane bulla 18S ribosomal RNA gene, partial sequence | blastn | 24601 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 5672823 | 5672823 | PRJNA597223_P_NODE_36105_length_242_cov_1.898551_g34259_i0 | PRJNA597223 | 36105 | 242 | 1.898551 | 4.59449342 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 228 | 3.3699999999999986e-55 | NTclustered | gi|187233665|gb|EU643499.1| | 104782 | g34259 | i0 | 90.395 | 0.731404958677686 | 177 | 11 | 73 | 1 | 66 | 242 | 443 | 273 | Adineta vaga ribosomal protein L26 mRNA, partial cds | blastn | 177 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 20267078 | 20267078 | PRJNA597223_P_NODE_10296_length_539_cov_4.636905_g8632_i0 | PRJNA597223 | 10296 | 539 | 4.636905 | 24.99291795 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 924 | 0 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g8632 | i0 | 97.765 | 45.0760667903525 | 537 | 10 | 99 | 1 | 1 | 535 | 1847 | 2383 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 24296 | 924 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 27995906 | 27995906 | PRJNA597223_P_NODE_165_length_2979_cov_7.500340_g102_i0 | PRJNA597223 | 165 | 2979 | 7.50034 | 223.4351286 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 447 | 1.2499999999999999e-131 | NR | CAF2516721.1 | 2762512 | g102 | i0 | 41 | 1.90936555891239 | 632 | 346 | 61.3 | 9 | 1831 | 5 | 337 | 964 | CAF2516721.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 5688 | 447 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 28659027 | 28659027 | PRJNA597223_P_NODE_52107_length_193_cov_1.670886_g50261_i0 | PRJNA597223 | 52107 | 193 | 1.670886 | 3.22480998 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 47.4 | 3.73e-4 | NR | CAF0761518.1 | 433720 | g50261 | i0 | 40.6 | 0.994818652849741 | 64 | 36 | 96.4 | 1 | 3 | 188 | 146 | 209 | CAF0761518.1 unnamed protein product [Adineta steineri] | diamond | 192 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28829972 | 28829972 | PRJNA597223_P_NODE_79488_length_158_cov_2.032520_g77642_i0 | PRJNA597223 | 79488 | 158 | 2.03252 | 3.2113816 | Rotaria | 231623 | Rotifera | other_Eukaryota | 55.5 | 3.21e-7 | NR | CAF1623482.1 | 392030 | g77642 | i0 | 48.1 | 20.7341772151899 | 52 | 27 | 98.7 | 0 | 156 | 1 | 109 | 160 | CAF1623482.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 3276 | 55.8 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29227423 | 29227423 | PRJNA597223_P_NODE_11289_length_512_cov_8.090147_g870_i6 | PRJNA597223 | 11289 | 512 | 8.090147 | 41.42155264 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 68.6 | 6.1e-10 | NR | CAF0993919.1 | 104777 | g870 | i6 | 42 | 4.787109375 | 88 | 48 | 49.8 | 3 | 441 | 187 | 147 | 234 | CAF0993919.1 unnamed protein product [Brachionus calyciflorus] | diamond | 2451 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29290297 | 29290297 | PRJNA597223_P_NODE_45089_length_210_cov_1.102857_g43243_i0 | PRJNA597223 | 45089 | 210 | 1.102857 | 2.3159997 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 49.3 | 1.19e-4 | NR | CAF2158178.1 | 392030 | g43243 | i0 | 45.5 | 3.14285714285714 | 55 | 30 | 78.6 | 0 | 208 | 44 | 751 | 805 | CAF2158178.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 660 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29542854 | 29542854 | PRJNA597223_P_NODE_76690_length_161_cov_7.269841_g74844_i0 | PRJNA597223 | 76690 | 161 | 7.269841 | 11.70444401 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 64.3 | 2.92e-10 | NR | CAF1461519.1 | 1234261 | g74844 | i0 | 56 | 0.93167701863354 | 50 | 22 | 93.2 | 0 | 161 | 12 | 240 | 289 | CAF1461519.1 unnamed protein product [Didymodactylos carnosus] | diamond | 150 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 30269701 | 30269701 | PRJNA597223_S_NODE_352_length_458_cov_2.439141_g295_i0 | PRJNA597223 | 352 | 458 | 2.439141 | 11.17126578 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 155 | 1.17e-41 | NR | CAF0943747.1 | 1234261 | g295 | i0 | 54.9 | 1.99781659388646 | 153 | 65 | 99.6 | 3 | 456 | 1 | 366 | 515 | CAF0943747.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 915 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 30743339 | 30743339 | PRJNA597223_P_NODE_53494_length_190_cov_2.864516_g51648_i0 | PRJNA597223 | 53494 | 190 | 2.864516 | 5.4425804 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 41.2 | 0.0414 | NR | CAF4188438.1 | 433720 | g51648 | i0 | 66.7 | 0.378947368421053 | 24 | 8 | 37.9 | 0 | 2 | 73 | 122 | 145 | CAF4188438.1 unnamed protein product, partial [Adineta steineri] | diamond | 72 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31198587 | 31198587 | PRJNA597223_P_NODE_14555_length_442_cov_2.641278_g12767_i0 | PRJNA597223 | 14555 | 442 | 2.641278 | 11.67444876 | root | 1 | Root_unresolved | Root_unresolved | 137 | 2.8e-34 | NR | CAF0790135.1 | 104777 | g12767 | i0 | 46.2 | 15.5904977375566 | 158 | 73 | 99.1 | 1 | 439 | 2 | 389 | 546 | CAF0790135.1 unnamed protein product [Brachionus calyciflorus] | diamond | 6891 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31343860 | 31343860 | PRJNA597223_P_NODE_65536_length_178_cov_2.000000_g63690_i0 | PRJNA597223 | 65536 | 178 | 2 | 3.56 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 59.7 | 1.65e-8 | NR | CAF3329596.1 | 2762512 | g63690 | i0 | 58.1 | 9.42134831460674 | 43 | 18 | 72.5 | 0 | 139 | 11 | 422 | 464 | CAF3329596.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 1677 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 32577718 | 32577718 | PRJNA597223_P_NODE_7839_length_624_cov_3.027165_g6335_i0 | PRJNA597223 | 7839 | 624 | 3.027165 | 18.8895096 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 119 | 6.2100000000000006e-27 | NR | CAF4517623.1 | 2762512 | g6335 | i0 | 52 | 1.41346153846154 | 98 | 47 | 47.1 | 0 | 324 | 617 | 193 | 290 | CAF4517623.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 882 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 |
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);;