contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1639325 | 1639325 | PRJNA168635_P_NODE_2602_length_511_cov_6.402597_g2216_i0 | PRJNA168635 | 2602 | 511 | 6.402597 | 32.71727067 | Collodictyon triciliatum | 190325 | Root_unresolved | Root_unresolved | 187 | 1.3099999999999999e-42 | NTclustered | gi|1200177733|gb|MF039367.1| | 190325 | g2216 | i0 | 91.852 | 25.8512720156556 | 135 | 10 | 26 | 1 | 340 | 474 | 4886 | 4753 | Collodictyon triciliatum isolate C_Arungen 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 | 13210 | 187 | 1 | Eukaryota | CRuMs | Collodictyonidae | Collodictyon | Collodictyon triciliatum | |||||
| 4191822 | 4191822 | PRJNA168635_P_NODE_6404_length_334_cov_15.512281_g5993_i0 | PRJNA168635 | 6404 | 334 | 15.512281 | 51.81101854 | uncultured Collodictyonidae | 440571 | Root_unresolved | Root_unresolved | 163 | 1.39e-35 | NTclustered | gi|2733867142|gb|PP812521.1| | 440571 | g5993 | i0 | 84.848 | 46.6347305389222 | 165 | 22 | 49 | 3 | 117 | 280 | 3541 | 3703 | Uncultured Collodictyonidae isolate Col20 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15576 | 163 | 1 | Eukaryota | CRuMs | Collodictyonidae | uncultured Collodictyonidae | ||||||
| 6742416 | 6742416 | PRJNA168635_P_NODE_6386_length_335_cov_5.118881_g5975_i0 | PRJNA168635 | 6386 | 335 | 5.118881 | 17.14825135 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 342 | 1.67e-89 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g5975 | i0 | 90.152 | 79.6656716417911 | 264 | 24 | 78 | 2 | 71 | 332 | 2524 | 2787 | 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 | 26688 | 342 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 8017979 | 8017979 | PRJNA168635_P_NODE_33707_length_157_cov_2.675926_g33291_i0 | PRJNA168635 | 33707 | 157 | 2.675926 | 4.20120382 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 261 | 1.98e-65 | NTclustered | gi|33641921|gb|AY268038.1| | 238746 | g33291 | i0 | 96.815 | 97.9554140127389 | 157 | 4 | 100 | 1 | 1 | 157 | 1423 | 1268 | Micronuclearia podoventralis small subunit ribosomal RNA gene, partial sequence | blastn | 15379 | 261 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 9292467 | 9292467 | PRJNA168635_P_NODE_16928_length_194_cov_3.551724_g16512_i0 | PRJNA168635 | 16928 | 194 | 3.551724 | 6.89034456 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 231 | 2e-56 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g16512 | i0 | 88.144 | 141.128865979381 | 194 | 23 | 100 | 0 | 1 | 194 | 3547 | 3740 | 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 | 27379 | 231 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 10568350 | 10568350 | PRJNA168635_P_NODE_1269_length_698_cov_6.443760_g956_i0 | PRJNA168635 | 1269 | 698 | 6.44376 | 44.9774448 | Collodictyon triciliatum | 190325 | Root_unresolved | Root_unresolved | 180 | 3.06e-40 | NTclustered | gi|1200177733|gb|MF039367.1| | 190325 | g956 | i0 | 91.045 | 31.067335243553 | 134 | 11 | 19 | 1 | 38 | 171 | 4753 | 4885 | Collodictyon triciliatum isolate C_Arungen 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 | 21685 | 180 | 1 | Eukaryota | CRuMs | Collodictyonidae | Collodictyon | Collodictyon triciliatum | |||||
| 10568436 | 10568436 | PRJNA168635_P_NODE_16389_length_197_cov_16.844595_g15973_i0 | PRJNA168635 | 16389 | 197 | 16.844595 | 33.18385215 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 259 | 9.37e-65 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g15973 | i0 | 90.404 | 101.060913705584 | 198 | 18 | 100 | 1 | 1 | 197 | 2227 | 2030 | 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 | 19909 | 259 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 11843206 | 11843206 | PRJNA168635_P_NODE_3090_length_474_cov_13.548235_g2696_i0 | PRJNA168635 | 3090 | 474 | 13.548235 | 64.2186339 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 625 | 2.17e-174 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g2696 | i0 | 90.546 | 101.445147679325 | 476 | 39 | 100 | 6 | 1 | 474 | 3013 | 2542 | 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 | 48085 | 625 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 11843233 | 11843233 | PRJNA168635_P_NODE_33210_length_158_cov_9.724771_g32794_i0 | PRJNA168635 | 33210 | 158 | 9.724771 | 15.36513818 | uncultured Micronuclearia | 1595896 | Root_unresolved | Root_unresolved | 270 | 3.3099999999999996e-68 | NTclustered | gi|1516250890|gb|MK177607.1| | 1595896 | g32794 | i0 | 97.468 | 100.550632911392 | 158 | 4 | 100 | 0 | 1 | 158 | 1561 | 1404 | Uncultured Micronuclearia clone DDI50.fa small subunit ribosomal RNA gene, partial sequence | blastn | 15887 | 270 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | uncultured Micronuclearia | |||||
| 11843238 | 11843238 | PRJNA168635_P_NODE_33570_length_157_cov_4.416667_g33154_i0 | PRJNA168635 | 33570 | 157 | 4.416667 | 6.93416719 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 169 | 1.23e-37 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g33154 | i0 | 85.987 | 68.1656050955414 | 157 | 22 | 100 | 0 | 1 | 157 | 528 | 372 | 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 | 10702 | 169 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 13118211 | 13118211 | PRJNA168635_P_NODE_19071_length_185_cov_4.514706_g18655_i0 | PRJNA168635 | 19071 | 185 | 4.514706 | 8.3522061 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 279 | 6.66e-71 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g18655 | i0 | 94.054 | 4.40540540540541 | 185 | 10 | 99 | 1 | 1 | 184 | 1296 | 1112 | 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 | 815 | 279 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 13118319 | 13118319 | PRJNA168635_P_NODE_24391_length_170_cov_4.752066_g23975_i0 | PRJNA168635 | 24391 | 170 | 4.752066 | 8.0785122 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 167 | 4.87e-37 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g23975 | i0 | 84.571 | 76.4470588235294 | 175 | 20 | 99 | 5 | 2 | 170 | 989 | 1162 | 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 | 12996 | 167 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 13118484 | 13118484 | PRJNA168635_P_NODE_4251_length_408_cov_10.671309_g3849_i0 | PRJNA168635 | 4251 | 408 | 10.671309 | 43.53894072 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 313 | 1.63e-80 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g3849 | i0 | 83.333 | 53.625 | 354 | 38 | 86 | 12 | 1 | 349 | 4095 | 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 | 21879 | 313 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 14393375 | 14393375 | PRJNA168635_P_NODE_10192_length_259_cov_6.200000_g9777_i0 | PRJNA168635 | 10192 | 259 | 6.2 | 16.058 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 169 | 2.24e-37 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g9777 | i0 | 79.848 | 40.019305019305 | 263 | 28 | 92 | 9 | 22 | 259 | 3041 | 3303 | 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 | 10365 | 169 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 14393474 | 14393474 | PRJNA168635_P_NODE_15172_length_206_cov_3.522293_g14756_i0 | PRJNA168635 | 15172 | 206 | 3.522293 | 7.25592358 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 364 | 2.0399999999999993e-96 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g14756 | i0 | 98.551 | 92.2961165048544 | 207 | 2 | 100 | 1 | 1 | 206 | 1247 | 1041 | 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 | 19013 | 364 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 15667543 | 15667543 | PRJNA168635_P_NODE_4733_length_387_cov_14.420118_g4329_i0 | PRJNA168635 | 4733 | 387 | 14.420118 | 55.80585666 | uncultured Micronuclearia | 1595896 | Root_unresolved | Root_unresolved | 676 | 0 | NTclustered | gi|1516250890|gb|MK177607.1| | 1595896 | g4329 | i0 | 98.196 | 92.8940568475452 | 388 | 6 | 100 | 1 | 1 | 387 | 513 | 900 | Uncultured Micronuclearia clone DDI50.fa small subunit ribosomal RNA gene, partial sequence | blastn | 35950 | 676 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | uncultured Micronuclearia | |||||
| 16941474 | 16941474 | PRJNA168635_P_NODE_10514_length_254_cov_9.112195_g10099_i0 | PRJNA168635 | 10514 | 254 | 9.112195 | 23.1449753 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 272 | 1.6299999999999998e-68 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g10099 | i0 | 86.275 | 44.6732283464567 | 255 | 29 | 99 | 5 | 1 | 252 | 2370 | 2621 | 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 | 11347 | 272 | 1 | Eukaryota | CRuMs | Rigifilida | Micronuclearia | Micronuclearia podoventralis | |||||
| 20766258 | 20766258 | PRJNA168635_P_NODE_5237_length_369_cov_4.981250_g4833_i0 | PRJNA168635 | 5237 | 369 | 4.98125 | 18.3808125 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 287 | 8.83e-73 | NTclustered | gi|1200177731|gb|MF039365.1| | 190327 | g4833 | i0 | 81.383 | 99.420054200542 | 376 | 49 | 100 | 17 | 1 | 369 | 4047 | 3686 | Diphylleia rotans isolate D_NIES3764 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 | 36686 | 287 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 22041003 | 22041003 | PRJNA168635_P_NODE_16738_length_195_cov_4.787671_g16322_i0 | PRJNA168635 | 16738 | 195 | 4.787671 | 9.33595845 | Micronuclearia podoventralis | 238746 | Root_unresolved | Root_unresolved | 182 | 2.06e-41 | NTclustered | gi|300078503|gb|GU001165.1| | 238746 | g16322 | i0 | 95.575 | 187.097435897436 | 113 | 5 | 99 | 0 | 1 | 113 | 3542 | 3654 | 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 | 36484 | 182 | 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);;