contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJEB58983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9052039 | 9052039 | PRJEB58983_P_NODE_19768_length_291_cov_2.068807_g19353_i0 | PRJEB58983 | 19768 | 291 | 2.068807 | 6.02022837 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 188 | 4.89e-57 | NR | RNA36125.1 | 10195 | g19353 | i0 | 94.5 | 0.938144329896907 | 91 | 5 | 93.8 | 0 | 19 | 291 | 1 | 91 | RNA36125.1 guanine nucleotide-binding subunit beta-2-like 1 [Brachionus plicatilis] | diamond | 273 | 188 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 11603309 | 11603309 | PRJEB58983_P_NODE_22910_length_275_cov_1.173267_g22495_i0 | PRJEB58983 | 22910 | 275 | 1.173267 | 3.22648425 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 164 | 2.87e-45 | NR | CAF1007883.1 | 104777 | g22495 | i0 | 85.7 | 1.98545454545455 | 91 | 13 | 99.3 | 0 | 274 | 2 | 97 | 187 | CAF1007883.1 unnamed protein product [Brachionus calyciflorus] | diamond | 546 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 14153487 | 14153487 | PRJEB58983_P_NODE_33152_length_237_cov_3.286585_g32737_i0 | PRJEB58983 | 33152 | 237 | 3.286585 | 7.78920645 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 103 | 1.22e-24 | NR | CAF0892122.1 | 104777 | g32737 | i0 | 72 | 3.84810126582278 | 75 | 21 | 94.9 | 0 | 1 | 225 | 4 | 78 | CAF0892122.1 unnamed protein product [Brachionus calyciflorus] | diamond | 912 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 26685287 | 26685287 | PRJEB58983_P_NODE_29281_length_249_cov_1.767045_g28866_i0 | PRJEB58983 | 29281 | 249 | 1.767045 | 4.39994205 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 70.9 | 4.23e-12 | NR | CAF1017436.1 | 104777 | g28866 | i0 | 43.1 | 0.867469879518072 | 72 | 39 | 85.5 | 2 | 35 | 247 | 176 | 246 | CAF1017436.1 unnamed protein product [Brachionus calyciflorus] | diamond | 216 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 26685291 | 26685291 | PRJEB58983_P_NODE_32461_length_242_cov_0.923077_g32046_i0 | PRJEB58983 | 32461 | 242 | 0.923077 | 2.23384634 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 60.5 | 2.03e-8 | NR | RNA15217.1 | 10195 | g32046 | i0 | 53.1 | 0.607438016528926 | 49 | 23 | 60.7 | 0 | 92 | 238 | 10 | 58 | RNA15217.1 Serine threonine- kinase, partial [Brachionus plicatilis] | diamond | 147 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 26938505 | 26938505 | PRJEB58983_P_NODE_18802_length_297_cov_4.441964_g18387_i0 | PRJEB58983 | 18802 | 297 | 4.441964 | 13.19263308 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 120 | 1.28e-30 | NR | CAF1646217.1 | 249248 | g18387 | i0 | 68.4 | 5.60606060606061 | 79 | 25 | 79.8 | 0 | 297 | 61 | 76 | 154 | CAF1646217.1 unnamed protein product, partial [Adineta ricciae] | diamond | 1665 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27413113 | 27413113 | PRJEB58983_P_NODE_31223_length_245_cov_0.866279_g30808_i0 | PRJEB58983 | 31223 | 245 | 0.866279 | 2.12238355 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 77 | 2.87e-14 | NR | CAF0782459.1 | 433720 | g30808 | i0 | 87.5 | 0.489795918367347 | 40 | 5 | 49 | 0 | 244 | 125 | 386 | 425 | CAF0782459.1 unnamed protein product [Adineta steineri] | diamond | 120 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 27476009 | 27476009 | PRJEB58983_P_NODE_33443_length_235_cov_3.358025_g33028_i0 | PRJEB58983 | 33443 | 235 | 3.358025 | 7.89135875 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 94.4 | 2.1500000000000003e-21 | NR | RNA11554.1 | 10195 | g33028 | i0 | 61.5 | 0.995744680851064 | 78 | 27 | 99.6 | 2 | 235 | 2 | 170 | 244 | RNA11554.1 serine protease 27-like [Brachionus plicatilis] | diamond | 234 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27602482 | 27602482 | PRJEB58983_P_NODE_25144_length_264_cov_2.806283_g24729_i0 | PRJEB58983 | 25144 | 264 | 2.806283 | 7.40858712 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 92 | 2.44e-20 | NR | RMZ98430.1 | 10195 | g24729 | i0 | 67.6 | 0.840909090909091 | 74 | 22 | 84.1 | 2 | 42 | 263 | 1 | 72 | RMZ98430.1 60S ribosomal L6-like [Brachionus plicatilis] | diamond | 222 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28359928 | 28359928 | PRJEB58983_P_NODE_25026_length_265_cov_1.531250_g24611_i0 | PRJEB58983 | 25026 | 265 | 1.53125 | 4.0578125 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 84.3 | 8.5e-19 | NR | CAF3440507.1 | 2762512 | g24611 | i0 | 85.4 | 0.543396226415094 | 48 | 7 | 54.3 | 0 | 1 | 144 | 22 | 69 | CAF3440507.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 144 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 28423409 | 28423409 | PRJEB58983_P_NODE_26646_length_258_cov_1.194595_g26231_i0 | PRJEB58983 | 26646 | 258 | 1.194595 | 3.0820551 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 125 | 1.5e-31 | NR | CAF0867764.1 | 104777 | g26231 | i0 | 68.6 | 2 | 86 | 27 | 100 | 0 | 1 | 258 | 314 | 399 | CAF0867764.1 unnamed protein product [Brachionus calyciflorus] | diamond | 516 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28833675 | 28833675 | PRJEB58983_P_NODE_34368_length_229_cov_2.551282_g33953_i0 | PRJEB58983 | 34368 | 229 | 2.551282 | 5.84243578 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 84 | 9.7e-17 | NR | CAF0778482.1 | 104777 | g33953 | i0 | 64.2 | 0.877729257641921 | 67 | 22 | 87.8 | 2 | 205 | 5 | 252 | 316 | CAF0778482.1 unnamed protein product [Brachionus calyciflorus] | diamond | 201 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29048069 | 29048069 | PRJEB58983_P_NODE_23748_length_271_cov_1.343434_g23333_i0 | PRJEB58983 | 23748 | 271 | 1.343434 | 3.64070614 | Brachionus | 10194 | Rotifera | other_Eukaryota | 120 | 1.16e-31 | NR | RNA18388.1 | 10195 | g23333 | i0 | 60 | 2.93357933579336 | 90 | 36 | 99.6 | 0 | 1 | 270 | 129 | 218 | RNA18388.1 T9SS C-terminal target domain-containing [Brachionus plicatilis] | diamond | 795 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29622578 | 29622578 | PRJEB58983_P_NODE_30030_length_247_cov_2.620690_g29615_i0 | PRJEB58983 | 30030 | 247 | 2.62069 | 6.4731043 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 79.7 | 3.88e-15 | NR | CAF0748059.1 | 104777 | g29615 | i0 | 47.6 | 0.995951417004049 | 82 | 38 | 98.4 | 3 | 243 | 1 | 407 | 484 | CAF0748059.1 unnamed protein product [Brachionus calyciflorus] | diamond | 246 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29685847 | 29685847 | PRJEB58983_P_NODE_24510_length_267_cov_2.360825_g24095_i0 | PRJEB58983 | 24510 | 267 | 2.360825 | 6.30340275 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 132 | 2.15e-33 | NR | CAF0762179.1 | 104777 | g24095 | i0 | 67.8 | 1.01123595505618 | 90 | 28 | 100 | 1 | 1 | 267 | 846 | 935 | CAF0762179.1 unnamed protein product [Brachionus calyciflorus] | diamond | 270 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30413042 | 30413042 | PRJEB58983_P_NODE_21033_length_284_cov_2.199052_g20618_i0 | PRJEB58983 | 21033 | 284 | 2.199052 | 6.24530768 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 76.6 | 7.61e-14 | NR | RNA11135.1 | 10195 | g20618 | i0 | 43.6 | 0.992957746478873 | 94 | 44 | 91.9 | 3 | 261 | 1 | 1274 | 1365 | RNA11135.1 transmembrane protein -like [Brachionus plicatilis] | diamond | 282 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31550778 | 31550778 | PRJEB58983_P_NODE_10676_length_384_cov_1.000000_g10261_i0 | PRJEB58983 | 10676 | 384 | 1 | 3.84 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 47 | 0.00603 | NR | CAF0715738.1 | 104777 | g10261 | i0 | 37.9 | 0.515625 | 66 | 41 | 51.6 | 0 | 200 | 3 | 1738 | 1803 | CAF0715738.1 unnamed protein product [Brachionus calyciflorus] | diamond | 198 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32783219 | 32783219 | PRJEB58983_P_NODE_23680_length_271_cov_1.868687_g23265_i0 | PRJEB58983 | 23680 | 271 | 1.868687 | 5.06414177 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 50.4 | 9.96e-5 | NR | CAF0869156.1 | 104777 | g23265 | i0 | 32.4 | 0.752767527675277 | 68 | 44 | 75.3 | 2 | 65 | 268 | 104 | 169 | CAF0869156.1 unnamed protein product [Brachionus calyciflorus] | diamond | 204 | 50.4 | 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);;