contig_metadata
15 rows where bioproject = "PRJNA429937", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8740328 | 8740328 | PRJNA429937_P_NODE_26087_length_717_cov_1408.433140_g15632_i0 | PRJNA429937 | 26087 | 717 | 1408.43314 | 10098.4656138 | Adineta | 104781 | Rotifera | other_Eukaryota | 1107 | 0 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g15632 | i0 | 95.677 | 41.7196652719665 | 694 | 20 | 96 | 9 | 7 | 694 | 2190 | 1501 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 29913 | 1118 | 0.990161001788909 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 9355746 | 9355746 | PRJNA429937_P_NODE_89568_length_334_cov_180.180328_g66996_i0 | PRJNA429937 | 89568 | 334 | 180.180328 | 601.80229552 | Brachionus patulus | 160652 | Rotifera | other_Eukaryota | 490 | 5.629999999999998e-134 | NTclustered | gi|61200806|gb|AY829084.1| | 160652 | g66996 | i0 | 94.904 | 91.8353293413174 | 314 | 15 | 94 | 1 | 1 | 313 | 1748 | 1435 | Brachionus patulus 28S ribosomal RNA gene, partial sequence | blastn | 30673 | 490 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus patulus | |
| 11290669 | 11290669 | PRJNA429937_P_NODE_25889_length_720_cov_1714.082489_g15499_i0 | PRJNA429937 | 25889 | 720 | 1714.082489 | 12341.3939208 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 1179 | 0 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g15499 | i0 | 97.54 | 39.9444444444444 | 691 | 13 | 96 | 3 | 24 | 711 | 1501 | 2190 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 28760 | 1179 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 26980736 | 26980736 | PRJNA429937_P_NODE_27762_length_694_cov_4.018045_g16726_i0 | PRJNA429937 | 27762 | 694 | 4.018045 | 27.8852323 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 399 | 6.97e-139 | NR | RNA19967.1 | 10195 | g16726 | i0 | 97 | 0.877521613832853 | 203 | 6 | 87.8 | 0 | 26 | 634 | 1 | 203 | RNA19967.1 acylpyruvase mitochondrial-like [Brachionus plicatilis] | diamond | 609 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27123521 | 27123521 | PRJNA429937_P_NODE_41382_length_559_cov_2.677358_g26263_i0 | PRJNA429937 | 41382 | 559 | 2.677358 | 14.96643122 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 139 | 1.98e-35 | NR | CAF0903444.1 | 392033 | g26263 | i0 | 74.2 | 6.37030411449016 | 93 | 24 | 49.9 | 0 | 302 | 24 | 341 | 433 | CAF0903444.1 unnamed protein product [Rotaria sordida] | diamond | 3561 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28780913 | 28780913 | PRJNA429937_P_NODE_72227_length_394_cov_3.268493_g17752_i3 | PRJNA429937 | 72227 | 394 | 3.268493 | 12.87786242 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 150 | 4e-43 | NR | CAF1512637.1 | 433720 | g17752 | i3 | 62.6 | 0.875634517766497 | 115 | 41 | 86 | 1 | 1 | 339 | 53 | 167 | CAF1512637.1 unnamed protein product, partial [Adineta steineri] | diamond | 345 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28812324 | 28812324 | PRJNA429937_P_NODE_64288_length_427_cov_3.057789_g17752_i1 | PRJNA429937 | 64288 | 427 | 3.057789 | 13.05675903 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 152 | 5.3e-44 | NR | CAF1512637.1 | 433720 | g17752 | i1 | 62.6 | 0.807962529274005 | 115 | 41 | 79.4 | 1 | 89 | 427 | 53 | 167 | CAF1512637.1 unnamed protein product, partial [Adineta steineri] | diamond | 345 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29223305 | 29223305 | PRJNA429937_P_NODE_82989_length_356_cov_3.550459_g17752_i5 | PRJNA429937 | 82989 | 356 | 3.550459 | 12.63963404 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 157 | 2.22e-46 | NR | CAF1512637.1 | 433720 | g17752 | i5 | 63.3 | 1.01123595505618 | 120 | 42 | 99.4 | 1 | 1 | 354 | 53 | 172 | CAF1512637.1 unnamed protein product, partial [Adineta steineri] | diamond | 360 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29538732 | 29538732 | PRJNA429937_P_NODE_47410_length_517_cov_2.778689_g30750_i0 | PRJNA429937 | 47410 | 517 | 2.778689 | 14.36582213 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 138 | 2.38e-35 | NR | CAF0903444.1 | 392033 | g30750 | i0 | 74.2 | 2.15860735009671 | 93 | 24 | 54 | 0 | 216 | 494 | 341 | 433 | CAF0903444.1 unnamed protein product [Rotaria sordida] | diamond | 1116 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 29980981 | 29980981 | PRJNA429937_P_NODE_47111_length_519_cov_2.859184_g30512_i0 | PRJNA429937 | 47111 | 519 | 2.859184 | 14.83916496 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 239 | 1.53e-74 | NR | CAF0903444.1 | 392033 | g30512 | i0 | 72.1 | 6.20809248554913 | 179 | 33 | 93.6 | 1 | 509 | 24 | 255 | 433 | CAF0903444.1 unnamed protein product [Rotaria sordida] | diamond | 3222 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 30297378 | 30297378 | PRJNA429937_P_NODE_20032_length_821_cov_24.006313_g11841_i0 | PRJNA429937 | 20032 | 821 | 24.006313 | 197.09182973 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 152 | 2.6399999999999998e-42 | NR | KAI3388965.1 | 104778 | g11841 | i0 | 60.2 | 1.65895249695493 | 113 | 45 | 41.3 | 0 | 760 | 422 | 4 | 116 | KAI3388965.1 hypothetical protein SNEBB_002876 [Seison nebaliae] | diamond | 1362 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 30865549 | 30865549 | PRJNA429937_P_NODE_79614_length_367_cov_3.718935_g17752_i4 | PRJNA429937 | 79614 | 367 | 3.718935 | 13.64849145 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 163 | 1.9499999999999998e-48 | NR | CAF1512637.1 | 433720 | g17752 | i4 | 62.1 | 1.01362397820163 | 124 | 45 | 99.7 | 1 | 2 | 367 | 44 | 167 | CAF1512637.1 unnamed protein product, partial [Adineta steineri] | diamond | 372 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31403106 | 31403106 | PRJNA429937_P_NODE_57536_length_459_cov_8.065116_g38436_i0 | PRJNA429937 | 57536 | 459 | 8.065116 | 37.01888244 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 79 | 8.53e-16 | NR | CAF4129484.1 | 433720 | g38436 | i0 | 36.2 | 0.686274509803922 | 105 | 65 | 68.6 | 1 | 447 | 133 | 5 | 107 | CAF4129484.1 unnamed protein product [Adineta steineri] | diamond | 315 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32035573 | 32035573 | PRJNA429937_P_NODE_29318_length_674_cov_2.643411_g17752_i0 | PRJNA429937 | 29318 | 674 | 2.643411 | 17.81659014 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 151 | 3.9e-42 | NR | CAF1512637.1 | 433720 | g17752 | i0 | 61 | 0.525222551928783 | 118 | 44 | 51.6 | 1 | 674 | 327 | 53 | 170 | CAF1512637.1 unnamed protein product, partial [Adineta steineri] | diamond | 354 | 151 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32098834 | 32098834 | PRJNA429937_P_NODE_67938_length_411_cov_3.371728_g17752_i2 | PRJNA429937 | 67938 | 411 | 3.371728 | 13.85780208 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 176 | 1.71e-53 | NR | CAF1512637.1 | 433720 | g17752 | i2 | 63.2 | 1.98540145985401 | 133 | 47 | 95.6 | 1 | 1 | 393 | 53 | 185 | CAF1512637.1 unnamed protein product, partial [Adineta steineri] | diamond | 816 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri |
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);;