contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA263496" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 368943 | 368943 | PRJNA263496_P_NODE_10941_length_238_cov_1.026455_g10688_i0 | PRJNA263496 | 10941 | 238 | 1.026455 | 2.4429629 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 412 | 8.51e-111 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g10688 | i0 | 97.908 | 73.7563025210084 | 239 | 3 | 100 | 2 | 1 | 238 | 4411 | 4174 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 17554 | 412 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 369605 | 369605 | PRJNA263496_P_NODE_8061_length_281_cov_2.672414_g7808_i0 | PRJNA263496 | 8061 | 281 | 2.672414 | 7.50948334 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 287 | 6.520000000000001e-73 | NTclustered | gi|270267490|ref|NC_013568.1| | 231624 | g7808 | i0 | 85.612 | 24.1779359430605 | 278 | 35 | 99 | 5 | 1 | 277 | 2150 | 2423 | Rotaria rotatoria mitochondrion, complete genome | blastn | 6794 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 3607710 | 3607710 | PRJNA263496_P_NODE_18783_length_179_cov_1.223077_g18530_i0 | PRJNA263496 | 18783 | 179 | 1.223077 | 2.18930783 | Brachionus | 10194 | Rotifera | other_Eukaryota | 137 | 4.07e-28 | NTclustered | gi|307640140|gb|GQ894748.1| | 183145 | g18530 | i0 | 84.892 | 49.340782122905 | 139 | 17 | 77 | 4 | 2 | 138 | 144 | 8 | Brachionus sp. Almenara isolate 7C29 large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 8832 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus sp. Almenara | |
| 6746754 | 6746754 | PRJNA263496_P_NODE_12426_length_222_cov_1.768786_g12173_i0 | PRJNA263496 | 12426 | 222 | 1.768786 | 3.92670492 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 274 | 3.86e-69 | NTclustered | gi|187233663|gb|EU643498.1| | 104782 | g12173 | i0 | 89.091 | 1.33333333333333 | 220 | 24 | 99 | 0 | 3 | 222 | 136 | 355 | Adineta vaga ribosomal protein S1a mRNA, partial cds | blastn | 296 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 8022542 | 8022542 | PRJNA263496_P_NODE_15227_length_200_cov_1.350993_g14974_i0 | PRJNA263496 | 15227 | 200 | 1.350993 | 2.701986 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 159 | 9.95e-35 | NTclustered | gi|402761777|gb|JX184020.1| | 104788 | g14974 | i0 | 84.242 | 0.825 | 165 | 24 | 82 | 2 | 2 | 165 | 227 | 64 | Macrotrachela quadricornifera isolate CR cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial | blastn | 165 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 9297453 | 9297453 | PRJNA263496_P_NODE_24608_length_162_cov_0.902655_g24355_i0 | PRJNA263496 | 24608 | 162 | 0.902655 | 1.4623011 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 110 | 7.89e-20 | NTclustered | gi|209867697|gb|EU637022.1| | 96448 | g24355 | i0 | 98.387 | 0.382716049382716 | 62 | 1 | 38 | 0 | 2 | 63 | 2890 | 2829 | Philodina roseola GM2 ganglioside activator precursor-like protein, tubulin-like protein, cAMP-dependent protein kinase typeII-alpha regulatory subunit-like protein, hypothetical proteins, Hox-6c, ubiquinol-cytochrome c reductase-like protein, hypothetical proteins, CDC23-like protein, exportin 5-like protein, Cezanne 2 protein-like protein, hypothetical protein, cationic amino acid transporter-like proteins, and hypothetical protein genes, complete cds; and RhoGAP-like protein gene, complete sequence | blastn | 62 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 10573692 | 10573692 | PRJNA263496_P_NODE_9829_length_252_cov_1.206897_g9576_i0 | PRJNA263496 | 9829 | 252 | 1.206897 | 3.04138044 | Philodina sp. NPS-2005 | 317012 | Rotifera | other_Eukaryota | 411 | 3.269999999999999e-110 | NTclustered | gi|62362203|gb|AY942841.1| | 317012 | g9576 | i0 | 96.032 | 1.63492063492063 | 252 | 10 | 100 | 0 | 1 | 252 | 354 | 103 | Philodina sp. NPS-2005 guanine nucleotide binding protein beta polypeptide 2-like 1 mRNA, partial cds | blastn | 412 | 411 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina sp. NPS-2005 | |
| 11260398 | 11260398 | PRJNA263496_P_NODE_20449_length_170_cov_1.264463_g20196_i0 | PRJNA263496 | 20449 | 170 | 1.264463 | 2.1495871 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 224 | 2.8499999999999996e-54 | NTclustered | gi|134141776|gb|EF173252.1| | 104782 | g20196 | i0 | 91.875 | 82.9411764705882 | 160 | 13 | 94 | 0 | 2 | 161 | 498 | 657 | Adineta vaga isolate TZ.1.2 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 14100 | 226 | 0.991150442477876 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 14398436 | 14398436 | PRJNA263496_P_NODE_25392_length_161_cov_0.910714_g25139_i0 | PRJNA263496 | 25392 | 161 | 0.910714 | 1.46624954 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 182 | 1.64e-41 | NTclustered | gi|194500475|gb|EU850440.1| | 96448 | g25139 | i0 | 87.037 | 1.00621118012422 | 162 | 19 | 100 | 2 | 1 | 161 | 23726 | 23886 | Philodina roseola rho GTPase activating protein, histone H4, histone H3, histone H2B, histone H2Av, cleft lip and palate associated transmembrane, mitochondrial ribosomal protein s22, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, filament protein, nucleolar complex associated protein, hypothetical protein 21, putative GPCR, and hypothetical protein 22 genes, complete cds | blastn | 162 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 18221271 | 18221271 | PRJNA263496_P_NODE_8255_length_277_cov_1.486842_g8002_i0 | PRJNA263496 | 8255 | 277 | 1.486842 | 4.11855234 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 261 | 3.89e-65 | NTclustered | gi|402761759|gb|JX184011.1| | 104788 | g8002 | i0 | 83.755 | 12.6823104693141 | 277 | 43 | 99 | 2 | 2 | 277 | 587 | 312 | Macrotrachela quadricornifera isolate MQ cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial | blastn | 3513 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 19495559 | 19495559 | PRJNA263496_P_NODE_7976_length_283_cov_1.743590_g7723_i0 | PRJNA263496 | 7976 | 283 | 1.74359 | 4.9343597 | Philodina megalotrocha | 1234259 | Rotifera | other_Eukaryota | 481 | 2.81e-131 | NTclustered | gi|1976325703|gb|MW577596.1| | 1234259 | g7723 | i0 | 97.509 | 99 | 281 | 7 | 99 | 0 | 3 | 283 | 236 | 516 | Philodina megalotrocha isolate RiGrAm.2.1 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial | blastn | 28017 | 481 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina megalotrocha | |
| 22045788 | 22045788 | PRJNA263496_P_NODE_17278_length_187_cov_1.478261_g17025_i0 | PRJNA263496 | 17278 | 187 | 1.478261 | 2.76434807 | Philodina plena | 563911 | Rotifera | other_Eukaryota | 265 | 1.89e-66 | NTclustered | gi|209405829|gb|EU751137.1| | 563911 | g17025 | i0 | 94.22 | 95.9839572192513 | 173 | 10 | 93 | 0 | 4 | 176 | 2 | 174 | Philodina plena isolate TU.j.1 cytochrome oxidase subunit I (cox1) gene, partial cds; mitochondrial | blastn | 17949 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina plena | |
| 22046226 | 22046226 | PRJNA263496_P_NODE_9438_length_257_cov_1.865385_g9185_i0 | PRJNA263496 | 9438 | 257 | 1.865385 | 4.79403945 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 248 | 2.78e-61 | NTclustered | gi|403492623|gb|JX193050.1| | 104782 | g9185 | i0 | 90.426 | 18.2295719844358 | 188 | 18 | 73 | 0 | 1 | 188 | 712 | 525 | Adineta vaga isolate BE1C1 alpha tubulin gene, partial cds | blastn | 4685 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 24595641 | 24595641 | PRJNA263496_P_NODE_3260_length_490_cov_4.950113_g3007_i0 | PRJNA263496 | 3260 | 490 | 4.950113 | 24.2555537 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 603 | 1.0499999999999999e-167 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g3007 | i0 | 89.648 | 27.9326530612245 | 483 | 37 | 97 | 11 | 14 | 490 | 1678 | 2153 | Philodina citrina complete mitochondrial genome | blastn | 13687 | 603 | 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);;