contig_metadata
11 rows where bioproject = "PRJDB4470", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6387486 | 6387486 | PRJDB4470_P_NODE_14306_length_650_cov_3.618968_g13305_i0 | PRJDB4470 | 14306 | 650 | 3.618968 | 23.523292 | Brachionus | 10194 | Rotifera | other_Eukaryota | 286 | 7.7e-96 | NR | RNA30310.1 | 10195 | g13305 | i0 | 82.8 | 1.59692307692308 | 174 | 29 | 80.3 | 1 | 615 | 94 | 1 | 173 | RNA30310.1 calcineurin subunit B type 2 [Brachionus plicatilis] | diamond | 1038 | 286 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 14037934 | 14037934 | PRJDB4470_P_NODE_84832_length_190_cov_2.517730_g83677_i0 | PRJDB4470 | 84832 | 190 | 2.51773 | 4.783687 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 239 | 1.17e-58 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g83677 | i0 | 89.231 | 48.1368421052632 | 195 | 15 | 100 | 2 | 1 | 190 | 1960 | 1767 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 9146 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 17559220 | 17559220 | PRJDB4470_P_NODE_31874_length_403_cov_2.016949_g30727_i0 | PRJDB4470 | 31874 | 403 | 2.016949 | 8.12830447 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 671 | 0 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g30727 | i0 | 98.177 | 49.4813895781638 | 384 | 7 | 95 | 0 | 20 | 403 | 2308 | 1925 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 19941 | 676 | 0.992603550295858 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 20107965 | 20107965 | PRJDB4470_P_NODE_79916_length_199_cov_1.646667_g78761_i0 | PRJDB4470 | 79916 | 199 | 1.646667 | 3.27686733 | Ploima | 84394 | Rotifera | other_Eukaryota | 300 | 5.5900000000000004e-77 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g78761 | i0 | 93.939 | 23.9597989949749 | 198 | 12 | 99 | 0 | 1 | 198 | 1694 | 1497 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 4768 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 27032375 | 27032375 | PRJDB4470_P_NODE_84562_length_191_cov_1.239437_g83407_i0 | PRJDB4470 | 84562 | 191 | 1.239437 | 2.36732467 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 51.2 | 3.16e-6 | NR | CAF0905598.1 | 249248 | g83407 | i0 | 63.6 | 0.518324607329843 | 33 | 12 | 51.8 | 0 | 91 | 189 | 73 | 105 | CAF0905598.1 unnamed protein product [Adineta ricciae] | diamond | 99 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27948519 | 27948519 | PRJDB4470_P_NODE_75125_length_209_cov_1.237500_g73970_i0 | PRJDB4470 | 75125 | 209 | 1.2375 | 2.586375 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 90.1 | 2.7e-19 | NR | CAF3329157.1 | 2762511 | g73970 | i0 | 69.7 | 2.18181818181818 | 76 | 16 | 99 | 3 | 2 | 208 | 214 | 289 | CAF3329157.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 456 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 30664384 | 30664384 | PRJDB4470_P_NODE_69553_length_222_cov_1.161850_g68398_i0 | PRJDB4470 | 69553 | 222 | 1.16185 | 2.579307 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 117 | 1.3799999999999998e-31 | NR | CAF0775232.1 | 104777 | g68398 | i0 | 75 | 0.972972972972973 | 72 | 18 | 97.3 | 0 | 5 | 220 | 5 | 76 | CAF0775232.1 unnamed protein product [Brachionus calyciflorus] | diamond | 216 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31075225 | 31075225 | PRJDB4470_P_NODE_40295_length_342_cov_1.744027_g39143_i0 | PRJDB4470 | 40295 | 342 | 1.744027 | 5.96457234 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 172 | 5.74e-48 | NR | CAF0976858.1 | 104777 | g39143 | i0 | 71.7 | 0.991228070175439 | 113 | 31 | 99.1 | 1 | 4 | 342 | 65 | 176 | CAF0976858.1 unnamed protein product [Brachionus calyciflorus] | diamond | 339 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31391438 | 31391438 | PRJDB4470_P_NODE_89756_length_183_cov_1.522388_g88601_i0 | PRJDB4470 | 89756 | 183 | 1.522388 | 2.78597004 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 53.5 | 7.85e-7 | NR | CAF1045442.1 | 104777 | g88601 | i0 | 60 | 0.655737704918033 | 40 | 16 | 65.6 | 0 | 179 | 60 | 83 | 122 | CAF1045442.1 unnamed protein product [Brachionus calyciflorus] | diamond | 120 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32530408 | 32530408 | PRJDB4470_P_NODE_46119_length_309_cov_1.600000_g44966_i0 | PRJDB4470 | 46119 | 309 | 1.6 | 4.944 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 176 | 5.2e-52 | NR | CAF0768596.1 | 104777 | g44966 | i0 | 79.4 | 0.990291262135922 | 102 | 21 | 99 | 0 | 3 | 308 | 135 | 236 | CAF0768596.1 unnamed protein product [Brachionus calyciflorus] | diamond | 306 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32870809 | 32870809 | PRJDB4470_P_NODE_118880_length_163_cov_0.912281_g117725_i0 | PRJDB4470 | 118880 | 163 | 0.912281 | 1.48701803 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67.4 | 7.48e-12 | NR | AFQ96956.1 | 104786 | g117725 | i0 | 77.8 | 1.98773006134969 | 36 | 8 | 66.3 | 0 | 56 | 163 | 160 | 195 | AFQ96956.1 cytochrome c oxidase subunit 2 [Habrotrocha constricta] | diamond | 324 | 67.8 | 0.994100294985251 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta |
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);;