contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Cryptomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 602019 | 602019 | PRJNA630162_P_NODE_20721_length_405_cov_34.477528_g19205_i0 | PRJNA630162 | 20721 | 405 | 34.477528 | 139.6339884 | Rozella sp. | 1932610 | Fungi | Fungi | 638 | 2.3399999999999996e-178 | NTclustered | gi|2468791001|gb|OQ702917.1| | 1932610 | g19205 | i0 | 95.062 | 102.120987654321 | 405 | 20 | 100 | 0 | 1 | 405 | 4288 | 3884 | Rozella sp. isolate PSC230 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 | 41359 | 638 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. | ||||
| 1877468 | 1877468 | PRJNA630162_P_NODE_101142_length_185_cov_1.389706_g99619_i0 | PRJNA630162 | 101142 | 185 | 1.389706 | 2.5709561 | Rozella sp. | 1932610 | Fungi | Fungi | 263 | 6.7e-66 | NTclustered | gi|2468791001|gb|OQ702917.1| | 1932610 | g99619 | i0 | 93.258 | 88.1459459459459 | 178 | 12 | 96 | 0 | 2 | 179 | 4286 | 4109 | Rozella sp. isolate PSC230 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 | 16307 | 263 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. | ||||
| 3152521 | 3152521 | PRJNA630162_P_NODE_130163_length_169_cov_2.133333_g128640_i0 | PRJNA630162 | 130163 | 169 | 2.133333 | 3.60533277 | Rozella sp. JEL347 | 276837 | Fungi | Fungi | 281 | 1.65e-71 | NTclustered | gi|82398068|gb|DQ273766.1| | 276837 | g128640 | i0 | 97.561 | 22.4082840236686 | 164 | 4 | 97 | 0 | 6 | 169 | 2433 | 2596 | Rozella sp. JEL347 isolate AFTOL-ID 16 28S ribosomal RNA gene, partial sequence | blastn | 3787 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. JEL347 | ||||
| 3153212 | 3153212 | PRJNA630162_P_NODE_42443_length_272_cov_3.439462_g40920_i0 | PRJNA630162 | 42443 | 272 | 3.439462 | 9.35533664 | Rozella sp. | 1932610 | Fungi | Fungi | 215 | 3.01e-51 | NTclustered | gi|2468791023|gb|OQ702923.1| | 1932610 | g40920 | i0 | 82.8 | 34.6838235294118 | 250 | 33 | 90 | 8 | 8 | 252 | 2685 | 2929 | Rozella sp. isolate PSC249 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 | 9434 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. | ||||
| 4430460 | 4430460 | PRJNA630162_P_NODE_88744_length_192_cov_5.069930_g87221_i0 | PRJNA630162 | 88744 | 192 | 5.06993 | 9.7342656 | Cryptomycota sp. | 2012228 | Fungi | Fungi | 255 | 1.17e-63 | NTclustered | gi|2468791035|gb|OQ702926.1| | 2012228 | g87221 | i0 | 91.444 | 98.2239583333333 | 187 | 15 | 97 | 1 | 1 | 187 | 4083 | 3898 | Cryptomycota sp. isolate PSC258 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 | 18859 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Cryptomycota sp. | |||||
| 8255039 | 8255039 | PRJNA630162_P_NODE_163387_length_160_cov_5.504505_g161864_i0 | PRJNA630162 | 163387 | 160 | 5.504505 | 8.807208 | uncultured Cryptomycota | 1130064 | Fungi | Fungi | 132 | 1.6600000000000002e-26 | NTclustered | gi|387155805|emb|HE806178.1| | 1130064 | g161864 | i0 | 93.258 | 53.91875 | 89 | 6 | 56 | 0 | 67 | 155 | 1850 | 1762 | Uncultured Cryptomycota partial 26S rRNA gene, clone Bcomple7 | blastn | 8627 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | uncultured Cryptomycota | |||||
| 8255478 | 8255478 | PRJNA630162_P_NODE_45407_length_262_cov_3.784038_g43884_i0 | PRJNA630162 | 45407 | 262 | 3.784038 | 9.91417956 | Cryptomycota sp. | 2012228 | Fungi | Fungi | 381 | 2.6799999999999996e-101 | NTclustered | gi|2468791035|gb|OQ702926.1| | 2012228 | g43884 | i0 | 93.103 | 106.427480916031 | 261 | 17 | 99 | 1 | 2 | 262 | 3926 | 3667 | Cryptomycota sp. isolate PSC258 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 | 27884 | 381 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Cryptomycota sp. | |||||
| 8255901 | 8255901 | PRJNA630162_P_NODE_85407_length_195_cov_7.979452_g83884_i0 | PRJNA630162 | 85407 | 195 | 7.979452 | 15.5599314 | Rozella sp. JEL347 | 276837 | Fungi | Fungi | 279 | 7.1e-71 | NTclustered | gi|82398068|gb|DQ273766.1| | 276837 | g83884 | i0 | 94.475 | 0.928205128205128 | 181 | 10 | 93 | 0 | 7 | 187 | 605 | 425 | Rozella sp. JEL347 isolate AFTOL-ID 16 28S ribosomal RNA gene, partial sequence | blastn | 181 | 279 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. JEL347 | ||||
| 9530965 | 9530965 | PRJNA630162_P_NODE_58348_length_231_cov_1.582418_g56825_i0 | PRJNA630162 | 58348 | 231 | 1.582418 | 3.65538558 | uncultured Cryptomycota | 1130064 | Fungi | Fungi | 305 | 1.43e-78 | NTclustered | gi|387155806|emb|HE806179.1| | 1130064 | g56825 | i0 | 90.476 | 36.4891774891775 | 231 | 22 | 100 | 0 | 1 | 231 | 310 | 540 | Uncultured Cryptomycota partial 26S rRNA gene, clone Dmlmple3 | blastn | 8429 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | uncultured Cryptomycota | |||||
| 11354558 | 11354558 | PRJNA630162_P_NODE_127329_length_170_cov_40.719008_g125806_i0 | PRJNA630162 | 127329 | 170 | 40.719008 | 69.2223136 | Rozella | 276836 | Fungi | Fungi | 270 | 3.61e-68 | NTclustered | gi|62866692|gb|AY997086.1| | 276837 | g125806 | i0 | 99.329 | 85.9882352941176 | 149 | 1 | 88 | 0 | 18 | 166 | 479 | 331 | Rozella sp. JEL347 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 14618 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. JEL347 | ||||
| 12081847 | 12081847 | PRJNA630162_P_NODE_56970_length_233_cov_13.831522_g55447_i0 | PRJNA630162 | 56970 | 233 | 13.831522 | 32.22744626 | Rozella sp. | 1932610 | Fungi | Fungi | 355 | 1.42e-93 | NTclustered | gi|2468791001|gb|OQ702917.1| | 1932610 | g55447 | i0 | 95.111 | 91.2832618025751 | 225 | 11 | 97 | 0 | 3 | 227 | 2625 | 2401 | Rozella sp. isolate PSC230 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 | 21269 | 355 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. | ||||
| 15904376 | 15904376 | PRJNA630162_P_NODE_115813_length_176_cov_3.354331_g114290_i0 | PRJNA630162 | 115813 | 176 | 3.354331 | 5.90362256 | Rozella sp. | 1932610 | Fungi | Fungi | 206 | 1.08e-48 | NTclustered | gi|2468791009|gb|OQ702919.1| | 1932610 | g114290 | i0 | 89.412 | 86.3465909090909 | 170 | 9 | 95 | 6 | 2 | 169 | 3719 | 3557 | Rozella sp. isolate PSC238 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 | 15197 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. | ||||
| 17180453 | 17180453 | PRJNA630162_P_NODE_57054_length_233_cov_3.353261_g55531_i0 | PRJNA630162 | 57054 | 233 | 3.353261 | 7.81309813 | uncultured Cryptomycota | 1130064 | Fungi | Fungi | 143 | 1.2e-29 | NTclustered | gi|2086101791|gb|MZ923352.1| | 1130064 | g55531 | i0 | 86.131 | 60.9055793991416 | 137 | 14 | 58 | 4 | 2 | 137 | 392 | 260 | Uncultured Cryptomycota clone UMPB-6 small subunit ribosomal RNA gene, partial sequence | blastn | 14191 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | uncultured Cryptomycota | |||||
| 17729322 | 17729322 | PRJNA630162_P_NODE_45674_length_261_cov_60.613208_g44151_i0 | PRJNA630162 | 45674 | 261 | 60.613208 | 158.20047288 | Rozella | 276836 | Fungi | Fungi | 424 | 4.3799999999999996e-114 | NTclustered | gi|47132211|gb|AY601707.1| | 276837 | g44151 | i0 | 96.139 | 99.8505747126437 | 259 | 10 | 99 | 0 | 3 | 261 | 73 | 331 | Rozella sp. JEL347 isolate AFTOL-ID 16 18S ribosomal RNA gene, partial sequence | blastn | 26061 | 424 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. JEL347 | ||||
| 18453350 | 18453350 | PRJNA630162_P_NODE_103235_length_183_cov_18.208955_g101712_i0 | PRJNA630162 | 103235 | 183 | 18.208955 | 33.32238765 | Rozella sp. JEL347 | 276837 | Fungi | Fungi | 313 | 6.479999999999998e-81 | NTclustered | gi|47132211|gb|AY601707.1| | 276837 | g101712 | i0 | 97.297 | 100.92349726776 | 185 | 3 | 100 | 1 | 1 | 183 | 1553 | 1369 | Rozella sp. JEL347 isolate AFTOL-ID 16 18S ribosomal RNA gene, partial sequence | blastn | 18469 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. JEL347 | ||||
| 18453388 | 18453388 | PRJNA630162_P_NODE_108515_length_180_cov_3.000000_g106992_i0 | PRJNA630162 | 108515 | 180 | 3 | 5.4 | Cryptomycota sp. | 2012228 | Fungi | Fungi | 159 | 8.75e-35 | NTclustered | gi|2468791071|gb|OQ702935.1| | 2012228 | g106992 | i0 | 83.425 | 1.00555555555556 | 181 | 20 | 97 | 7 | 6 | 180 | 3918 | 4094 | Cryptomycota sp. isolate PSC281 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 | 181 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Cryptomycota sp. | |||||
| 18453931 | 18453931 | PRJNA630162_P_NODE_165655_length_158_cov_3.403670_g164132_i0 | PRJNA630162 | 165655 | 158 | 3.40367 | 5.3777986 | Cryptomycota sp. | 2012228 | Fungi | Fungi | 195 | 2.05e-45 | NTclustered | gi|2468790980|gb|OQ702912.1| | 2012228 | g164132 | i0 | 90.066 | 79.1139240506329 | 151 | 13 | 95 | 2 | 8 | 157 | 3729 | 3878 | Cryptomycota sp. isolate PSC211 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 | 12500 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Cryptomycota sp. | |||||
| 21003907 | 21003907 | PRJNA630162_P_NODE_119477_length_174_cov_5.512000_g117954_i0 | PRJNA630162 | 119477 | 174 | 5.512 | 9.59088 | Rozella sp. | 1932610 | Fungi | Fungi | 224 | 2.93e-54 | NTclustered | gi|2468791023|gb|OQ702923.1| | 1932610 | g117954 | i0 | 89.773 | 101.344827586207 | 176 | 16 | 100 | 2 | 1 | 174 | 4103 | 4278 | Rozella sp. isolate PSC249 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 | 17634 | 224 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. | ||||
| 24829109 | 24829109 | PRJNA630162_P_NODE_96660_length_187_cov_3.942029_g95137_i0 | PRJNA630162 | 96660 | 187 | 3.942029 | 7.37159423 | Rozella sp. | 1932610 | Fungi | Fungi | 111 | 2.6e-20 | NTclustered | gi|2468791040|gb|OQ702927.1| | 1932610 | g95137 | i0 | 78.689 | 24.6791443850267 | 183 | 28 | 96 | 7 | 3 | 182 | 4372 | 4198 | Rozella sp. isolate PSC259 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 | 4615 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. |
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);;