contig_metadata
18 rows where bioproject = "PRJNA438687", tax_clade = "CRuMs" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 435247 | 435247 | PRJNA438687_S_NODE_1201_length_358_cov_4.445820_g1111_i0 | PRJNA438687 | 1201 | 358 | 4.44582 | 15.9160356 | Rigifila ramosa | 1122280 | Root_unresolved | Root_unresolved | 147 | 1.51e-30 | NTclustered | gi|390124886|dbj|AB686266.1| | 1122280 | g1111 | i0 | 88 | 17.9804469273743 | 125 | 13 | 34 | 2 | 236 | 358 | 711 | 835 | Rigifila ramosa gene for small subunit ribosomal RNA, partial sequence, strain: YPF923 | blastn | 6437 | 147 | 1 | Eukaryota | CRuMs | Rigifilida | Rigifila | Rigifila ramosa | |||||
| 435377 | 435377 | PRJNA438687_S_NODE_6941_length_165_cov_4.161538_g6851_i0 | PRJNA438687 | 6941 | 165 | 4.161538 | 6.8665377 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 292 | 7.47e-75 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g6851 | i0 | 99.379 | 57.8121212121212 | 161 | 1 | 98 | 0 | 1 | 161 | 2376 | 2536 | 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 | 9539 | 292 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 1710192 | 1710192 | PRJNA438687_S_NODE_4762_length_203_cov_15.958333_g4672_i0 | PRJNA438687 | 4762 | 203 | 15.958333 | 32.39541599 | Rigifila ramosa | 1122280 | Root_unresolved | Root_unresolved | 73.1 | 1.36e-8 | NTclustered | gi|390124887|dbj|AB686267.1| | 1122280 | g4672 | i0 | 88.333 | 0.295566502463054 | 60 | 7 | 30 | 0 | 144 | 203 | 1415 | 1474 | Rigifila ramosa gene for large subunit ribosomal RNA, partial sequence, strain: YPF923 | blastn | 60 | 73.1 | 1 | Eukaryota | CRuMs | Rigifilida | Rigifila | Rigifila ramosa | |||||
| 2985991 | 2985991 | PRJNA438687_S_NODE_3803_length_228_cov_4.186528_g3713_i0 | PRJNA438687 | 3803 | 228 | 4.186528 | 9.54528384 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 372 | 1.37e-98 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g3713 | i0 | 97.653 | 34.1578947368421 | 213 | 5 | 93 | 0 | 1 | 213 | 4220 | 4432 | 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 | 7788 | 372 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 4262343 | 4262343 | PRJNA438687_S_NODE_5444_length_189_cov_4.051948_g5354_i0 | PRJNA438687 | 5444 | 189 | 4.051948 | 7.65818172 | Rigifila ramosa | 1122280 | Root_unresolved | Root_unresolved | 219 | 1.51e-52 | NTclustered | gi|390124887|dbj|AB686267.1| | 1122280 | g5354 | i0 | 87.895 | 63.3386243386243 | 190 | 17 | 100 | 4 | 1 | 189 | 1149 | 965 | Rigifila ramosa gene for large subunit ribosomal RNA, partial sequence, strain: YPF923 | blastn | 11971 | 219 | 1 | Eukaryota | CRuMs | Rigifilida | Rigifila | Rigifila ramosa | |||||
| 5538939 | 5538939 | PRJNA438687_S_NODE_1405_length_340_cov_39.416393_g1315_i0 | PRJNA438687 | 1405 | 340 | 39.416393 | 134.0157362 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 538 | 2.0199999999999992e-148 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g1315 | i0 | 95.308 | 59.9941176470588 | 341 | 12 | 99 | 2 | 1 | 339 | 2990 | 3328 | 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 | 20398 | 538 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 6813049 | 6813049 | PRJNA438687_S_NODE_286_length_546_cov_22.906067_g212_i0 | PRJNA438687 | 286 | 546 | 22.906067 | 125.06712582 | Rigifila ramosa | 1122280 | Root_unresolved | Root_unresolved | 291 | 1.05e-73 | NTclustered | gi|390124887|dbj|AB686267.1| | 1122280 | g212 | i0 | 92.233 | 36.8113553113553 | 206 | 14 | 71 | 1 | 242 | 445 | 1661 | 1866 | Rigifila ramosa gene for large subunit ribosomal RNA, partial sequence, strain: YPF923 | blastn | 20099 | 291 | 1 | Eukaryota | CRuMs | Rigifilida | Rigifila | Rigifila ramosa | |||||
| 8088488 | 8088488 | PRJNA438687_S_NODE_2707_length_271_cov_6.656780_g2617_i0 | PRJNA438687 | 2707 | 271 | 6.65678 | 18.0398738 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 189 | 1.8199999999999998e-43 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g2617 | i0 | 79.71 | 69.3616236162362 | 276 | 45 | 98 | 7 | 6 | 271 | 1327 | 1053 | 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 | 18797 | 189 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 8088563 | 8088563 | PRJNA438687_S_NODE_6307_length_174_cov_41.395683_g6217_i0 | PRJNA438687 | 6307 | 174 | 41.395683 | 72.02848842 | uncultured Micronuclearia | 1595896 | Root_unresolved | Root_unresolved | 254 | 3.74e-63 | NTclustered | gi|1516250890|gb|MK177607.1| | 1595896 | g6217 | i0 | 94.512 | 95.6149425287356 | 164 | 9 | 94 | 0 | 1 | 164 | 916 | 1079 | Uncultured Micronuclearia clone DDI50.fa small subunit ribosomal RNA gene, partial sequence | blastn | 16637 | 254 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | uncultured Micronuclearia | |||||
| 10639242 | 10639242 | PRJNA438687_S_NODE_6429_length_172_cov_45.350365_g6339_i0 | PRJNA438687 | 6429 | 172 | 45.350365 | 78.0026278 | uncultured Micronuclearia | 1595896 | Root_unresolved | Root_unresolved | 272 | 1.02e-68 | NTclustered | gi|1516250890|gb|MK177607.1| | 1595896 | g6339 | i0 | 96.914 | 95.4941860465116 | 162 | 5 | 94 | 0 | 1 | 162 | 918 | 1079 | Uncultured Micronuclearia clone DDI50.fa small subunit ribosomal RNA gene, partial sequence | blastn | 16425 | 272 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | uncultured Micronuclearia | |||||
| 14464010 | 14464010 | PRJNA438687_S_NODE_5092_length_196_cov_39.819876_g5002_i0 | PRJNA438687 | 5092 | 196 | 39.819876 | 78.04695696 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 316 | 5.45e-82 | NTclustered | gi|33641921|gb|AY268038.1| | 238746 | g5002 | i0 | 97.312 | 95.1173469387755 | 186 | 5 | 95 | 0 | 11 | 196 | 1123 | 938 | Micronuclearia podoventralis small subunit ribosomal RNA gene, partial sequence | blastn | 18643 | 316 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 18287006 | 18287006 | PRJNA438687_S_NODE_6195_length_176_cov_6.652482_g6105_i0 | PRJNA438687 | 6195 | 176 | 6.652482 | 11.70836832 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 320 | 3.69e-83 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g6105 | i0 | 99.432 | 63.5284090909091 | 176 | 1 | 100 | 0 | 1 | 176 | 3724 | 3549 | 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 | 11181 | 320 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 18287027 | 18287027 | PRJNA438687_S_NODE_735_length_412_cov_10.244032_g646_i0 | PRJNA438687 | 735 | 412 | 10.244032 | 42.20541184 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 604 | 2.4199999999999993e-168 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g646 | i0 | 93.237 | 88.4563106796116 | 414 | 23 | 100 | 5 | 1 | 412 | 2980 | 2570 | 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 | 36444 | 604 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 19561200 | 19561200 | PRJNA438687_S_NODE_2876_length_263_cov_11.969298_g2786_i0 | PRJNA438687 | 2876 | 263 | 11.969298 | 31.47925374 | Rigifila ramosa | 1122280 | Root_unresolved | Root_unresolved | 209 | 1.35e-49 | NTclustered | gi|390124887|dbj|AB686267.1| | 1122280 | g2786 | i0 | 94.815 | 49.4942965779468 | 135 | 5 | 51 | 1 | 131 | 263 | 2666 | 2532 | Rigifila ramosa gene for large subunit ribosomal RNA, partial sequence, strain: YPF923 | blastn | 13017 | 209 | 1 | Eukaryota | CRuMs | Rigifilida | Rigifila | Rigifila ramosa | |||||
| 20836844 | 20836844 | PRJNA438687_S_NODE_2397_length_286_cov_11.832669_g2307_i0 | PRJNA438687 | 2397 | 286 | 11.832669 | 33.84143334 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 457 | 4.79e-124 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g2307 | i0 | 96.071 | 99.2552447552448 | 280 | 11 | 98 | 0 | 7 | 286 | 2000 | 1721 | 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 | 28387 | 457 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 20836959 | 20836959 | PRJNA438687_S_NODE_7917_length_153_cov_6.805085_g7827_i0 | PRJNA438687 | 7917 | 153 | 6.805085 | 10.41178005 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 235 | 1.16e-57 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g7827 | i0 | 94.702 | 104.78431372549 | 151 | 8 | 99 | 0 | 3 | 153 | 4080 | 4230 | 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 | 16032 | 235 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 22111922 | 22111922 | PRJNA438687_S_NODE_2878_length_263_cov_6.609649_g2788_i0 | PRJNA438687 | 2878 | 263 | 6.609649 | 17.38337687 | Rigifila ramosa | 1122280 | Root_unresolved | Root_unresolved | 78.7 | 3.96e-10 | NTclustered | gi|390124887|dbj|AB686267.1| | 1122280 | g2788 | i0 | 95.833 | 14.6844106463878 | 48 | 2 | 18 | 0 | 1 | 48 | 2256 | 2209 | Rigifila ramosa gene for large subunit ribosomal RNA, partial sequence, strain: YPF923 | blastn | 3862 | 78.7 | 1 | Eukaryota | CRuMs | Rigifilida | Rigifila | Rigifila ramosa | |||||
| 22111972 | 22111972 | PRJNA438687_S_NODE_5138_length_195_cov_10.775000_g5048_i0 | PRJNA438687 | 5138 | 195 | 10.775 | 21.01125 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 231 | 2.02e-56 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g5048 | i0 | 88.144 | 127.071794871795 | 194 | 23 | 99 | 0 | 1 | 194 | 3526 | 3719 | 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 | 24779 | 231 | 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);;