contig_metadata
14 rows where bioproject = "PRJNA274362", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2921362 | 2921362 | PRJNA274362_S_NODE_30743_length_172_cov_1.065041_g30623_i0 | PRJNA274362 | 30743 | 172 | 1.065041 | 1.83187052 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 246 | 6.17e-61 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g30623 | i0 | 93.865 | 49.0639534883721 | 163 | 10 | 95 | 0 | 2 | 164 | 1904 | 2066 | Philodina citrina complete mitochondrial genome | blastn | 8439 | 246 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 10574703 | 10574703 | PRJNA274362_S_NODE_31109_length_171_cov_1.221311_g30989_i0 | PRJNA274362 | 31109 | 171 | 1.221311 | 2.08844181 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 97.1 | 1.96e-22 | NR | CAF1223729.1 | 392033 | g30989 | i0 | 68.4 | 8 | 57 | 18 | 100 | 0 | 171 | 1 | 92 | 148 | CAF1223729.1 unnamed protein product, partial [Rotaria sordida] | diamond | 1368 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 13812010 | 13812010 | PRJNA274362_S_NODE_29431_length_175_cov_1.238095_g29311_i0 | PRJNA274362 | 29431 | 175 | 1.238095 | 2.16666625 | Metazoa | 33208 | Rotifera | other_Eukaryota | 318 | 1.32e-82 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g29311 | i0 | 99.429 | 54.9085714285714 | 175 | 1 | 100 | 0 | 1 | 175 | 2013 | 2187 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 9609 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 23322680 | 23322680 | PRJNA274362_S_NODE_28199_length_178_cov_1.976744_g28079_i0 | PRJNA274362 | 28199 | 178 | 1.976744 | 3.51860432 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 108 | 2.68e-26 | NR | CAF0778165.1 | 104777 | g28079 | i0 | 82.8 | 5.86516853932584 | 58 | 10 | 97.8 | 0 | 176 | 3 | 244 | 301 | CAF0778165.1 unnamed protein product [Brachionus calyciflorus] | diamond | 1044 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 26598916 | 26598916 | PRJNA274362_S_NODE_8461_length_295_cov_1.654472_g8341_i0 | PRJNA274362 | 8461 | 295 | 1.654472 | 4.8806924 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 89.7 | 2.14e-20 | NR | CAF0810198.1 | 104777 | g8341 | i0 | 57.1 | 0.854237288135593 | 84 | 33 | 82.4 | 1 | 279 | 37 | 62 | 145 | CAF0810198.1 unnamed protein product [Brachionus calyciflorus] | diamond | 252 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 26821063 | 26821063 | PRJNA274362_S_NODE_8221_length_299_cov_1.260000_g8101_i0 | PRJNA274362 | 8221 | 299 | 1.26 | 3.7674 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 46.6 | 0.00144 | NR | CAF0733166.1 | 104777 | g8101 | i0 | 53.1 | 0.491638795986622 | 49 | 22 | 49.2 | 1 | 1 | 147 | 115 | 162 | CAF0733166.1 unnamed protein product [Brachionus calyciflorus] | diamond | 147 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 26902104 | 26902104 | PRJNA274362_S_NODE_14461_length_236_cov_0.834225_g14341_i0 | PRJNA274362 | 14461 | 236 | 0.834225 | 1.968771 | Metazoa | 33208 | Rotifera | other_Eukaryota | 102 | 1.67e-24 | NR | CAF0767949.1 | 104777 | g14341 | i0 | 69.4 | 16.5254237288136 | 62 | 19 | 78.8 | 0 | 1 | 186 | 186 | 247 | CAF0767949.1 unnamed protein product [Brachionus calyciflorus] | diamond | 3900 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27200271 | 27200271 | PRJNA274362_S_NODE_32062_length_169_cov_0.866667_g31942_i0 | PRJNA274362 | 32062 | 169 | 0.866667 | 1.46466723 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 62.8 | 9.25e-11 | NR | CAF2108020.1 | 392030 | g31942 | i0 | 60.4 | 3.35502958579882 | 48 | 19 | 85.2 | 0 | 26 | 169 | 73 | 120 | CAF2108020.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 567 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28621648 | 28621648 | PRJNA274362_S_NODE_37347_length_162_cov_1.159292_g37227_i0 | PRJNA274362 | 37347 | 162 | 1.159292 | 1.87805304 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 78.2 | 3.31e-15 | NR | CAF0918362.1 | 1234261 | g37227 | i0 | 70 | 5.59259259259259 | 50 | 15 | 92.6 | 0 | 157 | 8 | 225 | 274 | CAF0918362.1 unnamed protein product [Didymodactylos carnosus] | diamond | 906 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 29410761 | 29410761 | PRJNA274362_S_NODE_36049_length_164_cov_0.904348_g35929_i0 | PRJNA274362 | 36049 | 164 | 0.904348 | 1.48313072 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 53.9 | 1.45e-6 | NR | UJR16642.1 | 104782 | g35929 | i0 | 44.4 | 2.67073170731707 | 54 | 29 | 98.8 | 1 | 2 | 163 | 705 | 757 | UJR16642.1 hypothetical protein I4U23_003542 [Adineta vaga] | diamond | 438 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29789612 | 29789612 | PRJNA274362_S_NODE_1531_length_637_cov_2.180272_g1428_i0 | PRJNA274362 | 1531 | 637 | 2.180272 | 13.88833264 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 120 | 5.089999999999999e-31 | NR | CAF3440507.1 | 2762512 | g1428 | i0 | 87 | 0.324960753532182 | 69 | 9 | 32.5 | 0 | 606 | 400 | 1 | 69 | CAF3440507.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 207 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 30136872 | 30136872 | PRJNA274362_S_NODE_24932_length_188_cov_2.791367_g24812_i0 | PRJNA274362 | 24932 | 188 | 2.791367 | 5.24776996 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 93.2 | 9.76e-22 | NR | CAF1372926.1 | 1234261 | g24812 | i0 | 64.5 | 6.92553191489362 | 62 | 22 | 98.9 | 0 | 187 | 2 | 10 | 71 | CAF1372926.1 unnamed protein product [Didymodactylos carnosus] | diamond | 1302 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 30611052 | 30611052 | PRJNA274362_S_NODE_14753_length_234_cov_0.843243_g14633_i0 | PRJNA274362 | 14753 | 234 | 0.843243 | 1.97318862 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 65.9 | 6.3e-11 | NR | CAF3661720.1 | 2762511 | g14633 | i0 | 45.7 | 2.69230769230769 | 70 | 38 | 89.7 | 0 | 6 | 215 | 137 | 206 | CAF3661720.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 630 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 32872740 | 32872740 | PRJNA274362_S_NODE_23940_length_191_cov_2.197183_g23820_i0 | PRJNA274362 | 23940 | 191 | 2.197183 | 4.19661953 | Philodinidae | 44580 | Rotifera | other_Eukaryota | 55.5 | 3.06e-7 | NR | CAF1372926.1 | 1234261 | g23820 | i0 | 40.3 | 9.78534031413612 | 62 | 37 | 97.4 | 0 | 191 | 6 | 54 | 115 | CAF1372926.1 unnamed protein product [Didymodactylos carnosus] | diamond | 1869 | 55.8 | 0.99462365591397806 | 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);;