contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA758398" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2015594 | 2015594 | PRJNA758398_S_NODE_16082_length_248_cov_1.633166_g15941_i0 | PRJNA758398 | 16082 | 248 | 1.633166 | 4.05025168 | Philodina sp. NPS-2005 | 317012 | Rotifera | other_Eukaryota | 331 | 2.57e-86 | NTclustered | gi|62362203|gb|AY942841.1| | 317012 | g15941 | i0 | 92.609 | 0.92741935483871 | 230 | 17 | 93 | 0 | 19 | 248 | 220 | 449 | Philodina sp. NPS-2005 guanine nucleotide binding protein beta polypeptide 2-like 1 mRNA, partial cds | blastn | 230 | 331 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina sp. NPS-2005 | |
| 2015978 | 2015978 | PRJNA758398_S_NODE_5022_length_424_cov_1.360000_g4881_i0 | PRJNA758398 | 5022 | 424 | 1.36 | 5.7664 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 470 | 9.52e-128 | NTclustered | gi|183178949|gb|EU432548.1| | 96448 | g4881 | i0 | 86.667 | 2.85849056603774 | 435 | 45 | 99 | 9 | 2 | 424 | 40710 | 40277 | Philodina roseola guanylyl cyclase gene, complete sequence; and TAR-protein (TAR_2), U1-like Zn-finger-containing protein (U1Zn_2), unknown (PruORF0001_2), unknown (PrPCG0001_2), methione sulfide reductase B (MSRB_2), Strabismus, serine-threonin kinase copy 2, plasma membrane calcium-dependent ATPase (CAse_2), myosin essential light chain (MELC_2), 82 kDa heat shock protein (hsp82_4), FBox-LRR protein (FBoxLRR_2), TPRA_2 (TPRA_2), phosphoribosylaminoimidazole carboxylase (PAICS_2), and unknown (PruORF0002_2) genes, complete cds | blastn | 1212 | 470 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 7118701 | 7118701 | PRJNA758398_S_NODE_43626_length_166_cov_1.521368_g43485_i0 | PRJNA758398 | 43626 | 166 | 1.521368 | 2.52547088 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 202 | 1.2999999999999998e-47 | NTclustered | gi|402761779|gb|JX184021.1| | 104788 | g43485 | i0 | 88.554 | 41.0481927710843 | 166 | 19 | 100 | 0 | 1 | 166 | 676 | 841 | Macrotrachela quadricornifera isolate HR cytochrome b (CYTB) gene, complete cds; mitochondrial | blastn | 6814 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 7118841 | 7118841 | PRJNA758398_S_NODE_7846_length_343_cov_2.040816_g7705_i0 | PRJNA758398 | 7846 | 343 | 2.040816 | 6.99999888 | Philodina sp. NPS-2005 | 317012 | Rotifera | other_Eukaryota | 396 | 1.3e-105 | NTclustered | gi|62362199|gb|AY942839.1| | 317012 | g7705 | i0 | 88.415 | 16.6618075801749 | 328 | 34 | 94 | 3 | 3 | 326 | 365 | 38 | Philodina sp. NPS-2005 S14e ribosomal protein-like protein mRNA, complete cds | blastn | 5715 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina sp. NPS-2005 | |
| 8392908 | 8392908 | PRJNA758398_S_NODE_22067_length_218_cov_3.017751_g21926_i0 | PRJNA758398 | 22067 | 218 | 3.017751 | 6.57869718 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 207 | 3.89e-49 | NTclustered | gi|403492564|gb|JX193021.1| | 249248 | g21926 | i0 | 89.571 | 14.9357798165138 | 163 | 17 | 75 | 0 | 54 | 216 | 1019 | 857 | Adineta ricciae isolate AU.1.2 alpha tubulin gene, partial cds | blastn | 3256 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 9668248 | 9668248 | PRJNA758398_S_NODE_29708_length_195_cov_1.047945_g29567_i0 | PRJNA758398 | 29708 | 195 | 1.047945 | 2.04349275 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 145 | 2.7e-30 | NTclustered | gi|183178949|gb|EU432548.1| | 96448 | g29567 | i0 | 84.459 | 17.4871794871795 | 148 | 21 | 75 | 2 | 5 | 151 | 39381 | 39527 | Philodina roseola guanylyl cyclase gene, complete sequence; and TAR-protein (TAR_2), U1-like Zn-finger-containing protein (U1Zn_2), unknown (PruORF0001_2), unknown (PrPCG0001_2), methione sulfide reductase B (MSRB_2), Strabismus, serine-threonin kinase copy 2, plasma membrane calcium-dependent ATPase (CAse_2), myosin essential light chain (MELC_2), 82 kDa heat shock protein (hsp82_4), FBox-LRR protein (FBoxLRR_2), TPRA_2 (TPRA_2), phosphoribosylaminoimidazole carboxylase (PAICS_2), and unknown (PruORF0002_2) genes, complete cds | blastn | 3410 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 17318225 | 17318225 | PRJNA758398_S_NODE_51014_length_162_cov_2.132743_g50873_i0 | PRJNA758398 | 51014 | 162 | 2.132743 | 3.45504366 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 171 | 3.57e-38 | NTclustered | gi|403492629|gb|JX193053.1| | 104782 | g50873 | i0 | 86.076 | 1.97530864197531 | 158 | 22 | 98 | 0 | 2 | 159 | 557 | 714 | Adineta vaga isolate BE1C1 alpha tubulin gene, partial cds | blastn | 320 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 19866590 | 19866590 | PRJNA758398_S_NODE_276_length_1365_cov_5.381459_g236_i0 | PRJNA758398 | 276 | 1365 | 5.381459 | 73.45691535 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 1637 | 0 | NTclustered | gi|402761741|gb|JX184002.1| | 104786 | g236 | i0 | 88.343 | 43.8498168498168 | 1364 | 157 | 99 | 2 | 3 | 1365 | 175 | 1537 | Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 59855 | 1637 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 19866685 | 19866685 | PRJNA758398_S_NODE_34216_length_183_cov_1.522388_g34075_i0 | PRJNA758398 | 34216 | 183 | 1.522388 | 2.78597004 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 224 | 3.1199999999999996e-54 | NTclustered | gi|403492558|gb|JX193018.1| | 249248 | g34075 | i0 | 89.326 | 26.0928961748634 | 178 | 19 | 97 | 0 | 2 | 179 | 571 | 748 | Adineta ricciae isolate AU.1.2 alpha tubulin gene, partial cds | blastn | 4775 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 20330818 | 20330818 | PRJNA758398_S_NODE_3076_length_539_cov_2.446939_g2938_i0 | PRJNA758398 | 3076 | 539 | 2.446939 | 13.18900121 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 606 | 9.009999999999996e-169 | NTclustered | gi|402761787|gb|JX184025.1| | 104782 | g2938 | i0 | 87.406 | 22.7384044526902 | 532 | 61 | 98 | 5 | 11 | 539 | 38 | 566 | Adineta vaga cytochrome b (CYTB) gene, complete cds; mitochondrial | blastn | 12256 | 608 | 0.996710526315789 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 21142078 | 21142078 | PRJNA758398_S_NODE_1537_length_727_cov_13.533923_g1424_i0 | PRJNA758398 | 1537 | 727 | 13.533923 | 98.39162021 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 828 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g1424 | i0 | 87.904 | 21.6341127922971 | 711 | 76 | 97 | 7 | 1 | 706 | 1694 | 2399 | Philodina citrina complete mitochondrial genome | blastn | 15728 | 828 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 21142427 | 21142427 | PRJNA758398_S_NODE_41817_length_167_cov_1.533898_g41676_i0 | PRJNA758398 | 41817 | 167 | 1.533898 | 2.56160966 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 169 | 1.33e-37 | NTclustered | gi|209867641|gb|EU637019.1| | 96448 | g41676 | i0 | 85.03 | 54.2994011976048 | 167 | 24 | 99 | 1 | 2 | 167 | 27019 | 27185 | 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 | 9068 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 22417138 | 22417138 | PRJNA758398_S_NODE_32838_length_186_cov_4.226277_g32697_i0 | PRJNA758398 | 32838 | 186 | 4.226277 | 7.86087522 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 267 | 5.22e-67 | NTclustered | gi|402761741|gb|JX184002.1| | 104786 | g32697 | i0 | 92.473 | 85.8763440860215 | 186 | 14 | 100 | 0 | 1 | 186 | 203 | 18 | Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 15973 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 23692743 | 23692743 | PRJNA758398_S_NODE_3559_length_502_cov_3.567329_g3418_i0 | PRJNA758398 | 3559 | 502 | 3.567329 | 17.90799158 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 440 | 8.959999999999997e-119 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g3418 | i0 | 83.403 | 10.5876494023904 | 476 | 78 | 95 | 1 | 1 | 476 | 9824 | 10298 | Philodina citrina complete mitochondrial genome | blastn | 5315 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina |
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);;