contig_metadata
16 rows where bioproject = "PRJNA400391", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1688893 | 1688893 | PRJNA400391_S_NODE_3482_length_215_cov_11.994444_g3421_i0 | PRJNA400391 | 3482 | 215 | 11.994444 | 25.7880546 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 348 | 2.16e-91 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g3421 | i0 | 95.814 | 100.883720930233 | 215 | 9 | 100 | 0 | 1 | 215 | 2526 | 2312 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 21690 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 1688936 | 1688936 | PRJNA400391_S_NODE_5322_length_171_cov_4.992647_g5261_i0 | PRJNA400391 | 5322 | 171 | 4.992647 | 8.53742637 | Polyarthra remata | 360693 | Rotifera | other_Eukaryota | 255 | 1.02e-63 | NTclustered | gi|83285205|gb|DQ297752.1| | 360693 | g5261 | i0 | 95.062 | 43.9707602339181 | 162 | 8 | 95 | 0 | 2 | 163 | 590 | 751 | Polyarthra remata 28S ribosomal RNA gene, partial sequence | blastn | 7519 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Synchaetidae | Polyarthra | Polyarthra remata | |
| 6791792 | 6791792 | PRJNA400391_S_NODE_3166_length_226_cov_2.659686_g3105_i0 | PRJNA400391 | 3166 | 226 | 2.659686 | 6.01089036 | Polyarthra remata | 360693 | Rotifera | other_Eukaryota | 348 | 2.2900000000000005e-91 | NTclustered | gi|83285205|gb|DQ297752.1| | 360693 | g3105 | i0 | 94.323 | 83.8185840707965 | 229 | 10 | 100 | 1 | 1 | 226 | 8 | 236 | Polyarthra remata 28S ribosomal RNA gene, partial sequence | blastn | 18943 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Synchaetidae | Polyarthra | Polyarthra remata | |
| 8067361 | 8067361 | PRJNA400391_S_NODE_1927_length_284_cov_4.449799_g1866_i0 | PRJNA400391 | 1927 | 284 | 4.449799 | 12.63742916 | Asplanchna sieboldii | 84397 | Rotifera | other_Eukaryota | 311 | 3.92e-80 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g1866 | i0 | 86.505 | 47.9612676056338 | 289 | 31 | 100 | 6 | 1 | 284 | 2095 | 1810 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 13621 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 9342203 | 9342203 | PRJNA400391_S_NODE_1908_length_285_cov_4.980000_g1847_i0 | PRJNA400391 | 1908 | 285 | 4.98 | 14.193 | Brachionus patulus | 160652 | Rotifera | other_Eukaryota | 313 | 1.09e-80 | NTclustered | gi|61200806|gb|AY829084.1| | 160652 | g1847 | i0 | 86.505 | 45.8245614035088 | 289 | 34 | 100 | 5 | 1 | 285 | 2096 | 1809 | Brachionus patulus 28S ribosomal RNA gene, partial sequence | blastn | 13060 | 313 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus patulus | |
| 9342294 | 9342294 | PRJNA400391_S_NODE_5968_length_160_cov_10.192000_g5907_i0 | PRJNA400391 | 5968 | 160 | 10.192 | 16.3072 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 267 | 4.35e-67 | NTclustered | gi|229609474|gb|FJ937584.1| | 104777 | g5907 | i0 | 96.875 | 100 | 160 | 4 | 100 | 1 | 1 | 160 | 466 | 308 | Brachionus calyciflorus voucher AHNU-Rotifer-W-ITS-T4 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 16000 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 10009094 | 10009094 | PRJNA400391_S_NODE_2368_length_259_cov_25.946429_g2307_i0 | PRJNA400391 | 2368 | 259 | 25.946429 | 67.20125111 | Ploima | 84394 | Rotifera | other_Eukaryota | 357 | 4.46e-94 | NTclustered | gi|83285079|gb|DQ297691.1| | 360655 | g2307 | i0 | 93.443 | 92.4015444015444 | 244 | 10 | 94 | 5 | 16 | 259 | 65 | 302 | Ascomorpha ovalis 18S ribosomal RNA gene, partial sequence | blastn | 23932 | 357 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Gastropidae | Ascomorpha | Ascomorpha ovalis | |
| 11284359 | 11284359 | PRJNA400391_S_NODE_5909_length_161_cov_4.000000_g5848_i0 | PRJNA400391 | 5909 | 161 | 4 | 6.44 | Ploima | 84394 | Rotifera | other_Eukaryota | 254 | 3.42e-63 | NTclustered | gi|37788190|gb|AY218143.1| | 231620 | g5848 | i0 | 95.031 | 84.7453416149068 | 161 | 8 | 100 | 0 | 1 | 161 | 180 | 20 | Euchlanis dilatata 28S ribosomal RNA gene, partial sequence | blastn | 13644 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Euchlanis | Euchlanis dilatata | |
| 13167799 | 13167799 | PRJNA400391_S_NODE_1671_length_299_cov_2.909091_g1610_i0 | PRJNA400391 | 1671 | 299 | 2.909091 | 8.69818209 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 342 | 1.4699999999999999e-89 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g1610 | i0 | 88.542 | 69.5451505016722 | 288 | 25 | 94 | 5 | 1 | 282 | 32 | 317 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 20794 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 15716746 | 15716746 | PRJNA400391_S_NODE_2313_length_263_cov_4.614035_g2252_i0 | PRJNA400391 | 2313 | 263 | 4.614035 | 12.13491205 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 322 | 1.66e-83 | NTclustered | gi|478683563|gb|KC193096.1| | 104777 | g2252 | i0 | 88.722 | 87.2851711026616 | 266 | 26 | 100 | 4 | 1 | 263 | 295 | 31 | Brachionus calyciflorus 28S ribosomal RNA gene, partial sequence | blastn | 22956 | 322 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 15716842 | 15716842 | PRJNA400391_S_NODE_6193_length_157_cov_2.762295_g6132_i0 | PRJNA400391 | 6193 | 157 | 2.762295 | 4.33680315 | Asplanchna sieboldii | 84397 | Rotifera | other_Eukaryota | 182 | 1.58e-41 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g6132 | i0 | 87.421 | 11.1210191082803 | 159 | 18 | 100 | 2 | 1 | 157 | 1143 | 1301 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 1746 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 16383408 | 16383408 | PRJNA400391_S_NODE_1833_length_290_cov_2.117647_g1772_i0 | PRJNA400391 | 1833 | 290 | 2.117647 | 6.1411763 | Philodinavus | 468647 | Rotifera | other_Eukaryota | 342 | 1.4199999999999997e-89 | NTclustered | gi|281323388|gb|GQ922293.1| | 317506 | g1772 | i0 | 87.973 | 97.1379310344828 | 291 | 33 | 100 | 2 | 1 | 290 | 408 | 119 | Uncultured bdelloid rotifer clone Rot_H_08D 18S ribosomal RNA gene, partial sequence | blastn | 28170 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Bdelloidea environmental sample | ||||
| 23366160 | 23366160 | PRJNA400391_S_NODE_3919_length_203_cov_10.071429_g3858_i0 | PRJNA400391 | 3919 | 203 | 10.071429 | 20.44500087 | Asplanchna sieboldii | 84397 | Rotifera | other_Eukaryota | 342 | 9.369999999999999e-90 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g3858 | i0 | 97.5 | 19.8374384236453 | 200 | 5 | 99 | 0 | 4 | 203 | 1727 | 1528 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 4027 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 23366163 | 23366163 | PRJNA400391_S_NODE_4159_length_197_cov_4.364198_g4098_i0 | PRJNA400391 | 4159 | 197 | 4.364198 | 8.59747006 | Polyarthra remata | 360693 | Rotifera | other_Eukaryota | 292 | 9.23e-75 | NTclustered | gi|83285205|gb|DQ297752.1| | 360693 | g4098 | i0 | 93.434 | 84.3908629441624 | 198 | 12 | 100 | 1 | 1 | 197 | 482 | 285 | Polyarthra remata 28S ribosomal RNA gene, partial sequence | blastn | 16625 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Synchaetidae | Polyarthra | Polyarthra remata | |
| 24640424 | 24640424 | PRJNA400391_S_NODE_2240_length_267_cov_3.099138_g2179_i0 | PRJNA400391 | 2240 | 267 | 3.099138 | 8.27469846 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 318 | 2.18e-82 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g2179 | i0 | 88.235 | 49.7078651685393 | 272 | 25 | 100 | 5 | 1 | 267 | 1823 | 2092 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 13272 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 24640512 | 24640512 | PRJNA400391_S_NODE_6120_length_158_cov_2.536585_g6059_i0 | PRJNA400391 | 6120 | 158 | 2.536585 | 4.0078043 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 276 | 7.120000000000001e-70 | NTclustered | gi|72153762|gb|DQ089743.1| | 231624 | g6059 | i0 | 98.101 | 12.974683544303801 | 158 | 3 | 100 | 0 | 1 | 158 | 2587 | 2430 | Rotaria rotatoria 28S ribosomal RNA gene, partial sequence | blastn | 2050 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria |
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);;