contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA222400" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2331803 | 2331803 | PRJNA222400_P_NODE_6362_length_178_cov_1.209302_g6329_i0 | PRJNA222400 | 6362 | 178 | 1.209302 | 2.15255756 | Asplanchna | 84396 | Rotifera | other_Eukaryota | 65.8 | 1.93e-6 | NTclustered | gi|2899343712|gb|PQ788833.1| | 2005548 | g6329 | i0 | 90.196 | 0.573033707865168 | 51 | 3 | 28 | 2 | 10 | 59 | 1908 | 1859 | Asplanchna brightwellii chromosome I mitochondrion, complete sequence | blastn | 102 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna brightwellii | |
| 4194249 | 4194249 | PRJNA222400_P_NODE_1204_length_470_cov_2.211401_g1171_i0 | PRJNA222400 | 1204 | 470 | 2.211401 | 10.3935847 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 353 | 1.12e-92 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g1171 | i0 | 80.462 | 2.32978723404255 | 476 | 81 | 100 | 9 | 1 | 470 | 10610 | 11079 | Philodina citrina complete mitochondrial genome | blastn | 1095 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 6744873 | 6744873 | PRJNA222400_P_NODE_6466_length_176_cov_1.637795_g6433_i0 | PRJNA222400 | 6466 | 176 | 1.637795 | 2.8825192 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 145 | 2.38e-30 | NTclustered | gi|270267490|ref|NC_013568.1| | 231624 | g6433 | i0 | 82.424 | 1.21022727272727 | 165 | 29 | 94 | 0 | 8 | 172 | 10016 | 10180 | Rotaria rotatoria mitochondrion, complete genome | blastn | 213 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 9295305 | 9295305 | PRJNA222400_P_NODE_6508_length_176_cov_1.228346_g6475_i0 | PRJNA222400 | 6508 | 176 | 1.228346 | 2.16188896 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 243 | 8.21e-60 | NTclustered | gi|402761805|gb|JX184034.1| | 104786 | g6475 | i0 | 91.477 | 2 | 176 | 15 | 100 | 0 | 1 | 176 | 518 | 693 | Habrotrocha constricta NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial | blastn | 352 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 11845823 | 11845823 | PRJNA222400_P_NODE_8150_length_166_cov_0.888889_g8117_i0 | PRJNA222400 | 8150 | 166 | 0.888889 | 1.47555574 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 167 | 4.76e-37 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g8117 | i0 | 87.943 | 0.849397590361446 | 141 | 17 | 85 | 0 | 1 | 141 | 10368 | 10508 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 141 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 14396283 | 14396283 | PRJNA222400_P_NODE_632_length_651_cov_3.740864_g602_i0 | PRJNA222400 | 632 | 651 | 3.740864 | 24.35302464 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 370 | 1.57e-97 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g602 | i0 | 78.583 | 26.4715821812596 | 593 | 104 | 89 | 20 | 1 | 582 | 11819 | 11239 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 17233 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 16944480 | 16944480 | PRJNA222400_P_NODE_3774_length_231_cov_1.115385_g3741_i0 | PRJNA222400 | 3774 | 231 | 1.115385 | 2.57653935 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 224 | 4.129999999999999e-54 | NTclustered | gi|402761757|gb|JX184010.1| | 104786 | g3741 | i0 | 84.513 | 1.95670995670996 | 226 | 35 | 98 | 0 | 1 | 226 | 247 | 22 | Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial | blastn | 452 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 19493110 | 19493110 | PRJNA222400_P_NODE_1056_length_501_cov_3.022124_g1023_i0 | PRJNA222400 | 1056 | 501 | 3.022124 | 15.14084124 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 593 | 6.489999999999998e-165 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g1023 | i0 | 88.048 | 1.93213572854291 | 502 | 58 | 100 | 2 | 1 | 501 | 3341 | 3841 | Philodina citrina complete mitochondrial genome | blastn | 968 | 593 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 22043798 | 22043798 | PRJNA222400_P_NODE_498_length_723_cov_8.382789_g469_i0 | PRJNA222400 | 498 | 723 | 8.382789 | 60.60756447 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 839 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g469 | i0 | 87.808 | 17.0774550484094 | 730 | 72 | 100 | 16 | 1 | 723 | 2394 | 1675 | Philodina citrina complete mitochondrial genome | blastn | 12347 | 839 | 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);;