contig_metadata
17 rows where bioproject = "PRJNA691918" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1948490 | 1948490 | PRJNA691918_S_NODE_82_length_233_cov_14891.638614_g81_i0 | PRJNA691918 | 82 | 233 | 14891.638614 | 34697.51797062 | uncultured fungus | 175245 | Fungi | Fungi | 283 | 6.789999999999999e-72 | NTclustered | gi|85700830|gb|DQ365437.1| | 175245 | g81 | i0 | 94.536 | 78.5579399141631 | 183 | 10 | 79 | 0 | 48 | 230 | 345 | 163 | Uncultured compost fungus clone 3F02 26S ribosomal RNA gene, partial sequence | blastn | 18304 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 4500490 | 4500490 | PRJNA691918_S_NODE_104_length_223_cov_15675.734375_g103_i0 | PRJNA691918 | 104 | 223 | 15675.734375 | 34956.88765625 | uncultured fungus | 175245 | Fungi | Fungi | 294 | 2.98e-75 | NTclustered | gi|2159203107|emb|OU941535.1| | 175245 | g103 | i0 | 97.661 | 28.9013452914798 | 171 | 4 | 77 | 0 | 5 | 175 | 582 | 752 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus02829 | blastn | 6445 | 294 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 4500491 | 4500491 | PRJNA691918_S_NODE_124_length_217_cov_21.403226_g123_i0 | PRJNA691918 | 124 | 217 | 21.403226 | 46.44500042 | uncultured fungus | 175245 | Fungi | Fungi | 80.5 | 8.79e-11 | NTclustered | gi|189032681|gb|EU691383.1| | 175245 | g123 | i0 | 80 | 0.506912442396313 | 110 | 21 | 50 | 1 | 15 | 123 | 378 | 269 | Uncultured soil fungus clone BPAGM2T0_4G 28S ribosomal RNA gene, partial sequence | blastn | 110 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 7051112 | 7051112 | PRJNA691918_S_NODE_26_length_283_cov_10647.571429_g25_i0 | PRJNA691918 | 26 | 283 | 10647.571429 | 30132.62714407 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 121 | 7.059999999999999e-23 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g25 | i0 | 97.183 | 25.13074204947 | 71 | 2 | 25 | 0 | 213 | 283 | 3376 | 3306 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 7112 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 7051115 | 7051115 | PRJNA691918_S_NODE_406_length_158_cov_11.897638_g405_i0 | PRJNA691918 | 406 | 158 | 11.897638 | 18.79826804 | uncultured fungus | 175245 | Fungi | Fungi | 171 | 3.46e-38 | NTclustered | gi|2159201598|emb|OU940632.1| | 175245 | g405 | i0 | 93.103 | 74.4050632911392 | 116 | 8 | 73 | 0 | 1 | 116 | 1849 | 1734 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01926 | blastn | 11756 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 10876536 | 10876536 | PRJNA691918_S_NODE_189_length_197_cov_18431.036145_g188_i0 | PRJNA691918 | 189 | 197 | 18431.036145 | 36309.14120565 | uncultured fungus | 175245 | Fungi | Fungi | 219 | 1.59e-52 | NTclustered | gi|375156252|gb|JQ311601.1| | 175245 | g188 | i0 | 93.793 | 24.8274111675127 | 145 | 9 | 74 | 0 | 51 | 195 | 298 | 154 | Uncultured soil fungus clone OTU97-798 28S ribosomal RNA gene, partial sequence | blastn | 4891 | 219 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 10876539 | 10876539 | PRJNA691918_S_NODE_29_length_281_cov_12246.192000_g28_i0 | PRJNA691918 | 29 | 281 | 12246.192 | 34411.79952 | uncultured fungus | 175245 | Fungi | Fungi | 311 | 3.87e-80 | NTclustered | gi|2159203701|emb|OU942103.1| | 175245 | g28 | i0 | 91.026 | 33.3629893238434 | 234 | 16 | 82 | 3 | 2 | 232 | 872 | 1103 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus03398 | blastn | 9375 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 10876540 | 10876540 | PRJNA691918_S_NODE_49_length_255_cov_13701.200893_g48_i0 | PRJNA691918 | 49 | 255 | 13701.200893 | 34938.06227715 | Microsporidium sp. LVPEI.SMW V3S1-FR | 1734473 | Fungi | Fungi | 357 | 4.3799999999999997e-94 | NTclustered | gi|937656209|gb|KR303710.1| | 1734473 | g48 | i0 | 98.049 | 81.1450980392157 | 205 | 4 | 80 | 0 | 1 | 205 | 765 | 969 | Microsporidium sp. LVPEI.SMW V3S1-FR small subunit ribosomal RNA gene, partial sequence | blastn | 20692 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. LVPEI.SMW V3S1-FR | ||||
| 12151684 | 12151684 | PRJNA691918_S_NODE_210_length_193_cov_18879.777778_g209_i0 | PRJNA691918 | 210 | 193 | 18879.777778 | 36437.97111154 | uncultured fungus | 175245 | Fungi | Fungi | 213 | 7.21e-51 | NTclustered | gi|2159201455|emb|OU940489.1| | 175245 | g209 | i0 | 93.151 | 37.7668393782383 | 146 | 8 | 75 | 2 | 1 | 144 | 805 | 950 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01783 | blastn | 7289 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 13426258 | 13426258 | PRJNA691918_S_NODE_191_length_197_cov_16156.192771_g190_i0 | PRJNA691918 | 191 | 197 | 16156.192771 | 31827.69975887 | uncultured fungus | 175245 | Fungi | Fungi | 259 | 9.37e-65 | NTclustered | gi|2159201594|emb|OU940628.1| | 175245 | g190 | i0 | 98.63 | 23.3756345177665 | 146 | 2 | 74 | 0 | 49 | 194 | 994 | 849 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01921 | blastn | 4605 | 259 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 13426259 | 13426259 | PRJNA691918_S_NODE_211_length_193_cov_18543.839506_g210_i0 | PRJNA691918 | 211 | 193 | 18543.839506 | 35789.61024658 | uncultured fungus | 175245 | Fungi | Fungi | 254 | 4.25e-63 | NTclustered | gi|2159202234|emb|OU940662.1| | 175245 | g210 | i0 | 97.945 | 22.5958549222798 | 146 | 3 | 76 | 0 | 45 | 190 | 243 | 98 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01956 | blastn | 4361 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 13933204 | 13933204 | PRJNA691918_S_NODE_111_length_221_cov_9.810526_g110_i0 | PRJNA691918 | 111 | 221 | 9.810526 | 21.68126246 | Mycosphaerellales | 2726947 | Fungi | Fungi | 379 | 7.909999999999998e-101 | NTclustered | gi|375156288|gb|JQ311637.1| | 175245 | g110 | i0 | 97.727 | 99.5475113122172 | 220 | 5 | 99 | 0 | 2 | 221 | 11 | 230 | Uncultured soil fungus clone OTU97-83 28S ribosomal RNA gene, partial sequence | blastn | 22000 | 379 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 15975192 | 15975192 | PRJNA691918_S_NODE_393_length_162_cov_11.931298_g392_i0 | PRJNA691918 | 393 | 162 | 11.931298 | 19.32870276 | uncultured fungus | 175245 | Fungi | Fungi | 171 | 3.57e-38 | NTclustered | gi|2159204111|emb|OU942513.1| | 175245 | g392 | i0 | 85.976 | 100.524691358025 | 164 | 18 | 100 | 4 | 1 | 162 | 1025 | 865 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus03807 | blastn | 16285 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 21581448 | 21581448 | PRJNA691918_S_NODE_237_length_188_cov_19116.089172_g236_i0 | PRJNA691918 | 237 | 188 | 19116.089172 | 35938.24764336 | Fungi | 4751 | Fungi | Fungi | 261 | 2.46e-65 | NTclustered | gi|1601879252|gb|MH751906.1| | 5341 | g236 | i0 | 99.306 | 76.0957446808511 | 144 | 1 | 77 | 0 | 1 | 144 | 381 | 524 | Agaricus bisporus 18S ribosomal RNA gene, partial sequence | blastn | 14306 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Agaricus | Agaricus bisporus | |
| 22349832 | 22349832 | PRJNA691918_S_NODE_378_length_166_cov_13.755556_g377_i0 | PRJNA691918 | 378 | 166 | 13.755556 | 22.83422296 | uncultured fungus | 175245 | Fungi | Fungi | 165 | 1.7100000000000002e-36 | NTclustered | gi|2159201850|emb|OU939863.1| | 175245 | g377 | i0 | 85.625 | 85.6265060240964 | 160 | 20 | 95 | 3 | 8 | 165 | 879 | 1037 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01156 | blastn | 14214 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 25405681 | 25405681 | PRJNA691918_S_NODE_220_length_192_cov_19047.931677_g219_i0 | PRJNA691918 | 220 | 192 | 19047.931677 | 36572.02881984 | Microsporidium | 144516 | Fungi | Fungi | 261 | 2.52e-65 | NTclustered | gi|267672585|gb|FJ820195.1| | 546760 | g219 | i0 | 99.306 | 74.9375 | 144 | 1 | 75 | 0 | 49 | 192 | 679 | 536 | Uncultured Microsporidia clone B1FAS7 FAS1 small subunit ribosomal RNA gene, partial sequence | blastn | 14388 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | uncultured Microsporidia | |||||
| 30714424 | 30714424 | PRJNA691918_S_NODE_14_length_310_cov_32.956989_g13_i0 | PRJNA691918 | 14 | 310 | 32.956989 | 102.1666659 | Funneliformis geosporum | 1117311 | Fungi | Fungi | 58.5 | 8.78e-9 | NR | CAI2174852.1 | 1117311 | g13 | i0 | 62.2 | 0.435483870967742 | 45 | 17 | 43.5 | 0 | 263 | 129 | 11 | 55 | CAI2174852.1 9324_t:CDS:2 [Funneliformis geosporum] | diamond | 135 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Funneliformis | Funneliformis geosporum |
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);;