contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA669701" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8288220 | 8288220 | PRJNA669701_P_NODE_108367_length_251_cov_0.865169_g107972_i0 | PRJNA669701 | 108367 | 251 | 0.865169 | 2.17157419 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 394 | 3.28e-105 | NTclustered | gi|1405682219|gb|MH231841.1| | 10195 | g107972 | i0 | 95.181 | 0.99203187250996006 | 249 | 12 | 99 | 0 | 3 | 251 | 720 | 472 | Brachionus plicatilis phosphatidylinositol 3-kinase catalytic subunit type 3 mRNA, complete cds | blastn | 249 | 394 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 8289530 | 8289530 | PRJNA669701_P_NODE_81227_length_280_cov_2.231884_g80832_i0 | PRJNA669701 | 81227 | 280 | 2.231884 | 6.2492752 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 303 | 6.45e-78 | NTclustered | gi|402761757|gb|JX184010.1| | 104786 | g80832 | i0 | 86.594 | 10.3107142857143 | 276 | 35 | 98 | 2 | 1 | 275 | 323 | 49 | Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial | blastn | 2887 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 10839163 | 10839163 | PRJNA669701_P_NODE_112389_length_250_cov_0.870056_g111994_i0 | PRJNA669701 | 112389 | 250 | 0.870056 | 2.17514 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 457 | 4.1099999999999985e-124 | NTclustered | gi|254587481|dbj|AB513493.1| | 10195 | g111994 | i0 | 99.6 | 67.964 | 250 | 1 | 100 | 0 | 1 | 250 | 781 | 532 | Brachionus plicatilis tef1a mRNA for translation elongation factor 1 alpha, complete cds | blastn | 16991 | 457 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 12114336 | 12114336 | PRJNA669701_P_NODE_11330_length_710_cov_5.714286_g10952_i0 | PRJNA669701 | 11330 | 710 | 5.714286 | 40.5714306 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 726 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g10952 | i0 | 85.356 | 22.0816901408451 | 717 | 87 | 100 | 15 | 1 | 710 | 1683 | 2388 | Philodina citrina complete mitochondrial genome | blastn | 15678 | 726 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 18488001 | 18488001 | PRJNA669701_P_NODE_28415_length_440_cov_12.365123_g28020_i0 | PRJNA669701 | 28415 | 440 | 12.365123 | 54.4065412 | Proales similis | 360698 | Rotifera | other_Eukaryota | 303 | 1.0600000000000001e-77 | NTclustered | gi|1859640894|gb|MN970216.1| | 360698 | g28020 | i0 | 80.282 | 8.16363636363636 | 426 | 64 | 94 | 18 | 1 | 415 | 12100 | 12516 | Proales similis mitochondrion, complete genome | blastn | 3592 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Proalidae | Proales | Proales similis | |
| 21038442 | 21038442 | PRJNA669701_P_NODE_53857_length_329_cov_4.210938_g53462_i0 | PRJNA669701 | 53857 | 329 | 4.210938 | 13.85398602 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 331 | 3.55e-86 | NTclustered | gi|402761779|gb|JX184021.1| | 104788 | g53462 | i0 | 85.489 | 37.8814589665653 | 317 | 46 | 96 | 0 | 11 | 327 | 1046 | 730 | Macrotrachela quadricornifera isolate HR cytochrome b (CYTB) gene, complete cds; mitochondrial | blastn | 12463 | 331 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 22312237 | 22312237 | PRJNA669701_P_NODE_104038_length_254_cov_2.602210_g103643_i0 | PRJNA669701 | 104038 | 254 | 2.60221 | 6.6096134 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 316 | 7.41e-82 | NTclustered | gi|402761725|gb|JX183994.1| | 104786 | g103643 | i0 | 89.286 | 1.99212598425197 | 252 | 27 | 99 | 0 | 2 | 253 | 373 | 624 | Habrotrocha constricta ATP synthase F0 subunit 6 (ATP6) gene, partial cds; mitochondrial | blastn | 506 | 316 | 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);;