contig_metadata
8 rows where bioproject = "PRJNA674048", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3193924 | 3193924 | PRJNA674048_P_NODE_13583_length_245_cov_3.142857_g13380_i0 | PRJNA674048 | 13583 | 245 | 3.142857 | 7.69999965 | Adineta vaga complex sp. B JFF-2016 | 1813165 | Rotifera | other_Eukaryota | 442 | 1.1199999999999994e-119 | NTclustered | gi|1005055631|gb|KU860774.1| | 1813165 | g13380 | i0 | 99.184 | 26.334693877551 | 245 | 2 | 100 | 0 | 1 | 245 | 1447 | 1691 | Adineta vaga complex sp. B JFF-2016 isolate H158a 28S ribosomal RNA gene, partial sequence | blastn | 6452 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. B JFF-2016 | |
| 12645264 | 12645264 | PRJNA674048_P_NODE_21530_length_189_cov_3.385714_g21327_i0 | PRJNA674048 | 21530 | 189 | 3.385714 | 6.39899946 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 344 | 2.39e-90 | NTclustered | gi|1399047|gb|U41281.1|PAU41281 | 44582 | g21327 | i0 | 99.471 | 100.116402116402 | 189 | 1 | 100 | 0 | 1 | 189 | 170 | 358 | Philodina acuticornis 18S rRNA gene | blastn | 18922 | 344 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina acuticornis | |
| 15945808 | 15945808 | PRJNA674048_P_NODE_26753_length_169_cov_1.733333_g26550_i0 | PRJNA674048 | 26753 | 169 | 1.733333 | 2.92933277 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 85.5 | 3.5e-18 | NR | CAF0892122.1 | 104777 | g26550 | i0 | 78.2 | 1.95266272189349 | 55 | 12 | 97.6 | 0 | 165 | 1 | 11 | 65 | CAF0892122.1 unnamed protein product [Brachionus calyciflorus] | diamond | 330 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 17221137 | 17221137 | PRJNA674048_P_NODE_24534_length_177_cov_2.312500_g24331_i0 | PRJNA674048 | 24534 | 177 | 2.3125 | 4.093125 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 300 | 4.84e-77 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g24331 | i0 | 97.175 | 3.12994350282486 | 177 | 5 | 100 | 0 | 1 | 177 | 10205 | 10381 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 554 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27113198 | 27113198 | PRJNA674048_P_NODE_32922_length_162_cov_0.920354_g32719_i0 | PRJNA674048 | 32922 | 162 | 0.920354 | 1.49097348 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 49.3 | 6.28e-5 | NR | CAF4860072.1 | 2762511 | g32719 | i0 | 61.5 | 5.05555555555556 | 39 | 13 | 68.5 | 1 | 4 | 114 | 2391 | 2429 | CAF4860072.1 unnamed protein product, partial [Rotaria sp. Silwood1] | diamond | 819 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 27176386 | 27176386 | PRJNA674048_P_NODE_30922_length_164_cov_0.904348_g30719_i0 | PRJNA674048 | 30922 | 164 | 0.904348 | 1.48313072 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 88.6 | 8.67e-19 | NR | CAF1096185.1 | 1234261 | g30719 | i0 | 70.4 | 0.98780487804878 | 54 | 16 | 98.8 | 0 | 163 | 2 | 341 | 394 | CAF1096185.1 unnamed protein product [Didymodactylos carnosus] | diamond | 162 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 32358325 | 32358325 | PRJNA674048_P_NODE_27299_length_169_cov_0.866667_g27096_i0 | PRJNA674048 | 27299 | 169 | 0.866667 | 1.46466723 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 52 | 1.15e-6 | NR | CAF3440507.1 | 2762512 | g27096 | i0 | 88.5 | 0.461538461538462 | 26 | 3 | 46.2 | 0 | 167 | 90 | 44 | 69 | CAF3440507.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 78 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 32465057 | 32465057 | PRJNA674048_P_NODE_17799_length_210_cov_1.795031_g17596_i0 | PRJNA674048 | 17799 | 210 | 1.795031 | 3.7695651 | Metazoa | 33208 | Rotifera | other_Eukaryota | 44.7 | 0.00534 | NR | KAI3384069.1 | 104778 | g17596 | i0 | 40.6 | 15.4428571428571 | 64 | 34 | 91.4 | 2 | 207 | 16 | 1325 | 1384 | KAI3384069.1 hypothetical protein SNEBB_000281 [Seison nebaliae] | diamond | 3243 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae |
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);;