contig_metadata
14 rows where bioproject = "PRJNA1158727", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1037654 | 1037654 | PRJNA1158727_P_NODE_41441_length_598_cov_1.173333_g34041_i0 | PRJNA1158727 | 41441 | 598 | 1.173333 | 7.01653134 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 5.53e-28 | NR | RMZ98034.1 | 10195 | g34041 | i0 | 46 | 1.48494983277592 | 150 | 74 | 71.7 | 3 | 431 | 3 | 70 | 219 | RMZ98034.1 Nascent polypeptide-associated complex subunit alpha [Brachionus plicatilis] | diamond | 888 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27091350 | 27091350 | PRJNA1158727_P_NODE_110242_length_279_cov_1.495146_g102781_i0 | PRJNA1158727 | 110242 | 279 | 1.495146 | 4.17145734 | Rotaria | 231623 | Rotifera | other_Eukaryota | 55.5 | 1.51e-6 | NR | CAF1050614.1 | 392030 | g102781 | i0 | 32.3 | 4.21505376344086 | 99 | 57 | 100 | 2 | 1 | 279 | 145 | 239 | CAF1050614.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 1176 | 55.8 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 27091355 | 27091355 | PRJNA1158727_P_NODE_47542_length_524_cov_1.720621_g40094_i0 | PRJNA1158727 | 47542 | 524 | 1.720621 | 9.01605404 | Rotaria | 231623 | Rotifera | other_Eukaryota | 234 | 6.260000000000001e-75 | NR | CAF0809184.1 | 392033 | g40094 | i0 | 63 | 6.18320610687023 | 184 | 58 | 99.6 | 1 | 1 | 522 | 1 | 184 | CAF0809184.1 unnamed protein product [Rotaria sordida] | diamond | 3240 | 234 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 27514321 | 27514321 | PRJNA1158727_P_NODE_117283_length_270_cov_2.182741_g109822_i0 | PRJNA1158727 | 117283 | 270 | 2.182741 | 5.8934007 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 80.1 | 2.57e-15 | NR | CAF0965790.1 | 1234261 | g109822 | i0 | 58.2 | 2.18888888888889 | 67 | 28 | 74.4 | 0 | 69 | 269 | 2 | 68 | CAF0965790.1 unnamed protein product [Didymodactylos carnosus] | diamond | 591 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27849232 | 27849232 | PRJNA1158727_P_NODE_155204_length_244_cov_0.900585_g147742_i0 | PRJNA1158727 | 155204 | 244 | 0.900585 | 2.1974274 | Adineta | 104781 | Rotifera | other_Eukaryota | 148 | 2.32e-39 | NR | CAF0887258.1 | 249248 | g147742 | i0 | 84 | 2.98770491803279 | 81 | 13 | 99.6 | 0 | 243 | 1 | 613 | 693 | CAF0887258.1 unnamed protein product [Adineta ricciae] | diamond | 729 | 149 | 0.993288590604027 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27956385 | 27956385 | PRJNA1158727_P_NODE_138525_length_250_cov_0.870056_g131063_i0 | PRJNA1158727 | 138525 | 250 | 0.870056 | 2.17514 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 48.9 | 2.58e-4 | NR | RNA02638.1 | 10195 | g131063 | i0 | 77.8 | 0.324 | 27 | 6 | 32.4 | 0 | 2 | 82 | 303 | 329 | RNA02638.1 phytanoyl- peroxisomal [Brachionus plicatilis] | diamond | 81 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28651006 | 28651006 | PRJNA1158727_P_NODE_113587_length_275_cov_1.297030_g106126_i0 | PRJNA1158727 | 113587 | 275 | 1.29703 | 3.5668325 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 89.7 | 1.63e-18 | NR | CAF3578007.1 | 433720 | g106126 | i0 | 58.7 | 3 | 92 | 31 | 99.3 | 2 | 275 | 3 | 371 | 456 | CAF3578007.1 unnamed protein product, partial [Adineta steineri] | diamond | 825 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28808530 | 28808530 | PRJNA1158727_P_NODE_165648_length_234_cov_2.391304_g158186_i0 | PRJNA1158727 | 165648 | 234 | 2.391304 | 5.59565136 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 84.7 | 7.88e-19 | NR | RNA30453.1 | 10195 | g158186 | i0 | 70.8 | 1.66666666666667 | 65 | 18 | 82.1 | 1 | 3 | 194 | 76 | 140 | RNA30453.1 small subunit ribosomal S30e [Brachionus plicatilis] | diamond | 390 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29219445 | 29219445 | PRJNA1158727_P_NODE_111669_length_277_cov_1.857843_g104208_i0 | PRJNA1158727 | 111669 | 277 | 1.857843 | 5.14622511 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 134 | 3.21e-34 | NR | CAF2775120.1 | 2762512 | g104208 | i0 | 80.2 | 2.95667870036101 | 91 | 18 | 98.6 | 0 | 2 | 274 | 442 | 532 | CAF2775120.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 819 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 29692601 | 29692601 | PRJNA1158727_P_NODE_98570_length_295_cov_2.923423_g91109_i0 | PRJNA1158727 | 98570 | 295 | 2.923423 | 8.62409785 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 58.9 | 1.33e-7 | NR | CAF4285350.1 | 392032 | g91109 | i0 | 61.5 | 1.18983050847458 | 39 | 15 | 39.7 | 0 | 123 | 7 | 33 | 71 | CAF4285350.1 unnamed protein product [Rotaria socialis] | diamond | 351 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 30249518 | 30249518 | PRJNA1158727_P_NODE_138672_length_250_cov_0.870056_g131210_i0 | PRJNA1158727 | 138672 | 250 | 0.870056 | 2.17514 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 143 | 1.2299999999999999e-40 | NR | CAF1091917.1 | 433720 | g131210 | i0 | 69.9 | 7.968 | 83 | 24 | 99.6 | 1 | 2 | 250 | 131 | 212 | CAF1091917.1 unnamed protein product [Adineta steineri] | diamond | 1992 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 30893563 | 30893563 | PRJNA1158727_P_NODE_164234_length_241_cov_0.880952_g156772_i0 | PRJNA1158727 | 164234 | 241 | 0.880952 | 2.12309432 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 48.1 | 1.23e-4 | NR | CAF1367500.1 | 2762511 | g156772 | i0 | 75.9 | 0.360995850622407 | 29 | 7 | 36.1 | 0 | 241 | 155 | 101 | 129 | CAF1367500.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 87 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 31892945 | 31892945 | PRJNA1158727_P_NODE_30017_length_807_cov_2.220708_g23157_i0 | PRJNA1158727 | 30017 | 807 | 2.220708 | 17.92111356 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 60.8 | 1.61e-6 | NR | UJR25340.1 | 104782 | g23157 | i0 | 31 | 4.3271375464684 | 129 | 82 | 46.8 | 4 | 701 | 324 | 296 | 420 | UJR25340.1 hypothetical protein I4U23_006690 [Adineta vaga] | diamond | 3492 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32538260 | 32538260 | PRJNA1158727_P_NODE_129099_length_257_cov_1.559783_g121638_i0 | PRJNA1158727 | 129099 | 257 | 1.559783 | 4.00864231 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 83.6 | 2.44e-18 | NR | CAF0858841.1 | 249248 | g121638 | i0 | 63.6 | 1.284046692607 | 55 | 20 | 64.2 | 0 | 50 | 214 | 72 | 126 | CAF0858841.1 unnamed protein product [Adineta ricciae] | diamond | 330 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae |
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);;