contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA384462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 405335 | 405335 | PRJNA384462_S_NODE_2281_length_345_cov_3.496622_g2165_i0 | PRJNA384462 | 2281 | 345 | 3.496622 | 12.0633459 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 353 | 7.99e-93 | NTclustered | gi|402761741|gb|JX184002.1| | 104786 | g2165 | i0 | 85.546 | 1.8695652173913 | 339 | 47 | 98 | 2 | 1 | 338 | 1183 | 1520 | Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 645 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 1680139 | 1680139 | PRJNA384462_S_NODE_11162_length_176_cov_1.889764_g11046_i0 | PRJNA384462 | 11162 | 176 | 1.889764 | 3.32598464 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 215 | 1.79e-51 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g11046 | i0 | 89.017 | 2.92045454545455 | 173 | 19 | 98 | 0 | 1 | 173 | 10756 | 10928 | Philodina citrina complete mitochondrial genome | blastn | 514 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 1680165 | 1680165 | PRJNA384462_S_NODE_2382_length_337_cov_1.364583_g2266_i0 | PRJNA384462 | 2382 | 337 | 1.364583 | 4.59864471 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 459 | 1.6e-124 | NTclustered | gi|157365320|gb|EF650520.1| | 96448 | g2266 | i0 | 98.462 | 73.4302670623145 | 260 | 4 | 77 | 0 | 1 | 260 | 371 | 630 | Philodina roseola isolate P.rose.IT cytochrome oxidase subunit I gene, partial cds; mitochondrial | blastn | 24746 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 2955979 | 2955979 | PRJNA384462_S_NODE_10503_length_180_cov_1.557252_g10387_i0 | PRJNA384462 | 10503 | 180 | 1.557252 | 2.8030536 | Mytilina mucronata | 360681 | Rotifera | other_Eukaryota | 148 | 1.89e-31 | NTclustered | gi|83321191|gb|DQ297809.1| | 360681 | g10387 | i0 | 82.353 | 7.22777777777778 | 170 | 30 | 94 | 0 | 2 | 171 | 170 | 1 | Mytilina mucronata histone H3 gene, partial cds | blastn | 1301 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Mytilina | Mytilina mucronata | |
| 2956042 | 2956042 | PRJNA384462_S_NODE_9363_length_188_cov_1.748201_g9247_i0 | PRJNA384462 | 9363 | 188 | 1.748201 | 3.28661788 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 215 | 1.94e-51 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g9247 | i0 | 88.636 | 4.72340425531915 | 176 | 20 | 94 | 0 | 9 | 184 | 3402 | 3577 | Philodina citrina complete mitochondrial genome | blastn | 888 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 15708085 | 15708085 | PRJNA384462_S_NODE_4993_length_240_cov_1.806283_g4877_i0 | PRJNA384462 | 4993 | 240 | 1.806283 | 4.3350792 | Philodina sp. CWB-2005 | 338313 | Rotifera | other_Eukaryota | 438 | 1.4199999999999995e-118 | NTclustered | gi|71840210|gb|DQ078552.1| | 338313 | g4877 | i0 | 99.583 | 99.6833333333333 | 240 | 1 | 100 | 0 | 1 | 240 | 385 | 146 | Philodina sp. CWB-2005 clone FlT2.1 cytochrome oxidase subunit 1 (cox1) gene, partial cds; mitochondrial | blastn | 23924 | 438 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina sp. CWB-2005 | |
| 16982699 | 16982699 | PRJNA384462_S_NODE_3714_length_272_cov_2.932735_g3598_i0 | PRJNA384462 | 3714 | 272 | 2.932735 | 7.9770392 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 303 | 6.24e-78 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g3598 | i0 | 86.813 | 10.4522058823529 | 273 | 34 | 100 | 2 | 1 | 272 | 10250 | 9979 | Philodina citrina complete mitochondrial genome | blastn | 2843 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 19531145 | 19531145 | PRJNA384462_S_NODE_10996_length_177_cov_1.593750_g10880_i0 | PRJNA384462 | 10996 | 177 | 1.59375 | 2.8209375 | Adineta sp. SCL-15-7 | 2843316 | Rotifera | other_Eukaryota | 222 | 1.08e-53 | NTclustered | gi|2049839123|gb|MT997071.1| | 2843316 | g10880 | i0 | 88.636 | 95.8700564971751 | 176 | 20 | 99 | 0 | 2 | 177 | 93 | 268 | Adineta sp. SCL-15-7 actin gene, partial cds | blastn | 16969 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta sp. SCL-15-7 | |
| 19531206 | 19531206 | PRJNA384462_S_NODE_916_length_534_cov_13.682474_g803_i0 | PRJNA384462 | 916 | 534 | 13.682474 | 73.06441116 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 767 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g803 | i0 | 92.83 | 38.685393258427 | 530 | 36 | 99 | 2 | 6 | 534 | 2414 | 1886 | Philodina citrina complete mitochondrial genome | blastn | 20658 | 767 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 20806927 | 20806927 | PRJNA384462_S_NODE_5657_length_228_cov_1.418994_g5541_i0 | PRJNA384462 | 5657 | 228 | 1.418994 | 3.23530632 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 259 | 1.12e-64 | NTclustered | gi|187233663|gb|EU643498.1| | 104782 | g5541 | i0 | 87.783 | 0.969298245614035 | 221 | 27 | 97 | 0 | 1 | 221 | 398 | 178 | Adineta vaga ribosomal protein S1a mRNA, partial cds | blastn | 221 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 24631720 | 24631720 | PRJNA384462_S_NODE_2600_length_322_cov_2.461538_g2484_i0 | PRJNA384462 | 2600 | 322 | 2.461538 | 7.92615236 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 424 | 5.56e-114 | NTclustered | gi|402761741|gb|JX184002.1| | 104786 | g2484 | i0 | 91.054 | 96.3726708074534 | 313 | 28 | 97 | 0 | 4 | 316 | 890 | 1202 | Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 31032 | 424 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta |
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);;