contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA352850" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16973458 | 16973458 | PRJNA352850_P_NODE_5634_length_1673_cov_4.831281_g3918_i0 | PRJNA352850 | 5634 | 1673 | 4.831281 | 80.82733113 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 582 | 3.549999999999999e-203 | NR | CAF0781405.1 | 104777 | g3918 | i0 | 75.9 | 1.38792588164973 | 382 | 81 | 68.5 | 2 | 1673 | 528 | 50 | 420 | CAF0781405.1 unnamed protein product [Brachionus calyciflorus] | diamond | 2322 | 582 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 24023050 | 24023050 | PRJNA352850_P_NODE_43479_length_376_cov_3.149847_g40646_i0 | PRJNA352850 | 43479 | 376 | 3.149847 | 11.84342472 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 177 | 2.1e-52 | NR | CAF0846119.1 | 249248 | g40646 | i0 | 98.8 | 7.28457446808511 | 83 | 1 | 66.2 | 0 | 331 | 83 | 229 | 311 | CAF0846119.1 unnamed protein product [Adineta ricciae] | diamond | 2739 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 26648606 | 26648606 | PRJNA352850_P_NODE_37401_length_419_cov_1.256757_g34569_i0 | PRJNA352850 | 37401 | 419 | 1.256757 | 5.26581183 | Brachionus | 10194 | Rotifera | other_Eukaryota | 104 | 2.1699999999999998e-23 | NR | RMZ94757.1 | 10195 | g34569 | i0 | 60.8 | 1.05966587112172 | 74 | 29 | 53 | 0 | 329 | 108 | 23 | 96 | RMZ94757.1 box C D snoRNA 1 isoform X2 [Brachionus plicatilis] | diamond | 444 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27201046 | 27201046 | PRJNA352850_P_NODE_52702_length_329_cov_1.485714_g49869_i0 | PRJNA352850 | 52702 | 329 | 1.485714 | 4.88799906 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 126 | 1.3899999999999999e-31 | NR | CAF0849295.1 | 104777 | g49869 | i0 | 58.1 | 1.69604863221885 | 93 | 39 | 84.8 | 0 | 4 | 282 | 427 | 519 | CAF0849295.1 unnamed protein product [Brachionus calyciflorus] | diamond | 558 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28338159 | 28338159 | PRJNA352850_P_NODE_32986_length_457_cov_2.156863_g30156_i0 | PRJNA352850 | 32986 | 457 | 2.156863 | 9.85686391 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 121 | 1.49e-28 | NR | CAF0817504.1 | 104777 | g30156 | i0 | 42.9 | 6.61706783369803 | 147 | 82 | 96.5 | 1 | 4 | 444 | 900 | 1044 | CAF0817504.1 unnamed protein product [Brachionus calyciflorus] | diamond | 3024 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28401265 | 28401265 | PRJNA352850_P_NODE_59586_length_301_cov_3.230159_g56753_i0 | PRJNA352850 | 59586 | 301 | 3.230159 | 9.72277859 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 54.7 | 5.02e-6 | NR | CAF0852736.1 | 1234261 | g56753 | i0 | 34.9 | 3.50830564784053 | 86 | 52 | 85.7 | 1 | 298 | 41 | 5650 | 5731 | CAF0852736.1 unnamed protein product [Didymodactylos carnosus] | diamond | 1056 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 29064458 | 29064458 | PRJNA352850_P_NODE_28668_length_504_cov_2.747253_g25842_i0 | PRJNA352850 | 28668 | 504 | 2.747253 | 13.84615512 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 184 | 1.68e-56 | NR | CAF0864049.1 | 104777 | g25842 | i0 | 71.9 | 0.827380952380952 | 139 | 39 | 82.7 | 0 | 497 | 81 | 1 | 139 | CAF0864049.1 unnamed protein product [Brachionus calyciflorus] | diamond | 417 | 184 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29537849 | 29537849 | PRJNA352850_P_NODE_16650_length_742_cov_5.974026_g13984_i0 | PRJNA352850 | 16650 | 742 | 5.974026 | 44.32727292 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 65.9 | 3.29e-8 | NR | CAF1545071.1 | 249248 | g13984 | i0 | 86.1 | 0.1455525606469 | 36 | 5 | 14.6 | 0 | 131 | 24 | 1196 | 1231 | CAF1545071.1 unnamed protein product, partial [Adineta ricciae] | diamond | 108 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30200969 | 30200969 | PRJNA352850_P_NODE_73392_length_262_cov_0.957746_g70559_i0 | PRJNA352850 | 73392 | 262 | 0.957746 | 2.50929452 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 132 | 5.53e-38 | NR | CAF0916921.1 | 2762511 | g70559 | i0 | 98.4 | 3.54961832061069 | 62 | 1 | 71 | 0 | 3 | 188 | 42 | 103 | CAF0916921.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 930 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 30313666 | 30313666 | PRJNA352850_P_NODE_6312_length_1545_cov_7.552139_g4486_i0 | PRJNA352850 | 6312 | 1545 | 7.552139 | 116.68054755 | Adineta | 104781 | Rotifera | other_Eukaryota | 909 | 0 | NR | UJR13961.1 | 104782 | g4486 | i0 | 87.6 | 3.74368932038835 | 485 | 60 | 94.2 | 0 | 90 | 1544 | 1 | 485 | UJR13961.1 hypothetical protein I4U23_000964 [Adineta vaga] | diamond | 5784 | 909 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30471299 | 30471299 | PRJNA352850_P_NODE_84753_length_241_cov_2.166667_g81920_i0 | PRJNA352850 | 84753 | 241 | 2.166667 | 5.22166747 | Adineta | 104781 | Rotifera | other_Eukaryota | 121 | 3.57e-30 | NR | UJR31515.1 | 104782 | g81920 | i0 | 74.7 | 1.96680497925311 | 79 | 20 | 98.3 | 0 | 239 | 3 | 466 | 544 | UJR31515.1 hypothetical protein I4U23_019004 [Adineta vaga] | diamond | 474 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30485611 | 30485611 | PRJNA352850_P_NODE_86253_length_231_cov_2.043956_g83420_i0 | PRJNA352850 | 86253 | 231 | 2.043956 | 4.72153836 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 51.6 | 6.16e-6 | NR | CAF1604783.1 | 249248 | g83420 | i0 | 100 | 0.935064935064935 | 24 | 0 | 31.2 | 0 | 1 | 72 | 117 | 140 | CAF1604783.1 unnamed protein product [Adineta ricciae] | diamond | 216 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30864609 | 30864609 | PRJNA352850_P_NODE_34934_length_439_cov_2.074359_g32103_i0 | PRJNA352850 | 34934 | 439 | 2.074359 | 9.10643601 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 226 | 3.87e-73 | NR | KAI3387873.1 | 104778 | g32103 | i0 | 75.7 | 0.929384965831435 | 136 | 33 | 92.9 | 0 | 436 | 29 | 32 | 167 | KAI3387873.1 hypothetical protein SNEBB_008664 [Seison nebaliae] | diamond | 408 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 32003081 | 32003081 | PRJNA352850_P_NODE_70378_length_268_cov_0.931507_g67545_i0 | PRJNA352850 | 70378 | 268 | 0.931507 | 2.49643876 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 75.5 | 1.47e-13 | NR | RMZ99492.1 | 10195 | g67545 | i0 | 66.7 | 2.6865671641791 | 48 | 16 | 53.7 | 0 | 266 | 123 | 159 | 206 | RMZ99492.1 transketolase 2 isoform X1 [Brachionus plicatilis] | diamond | 720 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 32698383 | 32698383 | PRJNA352850_P_NODE_64320_length_285_cov_2.152542_g61487_i0 | PRJNA352850 | 64320 | 285 | 2.152542 | 6.1347447 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 134 | 6.749999999999998e-35 | NR | CAF0828611.1 | 249248 | g61487 | i0 | 84 | 0.852631578947368 | 81 | 13 | 85.3 | 0 | 3 | 245 | 372 | 452 | CAF0828611.1 unnamed protein product [Adineta ricciae] | diamond | 243 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32887253 | 32887253 | PRJNA352850_P_NODE_13180_length_881_cov_6.597356_g10660_i0 | PRJNA352850 | 13180 | 881 | 6.5973560000000004 | 58.12270636 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 231 | 2.13e-65 | NR | CAF1010009.1 | 249248 | g10660 | i0 | 50.4 | 4.07264472190692 | 280 | 115 | 92.3 | 5 | 879 | 67 | 685 | 949 | CAF1010009.1 unnamed protein product [Adineta ricciae] | diamond | 3588 | 231 | 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);;