contig_metadata
11 rows where bioproject = "PRJNA1108009", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6591057 | 6591057 | PRJNA1108009_P_NODE_21706_length_274_cov_1.318408_g21388_i0 | PRJNA1108009 | 21706 | 274 | 1.318408 | 3.61243792 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 132 | 3.1400000000000003e-26 | NTclustered | gi|1066800225|gb|KX364936.1| | 96890 | g21388 | i0 | 85.294 | 46.6970802919708 | 136 | 10 | 50 | 6 | 139 | 274 | 9474 | 9599 | Brachionus rotundiformis chromosome I mitochondrion, complete sequence | blastn | 12795 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis | |
| 15515633 | 15515633 | PRJNA1108009_P_NODE_24153_length_254_cov_1.701657_g23835_i0 | PRJNA1108009 | 24153 | 254 | 1.701657 | 4.32220878 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 110 | 1.41e-27 | NR | KAI3378587.1 | 104778 | g23835 | i0 | 66.7 | 0.885826771653543 | 75 | 25 | 88.6 | 0 | 29 | 253 | 1 | 75 | KAI3378587.1 hypothetical protein SNEBB_007110 [Seison nebaliae] | diamond | 225 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 23165267 | 23165267 | PRJNA1108009_P_NODE_22339_length_269_cov_1.122449_g22021_i0 | PRJNA1108009 | 22339 | 269 | 1.122449 | 3.01938781 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 324 | 4.73e-84 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g22021 | i0 | 88.848 | 5.31598513011152 | 269 | 23 | 99 | 5 | 1 | 266 | 2111 | 2375 | Philodina citrina complete mitochondrial genome | blastn | 1430 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 27352427 | 27352427 | PRJNA1108009_P_NODE_26123_length_249_cov_0.875000_g25805_i0 | PRJNA1108009 | 26123 | 249 | 0.875 | 2.17875 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 85.1 | 2.59e-17 | NR | CCA94471.1 | 468664 | g25805 | i0 | 81.6 | 1.18072289156627 | 49 | 9 | 59 | 0 | 78 | 224 | 112 | 160 | CCA94471.1 Cytochrome B [Philodina citrina] | diamond | 294 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 27857328 | 27857328 | PRJNA1108009_P_NODE_24945_length_251_cov_0.865169_g24627_i0 | PRJNA1108009 | 24945 | 251 | 0.865169 | 2.17157419 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 45.8 | 0.00327 | NR | CAF1508723.1 | 392033 | g24627 | i0 | 33.3 | 1.86454183266932 | 78 | 52 | 93.2 | 0 | 243 | 10 | 353 | 430 | CAF1508723.1 unnamed protein product, partial [Rotaria sordida] | diamond | 468 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 30280595 | 30280595 | PRJNA1108009_P_NODE_28112_length_246_cov_0.890173_g27794_i0 | PRJNA1108009 | 28112 | 246 | 0.890173 | 2.18982558 | root | 1 | Root_unresolved | Root_unresolved | 55.8 | 9.33e-7 | NR | CAF0767582.1 | 1234261 | g27794 | i0 | 55.8 | 2.10975609756098 | 43 | 19 | 52.4 | 0 | 245 | 117 | 981 | 1023 | CAF0767582.1 unnamed protein product [Didymodactylos carnosus] | diamond | 519 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 30731176 | 30731176 | PRJNA1108009_P_NODE_30954_length_242_cov_0.911243_g30636_i0 | PRJNA1108009 | 30954 | 242 | 0.911243 | 2.20520806 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 85.1 | 3.77e-17 | NR | CAF2677723.1 | 2762512 | g30636 | i0 | 49.4 | 4.77272727272727 | 77 | 36 | 91.7 | 1 | 223 | 2 | 222 | 298 | CAF2677723.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 1155 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 31078904 | 31078904 | PRJNA1108009_P_NODE_21675_length_274_cov_1.557214_g21357_i0 | PRJNA1108009 | 21675 | 274 | 1.557214 | 4.26676636 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 94.4 | 4.08e-20 | NR | CAF0828795.1 | 433720 | g21357 | i0 | 50.5 | 10.7846715328467 | 93 | 41 | 98.5 | 2 | 271 | 2 | 2448 | 2538 | CAF0828795.1 unnamed protein product [Adineta steineri] | diamond | 2955 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31110167 | 31110167 | PRJNA1108009_P_NODE_20955_length_280_cov_1.285024_g20637_i0 | PRJNA1108009 | 20955 | 280 | 1.285024 | 3.5980672 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 45.4 | 0.00682 | NR | UJR09469.1 | 104782 | g20637 | i0 | 39.5 | 1.56428571428571 | 43 | 26 | 46.1 | 0 | 152 | 280 | 1220 | 1262 | UJR09469.1 hypothetical protein I4U23_013707 [Adineta vaga] | diamond | 438 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31354656 | 31354656 | PRJNA1108009_P_NODE_21696_length_274_cov_1.467662_g21378_i0 | PRJNA1108009 | 21696 | 274 | 1.467662 | 4.02139388 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 43.9 | 0.0209 | NR | UJR26290.1 | 104782 | g21378 | i0 | 37.3 | 4.6970802919708 | 51 | 30 | 53.6 | 1 | 148 | 2 | 193 | 243 | UJR26290.1 hypothetical protein I4U23_007628 [Adineta vaga] | diamond | 1287 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31584872 | 31584872 | PRJNA1108009_P_NODE_29296_length_244_cov_1.356725_g28978_i0 | PRJNA1108009 | 29296 | 244 | 1.356725 | 3.310409 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 115 | 1.11e-29 | NR | CAF0767949.1 | 104777 | g28978 | i0 | 80.2 | 0.995901639344262 | 81 | 16 | 99.6 | 0 | 243 | 1 | 23 | 103 | CAF0767949.1 unnamed protein product [Brachionus calyciflorus] | diamond | 243 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus |
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);;