contig_metadata
8 rows where bioproject = "PRJNA399711", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32917375 | 32917375 | PRJNA399711_S_NODE_10905_length_336_cov_6.675585_g10763_i0 | PRJNA399711 | 10905 | 336 | 6.675585 | 22.4299656 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 48.9 | 6.41e-4 | NR | UJR37596.1 | 104782 | g10763 | i0 | 36.6 | 2.07142857142857 | 82 | 41 | 63.4 | 3 | 2 | 214 | 184 | 265 | UJR37596.1 hypothetical protein I4U23_030293 [Adineta vaga] | diamond | 696 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32934880 | 32934880 | PRJNA399711_S_NODE_56169_length_191_cov_2.000000_g56027_i0 | PRJNA399711 | 56169 | 191 | 2 | 3.82 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 89.4 | 1.27e-21 | NR | CAF1236829.1 | 433720 | g56027 | i0 | 80.4 | 2.3717277486911 | 51 | 10 | 80.1 | 0 | 190 | 38 | 27 | 77 | CAF1236829.1 unnamed protein product [Adineta steineri] | diamond | 453 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 33020186 | 33020186 | PRJNA399711_S_NODE_44532_length_207_cov_11.841176_g44390_i0 | PRJNA399711 | 44532 | 207 | 11.841176 | 24.51123432 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 59.7 | 3.61e-9 | NR | CAF5066972.1 | 2762511 | g44390 | i0 | 44.4 | 3.91304347826087 | 54 | 30 | 78.3 | 0 | 6 | 167 | 92 | 145 | CAF5066972.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 810 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 33054185 | 33054185 | PRJNA399711_S_NODE_25485_length_253_cov_4.365741_g25343_i0 | PRJNA399711 | 25485 | 253 | 4.365741 | 11.04532473 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 67.8 | 7.98e-13 | NR | CAF1144179.1 | 392033 | g25343 | i0 | 60 | 0.711462450592885 | 60 | 24 | 71.1 | 0 | 8 | 187 | 12 | 71 | CAF1144179.1 unnamed protein product [Rotaria sordida] | diamond | 180 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 33088558 | 33088558 | PRJNA399711_S_NODE_57750_length_189_cov_2.217105_g57608_i0 | PRJNA399711 | 57750 | 189 | 2.217105 | 4.19032845 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 40.8 | 0.0269 | NR | CAF1532092.1 | 249248 | g57608 | i0 | 35.4 | 0.761904761904762 | 48 | 31 | 76.2 | 0 | 6 | 149 | 9 | 56 | CAF1532092.1 unnamed protein product [Adineta ricciae] | diamond | 144 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 33105339 | 33105339 | PRJNA399711_S_NODE_16158_length_296_cov_6.490347_g16016_i0 | PRJNA399711 | 16158 | 296 | 6.490347 | 19.21142712 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 59.7 | 2.02e-9 | NR | UJR21819.1 | 104782 | g16016 | i0 | 66.7 | 0.456081081081081 | 45 | 15 | 45.6 | 0 | 100 | 234 | 27 | 71 | UJR21819.1 hypothetical protein I4U23_024893 [Adineta vaga] | diamond | 135 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 33156649 | 33156649 | PRJNA399711_S_NODE_55656_length_191_cov_6.642857_g55514_i0 | PRJNA399711 | 55656 | 191 | 6.642857 | 12.68785687 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 54.7 | 5.27e-8 | NR | CAF0994775.1 | 1234261 | g55514 | i0 | 48.1 | 0.848167539267016 | 54 | 28 | 84.8 | 0 | 1 | 162 | 18 | 71 | CAF0994775.1 unnamed protein product [Didymodactylos carnosus] | diamond | 162 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 33163036 | 33163036 | PRJNA399711_S_NODE_54328_length_193_cov_3.480769_g54186_i0 | PRJNA399711 | 54328 | 193 | 3.480769 | 6.71788417 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 74.7 | 2.88e-14 | NR | CAF1427769.1 | 433720 | g54186 | i0 | 54.8 | 5.78238341968912 | 62 | 28 | 96.4 | 0 | 190 | 5 | 7 | 68 | CAF1427769.1 unnamed protein product [Adineta steineri] | diamond | 1116 | 74.7 | 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);;