contig_metadata
5 rows where bioproject = "PRJNA498309" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7487648 | 7487648 | PRJNA498309_S_NODE_29746_length_303_cov_305.488806_g27578_i0 | PRJNA498309 | 29746 | 303 | 305.488806 | 925.63108218 | Metazoa | 33208 | Rotifera | other_Eukaryota | 459 | 1.4199999999999996e-124 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g27578 | i0 | 97.059 | 29.5181518151815 | 272 | 8 | 90 | 0 | 1 | 272 | 2730 | 3001 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 8944 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 11961325 | 11961325 | PRJNA498309_S_NODE_49730_length_166_cov_7.572519_g47562_i0 | PRJNA498309 | 49730 | 166 | 7.572519 | 12.57038154 | Embata laticeps | 1234258 | Rotifera | other_Eukaryota | 296 | 5.82e-76 | NTclustered | gi|1345605787|gb|KY781181.1| | 1234258 | g47562 | i0 | 100 | 96.4638554216867 | 160 | 0 | 96 | 0 | 7 | 166 | 383 | 542 | Embata laticeps isolate MSAK27 small subunit ribosomal RNA gene, partial sequence | blastn | 16013 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Embata | Embata laticeps | |
| 13236034 | 13236034 | PRJNA498309_S_NODE_31731_length_281_cov_7.674797_g29563_i0 | PRJNA498309 | 31731 | 281 | 7.674797 | 21.56617957 | Embata laticeps | 1234258 | Rotifera | other_Eukaryota | 488 | 1.6699999999999998e-133 | NTclustered | gi|1345605787|gb|KY781181.1| | 1234258 | g29563 | i0 | 100 | 93.9786476868327 | 264 | 0 | 94 | 0 | 18 | 281 | 107 | 370 | Embata laticeps isolate MSAK27 small subunit ribosomal RNA gene, partial sequence | blastn | 26408 | 488 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Embata | Embata laticeps | |
| 20235196 | 20235196 | PRJNA498309_P_NODE_34896_length_475_cov_11.949772_g32851_i0 | PRJNA498309 | 34896 | 475 | 11.949772 | 56.761417 | Metazoa | 33208 | Rotifera | other_Eukaryota | 675 | 0 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g32851 | i0 | 94.331 | 44.3831578947368 | 441 | 23 | 93 | 2 | 24 | 463 | 2093 | 2532 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 21082 | 680 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 25335177 | 25335177 | PRJNA498309_P_NODE_40100_length_436_cov_19.869674_g37994_i0 | PRJNA498309 | 40100 | 436 | 19.869674 | 86.63177864 | Metazoa | 33208 | Rotifera | other_Eukaryota | 634 | 3.2899999999999995e-177 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g37994 | i0 | 95.062 | 62.0940366972477 | 405 | 16 | 92 | 3 | 32 | 433 | 3001 | 2598 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 27073 | 634 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola |
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);;