contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA704949" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2462344 | 2462344 | PRJNA704949_P_NODE_1639182_length_189_cov_2.792857_g1623843_i0 | PRJNA704949 | 1639182 | 189 | 2.792857 | 5.27849973 | Brachionidae | 10193 | Rotifera | other_Eukaryota | 333 | 5.169999999999999e-87 | NTclustered | gi|2177087|gb|U49911.1|BPU49911 | 10195 | g1623843 | i0 | 98.413 | 99.989417989418 | 189 | 3 | 100 | 0 | 1 | 189 | 1620 | 1432 | Brachionus plicatilis 18S rRNA gene, complete sequence | blastn | 18898 | 333 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 8352432 | 8352432 | PRJNA704949_P_NODE_596287_length_351_cov_3.235099_g580964_i0 | PRJNA704949 | 596287 | 351 | 3.235099 | 11.35519749 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 475 | 1.66e-129 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g580964 | i0 | 93.458 | 90.2165242165242 | 321 | 20 | 91 | 1 | 32 | 351 | 1434 | 1754 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 31666 | 475 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 11394613 | 11394613 | PRJNA704949_P_NODE_980129_length_263_cov_2.710280_g964794_i0 | PRJNA704949 | 980129 | 263 | 2.71028 | 7.1280364 | Ploima | 84394 | Rotifera | other_Eukaryota | 475 | 1.2e-129 | NTclustered | gi|259090060|gb|GQ503608.1| | 204738 | g964794 | i0 | 99.242 | 100.380228136882 | 264 | 1 | 100 | 1 | 1 | 263 | 109 | 372 | Keratella cochlearis 18S ribosomal RNA gene, partial sequence | blastn | 26400 | 475 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Keratella | Keratella cochlearis | |
| 16002417 | 16002417 | PRJNA704949_P_NODE_678273_length_327_cov_23.992806_g662945_i0 | PRJNA704949 | 678273 | 327 | 23.992806 | 78.45647562 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 261 | 4.69e-65 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g662945 | i0 | 83.391 | 8.59021406727829 | 289 | 40 | 88 | 5 | 25 | 311 | 10896 | 11178 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 2809 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 17271759 | 17271759 | PRJNA704949_P_NODE_1980114_length_168_cov_0.873950_g1964775_i0 | PRJNA704949 | 1980114 | 168 | 0.87395 | 1.468236 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 122 | 1.06e-23 | NTclustered | gi|218117238|emb|AM980948.1| | 10195 | g1964775 | i0 | 87.037 | 0.642857142857143 | 108 | 14 | 64 | 0 | 42 | 149 | 158 | 51 | Brachionus plicatilis partial mRNA for 60S ribosomal protein L13a, (RPL13a gene) | blastn | 108 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 22369429 | 22369429 | PRJNA704949_P_NODE_1768458_length_180_cov_1.190840_g1753119_i0 | PRJNA704949 | 1768458 | 180 | 1.19084 | 2.143512 | Cephalodella forficula | 360656 | Rotifera | other_Eukaryota | 315 | 1.76e-81 | NTclustered | gi|83285081|gb|DQ297693.1| | 360656 | g1753119 | i0 | 99.422 | 96.1111111111111 | 173 | 1 | 96 | 0 | 8 | 180 | 623 | 795 | Cephalodella forficula 18S ribosomal RNA gene, partial sequence | blastn | 17300 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Notommatidae | Cephalodella | Cephalodella forficula |
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);;