contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA473641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 444844 | 444844 | PRJNA473641_P_NODE_1321_length_696_cov_2.409310_g1243_i0 | PRJNA473641 | 1321 | 696 | 2.40931 | 16.7687976 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 590 | 1.1899999999999996e-163 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g1243 | i0 | 82.496 | 18.2672413793103 | 697 | 98 | 99 | 22 | 1 | 686 | 1681 | 2364 | Philodina citrina complete mitochondrial genome | blastn | 12714 | 590 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 8097980 | 8097980 | PRJNA473641_P_NODE_1587_length_650_cov_1.542461_g1507_i0 | PRJNA473641 | 1587 | 650 | 1.542461 | 10.0259965 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 771 | 0 | NTclustered | gi|1800242915|gb|MN983090.1| | 96446 | g1507 | i0 | 88.54 | 95.7661538461538 | 637 | 71 | 98 | 2 | 15 | 650 | 656 | 21 | Lecane bulla isolate LbullaMAG306 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial | blastn | 62248 | 771 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 13198844 | 13198844 | PRJNA473641_P_NODE_5011_length_405_cov_2.319277_g4928_i0 | PRJNA473641 | 5011 | 405 | 2.319277 | 9.39307185 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 248 | 4.62e-61 | NTclustered | gi|632795131|gb|KJ489418.1| | 392764 | g4928 | i0 | 84.524 | 5.25185185185185 | 252 | 37 | 62 | 2 | 65 | 315 | 5986 | 6236 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 2127 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 17022629 | 17022629 | PRJNA473641_P_NODE_7414_length_351_cov_1.107914_g7331_i0 | PRJNA473641 | 7414 | 351 | 1.107914 | 3.88877814 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 296 | 1.39e-75 | NTclustered | gi|632795131|gb|KJ489418.1| | 392764 | g7331 | i0 | 85.121 | 78.5612535612536 | 289 | 43 | 82 | 0 | 61 | 349 | 1010 | 1298 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 27575 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 19570939 | 19570939 | PRJNA473641_P_NODE_4176_length_437_cov_1.104396_g4093_i0 | PRJNA473641 | 4176 | 437 | 1.104396 | 4.82621052 | Brachionus koreanus | 1199090 | Rotifera | other_Eukaryota | 99 | 5.35e-16 | NTclustered | gi|1252327087|gb|KY828435.1| | 1199090 | g4093 | i0 | 81.6 | 5.98398169336384 | 125 | 17 | 29 | 6 | 3 | 127 | 769 | 887 | Brachionus koreanus elongation factor 1 alpha mRNA, partial cds | blastn | 2615 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus koreanus | |
| 22121717 | 22121717 | PRJNA473641_P_NODE_5338_length_396_cov_2.616099_g5255_i0 | PRJNA473641 | 5338 | 396 | 2.616099 | 10.35975204 | Eosphora ehrenbergi | 104793 | Rotifera | other_Eukaryota | 182 | 4.63e-41 | NTclustered | gi|6018205|gb|AF143858.1|AF143858 | 104793 | g5255 | i0 | 76.676 | 56.9444444444444 | 343 | 70 | 86 | 7 | 4 | 344 | 344 | 10 | Eosphora ehrenbergi 82 kD heat shock protein (hsp82) gene, partial cds | blastn | 22550 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Notommatidae | Eosphora | Eosphora ehrenbergi | |
| 24047406 | 24047406 | PRJNA473641_P_NODE_14199_length_275_cov_1.143564_g14116_i0 | PRJNA473641 | 14199 | 275 | 1.143564 | 3.144801 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 364 | 2.859999999999999e-96 | NTclustered | gi|134141720|gb|EF173224.1| | 104782 | g14116 | i0 | 90.545 | 99.8 | 275 | 26 | 100 | 0 | 1 | 275 | 86 | 360 | Adineta vaga isolate UK.5.2 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 27445 | 364 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga |
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);;