contig_metadata
12 rows where bioproject = "PRJNA980839", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27095491 | 27095491 | PRJNA980839_P_NODE_214602_length_247_cov_0.885057_g210818_i0 | PRJNA980839 | 214602 | 247 | 0.885057 | 2.18609079 | Adineta | 104781 | Rotifera | other_Eukaryota | 127 | 1.4799999999999998e-32 | NR | UJR24592.1 | 104782 | g210818 | i0 | 97.1 | 5.78137651821862 | 68 | 2 | 82.6 | 0 | 205 | 2 | 108 | 175 | UJR24592.1 hypothetical protein I4U23_005967 [Adineta vaga] | diamond | 1428 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27879133 | 27879133 | PRJNA980839_P_NODE_192225_length_254_cov_1.640884_g188441_i0 | PRJNA980839 | 192225 | 254 | 1.640884 | 4.16784536 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 65.5 | 4.12e-10 | NR | CAF3609291.1 | 392032 | g188441 | i0 | 63.5 | 1.81889763779528 | 52 | 18 | 60.2 | 1 | 6 | 158 | 262 | 313 | CAF3609291.1 unnamed protein product [Rotaria socialis] | diamond | 462 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 29242919 | 29242919 | PRJNA980839_P_NODE_178169_length_264_cov_1.549738_g174385_i0 | PRJNA980839 | 178169 | 264 | 1.549738 | 4.0913083200000004 | Rotaria | 231623 | Rotifera | other_Eukaryota | 68.9 | 2.93e-11 | NR | CAF1061203.1 | 392030 | g174385 | i0 | 57.6 | 6.75 | 66 | 19 | 75 | 1 | 1 | 198 | 268 | 324 | CAF1061203.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1782 | 69.3 | 0.994227994227994 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29363203 | 29363203 | PRJNA980839_P_NODE_232409_length_242_cov_1.639053_g228625_i0 | PRJNA980839 | 232409 | 242 | 1.639053 | 3.96650826 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 80.5 | 1.89e-15 | NR | UJR23625.1 | 104782 | g228625 | i0 | 100 | 0.45867768595041303 | 37 | 0 | 45.9 | 0 | 1 | 111 | 619 | 655 | UJR23625.1 hypothetical protein I4U23_026611 [Adineta vaga] | diamond | 111 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29615379 | 29615379 | PRJNA980839_P_NODE_214310_length_247_cov_0.885057_g210526_i0 | PRJNA980839 | 214310 | 247 | 0.885057 | 2.18609079 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 80.9 | 6.28e-16 | NR | UJR25070.1 | 104782 | g210526 | i0 | 68.4 | 1.44534412955466 | 57 | 18 | 69.2 | 0 | 75 | 245 | 161 | 217 | UJR25070.1 hypothetical protein I4U23_006430 [Adineta vaga] | diamond | 357 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30405816 | 30405816 | PRJNA980839_P_NODE_152233_length_285_cov_1.452830_g148449_i0 | PRJNA980839 | 152233 | 285 | 1.45283 | 4.1405655 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 135 | 1.07e-35 | NR | CAF1388660.1 | 249248 | g148449 | i0 | 97 | 1.38947368421053 | 66 | 2 | 69.5 | 0 | 88 | 285 | 98 | 163 | CAF1388660.1 unnamed protein product [Adineta ricciae] | diamond | 396 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30437299 | 30437299 | PRJNA980839_P_NODE_238013_length_241_cov_0.916667_g234229_i0 | PRJNA980839 | 238013 | 241 | 0.916667 | 2.20916747 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 43.5 | 0.0181 | NR | CAF4527539.1 | 2762511 | g234229 | i0 | 42.9 | 1.08298755186722 | 42 | 24 | 52.3 | 0 | 233 | 108 | 1 | 42 | CAF4527539.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 261 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 30816119 | 30816119 | PRJNA980839_P_NODE_182554_length_261_cov_1.319149_g178770_i0 | PRJNA980839 | 182554 | 261 | 1.319149 | 3.44297889 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 50.8 | 6.26e-5 | NR | CAF1195584.1 | 392033 | g178770 | i0 | 61.3 | 6.14942528735632 | 31 | 12 | 35.6 | 0 | 8 | 100 | 66 | 96 | CAF1195584.1 unnamed protein product [Rotaria sordida] | diamond | 1605 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 30847766 | 30847766 | PRJNA980839_P_NODE_207054_length_249_cov_0.875000_g203270_i0 | PRJNA980839 | 207054 | 249 | 0.875 | 2.17875 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 91.7 | 2.43e-19 | NR | CAF1039000.1 | 249248 | g203270 | i0 | 95.2 | 1.01204819277108 | 42 | 2 | 50.6 | 0 | 238 | 113 | 200 | 241 | CAF1039000.1 unnamed protein product [Adineta ricciae] | diamond | 252 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31106434 | 31106434 | PRJNA980839_P_NODE_123735_length_319_cov_1.126016_g119951_i0 | PRJNA980839 | 123735 | 319 | 1.126016 | 3.59199104 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 64.3 | 2.57e-9 | NR | UJR29474.1 | 104782 | g119951 | i0 | 39.6 | 1.98432601880878 | 106 | 51 | 98.7 | 3 | 319 | 5 | 410 | 503 | UJR29474.1 hypothetical protein I4U23_010686 [Adineta vaga] | diamond | 633 | 64.7 | 0.993817619783617 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31575034 | 31575034 | PRJNA980839_P_NODE_232576_length_242_cov_1.473373_g228792_i0 | PRJNA980839 | 232576 | 242 | 1.473373 | 3.56556266 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 42.7 | 0.0363 | NR | CAF0928535.1 | 249248 | g228792 | i0 | 53.1 | 0.793388429752066 | 32 | 15 | 39.7 | 0 | 101 | 6 | 438 | 469 | CAF0928535.1 unnamed protein product [Adineta ricciae] | diamond | 192 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32775993 | 32775993 | PRJNA980839_P_NODE_207220_length_249_cov_0.875000_g203436_i0 | PRJNA980839 | 207220 | 249 | 0.875 | 2.17875 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 47.4 | 9.45e-4 | NR | CAF3889509.1 | 392030 | g203436 | i0 | 34.3 | 1.68674698795181 | 70 | 41 | 78.3 | 2 | 196 | 2 | 182 | 251 | CAF3889509.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 420 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata |
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);;