contig_metadata
18 rows where bioproject = "PRJNA879067", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 855962 | 855962 | PRJNA879067_P_NODE_72141_length_376_cov_4.168317_g68656_i0 | PRJNA879067 | 72141 | 376 | 4.168317 | 15.67287192 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 472 | 2.3199999999999996e-128 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g68656 | i0 | 89.501 | 44.5984042553191 | 381 | 29 | 100 | 7 | 1 | 376 | 1770 | 2144 | Philodina citrina complete mitochondrial genome | blastn | 16769 | 472 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 2130033 | 2130033 | PRJNA879067_P_NODE_32082_length_729_cov_7.289634_g28735_i0 | PRJNA879067 | 32082 | 729 | 7.289634 | 53.14143186 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 127 | 2.7e-29 | NR | CAF0742297.1 | 1234261 | g28735 | i0 | 41.8 | 2.63374485596708 | 158 | 67 | 64.6 | 2 | 494 | 24 | 131 | 264 | CAF0742297.1 unnamed protein product [Didymodactylos carnosus] | diamond | 1920 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 2131869 | 2131869 | PRJNA879067_P_NODE_96602_length_274_cov_3.621891_g93116_i0 | PRJNA879067 | 96602 | 274 | 3.621891 | 9.92398134 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 383 | 7.86e-102 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g93116 | i0 | 91.756 | 55.978102189781 | 279 | 17 | 100 | 2 | 1 | 274 | 1985 | 1708 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 15338 | 383 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 4682359 | 4682359 | PRJNA879067_P_NODE_12744_length_1355_cov_25.481279_g8086_i2 | PRJNA879067 | 12744 | 1355 | 25.481279 | 345.27133045 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 95.1 | 1.68e-17 | NR | CAF1076364.1 | 392033 | g8086 | i2 | 44.2 | 0.422878228782288 | 95 | 49 | 21 | 1 | 654 | 370 | 127 | 217 | CAF1076364.1 unnamed protein product [Rotaria sordida] | diamond | 573 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 13607370 | 13607370 | PRJNA879067_P_NODE_10211_length_1543_cov_24.427211_g8086_i0 | PRJNA879067 | 10211 | 1543 | 24.427211 | 376.91186573 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 151 | 2.44e-37 | NR | CAF1003491.1 | 1234261 | g8086 | i0 | 41 | 2.04536616979909 | 222 | 99 | 39.9 | 8 | 648 | 1262 | 102 | 308 | CAF1003491.1 unnamed protein product [Didymodactylos carnosus] | diamond | 3156 | 151 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 16541903 | 16541903 | PRJNA879067_P_NODE_92573_length_289_cov_1.291667_g89087_i0 | PRJNA879067 | 92573 | 289 | 1.291667 | 3.73291763 | Ploima | 84394 | Rotifera | other_Eukaryota | 416 | 8.229999999999999e-112 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g89087 | i0 | 95.736 | 85.916955017301 | 258 | 11 | 89 | 0 | 3 | 260 | 1690 | 1433 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 24830 | 416 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 19980609 | 19980609 | PRJNA879067_P_NODE_11276_length_1458_cov_20.460650_g8086_i1 | PRJNA879067 | 11276 | 1458 | 20.46065 | 298.316277 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 183 | 1.58e-49 | NR | CAF1003491.1 | 1234261 | g8086 | i1 | 41.1 | 0.530864197530864 | 258 | 114 | 50.8 | 8 | 1022 | 282 | 78 | 308 | CAF1003491.1 unnamed protein product [Didymodactylos carnosus] | diamond | 774 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 19981783 | 19981783 | PRJNA879067_P_NODE_43956_length_580_cov_8.005917_g40495_i0 | PRJNA879067 | 43956 | 580 | 8.005917 | 46.4343186 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 137 | 9.57e-38 | NR | RNA25093.1 | 10195 | g40495 | i0 | 60 | 0.646551724137931 | 125 | 50 | 64.7 | 0 | 112 | 486 | 4 | 128 | RNA25093.1 Prefoldin subunit 1 [Brachionus plicatilis] | diamond | 375 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 22531061 | 22531061 | PRJNA879067_P_NODE_21038_length_975_cov_177.638581_g18063_i0 | PRJNA879067 | 21038 | 975 | 177.638581 | 1731.97616475 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 77 | 3.2e-12 | NR | CAF1103234.1 | 1234261 | g18063 | i0 | 27 | 0.615384615384615 | 200 | 127 | 57.8 | 7 | 334 | 897 | 58 | 250 | CAF1103234.1 unnamed protein product [Didymodactylos carnosus] | diamond | 600 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 22531817 | 22531817 | PRJNA879067_P_NODE_42798_length_592_cov_5.186898_g39339_i0 | PRJNA879067 | 42798 | 592 | 5.186898 | 30.70643616 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 671 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g39339 | i0 | 90.019 | 33.089527027027 | 521 | 48 | 88 | 4 | 66 | 585 | 1876 | 2393 | Philodina citrina complete mitochondrial genome | blastn | 19589 | 671 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 23806495 | 23806495 | PRJNA879067_P_NODE_21039_length_975_cov_172.016630_g18063_i1 | PRJNA879067 | 21039 | 975 | 172.01663 | 1677.1621425 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 76.6 | 4.38e-12 | NR | CAF1103234.1 | 1234261 | g18063 | i1 | 27 | 0.615384615384615 | 200 | 127 | 57.8 | 7 | 642 | 79 | 58 | 250 | CAF1103234.1 unnamed protein product [Didymodactylos carnosus] | diamond | 600 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 25080848 | 25080848 | PRJNA879067_P_NODE_34220_length_698_cov_2.795200_g30840_i0 | PRJNA879067 | 34220 | 698 | 2.7952 | 19.510496 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 272 | 4.669999999999999e-87 | NR | CAF0719324.1 | 433720 | g30840 | i0 | 57.3 | 1.00573065902579 | 234 | 95 | 99.7 | 3 | 2 | 697 | 112 | 342 | CAF0719324.1 unnamed protein product [Adineta steineri] | diamond | 702 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 27118272 | 27118272 | PRJNA879067_P_NODE_89482_length_300_cov_3.074890_g85996_i0 | PRJNA879067 | 89482 | 300 | 3.07489 | 9.22467 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 117 | 4.96e-32 | NR | CAF1621987.1 | 1234261 | g85996 | i0 | 89.6 | 2.01 | 67 | 7 | 67 | 0 | 3 | 203 | 20 | 86 | CAF1621987.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 603 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27181514 | 27181514 | PRJNA879067_P_NODE_17602_length_1101_cov_10.723735_g14824_i0 | PRJNA879067 | 17602 | 1101 | 10.723735 | 118.06832235 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 107 | 4e-22 | NR | CAF0879695.1 | 104777 | g14824 | i0 | 40.3 | 0.337874659400545 | 124 | 74 | 33.8 | 0 | 691 | 1062 | 9 | 132 | CAF0879695.1 unnamed protein product [Brachionus calyciflorus] | diamond | 372 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28508091 | 28508091 | PRJNA879067_P_NODE_99507_length_264_cov_1.612565_g96021_i0 | PRJNA879067 | 99507 | 264 | 1.612565 | 4.2571716 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 48.1 | 5.47e-5 | NR | CAF5114417.1 | 2762511 | g96021 | i0 | 64.5 | 0.693181818181818 | 31 | 11 | 35.2 | 0 | 120 | 212 | 47 | 77 | CAF5114417.1 unnamed protein product, partial [Rotaria sp. Silwood1] | diamond | 183 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 29423439 | 29423439 | PRJNA879067_P_NODE_11249_length_1460_cov_17.823360_g9005_i0 | PRJNA879067 | 11249 | 1460 | 17.82336 | 260.221056 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 123 | 2.8700000000000003e-27 | NR | CAF1003491.1 | 1234261 | g9005 | i0 | 52 | 0.472602739726027 | 102 | 48 | 21 | 1 | 1114 | 809 | 91 | 191 | CAF1003491.1 unnamed protein product [Didymodactylos carnosus] | diamond | 690 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 32236979 | 32236979 | PRJNA879067_P_NODE_16378_length_1157_cov_3.727860_g13660_i0 | PRJNA879067 | 16378 | 1157 | 3.72786 | 43.1313402 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 84.7 | 1.53e-13 | NR | CAF0847328.1 | 104777 | g13660 | i0 | 45.3 | 0.246326707000864 | 95 | 46 | 23.6 | 3 | 66 | 338 | 153 | 245 | CAF0847328.1 unnamed protein product [Brachionus calyciflorus] | diamond | 285 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32647180 | 32647180 | PRJNA879067_P_NODE_108900_length_244_cov_0.865497_g105414_i0 | PRJNA879067 | 108900 | 244 | 0.865497 | 2.11181268 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 54.3 | 3.01e-6 | NR | CAF4750308.1 | 2762511 | g105414 | i0 | 55.6 | 3.92213114754098 | 45 | 19 | 54.1 | 1 | 1 | 132 | 23 | 67 | CAF4750308.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 957 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 |
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);;