contig_metadata
13 rows where bioproject = "PRJNA358490", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6776783 | 6776783 | PRJNA358490_P_NODE_906_length_1347_cov_8.377676_g828_i0 | PRJNA358490 | 906 | 1347 | 8.377676 | 112.84729572 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 1541 | 0 | NTclustered | gi|402761741|gb|JX184002.1| | 104786 | g828 | i0 | 87.689 | 42.9903489235338 | 1324 | 161 | 98 | 2 | 22 | 1344 | 208 | 1530 | Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 57908 | 1541 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 8052223 | 8052223 | PRJNA358490_P_NODE_14047_length_198_cov_1.792453_g13703_i0 | PRJNA358490 | 14047 | 198 | 1.792453 | 3.54905694 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 348 | 1.95e-91 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g13703 | i0 | 98.477 | 14.8434343434343 | 197 | 3 | 99 | 0 | 1 | 197 | 2585 | 2389 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 2939 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 10602837 | 10602837 | PRJNA358490_P_NODE_5129_length_606_cov_5.982363_g4846_i0 | PRJNA358490 | 5129 | 606 | 5.982363 | 36.25311978 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 258 | 1.77e-85 | NR | CAF3339458.1 | 2762511 | g4846 | i0 | 93.5 | 0.688118811881188 | 139 | 9 | 68.8 | 0 | 63 | 479 | 1 | 139 | CAF3339458.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 417 | 258 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 12551765 | 12551765 | PRJNA358490_P_NODE_8050_length_433_cov_2.091371_g7709_i0 | PRJNA358490 | 8050 | 433 | 2.091371 | 9.05563643 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 173 | 5.3099999999999985e-47 | NR | UJR31491.1 | 104782 | g7709 | i0 | 75.4 | 6.57505773672055 | 118 | 22 | 81.8 | 1 | 356 | 3 | 1 | 111 | UJR31491.1 hypothetical protein I4U23_018980 [Adineta vaga] | diamond | 2847 | 173 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 13152805 | 13152805 | PRJNA358490_P_NODE_4591_length_652_cov_13.311582_g4326_i0 | PRJNA358490 | 4591 | 652 | 13.311582 | 86.79151464 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 667 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g4326 | i0 | 87.65 | 31.6871165644172 | 583 | 61 | 88 | 10 | 77 | 652 | 1828 | 2406 | Philodina citrina complete mitochondrial genome | blastn | 20660 | 667 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 20800548 | 20800548 | PRJNA358490_P_NODE_3737_length_739_cov_5.061429_g3512_i0 | PRJNA358490 | 3737 | 739 | 5.061429 | 37.40396031 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 347 | 5.519999999999997e-119 | NR | CAF5181533.1 | 392030 | g3512 | i0 | 92.7 | 1.52638700947226 | 193 | 14 | 78.3 | 0 | 56 | 634 | 8 | 200 | CAF5181533.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 1128 | 347 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 24625263 | 24625263 | PRJNA358490_P_NODE_2360_length_927_cov_7.825450_g2199_i0 | PRJNA358490 | 2360 | 927 | 7.82545 | 72.5419215 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 479 | 2.3e-168 | NR | CAF0961233.1 | 392033 | g2199 | i0 | 92.4 | 1.69255663430421 | 262 | 20 | 84.8 | 0 | 815 | 30 | 35 | 296 | CAF0961233.1 unnamed protein product [Rotaria sordida] | diamond | 1569 | 479 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 24625359 | 24625359 | PRJNA358490_P_NODE_8920_length_391_cov_3.224432_g8579_i0 | PRJNA358490 | 8920 | 391 | 3.224432 | 12.60752912 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 350 | 1.18e-91 | NTclustered | gi|402761723|gb|JX183993.1| | 104782 | g8579 | i0 | 83.646 | 0.953964194373402 | 373 | 59 | 95 | 1 | 1 | 371 | 620 | 248 | Adineta vaga ATP synthase F0 subunit 6 (ATP6) gene, partial cds; mitochondrial | blastn | 373 | 350 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27201093 | 27201093 | PRJNA358490_P_NODE_9482_length_360_cov_2.841121_g9140_i0 | PRJNA358490 | 9482 | 360 | 2.841121 | 10.2280356 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 97.8 | 5.0099999999999994e-24 | NR | CAF1425027.1 | 249248 | g9140 | i0 | 63.2 | 0.633333333333333 | 76 | 21 | 57.5 | 2 | 78 | 284 | 4 | 79 | CAF1425027.1 unnamed protein product [Adineta ricciae] | diamond | 228 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27643742 | 27643742 | PRJNA358490_P_NODE_6784_length_498_cov_2.566449_g6453_i0 | PRJNA358490 | 6784 | 498 | 2.566449 | 12.78091602 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 75.1 | 4.09e-14 | NR | AFQ96990.1 | 104788 | g6453 | i0 | 70 | 0.602409638554217 | 50 | 15 | 30.1 | 0 | 27 | 176 | 3 | 52 | AFQ96990.1 NADH dehydrogenase subunit 3 [Macrotrachela quadricornifera] | diamond | 300 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 27896013 | 27896013 | PRJNA358490_P_NODE_15045_length_182_cov_1.419580_g14701_i0 | PRJNA358490 | 15045 | 182 | 1.41958 | 2.5836356 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 85.9 | 5.93e-18 | NR | CAF0906554.1 | 249248 | g14701 | i0 | 73.6 | 1.74725274725275 | 53 | 14 | 87.4 | 0 | 23 | 181 | 286 | 338 | CAF0906554.1 unnamed protein product [Adineta ricciae] | diamond | 318 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28938166 | 28938166 | PRJNA358490_P_NODE_12948_length_223_cov_1.766304_g12604_i0 | PRJNA358490 | 12948 | 223 | 1.766304 | 3.93885792 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 111 | 1.89e-27 | NR | CAF3431822.1 | 2762511 | g12604 | i0 | 77 | 4.10313901345291 | 61 | 14 | 82.1 | 0 | 222 | 40 | 270 | 330 | CAF3431822.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 915 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 30548740 | 30548740 | PRJNA358490_P_NODE_17153_length_159_cov_2.008333_g16809_i0 | PRJNA358490 | 17153 | 159 | 2.008333 | 3.19324947 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 43.1 | 0.00813 | NR | CAF2578343.1 | 2762512 | g16809 | i0 | 80 | 0.471698113207547 | 25 | 5 | 47.2 | 0 | 2 | 76 | 224 | 248 | CAF2578343.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 75 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 |
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);;