contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA299585" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1650080 | 1650080 | PRJNA299585_S_NODE_9602_length_219_cov_2.484211_g9372_i0 | PRJNA299585 | 9602 | 219 | 2.484211 | 5.44042209 | Olpidium brassicae | 70189 | Fungi | Fungi | 324 | 3.72e-84 | NTclustered | gi|311235549|ref|NG_027564.1| | 70189 | g9372 | i0 | 93.607 | 99.6575342465753 | 219 | 11 | 100 | 2 | 1 | 219 | 1943 | 1728 | Olpidium brassicae DUKE DUH0009361 28S rRNA gene, partial sequence; from reference material | blastn | 21825 | 324 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium brassicae | |
| 6752744 | 6752744 | PRJNA299585_S_NODE_13446_length_169_cov_4.000000_g13216_i0 | PRJNA299585 | 13446 | 169 | 4 | 6.76 | uncultured fungus | 175245 | Fungi | Fungi | 313 | 5.859999999999999e-81 | NTclustered | gi|2159201108|emb|OU940125.1| | 175245 | g13216 | i0 | 100 | 100.289940828402 | 169 | 0 | 100 | 0 | 1 | 169 | 1496 | 1664 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01419 | blastn | 16949 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 9989860 | 9989860 | PRJNA299585_S_NODE_10168_length_208_cov_20.301676_g9938_i0 | PRJNA299585 | 10168 | 208 | 20.301676 | 42.22748608 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 8.42e-6 | NTclustered | gi|2749703766|ref|XM_014090103.2| | 63577 | g9938 | i0 | 85.714 | 1.24038461538462 | 63 | 6 | 30 | 1 | 146 | 208 | 2198 | 2257 | Trichoderma atroviride uncharacterized protein (TrAtP1_012533), partial mRNA | blastn | 258 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma atroviride | |
| 9989871 | 9989871 | PRJNA299585_S_NODE_13348_length_170_cov_3.283688_g13118_i0 | PRJNA299585 | 13348 | 170 | 3.283688 | 5.5822696 | Dothideomycetes | 147541 | Fungi | Fungi | 311 | 2.12e-80 | NTclustered | gi|206597967|gb|FJ176833.1| | 40221 | g13118 | i0 | 100 | 98.8352941176471 | 168 | 0 | 99 | 0 | 3 | 170 | 215 | 48 | Symbiotaphrina kochii isolate AFTOL-ID 1902 18S small subunit ribosomal RNA gene, partial sequence | blastn | 16802 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Symbiotaphrinales | Symbiotaphrinaceae | Symbiotaphrina | Symbiotaphrina kochii | ||
| 13128938 | 13128938 | PRJNA299585_S_NODE_14431_length_161_cov_3.060606_g14201_i0 | PRJNA299585 | 14431 | 161 | 3.060606 | 4.92757566 | Olpidium brassicae | 70189 | Fungi | Fungi | 215 | 1.61e-51 | NTclustered | gi|311235549|ref|NG_027564.1| | 70189 | g14201 | i0 | 94.928 | 103.018633540373 | 138 | 6 | 85 | 1 | 1 | 137 | 3100 | 3237 | Olpidium brassicae DUKE DUH0009361 28S rRNA gene, partial sequence; from reference material | blastn | 16586 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium brassicae | |
| 14404134 | 14404134 | PRJNA299585_S_NODE_3632_length_462_cov_3.725173_g3195_i1 | PRJNA299585 | 3632 | 462 | 3.725173 | 17.21029926 | uncultured Ascomycota | 175243 | Fungi | Fungi | 678 | 0 | NTclustered | gi|313483124|gb|HQ433129.1| | 175243 | g3195 | i1 | 99.73 | 78.6168831168831 | 370 | 1 | 80 | 0 | 1 | 370 | 335 | 704 | Uncultured Ascomycota clone asc07192 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 36321 | 678 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | uncultured Ascomycota | |||||
| 18226975 | 18226975 | PRJNA299585_S_NODE_8315_length_246_cov_3.801843_g8085_i0 | PRJNA299585 | 8315 | 246 | 3.801843 | 9.35253378 | uncultured fungus | 175245 | Fungi | Fungi | 455 | 1.4500000000000002e-123 | NTclustered | gi|2159201108|emb|OU940125.1| | 175245 | g8085 | i0 | 100 | 99.0325203252033 | 246 | 0 | 100 | 0 | 1 | 246 | 752 | 997 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01419 | blastn | 24362 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 18226985 | 18226985 | PRJNA299585_S_NODE_8895_length_233_cov_2.784314_g8665_i0 | PRJNA299585 | 8895 | 233 | 2.784314 | 6.48745162 | uncultured fungus | 175245 | Fungi | Fungi | 425 | 1.07e-114 | NTclustered | gi|2159201108|emb|OU940125.1| | 175245 | g8665 | i0 | 99.571 | 2.73390557939914 | 233 | 1 | 100 | 0 | 1 | 233 | 1159 | 1391 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01419 | blastn | 637 | 425 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 18913146 | 18913146 | PRJNA299585_S_NODE_15855_length_151_cov_2.254098_g15625_i0 | PRJNA299585 | 15855 | 151 | 2.254098 | 3.40368798 | root | 1 | Root_unresolved | Root_unresolved | 279 | 5.19e-71 | NTclustered | gi|1280049812|gb|MF072571.1| | 29917 | g15625 | i0 | 100 | 100 | 151 | 0 | 100 | 0 | 1 | 151 | 705 | 555 | Cladosporium cladosporioides strain 007 small subunit ribosomal RNA gene, partial sequence | blastn | 15100 | 279 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 21463466 | 21463466 | PRJNA299585_S_NODE_13077_length_172_cov_7.825175_g12847_i0 | PRJNA299585 | 13077 | 172 | 7.825175 | 13.459301 | Fungi | 4751 | Fungi | Fungi | 313 | 5.989999999999998e-81 | NTclustered | gi|82398540|gb|DQ273807.1| | 34480 | g12847 | i0 | 99.419 | 100.005813953488 | 172 | 1 | 100 | 0 | 1 | 172 | 2995 | 2824 | Basidiobolus ranarum isolate AFTOL-ID 301 28S ribosomal RNA gene, partial sequence | blastn | 17201 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 21463497 | 21463497 | PRJNA299585_S_NODE_8077_length_252_cov_5.354260_g7847_i0 | PRJNA299585 | 8077 | 252 | 5.35426 | 13.4927352 | Malassezia | 55193 | Fungi | Fungi | 466 | 6.89e-127 | NTclustered | gi|37575174|gb|AY387222.1| | 55194 | g7847 | i0 | 100 | 100 | 252 | 0 | 100 | 0 | 1 | 252 | 12 | 263 | Malassezia furfur strain TPB1 large subunit ribosomal RNA gene, partial sequence | blastn | 25200 | 466 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 22051705 | 22051705 | PRJNA299585_S_NODE_3418_length_484_cov_4.778022_g3195_i0 | PRJNA299585 | 3418 | 484 | 4.778022 | 23.12562648 | uncultured Ascomycota | 175243 | Fungi | Fungi | 665 | 0 | NTclustered | gi|313483124|gb|HQ433129.1| | 175243 | g3195 | i0 | 99.189 | 75.2190082644628 | 370 | 2 | 76 | 1 | 1 | 369 | 335 | 704 | Uncultured Ascomycota clone asc07192 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 36406 | 665 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | uncultured Ascomycota |
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);;