contig_metadata
15 rows where bioproject = "PRJNA793147" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7156722 | 7156722 | PRJNA793147_P_NODE_63426_length_214_cov_2.055172_g63160_i0 | PRJNA793147 | 63426 | 214 | 2.055172 | 4.39806808 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 94 | 7.94e-22 | NR | KAI3380233.1 | 104778 | g63160 | i0 | 68.4 | 1.5981308411215 | 57 | 18 | 79.9 | 0 | 43 | 213 | 143 | 199 | KAI3380233.1 hypothetical protein SNEBB_010801 [Seison nebaliae] | diamond | 342 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 10981708 | 10981708 | PRJNA793147_P_NODE_3489_length_1011_cov_23.877919_g3300_i0 | PRJNA793147 | 3489 | 1011 | 23.877919 | 241.40576109 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 276 | 1.75e-85 | NR | CAF1213640.1 | 392033 | g3300 | i0 | 47.4 | 9.49851632047478 | 310 | 155 | 89.9 | 6 | 50 | 958 | 195 | 503 | CAF1213640.1 unnamed protein product [Rotaria sordida] | diamond | 9603 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 13530984 | 13530984 | PRJNA793147_P_NODE_12071_length_494_cov_3.211765_g11806_i0 | PRJNA793147 | 12071 | 494 | 3.211765 | 15.8661191 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 248 | 7.62e-79 | NR | RNA34891.1 | 10195 | g11806 | i0 | 73 | 5.93927125506073 | 163 | 44 | 99 | 0 | 494 | 6 | 199 | 361 | RNA34891.1 putative isocitrate dehydrogenase [NAD] subunit mitochondrial isoform X2 [Brachionus plicatilis] | diamond | 2934 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27306783 | 27306783 | PRJNA793147_P_NODE_21263_length_361_cov_5.828767_g20997_i0 | PRJNA793147 | 21263 | 361 | 5.828767 | 21.04184887 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 77.8 | 7.99e-16 | NR | KAI3380542.1 | 104778 | g20997 | i0 | 40.7 | 0.756232686980609 | 91 | 54 | 75.6 | 0 | 14 | 286 | 11 | 101 | KAI3380542.1 hypothetical protein SNEBB_010553 [Seison nebaliae] | diamond | 273 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 28294623 | 28294623 | PRJNA793147_P_NODE_50506_length_235_cov_1.734940_g50240_i0 | PRJNA793147 | 50506 | 235 | 1.73494 | 4.077109 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 50.4 | 6.49e-5 | NR | UJR28749.1 | 104782 | g50240 | i0 | 41.6 | 5.82127659574468 | 77 | 32 | 97 | 2 | 232 | 5 | 51 | 115 | UJR28749.1 hypothetical protein I4U23_009976 [Adineta vaga] | diamond | 1368 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 28790557 | 28790557 | PRJNA793147_P_NODE_28927_length_310_cov_1.792531_g28661_i0 | PRJNA793147 | 28927 | 310 | 1.792531 | 5.5568461 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 43.5 | 0.0383 | NR | CAF1003086.1 | 104777 | g28661 | i0 | 34.8 | 0.667741935483871 | 69 | 43 | 64.8 | 1 | 221 | 21 | 145 | 213 | CAF1003086.1 unnamed protein product [Brachionus calyciflorus] | diamond | 207 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29642871 | 29642871 | PRJNA793147_P_NODE_37030_length_276_cov_1.729469_g36764_i0 | PRJNA793147 | 37030 | 276 | 1.729469 | 4.77333444 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 83.6 | 6.92e-18 | NR | CAF1076524.1 | 104777 | g36764 | i0 | 44 | 0.989130434782609 | 91 | 50 | 98.9 | 1 | 275 | 3 | 65 | 154 | CAF1076524.1 unnamed protein product [Brachionus calyciflorus] | diamond | 273 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30116857 | 30116857 | PRJNA793147_P_NODE_37352_length_275_cov_1.398058_g37086_i0 | PRJNA793147 | 37352 | 275 | 1.398058 | 3.8446595 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 65.5 | 3.07e-10 | NR | CAF1275845.1 | 1234261 | g37086 | i0 | 39.6 | 0.992727272727273 | 91 | 46 | 99.3 | 2 | 2 | 274 | 133 | 214 | CAF1275845.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 273 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 30116859 | 30116859 | PRJNA793147_P_NODE_43412_length_256_cov_1.229947_g43146_i0 | PRJNA793147 | 43412 | 256 | 1.229947 | 3.14866432 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 134 | 5.19e-36 | NR | CAF0920811.1 | 1234261 | g43146 | i0 | 71.4 | 4.96875 | 84 | 23 | 97.3 | 1 | 8 | 256 | 165 | 248 | CAF0920811.1 unnamed protein product [Didymodactylos carnosus] | diamond | 1272 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 30379288 | 30379288 | PRJNA793147_P_NODE_37312_length_275_cov_1.718447_g37046_i0 | PRJNA793147 | 37312 | 275 | 1.718447 | 4.72572925 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 92.8 | 1.19e-19 | NR | UJR21382.1 | 104782 | g37046 | i0 | 51.3 | 9.94909090909091 | 76 | 37 | 82.9 | 0 | 235 | 8 | 41 | 116 | UJR21382.1 hypothetical protein I4U23_024474 [Adineta vaga] | diamond | 2736 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30843794 | 30843794 | PRJNA793147_P_NODE_46434_length_247_cov_1.567416_g46168_i0 | PRJNA793147 | 46434 | 247 | 1.567416 | 3.87151752 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 77.8 | 8.51e-15 | NR | RNA02720.1 | 10195 | g46168 | i0 | 43.9 | 7.96761133603239 | 82 | 46 | 99.6 | 0 | 246 | 1 | 29 | 110 | RNA02720.1 mitochondrial import receptor subunit TOM40 -like protein [Brachionus plicatilis] | diamond | 1968 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30916199 | 30916199 | PRJNA793147_P_NODE_16534_length_414_cov_3.492754_g16268_i0 | PRJNA793147 | 16534 | 414 | 3.492754 | 14.46000156 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 106 | 8.38e-27 | NR | RNA11463.1 | 10195 | g16268 | i0 | 47.5 | 4.93478260869565 | 99 | 52 | 71.7 | 0 | 5 | 301 | 2 | 100 | RNA11463.1 cytosolic thioredoxin Trx1 [Brachionus plicatilis] | diamond | 2043 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31033553 | 31033553 | PRJNA793147_P_NODE_5315_length_793_cov_4.084254_g5087_i0 | PRJNA793147 | 5315 | 793 | 4.084254 | 32.38813422 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 76.6 | 9.08e-12 | NR | CAF0935251.1 | 1234261 | g5087 | i0 | 29.8 | 3.03026481715006 | 275 | 152 | 90.4 | 9 | 3 | 719 | 338 | 607 | CAF0935251.1 unnamed protein product [Didymodactylos carnosus] | diamond | 2403 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 31096358 | 31096358 | PRJNA793147_P_NODE_57235_length_230_cov_0.894410_g56969_i0 | PRJNA793147 | 57235 | 230 | 0.89441 | 2.057143 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 62.8 | 1.81e-9 | NR | CAF1052887.1 | 392033 | g56969 | i0 | 49.3 | 8.12608695652174 | 71 | 33 | 88.7 | 2 | 204 | 1 | 96 | 166 | CAF1052887.1 unnamed protein product [Rotaria sordida] | diamond | 1869 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32266971 | 32266971 | PRJNA793147_P_NODE_36678_length_277_cov_14.274038_g36412_i0 | PRJNA793147 | 36678 | 277 | 14.274038 | 39.53908526 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 46.2 | 0.00163 | NR | CAF2736995.1 | 2762512 | g36412 | i0 | 42.6 | 1.16967509025271 | 54 | 31 | 58.5 | 0 | 228 | 67 | 84 | 137 | CAF2736995.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 324 | 46.2 | 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);;