contig_metadata
17 rows where bioproject = "PRJEB81327", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6518012 | 6518012 | PRJEB81327_P_NODE_37206_length_266_cov_1.336788_g36598_i0 | PRJEB81327 | 37206 | 266 | 1.336788 | 3.55585608 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 279 | 1.03e-70 | NTclustered | gi|167842611|gb|EU188928.1| | 96446 | g36598 | i0 | 86.434 | 87.4661654135338 | 258 | 31 | 96 | 4 | 7 | 262 | 15 | 270 | Lecane bulla isolate Cattail D cytochrome oxidase subunit I-like (cox1) gene, partial sequence; mitochondrial | blastn | 23266 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 18848486 | 18848486 | PRJEB81327_P_NODE_16715_length_330_cov_1.828794_g16107_i0 | PRJEB81327 | 16715 | 330 | 1.828794 | 6.0350202 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 93.6 | 4.58e-21 | NR | CAF2066270.1 | 392030 | g16107 | i0 | 56 | 0.763636363636364 | 84 | 36 | 76.4 | 1 | 252 | 1 | 93 | 175 | CAF2066270.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 252 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 20540506 | 20540506 | PRJEB81327_P_NODE_14677_length_351_cov_2.517986_g14069_i0 | PRJEB81327 | 14677 | 351 | 2.517986 | 8.83813086 | Plationus patulus | 360686 | Rotifera | other_Eukaryota | 287 | 8.35e-73 | NTclustered | gi|83321197|gb|DQ297812.1| | 360686 | g14069 | i0 | 85.455 | 84.4529914529915 | 275 | 40 | 78 | 0 | 17 | 291 | 275 | 1 | Plationus patulus histone H3 gene, partial cds | blastn | 29643 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Plationus | Plationus patulus | |
| 23091577 | 23091577 | PRJEB81327_P_NODE_20199_length_309_cov_1.656780_g19591_i0 | PRJEB81327 | 20199 | 309 | 1.65678 | 5.1194502 | Polyarthra remata | 360693 | Rotifera | other_Eukaryota | 466 | 8.7e-127 | NTclustered | gi|83285205|gb|DQ297752.1| | 360693 | g19591 | i0 | 93.851 | 79.1909385113269 | 309 | 19 | 100 | 0 | 1 | 309 | 601 | 293 | Polyarthra remata 28S ribosomal RNA gene, partial sequence | blastn | 24470 | 466 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Synchaetidae | Polyarthra | Polyarthra remata | |
| 26781188 | 26781188 | PRJEB81327_P_NODE_26861_length_284_cov_1.454976_g26253_i0 | PRJEB81327 | 26861 | 284 | 1.454976 | 4.1321318399999996 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 61.2 | 1.97e-8 | NR | CAF3102815.1 | 2762512 | g26253 | i0 | 33.7 | 4.84859154929577 | 92 | 57 | 94 | 2 | 2 | 268 | 1215 | 1305 | CAF3102815.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 1377 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 27722390 | 27722390 | PRJEB81327_P_NODE_45424_length_252_cov_1.502793_g44816_i0 | PRJEB81327 | 45424 | 252 | 1.502793 | 3.78703836 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 62.8 | 3.64e-9 | NR | UJR35955.1 | 104782 | g44816 | i0 | 80 | 7.91666666666667 | 35 | 7 | 41.7 | 0 | 107 | 3 | 770 | 804 | UJR35955.1 hypothetical protein I4U23_028696 [Adineta vaga] | diamond | 1995 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27785345 | 27785345 | PRJEB81327_P_NODE_59104_length_244_cov_0.900585_g58496_i0 | PRJEB81327 | 59104 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 117 | 1.71e-29 | NR | CAF1018896.1 | 249248 | g58496 | i0 | 69.5 | 3.98360655737705 | 82 | 24 | 99.6 | 1 | 243 | 1 | 224 | 305 | CAF1018896.1 unnamed protein product [Adineta ricciae] | diamond | 972 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27918629 | 27918629 | PRJEB81327_P_NODE_48085_length_250_cov_0.870056_g47477_i0 | PRJEB81327 | 48085 | 250 | 0.870056 | 2.17514 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 58.9 | 8.05e-8 | NR | CAF2974361.1 | 2762512 | g47477 | i0 | 78.1 | 2.688 | 32 | 7 | 38.4 | 0 | 138 | 43 | 420 | 451 | CAF2974361.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 672 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 28455664 | 28455664 | PRJEB81327_P_NODE_9106_length_458_cov_1.332468_g8498_i0 | PRJEB81327 | 9106 | 458 | 1.332468 | 6.10270344 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 103 | 4.24e-25 | NR | CAF0711365.1 | 104777 | g8498 | i0 | 52.7 | 1.59170305676856 | 93 | 44 | 60.9 | 0 | 456 | 178 | 1 | 93 | CAF0711365.1 unnamed protein product [Brachionus calyciflorus] | diamond | 729 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28771176 | 28771176 | PRJEB81327_P_NODE_59407_length_244_cov_0.900585_g58799_i0 | PRJEB81327 | 59407 | 244 | 0.900585 | 2.1974274 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 122 | 2.55e-30 | NR | CAF1089140.1 | 433720 | g58799 | i0 | 73.5 | 3.06147540983607 | 83 | 19 | 98.4 | 1 | 242 | 3 | 517 | 599 | CAF1089140.1 unnamed protein product [Adineta steineri] | diamond | 747 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29213485 | 29213485 | PRJEB81327_P_NODE_33369_length_272_cov_1.874372_g32761_i0 | PRJEB81327 | 33369 | 272 | 1.874372 | 5.09829184 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 61.6 | 4.67e-9 | NR | UJR13957.1 | 104782 | g32761 | i0 | 45.7 | 2.27205882352941 | 70 | 33 | 72.8 | 3 | 21 | 218 | 145 | 213 | UJR13957.1 hypothetical protein I4U23_000960 [Adineta vaga] | diamond | 618 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29654891 | 29654891 | PRJEB81327_P_NODE_61790_length_243_cov_0.905882_g61182_i0 | PRJEB81327 | 61790 | 243 | 0.905882 | 2.20129326 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 43.1 | 0.0261 | NR | CAF1007324.1 | 433720 | g61182 | i0 | 34.1 | 3.58024691358025 | 85 | 49 | 100 | 3 | 243 | 1 | 23 | 104 | CAF1007324.1 unnamed protein product, partial [Adineta steineri] | diamond | 870 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 30121599 | 30121599 | PRJEB81327_P_NODE_57352_length_245_cov_0.895349_g56744_i0 | PRJEB81327 | 57352 | 245 | 0.895349 | 2.19360505 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 77 | 2.88e-14 | NR | CAF1362088.1 | 433720 | g56744 | i0 | 43.4 | 3.04897959183673 | 83 | 45 | 99.2 | 1 | 243 | 1 | 84 | 166 | CAF1362088.1 unnamed protein product [Adineta steineri] | diamond | 747 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 30223769 | 30223769 | PRJEB81327_P_NODE_50472_length_249_cov_0.875000_g49864_i0 | PRJEB81327 | 50472 | 249 | 0.875 | 2.17875 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 100 | 6.84e-25 | NR | CAF0709646.1 | 104777 | g49864 | i0 | 84.4 | 0.771084337349398 | 64 | 9 | 77.1 | 1 | 247 | 56 | 84 | 146 | CAF0709646.1 unnamed protein product [Brachionus calyciflorus] | diamond | 192 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30658880 | 30658880 | PRJEB81327_P_NODE_15213_length_346_cov_0.846154_g14605_i0 | PRJEB81327 | 15213 | 346 | 0.846154 | 2.92769284 | Metazoa | 33208 | Rotifera | other_Eukaryota | 104 | 3.129999999999999e-23 | NR | KAI3388539.1 | 104778 | g14605 | i0 | 52.2 | 4.98554913294798 | 115 | 55 | 99.7 | 0 | 346 | 2 | 15 | 129 | KAI3388539.1 hypothetical protein SNEBB_002960 [Seison nebaliae] | diamond | 1725 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 31544032 | 31544032 | PRJEB81327_P_NODE_60276_length_243_cov_2.700000_g59668_i0 | PRJEB81327 | 60276 | 243 | 2.7 | 6.561 | Adineta | 104781 | Rotifera | other_Eukaryota | 42.7 | 0.0364 | NR | UJR28940.1 | 104782 | g59668 | i0 | 67.9 | 0.691358024691358 | 28 | 9 | 34.6 | 0 | 89 | 6 | 163 | 190 | UJR28940.1 hypothetical protein I4U23_010157 [Adineta vaga] | diamond | 168 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31607204 | 31607204 | PRJEB81327_P_NODE_63356_length_242_cov_0.911243_g62748_i0 | PRJEB81327 | 63356 | 242 | 0.911243 | 2.20520806 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 79 | 6.66e-15 | NR | CAF0905594.1 | 433720 | g62748 | i0 | 68.6 | 5.65289256198347 | 51 | 16 | 63.2 | 0 | 191 | 39 | 795 | 845 | CAF0905594.1 unnamed protein product [Adineta steineri] | diamond | 1368 | 79.3 | 0.996216897856242 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri |
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);;