contig_metadata
8 rows where bioproject = "PRJNA944406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2199998 | 2199998 | PRJNA944406_P_NODE_49422_length_264_cov_1.094241_g48463_i0 | PRJNA944406 | 49422 | 264 | 1.094241 | 2.88879624 | Rozella sp. | 1932610 | Fungi | Fungi | 213 | 1.05e-50 | NTclustered | gi|2468791040|gb|OQ702927.1| | 1932610 | g48463 | i0 | 81.783 | 91.4393939393939 | 258 | 43 | 97 | 4 | 2 | 258 | 4227 | 4481 | 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 | 24140 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. | ||||
| 3475099 | 3475099 | PRJNA944406_P_NODE_2563_length_863_cov_4.268354_g1793_i0 | PRJNA944406 | 2563 | 863 | 4.268354 | 36.83589502 | Rozella sp. | 1932610 | Fungi | Fungi | 178 | 1.38e-39 | NTclustered | gi|2468791040|gb|OQ702927.1| | 1932610 | g1793 | i0 | 94.068 | 15.8945538818076 | 118 | 5 | 24 | 2 | 698 | 814 | 4356 | 4472 | 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 | 13717 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. | ||||
| 7302287 | 7302287 | PRJNA944406_P_NODE_13806_length_343_cov_1.140741_g12847_i0 | PRJNA944406 | 13806 | 343 | 1.140741 | 3.91274163 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 191 | 7.44e-59 | NR | PJF17825.1 | 1246581 | g12847 | i0 | 74.6 | 4.95918367346939 | 114 | 29 | 99.7 | 0 | 343 | 2 | 46 | 159 | PJF17825.1 hypothetical protein PSACC_02363 [Paramicrosporidium saccamoebae] | diamond | 1701 | 191 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 23877535 | 23877535 | PRJNA944406_P_NODE_7639_length_454_cov_3.650919_g6683_i0 | PRJNA944406 | 7639 | 454 | 3.650919 | 16.57517226 | uncultured Cryptomycota | 1130064 | Fungi | Fungi | 237 | 1.13e-57 | NTclustered | gi|2086101624|gb|MZ923185.1| | 1130064 | g6683 | i0 | 77.189 | 67.0462555066079 | 434 | 82 | 93 | 13 | 2 | 421 | 695 | 265 | Uncultured Cryptomycota clone UMPB-1161 small subunit ribosomal RNA gene, partial sequence | blastn | 30439 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | uncultured Cryptomycota | |||||
| 27909494 | 27909494 | PRJNA944406_P_NODE_29765_length_282_cov_1.473684_g28806_i0 | PRJNA944406 | 29765 | 282 | 1.473684 | 4.15578888 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 124 | 9.2e-31 | NR | PJF17226.1 | 1246581 | g28806 | i0 | 68.1 | 1 | 94 | 29 | 98.9 | 1 | 280 | 2 | 627 | 720 | PJF17226.1 DNA helicase [Paramicrosporidium saccamoebae] | diamond | 282 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 29141404 | 29141404 | PRJNA944406_P_NODE_93909_length_244_cov_1.035088_g92950_i0 | PRJNA944406 | 93909 | 244 | 1.035088 | 2.52561472 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 132 | 2.39e-36 | NR | PJF17825.1 | 1246581 | g92950 | i0 | 73.8 | 3.83606557377049 | 80 | 21 | 98.4 | 0 | 3 | 242 | 41 | 120 | PJF17825.1 hypothetical protein PSACC_02363 [Paramicrosporidium saccamoebae] | diamond | 936 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 32396620 | 32396620 | PRJNA944406_P_NODE_85099_length_246_cov_1.335260_g84140_i0 | PRJNA944406 | 85099 | 246 | 1.33526 | 3.2847396 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 85.5 | 1.31e-17 | NR | PJF18422.1 | 1246581 | g84140 | i0 | 51.9 | 0.98780487804878 | 81 | 39 | 98.8 | 0 | 244 | 2 | 230 | 310 | PJF18422.1 Mannose-1-phosphate guanyltransferase [Paramicrosporidium saccamoebae] | diamond | 243 | 85.5 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 32617671 | 32617671 | PRJNA944406_P_NODE_10960_length_377_cov_1.440789_g10001_i0 | PRJNA944406 | 10960 | 377 | 1.440789 | 5.43177453 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 169 | 1.1699999999999998e-47 | NR | PJF17735.1 | 1246581 | g10001 | i0 | 61.9 | 1.0026525198939 | 126 | 46 | 98.7 | 1 | 5 | 376 | 127 | 252 | PJF17735.1 hypothetical protein PSACC_02450 [Paramicrosporidium saccamoebae] | diamond | 378 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae |
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);;