contig_metadata
16 rows where bioproject = "PRJNA1011833", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26813194 | 26813194 | PRJNA1011833_S_NODE_5641_length_449_cov_11.187192_g5229_i0 | PRJNA1011833 | 5641 | 449 | 11.187192 | 50.23049208 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 134 | 3.36e-36 | NR | CAF4077026.1 | 392030 | g5229 | i0 | 50.8 | 4.29621380846325 | 128 | 63 | 85.5 | 0 | 3 | 386 | 91 | 218 | CAF4077026.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 1929 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 27034675 | 27034675 | PRJNA1011833_S_NODE_4862_length_471_cov_5.738318_g4455_i0 | PRJNA1011833 | 4862 | 471 | 5.738318 | 27.02747778 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 47.8 | 0.00295 | NR | UJR27234.1 | 104782 | g4455 | i0 | 25.9 | 1.80891719745223 | 135 | 95 | 83.4 | 4 | 13 | 405 | 34 | 167 | UJR27234.1 hypothetical protein I4U23_008530 [Adineta vaga] | diamond | 852 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27343407 | 27343407 | PRJNA1011833_S_NODE_8863_length_387_cov_3.191860_g8445_i0 | PRJNA1011833 | 8863 | 387 | 3.19186 | 12.3524982 | Metazoa | 33208 | Rotifera | other_Eukaryota | 138 | 5.01e-35 | NR | RNA08825.1 | 10195 | g8445 | i0 | 52.9 | 2.75968992248062 | 119 | 56 | 92.2 | 0 | 2 | 358 | 556 | 674 | RNA08825.1 Glycyl-tRNA synthetase [Brachionus plicatilis] | diamond | 1068 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28037908 | 28037908 | PRJNA1011833_S_NODE_27145_length_227_cov_2.608696_g26725_i0 | PRJNA1011833 | 27145 | 227 | 2.608696 | 5.92173992 | root | 1 | Root_unresolved | Root_unresolved | 48.1 | 6.98e-5 | NR | CAF5079846.1 | 392030 | g26725 | i0 | 46.4 | 3.97797356828194 | 56 | 30 | 74 | 0 | 1 | 168 | 19 | 74 | CAF5079846.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 903 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28416832 | 28416832 | PRJNA1011833_S_NODE_10226_length_367_cov_4.135802_g9808_i0 | PRJNA1011833 | 10226 | 367 | 4.135802 | 15.17839334 | Metazoa | 33208 | Rotifera | other_Eukaryota | 70.5 | 3.73e-13 | NR | RNA07666.1 | 10195 | g9808 | i0 | 50.8 | 1.49591280653951 | 61 | 30 | 49.9 | 0 | 68 | 250 | 20 | 80 | RNA07666.1 migration and invasion enhancer 1 [Brachionus plicatilis] | diamond | 549 | 71.2 | 0.990168539325843 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28424462 | 28424462 | PRJNA1011833_S_NODE_2546_length_579_cov_27.710821_g2175_i0 | PRJNA1011833 | 2546 | 579 | 27.710821 | 160.44565359 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 139 | 3.4099999999999996e-37 | NR | CAF4171232.1 | 392032 | g2175 | i0 | 52.9 | 0.803108808290155 | 155 | 66 | 77.2 | 2 | 579 | 133 | 104 | 257 | CAF4171232.1 unnamed protein product [Rotaria socialis] | diamond | 465 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 29465866 | 29465866 | PRJNA1011833_S_NODE_13550_length_326_cov_8.664311_g13130_i0 | PRJNA1011833 | 13550 | 326 | 8.664311 | 28.24565386 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 119 | 3.51e-29 | NR | KAI3384461.1 | 104778 | g13130 | i0 | 52.5 | 1.88650306748466 | 101 | 48 | 92.9 | 0 | 315 | 13 | 347 | 447 | KAI3384461.1 hypothetical protein SNEBB_003196 [Seison nebaliae] | diamond | 615 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 29497815 | 29497815 | PRJNA1011833_S_NODE_21490_length_259_cov_3.189815_g21070_i0 | PRJNA1011833 | 21490 | 259 | 3.189815 | 8.26162085 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 49.7 | 1.63e-4 | NR | RNA34384.1 | 10195 | g21070 | i0 | 47.2 | 2.10810810810811 | 53 | 28 | 61.4 | 0 | 160 | 2 | 433 | 485 | RNA34384.1 5 -nucleotidase domain-containing 3-like [Brachionus plicatilis] | diamond | 546 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29553102 | 29553102 | PRJNA1011833_S_NODE_22390_length_253_cov_2.057143_g21970_i0 | PRJNA1011833 | 22390 | 253 | 2.057143 | 5.20457179 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 45.1 | 0.00241 | NR | UJR24018.1 | 104782 | g21970 | i0 | 34.5 | 2.98814229249012 | 84 | 55 | 99.6 | 0 | 252 | 1 | 21 | 104 | UJR24018.1 hypothetical protein I4U23_026983 [Adineta vaga] | diamond | 756 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29750165 | 29750165 | PRJNA1011833_S_NODE_38491_length_188_cov_0.993103_g38071_i0 | PRJNA1011833 | 38491 | 188 | 0.993103 | 1.86703364 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 60.5 | 8.96e-9 | NR | CAF1095581.1 | 104777 | g38071 | i0 | 41.4 | 1.85106382978723 | 58 | 32 | 89.4 | 1 | 19 | 186 | 244 | 301 | CAF1095581.1 unnamed protein product [Brachionus calyciflorus] | diamond | 348 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30027202 | 30027202 | PRJNA1011833_S_NODE_23851_length_244_cov_3.597015_g23431_i0 | PRJNA1011833 | 23851 | 244 | 3.597015 | 8.7767166 | Metazoa | 33208 | Rotifera | other_Eukaryota | 67.8 | 5.32e-12 | NR | CAF5195233.1 | 392030 | g23431 | i0 | 43.3 | 3.25819672131148 | 67 | 35 | 78.7 | 1 | 6 | 197 | 42 | 108 | CAF5195233.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 795 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 30090124 | 30090124 | PRJNA1011833_S_NODE_7152_length_417_cov_2.922460_g6736_i0 | PRJNA1011833 | 7152 | 417 | 2.92246 | 12.1866582 | Brachionus | 10194 | Rotifera | other_Eukaryota | 112 | 3.83e-26 | NR | RNA30901.1 | 10195 | g6736 | i0 | 47.2 | 1.65467625899281 | 106 | 56 | 76.3 | 0 | 3 | 320 | 316 | 421 | RNA30901.1 Bystin [Brachionus plicatilis] | diamond | 690 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30438073 | 30438073 | PRJNA1011833_S_NODE_14253_length_319_cov_3.028986_g13833_i0 | PRJNA1011833 | 14253 | 319 | 3.028986 | 9.66246534 | Metazoa | 33208 | Rotifera | other_Eukaryota | 99.4 | 1.19e-23 | NR | CAF0731536.1 | 104777 | g13833 | i0 | 49 | 1.94670846394984 | 102 | 51 | 95.9 | 1 | 12 | 317 | 53 | 153 | CAF0731536.1 unnamed protein product [Brachionus calyciflorus] | diamond | 621 | 100 | 0.994 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31077483 | 31077483 | PRJNA1011833_S_NODE_11235_length_353_cov_6.161290_g10815_i0 | PRJNA1011833 | 11235 | 353 | 6.16129 | 21.7493537 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 133 | 1.12e-33 | NR | CAF1284342.1 | 392030 | g10815 | i0 | 57 | 8.1586402266289 | 107 | 46 | 90.9 | 0 | 2 | 322 | 435 | 541 | CAF1284342.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 2880 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 31741283 | 31741283 | PRJNA1011833_S_NODE_54477_length_156_cov_1.371681_g54057_i0 | PRJNA1011833 | 54477 | 156 | 1.371681 | 2.13982236 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 43.1 | 0.00818 | NR | CAF1651647.1 | 249248 | g54057 | i0 | 38.3 | 3.90384615384615 | 47 | 29 | 90.4 | 0 | 14 | 154 | 176 | 222 | CAF1651647.1 unnamed protein product, partial [Adineta ricciae] | diamond | 609 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32437744 | 32437744 | PRJNA1011833_S_NODE_3439_length_525_cov_5.993776_g3047_i0 | PRJNA1011833 | 3439 | 525 | 5.993776 | 31.467324 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 148 | 4.3e-41 | NR | CAF1394187.1 | 1234261 | g3047 | i0 | 42.2 | 1.85714285714286 | 161 | 93 | 92 | 0 | 6 | 488 | 72 | 232 | CAF1394187.1 unnamed protein product [Didymodactylos carnosus] | diamond | 975 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus |
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);;