contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA611476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10794343 | 10794343 | PRJNA611476_P_NODE_88889_length_249_cov_0.875000_g88098_i0 | PRJNA611476 | 88889 | 249 | 0.875 | 2.17875 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 327 | 3.34e-85 | NTclustered | gi|183178937|gb|EU432547.1| | 96448 | g88098 | i0 | 90.4 | 4.76706827309237 | 250 | 22 | 100 | 2 | 1 | 249 | 30711 | 30959 | Philodina roseola TAR protein gene, partial cds; U1-like Zn-finger-containing protein (U1Zn_1), unknown (PruORF0001_1), unknown (PrPCG0001_1), methione sulfide reductase B (MSRB_1), Strabismus, serine-threonin kinase copy 1, plasma membrane calcium-dependent ATPase (CAse_1), myosin essential light chain (MELC_1), and 82 kDa heat shock protein (hsp82_1) genes, complete cds; FBoxLRR_1 gene, complete sequence; and TPRA_1 (TPRA_1) gene, complete cds | blastn | 1187 | 327 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 12068792 | 12068792 | PRJNA611476_P_NODE_38250_length_343_cov_0.996296_g37459_i0 | PRJNA611476 | 38250 | 343 | 0.996296 | 3.41729528 | Philodina sp. NPS-2005 | 317012 | Rotifera | other_Eukaryota | 381 | 3.639999999999999e-101 | NTclustered | gi|62362199|gb|AY942839.1| | 317012 | g37459 | i0 | 86.589 | 27.7172011661808 | 343 | 46 | 100 | 0 | 1 | 343 | 148 | 490 | Philodina sp. NPS-2005 S14e ribosomal protein-like protein mRNA, complete cds | blastn | 9507 | 381 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina sp. NPS-2005 | |
| 12069555 | 12069555 | PRJNA611476_P_NODE_9410_length_634_cov_1.698752_g8628_i0 | PRJNA611476 | 9410 | 634 | 1.698752 | 10.77008768 | Lecane closterocerca | 1213203 | Rotifera | other_Eukaryota | 682 | 0 | NTclustered | gi|401880205|gb|JX216670.1| | 1213203 | g8628 | i0 | 86.688 | 96.2034700315457 | 616 | 80 | 97 | 2 | 20 | 634 | 2 | 616 | Lecane closterocerca voucher ECOCHZ-AG0915.1 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial | blastn | 60993 | 682 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane closterocerca | |
| 13344005 | 13344005 | PRJNA611476_P_NODE_7331_length_716_cov_4.519440_g6564_i0 | PRJNA611476 | 7331 | 716 | 4.51944 | 32.3591904 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 837 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g6564 | i0 | 87.989 | 21.9804469273743 | 716 | 77 | 99 | 6 | 5 | 716 | 2399 | 1689 | Philodina citrina complete mitochondrial genome | blastn | 15738 | 837 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 14618140 | 14618140 | PRJNA611476_P_NODE_20232_length_443_cov_1.456757_g19441_i0 | PRJNA611476 | 20232 | 443 | 1.456757 | 6.45343351 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 507 | 7.61e-139 | NTclustered | gi|402761791|gb|JX184027.1| | 104788 | g19441 | i0 | 87.416 | 24.2708803611738 | 445 | 51 | 100 | 5 | 1 | 443 | 493 | 52 | Macrotrachela quadricornifera isolate MQ cytochrome b (CYTB) gene, complete cds; mitochondrial | blastn | 10752 | 507 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 18441189 | 18441189 | PRJNA611476_P_NODE_17895_length_468_cov_1.556962_g17105_i0 | PRJNA611476 | 17895 | 468 | 1.556962 | 7.28658216 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 424 | 8.37e-114 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g17105 | i0 | 83.516 | 3.97008547008547 | 455 | 73 | 97 | 2 | 15 | 468 | 10155 | 9702 | Philodina citrina complete mitochondrial genome | blastn | 1858 | 424 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 18441194 | 18441194 | PRJNA611476_P_NODE_1815_length_1464_cov_2.744069_g1323_i0 | PRJNA611476 | 1815 | 1464 | 2.744069 | 40.17317016 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 1766 | 0 | NTclustered | gi|402761741|gb|JX184002.1| | 104786 | g1323 | i0 | 88.464 | 47.5696721311475 | 1465 | 166 | 99 | 3 | 1 | 1463 | 1531 | 68 | Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 69642 | 1766 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 19715808 | 19715808 | PRJNA611476_P_NODE_25056_length_404_cov_1.516616_g24265_i0 | PRJNA611476 | 25056 | 404 | 1.516616 | 6.12712864 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 272 | 2.73e-68 | NTclustered | gi|402761877|gb|JX184070.1| | 104788 | g24265 | i0 | 79.208 | 9.03217821782178 | 404 | 74 | 99 | 10 | 1 | 399 | 534 | 932 | Macrotrachela quadricornifera isolate MM NADH dehydrogenase subunit 5 (ND5) gene, complete cds; mitochondrial | blastn | 3649 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 21549903 | 21549903 | PRJNA611476_P_NODE_50677_length_306_cov_1.321888_g49886_i0 | PRJNA611476 | 50677 | 306 | 1.321888 | 4.04497728 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 355 | 1.94e-93 | NTclustered | gi|209867641|gb|EU637019.1| | 96448 | g49886 | i0 | 87.582 | 29.9607843137255 | 306 | 38 | 100 | 0 | 1 | 306 | 26975 | 27280 | Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds | blastn | 9168 | 355 | 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);;