contig_metadata
25 rows where bioproject = "PRJNA255848", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15671538 | 15671538 | PRJNA255848_P_NODE_8413_length_365_cov_0.965190_g8095_i0 | PRJNA255848 | 8413 | 365 | 0.96519 | 3.5229435 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 350 | 1.1e-91 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g8095 | i0 | 86.916 | 48.9616438356164 | 321 | 31 | 87 | 10 | 13 | 328 | 1823 | 2137 | Philodina citrina complete mitochondrial genome | blastn | 17871 | 350 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 27326927 | 27326927 | PRJNA255848_P_NODE_22983_length_208_cov_1.188679_g22665_i0 | PRJNA255848 | 22983 | 208 | 1.188679 | 2.47245232 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 123 | 5.73e-32 | NR | CAF0978879.1 | 249248 | g22665 | i0 | 87.1 | 1.00961538461538 | 70 | 8 | 99.5 | 1 | 207 | 1 | 258 | 327 | CAF0978879.1 unnamed protein product [Adineta ricciae] | diamond | 210 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27326930 | 27326930 | PRJNA255848_P_NODE_47523_length_161_cov_0.910714_g47205_i0 | PRJNA255848 | 47523 | 161 | 0.910714 | 1.46624954 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 89.7 | 1.85e-19 | NR | UJR13415.1 | 104782 | g47205 | i0 | 81.8 | 1.02484472049689 | 55 | 8 | 98.8 | 1 | 1 | 159 | 121 | 175 | UJR13415.1 hypothetical protein I4U23_000430 [Adineta vaga] | diamond | 165 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27344841 | 27344841 | PRJNA255848_P_NODE_45503_length_162_cov_0.902655_g45185_i0 | PRJNA255848 | 45503 | 162 | 0.902655 | 1.4623011 | Adineta | 104781 | Rotifera | other_Eukaryota | 99 | 1.2699999999999999e-23 | NR | UJR31597.1 | 104782 | g45185 | i0 | 88.7 | 1.96296296296296 | 53 | 6 | 98.1 | 0 | 3 | 161 | 58 | 110 | UJR31597.1 hypothetical protein I4U23_019083 [Adineta vaga] | diamond | 318 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27547918 | 27547918 | PRJNA255848_P_NODE_42984_length_163_cov_0.894737_g42666_i0 | PRJNA255848 | 42984 | 163 | 0.894737 | 1.45842131 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 100 | 4.049999999999999e-23 | NR | UJR31513.1 | 104782 | g42666 | i0 | 90.4 | 0.957055214723926 | 52 | 5 | 95.7 | 0 | 3 | 158 | 367 | 418 | UJR31513.1 hypothetical protein I4U23_019002 [Adineta vaga] | diamond | 156 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27565522 | 27565522 | PRJNA255848_P_NODE_41804_length_164_cov_0.886957_g41486_i0 | PRJNA255848 | 41804 | 164 | 0.886957 | 1.45460948 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 114 | 8.58e-29 | NR | CAF1064777.1 | 249248 | g41486 | i0 | 100 | 12.8048780487805 | 54 | 0 | 98.8 | 0 | 163 | 2 | 213 | 266 | CAF1064777.1 unnamed protein product [Adineta ricciae] | diamond | 2100 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27926857 | 27926857 | PRJNA255848_P_NODE_37185_length_166_cov_0.871795_g36867_i0 | PRJNA255848 | 37185 | 166 | 0.871795 | 1.4471797 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 90.1 | 3.72e-22 | NR | CAF0824940.1 | 249248 | g36867 | i0 | 76.4 | 0.993975903614458 | 55 | 12 | 99.4 | 1 | 166 | 2 | 13 | 66 | CAF0824940.1 unnamed protein product [Adineta ricciae] | diamond | 165 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28134170 | 28134170 | PRJNA255848_P_NODE_40205_length_165_cov_0.879310_g39887_i0 | PRJNA255848 | 40205 | 165 | 0.87931 | 1.4508615 | Adineta | 104781 | Rotifera | other_Eukaryota | 81.6 | 2.46e-16 | NR | UJR08210.1 | 104782 | g39887 | i0 | 74.1 | 2.94545454545455 | 54 | 14 | 98.2 | 0 | 164 | 3 | 428 | 481 | UJR08210.1 hypothetical protein I4U23_012483 [Adineta vaga] | diamond | 486 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 28148011 | 28148011 | PRJNA255848_P_NODE_35205_length_167_cov_0.864407_g34887_i0 | PRJNA255848 | 35205 | 167 | 0.864407 | 1.44355969 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 107 | 1.63e-25 | NR | CAF3877145.1 | 433720 | g34887 | i0 | 94.5 | 1.97604790419162 | 55 | 3 | 98.8 | 0 | 167 | 3 | 840 | 894 | CAF3877145.1 unnamed protein product [Adineta steineri] | diamond | 330 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28354979 | 28354979 | PRJNA255848_P_NODE_46146_length_162_cov_0.902655_g45828_i0 | PRJNA255848 | 46146 | 162 | 0.902655 | 1.4623011 | Rotaria | 231623 | Rotifera | other_Eukaryota | 106 | 2.94e-28 | NR | CAF5219753.1 | 392030 | g45828 | i0 | 98.1 | 4.88888888888889 | 53 | 1 | 98.1 | 0 | 161 | 3 | 2 | 54 | CAF5219753.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 792 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28905405 | 28905405 | PRJNA255848_P_NODE_37808_length_166_cov_0.871795_g37490_i0 | PRJNA255848 | 37808 | 166 | 0.871795 | 1.4471797 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 98.6 | 2.84e-22 | NR | CAF0934930.1 | 249248 | g37490 | i0 | 89.1 | 4.01204819277108 | 55 | 6 | 99.4 | 0 | 2 | 166 | 131 | 185 | CAF0934930.1 unnamed protein product [Adineta ricciae] | diamond | 666 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28968883 | 28968883 | PRJNA255848_P_NODE_40508_length_165_cov_0.879310_g40190_i0 | PRJNA255848 | 40508 | 165 | 0.87931 | 1.4508615 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 96.3 | 1.7700000000000003e-21 | NR | CAF0866686.1 | 249248 | g40190 | i0 | 89.3 | 4 | 56 | 4 | 98.2 | 1 | 164 | 3 | 666 | 721 | CAF0866686.1 unnamed protein product [Adineta ricciae] | diamond | 660 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28968885 | 28968885 | PRJNA255848_P_NODE_45728_length_162_cov_0.902655_g45410_i0 | PRJNA255848 | 45728 | 162 | 0.902655 | 1.4623011 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 105 | 7.07e-25 | NR | UJR23284.1 | 104782 | g45410 | i0 | 83 | 4.90740740740741 | 53 | 9 | 98.1 | 0 | 160 | 2 | 3257 | 3309 | UJR23284.1 hypothetical protein I4U23_026301 [Adineta vaga] | diamond | 795 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29537090 | 29537090 | PRJNA255848_P_NODE_45470_length_162_cov_0.902655_g45152_i0 | PRJNA255848 | 45470 | 162 | 0.902655 | 1.4623011 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 59.3 | 1.74e-8 | NR | UJR25623.1 | 104782 | g45152 | i0 | 76.6 | 0.87037037037037 | 47 | 11 | 87 | 0 | 142 | 2 | 2425 | 2471 | UJR25623.1 hypothetical protein I4U23_006975 [Adineta vaga] | diamond | 141 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29617654 | 29617654 | PRJNA255848_P_NODE_42030_length_164_cov_0.886957_g41712_i0 | PRJNA255848 | 42030 | 164 | 0.886957 | 1.45460948 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 109 | 4.49e-26 | NR | CAF1169039.1 | 249248 | g41712 | i0 | 96.3 | 5.92682926829268 | 54 | 2 | 98.8 | 0 | 2 | 163 | 338 | 391 | CAF1169039.1 unnamed protein product [Adineta ricciae] | diamond | 972 | 110 | 0.990909090909091 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30295601 | 30295601 | PRJNA255848_P_NODE_32432_length_174_cov_1.632000_g32114_i0 | PRJNA255848 | 32432 | 174 | 1.632 | 2.83968 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 108 | 7e-26 | NR | UJR37813.1 | 104782 | g32114 | i0 | 85.7 | 1.93103448275862 | 56 | 8 | 96.6 | 0 | 173 | 6 | 943 | 998 | UJR37813.1 hypothetical protein I4U23_030503 [Adineta vaga] | diamond | 336 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30674223 | 30674223 | PRJNA255848_P_NODE_36253_length_167_cov_0.864407_g35935_i0 | PRJNA255848 | 36253 | 167 | 0.864407 | 1.44355969 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 51.6 | 9.98e-6 | NR | UJR10546.1 | 104782 | g35935 | i0 | 58.9 | 1.0059880239521 | 56 | 22 | 98.8 | 1 | 3 | 167 | 2115 | 2170 | UJR10546.1 hypothetical protein I4U23_014746 [Adineta vaga] | diamond | 168 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30769199 | 30769199 | PRJNA255848_P_NODE_28954_length_185_cov_1.125000_g28636_i0 | PRJNA255848 | 28954 | 185 | 1.125 | 2.08125 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 113 | 1.24e-27 | NR | CAF0735499.1 | 249248 | g28636 | i0 | 86.9 | 1.97837837837838 | 61 | 8 | 98.9 | 0 | 185 | 3 | 229 | 289 | CAF0735499.1 unnamed protein product [Adineta ricciae] | diamond | 366 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31102663 | 31102663 | PRJNA255848_P_NODE_42515_length_163_cov_1.789474_g42197_i0 | PRJNA255848 | 42515 | 163 | 1.789474 | 2.91684262 | Adineta | 104781 | Rotifera | other_Eukaryota | 104 | 1.88e-24 | NR | UJR13580.1 | 104782 | g42197 | i0 | 98.1 | 9.93865030674847 | 54 | 1 | 99.4 | 0 | 163 | 2 | 430 | 483 | UJR13580.1 hypothetical protein I4U23_000593 [Adineta vaga] | diamond | 1620 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31654080 | 31654080 | PRJNA255848_P_NODE_35597_length_167_cov_0.864407_g35279_i0 | PRJNA255848 | 35597 | 167 | 0.864407 | 1.44355969 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 78.2 | 3.86e-17 | NR | CAF1042797.1 | 2762511 | g35279 | i0 | 78.9 | 1.41916167664671 | 38 | 8 | 68.3 | 0 | 2 | 115 | 57 | 94 | CAF1042797.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 237 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 31717517 | 31717517 | PRJNA255848_P_NODE_45237_length_162_cov_0.902655_g44919_i0 | PRJNA255848 | 45237 | 162 | 0.902655 | 1.4623011 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 110 | 2.02e-27 | NR | UJR30814.1 | 104782 | g44919 | i0 | 94.3 | 0.981481481481482 | 53 | 3 | 98.1 | 0 | 161 | 3 | 50 | 102 | UJR30814.1 hypothetical protein I4U23_018332 [Adineta vaga] | diamond | 159 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32002259 | 32002259 | PRJNA255848_P_NODE_41558_length_164_cov_0.886957_g41240_i0 | PRJNA255848 | 41558 | 164 | 0.886957 | 1.45460948 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 80.5 | 6.27e-16 | NR | CAF0933138.1 | 433720 | g41240 | i0 | 73.1 | 1.90243902439024 | 52 | 14 | 95.1 | 0 | 158 | 3 | 135 | 186 | CAF0933138.1 unnamed protein product [Adineta steineri] | diamond | 312 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32020023 | 32020023 | PRJNA255848_P_NODE_41118_length_164_cov_0.886957_g40800_i0 | PRJNA255848 | 41118 | 164 | 0.886957 | 1.45460948 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 89.4 | 4.31e-21 | NR | UJR16431.1 | 104782 | g40800 | i0 | 82.7 | 3.76829268292683 | 52 | 9 | 95.1 | 0 | 4 | 159 | 1 | 52 | UJR16431.1 hypothetical protein I4U23_003333 [Adineta vaga] | diamond | 618 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32318970 | 32318970 | PRJNA255848_P_NODE_33799_length_170_cov_1.388430_g33481_i0 | PRJNA255848 | 33799 | 170 | 1.38843 | 2.360331 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 72.4 | 3.09e-13 | NR | CAF1686394.1 | 249248 | g33481 | i0 | 67.3 | 1.90588235294118 | 55 | 18 | 97.1 | 0 | 3 | 167 | 34 | 88 | CAF1686394.1 unnamed protein product, partial [Adineta ricciae] | diamond | 324 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32540379 | 32540379 | PRJNA255848_P_NODE_46999_length_161_cov_0.910714_g46681_i0 | PRJNA255848 | 46999 | 161 | 0.910714 | 1.46624954 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 100 | 2.3499999999999994e-23 | NR | UJR10022.1 | 104782 | g46681 | i0 | 94 | 0.93167701863354 | 50 | 3 | 93.2 | 0 | 10 | 159 | 144 | 193 | UJR10022.1 hypothetical protein I4U23_014245 [Adineta vaga] | diamond | 150 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga |
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);;