contig_metadata
13 rows where bioproject = "PRJNA1123309", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2829047 | 2829047 | PRJNA1123309_P_NODE_41103_length_268_cov_1.194872_g40723_i0 | PRJNA1123309 | 41103 | 268 | 1.194872 | 3.20225696 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 81.3 | 1.44e-15 | NR | CAF3369437.1 | 2762511 | g40723 | i0 | 53.7 | 5.50746268656716 | 82 | 37 | 91.8 | 1 | 259 | 14 | 154 | 234 | CAF3369437.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 1476 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 13032293 | 13032293 | PRJNA1123309_P_NODE_66891_length_242_cov_0.911243_g66511_i0 | PRJNA1123309 | 66891 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 139 | 4.9399999999999986e-40 | NR | RNA13848.1 | 10195 | g66511 | i0 | 76.9 | 8.7396694214876 | 78 | 18 | 96.7 | 0 | 3 | 236 | 76 | 153 | RNA13848.1 peptidyl-prolyl cis-trans isomerase [Brachionus plicatilis] | diamond | 2115 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 26626991 | 26626991 | PRJNA1123309_P_NODE_5701_length_613_cov_2.011111_g5350_i0 | PRJNA1123309 | 5701 | 613 | 2.011111 | 12.32811043 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 224 | 2.48e-70 | NR | CAF1269676.1 | 392030 | g5350 | i0 | 66.5 | 2.4910277324633 | 176 | 56 | 86.1 | 1 | 543 | 16 | 22 | 194 | CAF1269676.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1527 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28175429 | 28175429 | PRJNA1123309_P_NODE_18406_length_366_cov_1.010239_g18027_i0 | PRJNA1123309 | 18406 | 366 | 1.010239 | 3.69747474 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 52.4 | 1.55e-5 | NR | CAF0985915.1 | 433720 | g18027 | i0 | 43.1 | 3.10655737704918 | 51 | 22 | 41.8 | 1 | 155 | 307 | 4 | 47 | CAF0985915.1 unnamed protein product [Adineta steineri] | diamond | 1137 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29186204 | 29186204 | PRJNA1123309_P_NODE_6389_length_585_cov_1.492188_g6031_i0 | PRJNA1123309 | 6389 | 585 | 1.492188 | 8.7292998 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 64.7 | 1.56e-9 | NR | CAF1009136.1 | 433720 | g6031 | i0 | 28.9 | 2.8051282051282 | 128 | 82 | 64.6 | 2 | 414 | 37 | 8 | 128 | CAF1009136.1 unnamed protein product [Adineta steineri] | diamond | 1641 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29975410 | 29975410 | PRJNA1123309_P_NODE_57711_length_247_cov_0.896552_g57331_i0 | PRJNA1123309 | 57711 | 247 | 0.896552 | 2.21448344 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 129 | 1.4599999999999998e-35 | NR | CAF0801069.1 | 1234261 | g57331 | i0 | 76.9 | 0.947368421052632 | 78 | 18 | 94.7 | 0 | 14 | 247 | 76 | 153 | CAF0801069.1 unnamed protein product [Didymodactylos carnosus] | diamond | 234 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 30575476 | 30575476 | PRJNA1123309_P_NODE_8013_length_529_cov_2.311404_g7645_i0 | PRJNA1123309 | 8013 | 529 | 2.311404 | 12.22732716 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 75.5 | 1.72e-12 | NR | CAF4153536.1 | 392030 | g7645 | i0 | 49.3 | 2.14933837429112 | 75 | 35 | 42.5 | 1 | 81 | 305 | 180 | 251 | CAF4153536.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1137 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 30627884 | 30627884 | PRJNA1123309_P_NODE_41013_length_268_cov_1.435897_g40633_i0 | PRJNA1123309 | 41013 | 268 | 1.435897 | 3.84820396 | root | 1 | Root_unresolved | Root_unresolved | 64.7 | 1.86e-10 | NR | CAF3885301.1 | 392030 | g40633 | i0 | 40.2 | 3.62686567164179 | 87 | 42 | 96.3 | 3 | 9 | 266 | 31 | 108 | CAF3885301.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 972 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 31460899 | 31460899 | PRJNA1123309_P_NODE_4196_length_702_cov_2.004769_g3868_i0 | PRJNA1123309 | 4196 | 702 | 2.004769 | 14.07347838 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 121 | 1.96e-27 | NR | CAF1276889.1 | 433720 | g3868 | i0 | 50.4 | 2.06837606837607 | 123 | 52 | 51.3 | 2 | 9 | 368 | 608 | 724 | CAF1276889.1 unnamed protein product [Adineta steineri] | diamond | 1452 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31766087 | 31766087 | PRJNA1123309_P_NODE_40037_length_270_cov_2.314721_g39657_i0 | PRJNA1123309 | 40037 | 270 | 2.314721 | 6.2497467 | root | 1 | Root_unresolved | Root_unresolved | 121 | 5.05e-32 | NR | CAF0713792.1 | 433720 | g39657 | i0 | 68.2 | 2.77777777777778 | 85 | 24 | 91.1 | 1 | 269 | 24 | 109 | 193 | CAF0713792.1 unnamed protein product [Adineta steineri] | diamond | 750 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32283448 | 32283448 | PRJNA1123309_P_NODE_40859_length_268_cov_2.092308_g40479_i0 | PRJNA1123309 | 40859 | 268 | 2.092308 | 5.60738544 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 50.4 | 1.03e-4 | NR | CAF1391084.1 | 249248 | g40479 | i0 | 42.1 | 1.70149253731343 | 76 | 42 | 82.8 | 1 | 258 | 37 | 1136 | 1211 | CAF1391084.1 unnamed protein product [Adineta ricciae] | diamond | 456 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32441686 | 32441686 | PRJNA1123309_P_NODE_11339_length_451_cov_1.103175_g10963_i0 | PRJNA1123309 | 11339 | 451 | 1.103175 | 4.97531925 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 150 | 6.7e-42 | NR | CAF1126080.1 | 1234261 | g10963 | i0 | 53.1 | 0.951219512195122 | 143 | 62 | 95.1 | 2 | 435 | 7 | 73 | 210 | CAF1126080.1 unnamed protein product [Didymodactylos carnosus] | diamond | 429 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 32788211 | 32788211 | PRJNA1123309_P_NODE_18260_length_367_cov_1.047619_g17881_i0 | PRJNA1123309 | 18260 | 367 | 1.047619 | 3.84476173 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 79.7 | 1.74e-14 | NR | CAF0886665.1 | 392033 | g17881 | i0 | 40.2 | 3.92370572207084 | 107 | 53 | 79.3 | 2 | 75 | 365 | 986 | 1091 | CAF0886665.1 unnamed protein product [Rotaria sordida] | diamond | 1440 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida |
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);;