contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA533114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 505080 | 505080 | PRJNA533114_P_NODE_3781_length_1099_cov_17.609162_g3631_i0 | PRJNA533114 | 3781 | 1099 | 17.609162 | 193.52469038 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 388 | 7.5e-103 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g3631 | i0 | 76.986 | 16.3921747042766 | 730 | 136 | 65 | 28 | 364 | 1078 | 11079 | 11791 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 18015 | 388 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 1779936 | 1779936 | PRJNA533114_P_NODE_13162_length_624_cov_1.257713_g12918_i0 | PRJNA533114 | 13162 | 624 | 1.257713 | 7.84812912 | Brachionus koreanus | 1199090 | Rotifera | other_Eukaryota | 342 | 3.2799999999999996e-89 | NTclustered | gi|477541870|gb|KC603851.1| | 1199090 | g12918 | i0 | 76.763 | 23.7804487179487 | 624 | 138 | 99 | 7 | 3 | 623 | 151 | 770 | Brachionus sp. 'koreanus' chromosome I mitochondrion, complete sequence | blastn | 14839 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus koreanus | |
| 3055564 | 3055564 | PRJNA533114_P_NODE_12823_length_632_cov_1.468694_g12581_i0 | PRJNA533114 | 12823 | 632 | 1.468694 | 9.28214608 | Cyrtonia tuba | 1087466 | Rotifera | other_Eukaryota | 571 | 3.9e-158 | NTclustered | gi|2501307307|gb|OQ940324.1| | 1087466 | g12581 | i0 | 83.096 | 78.7879746835443 | 633 | 101 | 99 | 6 | 2 | 631 | 759 | 130 | Cyrtonia tuba isolate 1 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial | blastn | 49794 | 571 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Epiphanidae | Cyrtonia | Cyrtonia tuba | |
| 5608265 | 5608265 | PRJNA533114_P_NODE_111945_length_244_cov_0.900585_g111693_i0 | PRJNA533114 | 111945 | 244 | 0.900585 | 2.1974274 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 337 | 5.429999999999998e-88 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g111693 | i0 | 91.566 | 43.5327868852459 | 249 | 14 | 99 | 3 | 1 | 243 | 1763 | 2010 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 10622 | 337 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 10709053 | 10709053 | PRJNA533114_P_NODE_3609_length_1118_cov_24.252632_g3461_i0 | PRJNA533114 | 3609 | 1118 | 24.252632 | 271.14442576 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 401 | 9.809999999999998e-107 | NTclustered | gi|1066800225|gb|KX364936.1| | 96890 | g3461 | i0 | 80.389 | 35.3067978533095 | 566 | 79 | 50 | 29 | 555 | 1109 | 9500 | 10044 | Brachionus rotundiformis chromosome I mitochondrion, complete sequence | blastn | 39473 | 401 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis | |
| 13258465 | 13258465 | PRJNA533114_P_NODE_16511_length_556_cov_2.732919_g16262_i0 | PRJNA533114 | 16511 | 556 | 2.732919 | 15.19502964 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 381 | 6.149999999999999e-101 | NTclustered | gi|2105975276|gb|MZ706949.1| | 104777 | g16262 | i0 | 80.077 | 59.7248201438849 | 522 | 96 | 93 | 7 | 1 | 518 | 26727 | 27244 | Brachionus calyciflorus chromosome I mitochondrion, complete sequence | blastn | 33207 | 381 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 13258647 | 13258647 | PRJNA533114_P_NODE_26431_length_443_cov_1.456757_g26179_i0 | PRJNA533114 | 26431 | 443 | 1.456757 | 6.45343351 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 259 | 2.35e-64 | NTclustered | gi|1066800230|gb|KX364937.1| | 96890 | g26179 | i0 | 79.434 | 21.7562076749436 | 389 | 62 | 86 | 15 | 41 | 420 | 5747 | 6126 | Brachionus rotundiformis chromosome II mitochondrion, complete sequence | blastn | 9638 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis | |
| 13258800 | 13258800 | PRJNA533114_P_NODE_3711_length_1106_cov_15.164569_g3561_i0 | PRJNA533114 | 3711 | 1106 | 15.164569 | 167.72013314 | Asplanchna sp. | 3231738 | Rotifera | other_Eukaryota | 425 | 5.76e-114 | NTclustered | gi|2778092479|gb|PP988071.1| | 3231738 | g3561 | i0 | 75.676 | 14.8345388788427 | 999 | 163 | 87 | 70 | 119 | 1078 | 1415 | 2372 | Asplanchna sp. chromosome I mitochondrion, complete sequence | blastn | 16407 | 425 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sp. | |
| 18356757 | 18356757 | PRJNA533114_P_NODE_5695_length_922_cov_3.542992_g5519_i0 | PRJNA533114 | 5695 | 922 | 3.542992 | 32.66638624 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 625 | 4.379999999999999e-174 | NTclustered | gi|1802791203|gb|MN256532.1| | 392764 | g5519 | i0 | 79.272 | 66.5553145336226 | 907 | 178 | 98 | 10 | 21 | 922 | 151 | 1052 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 61364 | 625 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 20906962 | 20906962 | PRJNA533114_P_NODE_28557_length_427_cov_1.522599_g28305_i0 | PRJNA533114 | 28557 | 427 | 1.522599 | 6.50149773 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 355 | 2.8e-93 | NTclustered | gi|72153656|gb|DQ089731.1| | 96446 | g28305 | i0 | 83.081 | 89.6580796252927 | 396 | 61 | 92 | 5 | 1 | 393 | 124 | 516 | Lecane bulla cytochrome oxidase subunit I gene, partial cds; mitochondrial | blastn | 38284 | 355 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 23457765 | 23457765 | PRJNA533114_P_NODE_80659_length_270_cov_1.563452_g80407_i0 | PRJNA533114 | 80659 | 270 | 1.563452 | 4.2213204 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 337 | 6.1e-88 | NTclustered | gi|254587481|dbj|AB513493.1| | 10195 | g80407 | i0 | 89.259 | 94.9481481481481 | 270 | 27 | 99 | 2 | 2 | 270 | 641 | 373 | Brachionus plicatilis tef1a mRNA for translation elongation factor 1 alpha, complete cds | blastn | 25636 | 337 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 24730500 | 24730500 | PRJNA533114_P_NODE_121400_length_240_cov_3.233533_g121148_i0 | PRJNA533114 | 121400 | 240 | 3.233533 | 7.7604792 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 244 | 3.3199999999999996e-60 | NTclustered | gi|1802791203|gb|MN256532.1| | 392764 | g121148 | i0 | 85 | 96.2916666666667 | 240 | 36 | 100 | 0 | 1 | 240 | 689 | 928 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 23110 | 244 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens |
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);;