contig_metadata
12 rows where bioproject = "PRJNA432257", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10633297 | 10633297 | PRJNA432257_S_NODE_2409_length_693_cov_73.952744_g2258_i0 | PRJNA432257 | 2409 | 693 | 73.952744 | 512.49251592 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 372 | 2.08e-122 | NR | CAF0858276.1 | 104777 | g2258 | i0 | 83.6 | 1.95238095238095 | 219 | 31 | 93.5 | 2 | 44 | 691 | 445 | 661 | CAF0858276.1 unnamed protein product [Brachionus calyciflorus] | diamond | 1353 | 372 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 26680641 | 26680641 | PRJNA432257_S_NODE_53101_length_226_cov_2.253968_g52720_i0 | PRJNA432257 | 53101 | 226 | 2.253968 | 5.0939676800000004 | root | 1 | Root_unresolved | Root_unresolved | 89 | 1.34e-18 | NR | CAF0950252.1 | 249248 | g52720 | i0 | 58.9 | 5.77433628318584 | 73 | 30 | 96.9 | 0 | 226 | 8 | 198 | 270 | CAF0950252.1 unnamed protein product [Adineta ricciae] | diamond | 1305 | 89.4 | 0.995525727069351 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27360442 | 27360442 | PRJNA432257_S_NODE_3843_length_576_cov_54.897959_g3617_i0 | PRJNA432257 | 3843 | 576 | 54.897959 | 316.21224384 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 191 | 8.79e-57 | NR | CAF1126899.1 | 433720 | g3617 | i0 | 54.1 | 2.6875 | 172 | 78 | 89.1 | 1 | 18 | 530 | 119 | 290 | CAF1126899.1 unnamed protein product [Adineta steineri] | diamond | 1548 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28355446 | 28355446 | PRJNA432257_S_NODE_59246_length_217_cov_1.950000_g58865_i0 | PRJNA432257 | 59246 | 217 | 1.95 | 4.2315 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 99 | 4.659999999999999e-23 | NR | UJR37604.1 | 104782 | g58865 | i0 | 60.6 | 5.59907834101382 | 71 | 27 | 98.2 | 1 | 2 | 214 | 223 | 292 | UJR37604.1 hypothetical protein I4U23_030301 [Adineta vaga] | diamond | 1215 | 99.8 | 0.991983967935872 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 28907192 | 28907192 | PRJNA432257_S_NODE_58508_length_218_cov_1.939227_g58127_i0 | PRJNA432257 | 58508 | 218 | 1.939227 | 4.22751486 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 56.6 | 9.98e-8 | NR | CAF0842191.1 | 104777 | g58127 | i0 | 50 | 0.715596330275229 | 52 | 26 | 71.6 | 0 | 216 | 61 | 47 | 98 | CAF0842191.1 unnamed protein product [Brachionus calyciflorus] | diamond | 156 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29160253 | 29160253 | PRJNA432257_S_NODE_122969_length_154_cov_2.034188_g122588_i0 | PRJNA432257 | 122969 | 154 | 2.034188 | 3.13264952 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 56.2 | 1.91e-7 | NR | CAF0832369.1 | 433720 | g122588 | i0 | 56.8 | 0.857142857142857 | 44 | 19 | 85.7 | 0 | 23 | 154 | 282 | 325 | CAF0832369.1 unnamed protein product [Adineta steineri] | diamond | 132 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29696436 | 29696436 | PRJNA432257_S_NODE_88470_length_185_cov_35.527027_g88089_i0 | PRJNA432257 | 88470 | 185 | 35.527027 | 65.72499995 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 62.8 | 3.7e-10 | NR | CAF3496816.1 | 2762511 | g88089 | i0 | 57.1 | 2.38378378378378 | 49 | 21 | 79.5 | 0 | 152 | 6 | 97 | 145 | CAF3496816.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 441 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 30534552 | 30534552 | PRJNA432257_S_NODE_55013_length_223_cov_2.220430_g54632_i0 | PRJNA432257 | 55013 | 223 | 2.22043 | 4.9515589 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 91.3 | 6.33e-22 | NR | CAF1267284.1 | 249248 | g54632 | i0 | 97.9 | 5.05829596412556 | 47 | 1 | 63.2 | 0 | 223 | 83 | 55 | 101 | CAF1267284.1 unnamed protein product [Adineta ricciae] | diamond | 1128 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30928936 | 30928936 | PRJNA432257_S_NODE_11154_length_393_cov_3.662921_g10786_i0 | PRJNA432257 | 11154 | 393 | 3.662921 | 14.39527953 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 147 | 2.62e-38 | NR | RNA03977.1 | 10195 | g10786 | i0 | 64.8 | 0.931297709923664 | 122 | 42 | 93.1 | 1 | 376 | 11 | 615 | 735 | RNA03977.1 nucleolar MIF4G domain-containing 1 [Brachionus plicatilis] | diamond | 366 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30977080 | 30977080 | PRJNA432257_S_NODE_85854_length_187_cov_162.140000_g85473_i0 | PRJNA432257 | 85854 | 187 | 162.14 | 303.2018 | Adineta | 104781 | Rotifera | other_Eukaryota | 68.2 | 1.93e-11 | NR | CAF0906268.1 | 249248 | g85473 | i0 | 100 | 1.82887700534759 | 38 | 0 | 61 | 0 | 148 | 35 | 841 | 878 | CAF0906268.1 unnamed protein product [Adineta ricciae] | diamond | 342 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31071856 | 31071856 | PRJNA432257_S_NODE_109615_length_167_cov_1.200000_g109234_i0 | PRJNA432257 | 109615 | 167 | 1.2 | 2.004 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 88.2 | 1.27e-18 | NR | CAF3700171.1 | 433720 | g109234 | i0 | 73.5 | 5.29940119760479 | 49 | 13 | 88 | 0 | 19 | 165 | 1 | 49 | CAF3700171.1 unnamed protein product, partial [Adineta steineri] | diamond | 885 | 88.6 | 0.99548532731377 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31103188 | 31103188 | PRJNA432257_S_NODE_88715_length_185_cov_5.222973_g88334_i0 | PRJNA432257 | 88715 | 185 | 5.222973 | 9.66250005 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 43.9 | 0.00395 | NR | CAF0762083.1 | 433720 | g88334 | i0 | 87.5 | 0.794594594594595 | 24 | 3 | 38.9 | 0 | 151 | 80 | 139 | 162 | CAF0762083.1 unnamed protein product [Adineta steineri] | diamond | 147 | 43.9 | 1 | 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);;