contig_metadata
27 rows where bioproject = "PRJNA1061474", tax_phylum = "Rotifera" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2728417 | 2728417 | PRJNA1061474_P_NODE_18483_length_460_cov_3.702842_g18237_i0 | PRJNA1061474 | 18483 | 460 | 3.702842 | 17.0330732 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 477 | 6.219999999999998e-130 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g18237 | i0 | 85.996 | 28.2434782608696 | 457 | 50 | 98 | 12 | 3 | 454 | 1732 | 2179 | Philodina citrina complete mitochondrial genome | blastn | 12992 | 477 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 9106042 | 9106042 | PRJNA1061474_P_NODE_35128_length_307_cov_1.260684_g34882_i0 | PRJNA1061474 | 35128 | 307 | 1.260684 | 3.87029988 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 196 | 6.389999999999999e-61 | NR | CAF1146830.1 | 433720 | g34882 | i0 | 92.8 | 2.84364820846906 | 97 | 7 | 94.8 | 0 | 291 | 1 | 76 | 172 | CAF1146830.1 unnamed protein product [Adineta steineri] | diamond | 873 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 11656477 | 11656477 | PRJNA1061474_P_NODE_19330_length_448_cov_1.122667_g19084_i0 | PRJNA1061474 | 19330 | 448 | 1.122667 | 5.02954816 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 263 | 6.359999999999998e-88 | NR | CAF0719423.1 | 2762511 | g19084 | i0 | 93.3 | 0.904017857142857 | 135 | 9 | 90.4 | 0 | 43 | 447 | 1 | 135 | CAF0719423.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 405 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 19304213 | 19304213 | PRJNA1061474_P_NODE_36096_length_301_cov_1.254386_g35850_i0 | PRJNA1061474 | 36096 | 301 | 1.254386 | 3.77570186 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 159 | 7.69e-48 | NR | CAF1123272.1 | 249248 | g35850 | i0 | 100 | 0.857142857142857 | 86 | 0 | 85.7 | 0 | 1 | 258 | 71 | 156 | CAF1123272.1 unnamed protein product [Adineta ricciae] | diamond | 258 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 19304812 | 19304812 | PRJNA1061474_P_NODE_58216_length_236_cov_2.073620_g57970_i0 | PRJNA1061474 | 58216 | 236 | 2.07362 | 4.8937432 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 84 | 6.59e-19 | NR | CAF1092220.1 | 249248 | g57970 | i0 | 97.7 | 0.546610169491525 | 43 | 1 | 54.7 | 0 | 159 | 31 | 1 | 43 | CAF1092220.1 unnamed protein product [Adineta ricciae] | diamond | 129 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 21855873 | 21855873 | PRJNA1061474_P_NODE_54458_length_244_cov_0.900585_g54212_i0 | PRJNA1061474 | 54458 | 244 | 0.900585 | 2.1974274 | Brachionus | 10194 | Rotifera | other_Eukaryota | 93.2 | 5.82e-20 | NR | YP_001739869.1 | 10195 | g54212 | i0 | 67.1 | 4.25409836065574 | 73 | 24 | 89.8 | 0 | 221 | 3 | 88 | 160 | YP_001739869.1 NADH dehydrogenase subunit 5 [Brachionus plicatilis] | diamond | 1038 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 23131218 | 23131218 | PRJNA1061474_P_NODE_50019_length_247_cov_0.885057_g49773_i0 | PRJNA1061474 | 50019 | 247 | 0.885057 | 2.18609079 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 147 | 1.56e-40 | NR | CAF1022645.1 | 249248 | g49773 | i0 | 92.7 | 1.9919028340081 | 82 | 6 | 99.6 | 0 | 246 | 1 | 3 | 84 | CAF1022645.1 unnamed protein product [Adineta ricciae] | diamond | 492 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 26750165 | 26750165 | PRJNA1061474_P_NODE_46861_length_250_cov_0.870056_g46615_i0 | PRJNA1061474 | 46861 | 250 | 0.870056 | 2.17514 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 129 | 2.61e-33 | NR | CAF0940899.1 | 249248 | g46615 | i0 | 74.1 | 2.916 | 81 | 21 | 97.2 | 0 | 249 | 7 | 244 | 324 | CAF0940899.1 unnamed protein product [Adineta ricciae] | diamond | 729 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27098653 | 27098653 | PRJNA1061474_P_NODE_22162_length_412_cov_0.893805_g21916_i0 | PRJNA1061474 | 22162 | 412 | 0.893805 | 3.6824766 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 223 | 8.4e-72 | NR | CAF0944959.1 | 249248 | g21916 | i0 | 82.5 | 1.99514563106796 | 137 | 24 | 99.8 | 0 | 2 | 412 | 1 | 137 | CAF0944959.1 unnamed protein product [Adineta ricciae] | diamond | 822 | 223 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27691046 | 27691046 | PRJNA1061474_P_NODE_30124_length_339_cov_0.943609_g29878_i0 | PRJNA1061474 | 30124 | 339 | 0.943609 | 3.19883451 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47 | 0.00305 | NR | CAF0890753.1 | 104777 | g29878 | i0 | 48.9 | 1.84955752212389 | 45 | 23 | 39.8 | 0 | 337 | 203 | 138 | 182 | CAF0890753.1 unnamed protein product [Brachionus calyciflorus] | diamond | 627 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27793740 | 27793740 | PRJNA1061474_P_NODE_55384_length_243_cov_0.905882_g55138_i0 | PRJNA1061474 | 55384 | 243 | 0.905882 | 2.20129326 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 139 | 1.8299999999999999e-38 | NR | CAF1536726.1 | 249248 | g55138 | i0 | 85.5 | 0.938271604938272 | 76 | 11 | 93.8 | 0 | 15 | 242 | 178 | 253 | CAF1536726.1 unnamed protein product [Adineta ricciae] | diamond | 228 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27825306 | 27825306 | PRJNA1061474_P_NODE_41744_length_270_cov_1.385787_g41498_i0 | PRJNA1061474 | 41744 | 270 | 1.385787 | 3.7416249 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 187 | 2.459999999999999e-55 | NR | CAF0779479.1 | 249248 | g41498 | i0 | 93.3 | 4 | 90 | 6 | 100 | 0 | 270 | 1 | 55 | 144 | CAF0779479.1 unnamed protein product [Adineta ricciae] | diamond | 1080 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27856676 | 27856676 | PRJNA1061474_P_NODE_45525_length_251_cov_0.865169_g45279_i0 | PRJNA1061474 | 45525 | 251 | 0.865169 | 2.17157419 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 152 | 8.69e-41 | NR | UJR14866.1 | 104782 | g45279 | i0 | 96.4 | 1.9840637450199201 | 83 | 3 | 99.2 | 0 | 2 | 250 | 344 | 426 | UJR14866.1 hypothetical protein I4U23_001851 [Adineta vaga] | diamond | 498 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 28614591 | 28614591 | PRJNA1061474_P_NODE_47007_length_250_cov_0.870056_g46761_i0 | PRJNA1061474 | 47007 | 250 | 0.870056 | 2.17514 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 152 | 1.9699999999999998e-42 | NR | CAF0841501.1 | 249248 | g46761 | i0 | 92.8 | 0.996 | 83 | 6 | 99.6 | 0 | 1 | 249 | 224 | 306 | CAF0841501.1 unnamed protein product [Adineta ricciae] | diamond | 249 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28962094 | 28962094 | PRJNA1061474_P_NODE_41748_length_270_cov_1.345178_g41502_i0 | PRJNA1061474 | 41748 | 270 | 1.345178 | 3.6319806 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 62 | 5.92e-10 | NR | CAF3973119.1 | 433720 | g41502 | i0 | 57.3 | 0.988888888888889 | 89 | 38 | 98.9 | 0 | 3 | 269 | 14 | 102 | CAF3973119.1 unnamed protein product, partial [Adineta steineri] | diamond | 267 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29151676 | 29151676 | PRJNA1061474_P_NODE_48449_length_249_cov_0.875000_g48203_i0 | PRJNA1061474 | 48449 | 249 | 0.875 | 2.17875 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 162 | 5.64e-47 | NR | CAF0734850.1 | 249248 | g48203 | i0 | 92.7 | 0.987951807228916 | 82 | 6 | 98.8 | 0 | 3 | 248 | 13 | 94 | CAF0734850.1 unnamed protein product [Adineta ricciae] | diamond | 246 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29592928 | 29592928 | PRJNA1061474_P_NODE_48250_length_249_cov_0.875000_g48004_i0 | PRJNA1061474 | 48250 | 249 | 0.875 | 2.17875 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 134 | 1.74e-34 | NR | CAF0849888.1 | 249248 | g48004 | i0 | 85.5 | 1 | 83 | 11 | 100 | 1 | 249 | 1 | 536 | 617 | CAF0849888.1 unnamed protein product [Adineta ricciae] | diamond | 249 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29624422 | 29624422 | PRJNA1061474_P_NODE_50830_length_247_cov_0.885057_g50584_i0 | PRJNA1061474 | 50830 | 247 | 0.885057 | 2.18609079 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 53.1 | 8.63e-6 | NR | CAF0853347.1 | 433720 | g50584 | i0 | 68.6 | 0.425101214574899 | 35 | 11 | 42.5 | 0 | 122 | 226 | 873 | 907 | CAF0853347.1 unnamed protein product [Adineta steineri] | diamond | 105 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29624428 | 29624428 | PRJNA1061474_P_NODE_54230_length_244_cov_0.900585_g53984_i0 | PRJNA1061474 | 54230 | 244 | 0.900585 | 2.1974274 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 117 | 2.87e-28 | NR | CAF0782761.1 | 249248 | g53984 | i0 | 92.9 | 0.860655737704918 | 70 | 5 | 86.1 | 0 | 2 | 211 | 1419 | 1488 | CAF0782761.1 unnamed protein product [Adineta ricciae] | diamond | 210 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29679494 | 29679494 | PRJNA1061474_P_NODE_47090_length_250_cov_0.870056_g46844_i0 | PRJNA1061474 | 47090 | 250 | 0.870056 | 2.17514 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 170 | 8.08e-49 | NR | CAF1668876.1 | 249248 | g46844 | i0 | 100 | 12.948 | 83 | 0 | 99.6 | 0 | 250 | 2 | 94 | 176 | CAF1668876.1 unnamed protein product [Adineta ricciae] | diamond | 3237 | 170 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30572373 | 30572373 | PRJNA1061474_P_NODE_49493_length_248_cov_0.880000_g49247_i0 | PRJNA1061474 | 49493 | 248 | 0.88 | 2.1824 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 143 | 1.54e-38 | NR | CAF1289936.1 | 249248 | g49247 | i0 | 96.1 | 0.931451612903226 | 77 | 3 | 93.1 | 0 | 3 | 233 | 386 | 462 | CAF1289936.1 unnamed protein product [Adineta ricciae] | diamond | 231 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30920358 | 30920358 | PRJNA1061474_P_NODE_31614_length_329_cov_0.902344_g31368_i0 | PRJNA1061474 | 31614 | 329 | 0.902344 | 2.96871176 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 224 | 2.14e-71 | NR | CAF0761763.1 | 249248 | g31368 | i0 | 99.1 | 0.993920972644377 | 109 | 1 | 99.4 | 0 | 3 | 329 | 56 | 164 | CAF0761763.1 unnamed protein product [Adineta ricciae] | diamond | 327 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31457673 | 31457673 | PRJNA1061474_P_NODE_40796_length_275_cov_1.524752_g40550_i0 | PRJNA1061474 | 40796 | 275 | 1.524752 | 4.193068 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 162 | 1.62e-45 | NR | CAF0832000.1 | 249248 | g40550 | i0 | 94.4 | 0.981818181818182 | 90 | 5 | 98.2 | 0 | 274 | 5 | 215 | 304 | CAF0832000.1 unnamed protein product [Adineta ricciae] | diamond | 270 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31995360 | 31995360 | PRJNA1061474_P_NODE_57818_length_241_cov_0.916667_g57572_i0 | PRJNA1061474 | 57818 | 241 | 0.916667 | 2.20916747 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 138 | 3.26e-39 | NR | CAF1326404.1 | 249248 | g57572 | i0 | 89.7 | 0.970954356846473 | 78 | 8 | 97.1 | 0 | 235 | 2 | 1 | 78 | CAF1326404.1 unnamed protein product [Adineta ricciae] | diamond | 234 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32090246 | 32090246 | PRJNA1061474_P_NODE_53958_length_244_cov_0.900585_g53712_i0 | PRJNA1061474 | 53958 | 244 | 0.900585 | 2.1974274 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 73.6 | 3.31e-13 | NR | CAF1161203.1 | 249248 | g53712 | i0 | 84 | 0.614754098360656 | 50 | 5 | 57.8 | 1 | 228 | 88 | 1 | 50 | CAF1161203.1 unnamed protein product [Adineta ricciae] | diamond | 150 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32406710 | 32406710 | PRJNA1061474_P_NODE_50299_length_247_cov_0.885057_g50053_i0 | PRJNA1061474 | 50299 | 247 | 0.885057 | 2.18609079 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 165 | 9.33e-48 | NR | CAF0846607.1 | 249248 | g50053 | i0 | 98.8 | 0.995951417004049 | 82 | 1 | 99.6 | 0 | 246 | 1 | 239 | 320 | CAF0846607.1 unnamed protein product [Adineta ricciae] | diamond | 246 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32525295 | 32525295 | PRJNA1061474_P_NODE_49119_length_248_cov_0.880000_g48873_i0 | PRJNA1061474 | 49119 | 248 | 0.88 | 2.1824 | Adineta | 104781 | Rotifera | other_Eukaryota | 56.6 | 1.73e-7 | NR | CAF1177784.1 | 249248 | g48873 | i0 | 95.3 | 2.06854838709677 | 43 | 2 | 52 | 0 | 246 | 118 | 18 | 60 | CAF1177784.1 unnamed protein product [Adineta ricciae] | diamond | 513 | 57 | 0.992982456140351 | 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);;