contig_metadata
12 rows where bioproject = "PRJNA400391" and tax_clade = "CRuMs"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2964801 | 2964801 | PRJNA400391_S_NODE_2743_length_242_cov_3.768116_g2682_i0 | PRJNA400391 | 2743 | 242 | 3.768116 | 9.11884072 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 409 | 1.12e-109 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g2682 | i0 | 97.854 | 26.9710743801653 | 233 | 5 | 96 | 0 | 10 | 242 | 4432 | 4200 | Micronuclearia podoventralis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 6527 | 409 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 6791870 | 6791870 | PRJNA400391_S_NODE_666_length_407_cov_35.854839_g606_i0 | PRJNA400391 | 666 | 407 | 35.854839 | 145.92919473 | Rigifila ramosa | 1122280 | Root_unresolved | Root_unresolved | 163 | 1.7299999999999998e-35 | NTclustered | gi|390124887|dbj|AB686267.1| | 1122280 | g606 | i0 | 83.069 | 1.37837837837838 | 189 | 23 | 45 | 9 | 226 | 407 | 3316 | 3130 | Rigifila ramosa gene for large subunit ribosomal RNA, partial sequence, strain: YPF923 | blastn | 561 | 163 | 1 | Eukaryota | CRuMs | Rigifilida | Rigifila | Rigifila ramosa | |||||
| 9342276 | 9342276 | PRJNA400391_S_NODE_5088_length_175_cov_2.035714_g5027_i0 | PRJNA400391 | 5088 | 175 | 2.035714 | 3.5624995 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 246 | 6.3e-61 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g5027 | i0 | 92.486 | 67.3885714285714 | 173 | 11 | 98 | 2 | 1 | 171 | 1321 | 1149 | Micronuclearia podoventralis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 11793 | 246 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 10617960 | 10617960 | PRJNA400391_S_NODE_2849_length_238_cov_2.709360_g2788_i0 | PRJNA400391 | 2849 | 238 | 2.70936 | 6.4482768 | uncultured Micronuclearia | 1595896 | Root_unresolved | Root_unresolved | 424 | 3.93e-114 | NTclustered | gi|1516250890|gb|MK177607.1| | 1595896 | g2788 | i0 | 98.739 | 100.155462184874 | 238 | 3 | 100 | 0 | 1 | 238 | 58 | 295 | Uncultured Micronuclearia clone DDI50.fa small subunit ribosomal RNA gene, partial sequence | blastn | 23837 | 424 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | uncultured Micronuclearia | |||||
| 10618049 | 10618049 | PRJNA400391_S_NODE_6309_length_155_cov_4.266667_g6248_i0 | PRJNA400391 | 6309 | 155 | 4.266667 | 6.61333385 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 239 | 9.11e-59 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g6248 | i0 | 94.771 | 104.774193548387 | 153 | 8 | 99 | 0 | 3 | 155 | 4080 | 4232 | Micronuclearia podoventralis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 16240 | 239 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 13167874 | 13167874 | PRJNA400391_S_NODE_4911_length_179_cov_24.111111_g4850_i0 | PRJNA400391 | 4911 | 179 | 24.111111 | 43.15888869 | uncultured Micronuclearia | 1595896 | Root_unresolved | Root_unresolved | 292 | 8.210000000000001e-75 | NTclustered | gi|1516250890|gb|MK177607.1| | 1595896 | g4850 | i0 | 96.089 | 100.385474860335 | 179 | 7 | 100 | 0 | 1 | 179 | 1080 | 902 | Uncultured Micronuclearia clone DDI50.fa small subunit ribosomal RNA gene, partial sequence | blastn | 17969 | 292 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | uncultured Micronuclearia | |||||
| 14443068 | 14443068 | PRJNA400391_S_NODE_612_length_422_cov_5.033592_g552_i0 | PRJNA400391 | 612 | 422 | 5.033592 | 21.24175824 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 551 | 3.2899999999999986e-152 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g552 | i0 | 90.33 | 90.5829383886256 | 424 | 36 | 100 | 5 | 1 | 422 | 2560 | 2980 | Micronuclearia podoventralis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 38226 | 551 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 18265692 | 18265692 | PRJNA400391_S_NODE_3455_length_216_cov_20.276243_g3394_i0 | PRJNA400391 | 3455 | 216 | 20.276243 | 43.79668488 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 134 | 6.62e-27 | NTclustered | gi|1200177720|gb|MF039354.1| | 190327 | g3394 | i0 | 79.111 | 37.0509259259259 | 225 | 24 | 100 | 14 | 1 | 216 | 795 | 1005 | Diphylleia rotans isolate D_BOR42 18S ribosomal RNA gene, partial sequence | blastn | 8003 | 134 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 18265759 | 18265759 | PRJNA400391_S_NODE_6315_length_155_cov_2.591667_g6254_i0 | PRJNA400391 | 6315 | 155 | 2.591667 | 4.01708385 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 272 | 8.99e-69 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g6254 | i0 | 98.693 | 31.7096774193548 | 153 | 2 | 99 | 0 | 3 | 155 | 3087 | 3239 | Micronuclearia podoventralis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 4915 | 272 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 19539844 | 19539844 | PRJNA400391_S_NODE_3436_length_217_cov_2.994505_g3375_i0 | PRJNA400391 | 3436 | 217 | 2.994505 | 6.49807585 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 134 | 6.650000000000001e-27 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g3375 | i0 | 78.241 | 20.4331797235023 | 216 | 36 | 96 | 9 | 10 | 217 | 4432 | 4220 | Micronuclearia podoventralis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 4434 | 134 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 20815763 | 20815763 | PRJNA400391_S_NODE_5337_length_171_cov_2.522059_g5276_i0 | PRJNA400391 | 5337 | 171 | 2.522059 | 4.31272089 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 316 | 4.6e-82 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g5276 | i0 | 100 | 40.7777777777778 | 171 | 0 | 100 | 0 | 1 | 171 | 2561 | 2391 | Micronuclearia podoventralis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 6973 | 316 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 24640482 | 24640482 | PRJNA400391_S_NODE_4540_length_187_cov_19.453947_g4479_i0 | PRJNA400391 | 4540 | 187 | 19.453947 | 36.37888089 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 340 | 3.0499999999999998e-89 | NTclustered | gi|33641921|gb|AY268038.1| | 238746 | g4479 | i0 | 99.465 | 100.320855614973 | 187 | 1 | 100 | 0 | 1 | 187 | 938 | 1124 | Micronuclearia podoventralis small subunit ribosomal RNA gene, partial sequence | blastn | 18760 | 340 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis |
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);;