contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA642647" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1158547 | 1158547 | PRJNA642647_P_NODE_181_length_844_cov_43.156134_g150_i0 | PRJNA642647 | 181 | 844 | 43.156134 | 364.23777096 | Ploima | 84394 | Rotifera | other_Eukaryota | 573 | 1.4699999999999995e-158 | NTclustered | gi|61200806|gb|AY829084.1| | 160652 | g150 | i0 | 94.851 | 47.8471563981043 | 369 | 16 | 65 | 3 | 4 | 369 | 1363 | 1731 | Brachionus patulus 28S ribosomal RNA gene, partial sequence | blastn | 40383 | 575 | 0.996521739130435 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus patulus | |
| 3168836 | 3168836 | PRJNA642647_P_NODE_5403_length_163_cov_2.920635_g5353_i0 | PRJNA642647 | 5403 | 163 | 2.920635 | 4.76063505 | Brachionus patulus | 160652 | Rotifera | other_Eukaryota | 268 | 1.24e-67 | NTclustered | gi|61200806|gb|AY829084.1| | 160652 | g5353 | i0 | 96.875 | 77.4049079754601 | 160 | 5 | 98 | 0 | 4 | 163 | 1142 | 1301 | Brachionus patulus 28S ribosomal RNA gene, partial sequence | blastn | 12617 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus patulus | |
| 6996574 | 6996574 | PRJNA642647_P_NODE_586_length_462_cov_13.134118_g537_i0 | PRJNA642647 | 586 | 462 | 13.134118 | 60.67962516 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 640 | 7.529999999999999e-179 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g537 | i0 | 91.757 | 75.8701298701299 | 461 | 36 | 99 | 2 | 1 | 459 | 747 | 287 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 35052 | 640 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 13372008 | 13372008 | PRJNA642647_P_NODE_2691_length_211_cov_2.994253_g2641_i0 | PRJNA642647 | 2691 | 211 | 2.994253 | 6.31787383 | Habrotrocha elusa | 468653 | Rotifera | other_Eukaryota | 379 | 7.489999999999999e-101 | NTclustered | gi|2537903795|gb|KM043260.2| | 1548227 | g2641 | i0 | 99.519 | 98.5355450236967 | 208 | 1 | 99 | 0 | 1 | 208 | 849 | 642 | Habrotrocha elusa elusa voucher HB001 18S ribosomal RNA gene, partial sequence | blastn | 20791 | 379 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha elusa | |
| 17195917 | 17195917 | PRJNA642647_P_NODE_1734_length_263_cov_12.880531_g1684_i0 | PRJNA642647 | 1734 | 263 | 12.880531 | 33.87579653 | Epiphanes senta | 338913 | Rotifera | other_Eukaryota | 355 | 1.63e-93 | NTclustered | gi|72153754|gb|DQ089742.1| | 338913 | g1684 | i0 | 91.571 | 53.4334600760456 | 261 | 17 | 98 | 5 | 4 | 261 | 1841 | 2099 | Epiphanes senta 28S ribosomal RNA gene, partial sequence | blastn | 14053 | 355 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Epiphanidae | Epiphanes | Epiphanes senta | |
| 17736459 | 17736459 | PRJNA642647_P_NODE_2554_length_216_cov_3.039106_g2504_i0 | PRJNA642647 | 2554 | 216 | 3.039106 | 6.56446896 | Metazoa | 33208 | Rotifera | other_Eukaryota | 394 | 2.75e-105 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g2504 | i0 | 99.537 | 90.6435185185185 | 216 | 1 | 100 | 0 | 1 | 216 | 930 | 1145 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 19579 | 394 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 17736471 | 17736471 | PRJNA642647_P_NODE_3854_length_182_cov_11.675862_g3804_i0 | PRJNA642647 | 3854 | 182 | 11.675862 | 21.25006884 | Brachionus | 10194 | Rotifera | other_Eukaryota | 316 | 4.97e-82 | NTclustered | gi|1035550476|gb|KU299741.1| | 1858257 | g3804 | i0 | 98.87 | 96.7252747252747 | 177 | 2 | 97 | 0 | 2 | 178 | 594 | 418 | Brachionus plicatilis complex sp. Esk 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 17604 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis complex sp. Esk | |
| 22295060 | 22295060 | PRJNA642647_P_NODE_2258_length_228_cov_3.340314_g2208_i0 | PRJNA642647 | 2258 | 228 | 3.340314 | 7.61591592 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 383 | 6.35e-102 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g2208 | i0 | 97.333 | 57.6052631578947 | 225 | 6 | 99 | 0 | 4 | 228 | 2485 | 2709 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 13134 | 383 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 24110432 | 24110432 | PRJNA642647_P_NODE_1539_length_280_cov_3.345679_g1489_i0 | PRJNA642647 | 1539 | 280 | 3.345679 | 9.3679012 | Metazoa | 33208 | Rotifera | other_Eukaryota | 475 | 1.2899999999999997e-129 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g1489 | i0 | 99.615 | 41.025 | 260 | 1 | 93 | 0 | 1 | 260 | 2174 | 1915 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 11487 | 475 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola |
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);;