contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA763718" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020225 | 2020225 | PRJNA763718_S_NODE_6542_length_171_cov_1.626866_g6334_i0 | PRJNA763718 | 6542 | 171 | 1.626866 | 2.78194086 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 152 | 1.37e-32 | NTclustered | gi|403492568|gb|JX193023.1| | 249248 | g6334 | i0 | 88.189 | 3.22222222222222 | 127 | 15 | 74 | 0 | 45 | 171 | 1027 | 901 | Adineta ricciae isolate AU.1.2 alpha tubulin gene, partial cds | blastn | 551 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 7583455 | 7583455 | PRJNA763718_S_NODE_8366_length_153_cov_1.965517_g8158_i0 | PRJNA763718 | 8366 | 153 | 1.965517 | 3.00724101 | Ploima | 84394 | Rotifera | other_Eukaryota | 272 | 8.84e-69 | NTclustered | gi|1957252648|gb|MW484998.1| | 1213212 | g8158 | i0 | 98.693 | 100.104575163399 | 153 | 2 | 100 | 0 | 1 | 153 | 1411 | 1563 | Lecane monostyla voucher NNIBRIV50294 small subunit ribosomal RNA gene, partial sequence | blastn | 15316 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane monostyla | |
| 13497968 | 13497968 | PRJNA763718_S_NODE_8251_length_154_cov_1.649573_g8043_i0 | PRJNA763718 | 8251 | 154 | 1.649573 | 2.54034242 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 150 | 4.359999999999999e-32 | NTclustered | gi|2105975276|gb|MZ706949.1| | 104777 | g8043 | i0 | 89.744 | 73.5714285714286 | 117 | 12 | 76 | 0 | 37 | 153 | 26798 | 26682 | Brachionus calyciflorus chromosome I mitochondrion, complete sequence | blastn | 11330 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 14773140 | 14773140 | PRJNA763718_S_NODE_7152_length_164_cov_1.519685_g6944_i0 | PRJNA763718 | 7152 | 164 | 1.519685 | 2.4922834 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 152 | 1.31e-32 | NTclustered | gi|402761789|gb|JX184026.1| | 104786 | g6944 | i0 | 83.832 | 1.01829268292683 | 167 | 19 | 99 | 6 | 2 | 164 | 895 | 1057 | Habrotrocha constricta cytochrome b (CYTB) gene, complete cds; mitochondrial | blastn | 167 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 16046799 | 16046799 | PRJNA763718_S_NODE_2533_length_285_cov_9.814516_g2325_i0 | PRJNA763718 | 2533 | 285 | 9.814516 | 27.9713706 | Brachionus angularis | 396692 | Rotifera | other_Eukaryota | 183 | 8.949999999999997e-42 | NTclustered | gi|213959396|gb|FJ426630.1| | 396692 | g2325 | i0 | 79.554 | 9.44912280701754 | 269 | 45 | 93 | 10 | 12 | 277 | 380 | 119 | Brachionus angularis voucher S. H. Cheng 001 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 2693 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus angularis | |
| 16046816 | 16046816 | PRJNA763718_S_NODE_5173_length_192_cov_10.832258_g4965_i0 | PRJNA763718 | 5173 | 192 | 10.832258 | 20.79793536 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 281 | 1.9400000000000002e-71 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g4965 | i0 | 93.264 | 50.6927083333333 | 193 | 10 | 99 | 3 | 1 | 191 | 1907 | 2098 | Philodina citrina complete mitochondrial genome | blastn | 9733 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 18595845 | 18595845 | PRJNA763718_S_NODE_6055_length_177_cov_11.400000_g5847_i0 | PRJNA763718 | 6055 | 177 | 11.4 | 20.178 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 255 | 1.06e-63 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g5847 | i0 | 96.154 | 4.24293785310734 | 156 | 6 | 88 | 0 | 22 | 177 | 2399 | 2244 | Philodina citrina complete mitochondrial genome | blastn | 751 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 21146734 | 21146734 | PRJNA763718_S_NODE_6877_length_167_cov_1.784615_g6669_i0 | PRJNA763718 | 6877 | 167 | 1.784615 | 2.98030705 | Lecane hamata | 1213208 | Rotifera | other_Eukaryota | 191 | 2.85e-44 | NTclustered | gi|1199302039|gb|KY749534.1| | 1213208 | g6669 | i0 | 87.349 | 99.0958083832335 | 166 | 21 | 99 | 0 | 1 | 166 | 594 | 429 | Lecane hamata isolate TIN60DE cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 16549 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane hamata | |
| 23697132 | 23697132 | PRJNA763718_S_NODE_3699_length_230_cov_1.984456_g3491_i0 | PRJNA763718 | 3699 | 230 | 1.984456 | 4.5642488 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 309 | 1.1e-79 | NTclustered | gi|402761731|gb|JX183997.1| | 104788 | g3491 | i0 | 90.87 | 98.5913043478261 | 230 | 21 | 100 | 0 | 1 | 230 | 694 | 923 | Macrotrachela quadricornifera isolate HR cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 22676 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera |
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);;