contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA451191" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1092641 | 1092641 | PRJNA451191_P_NODE_20221_length_319_cov_2.143411_g19950_i0 | PRJNA451191 | 20221 | 319 | 2.143411 | 6.83748109 | Cladosporium | 5498 | Fungi | Fungi | 573 | 5.159999999999998e-159 | NTclustered | gi|284158823|gb|GU214410.1| | 29918 | g19950 | i0 | 99.06 | 96.551724137931 | 319 | 3 | 100 | 0 | 1 | 319 | 3269 | 2951 | Cladosporium herbarum strain CBS 723.79 28S large subunit ribosomal RNA gene, partial sequence | blastn | 30800 | 573 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium herbarum | |
| 4268038 | 4268038 | PRJNA451191_P_NODE_50764_length_206_cov_0.896552_g50493_i0 | PRJNA451191 | 50764 | 206 | 0.896552 | 1.84689712 | Eremothecium gossypii | 33169 | Fungi | Fungi | 71.3 | 4.97e-8 | NTclustered | gi|47074551|ref|NM_210935.1| | 284811 | g50493 | i0 | 93.617 | 3.86407766990291 | 47 | 3 | 23 | 0 | 156 | 202 | 302 | 256 | Eremothecium gossypii ATCC 10895 60S ribosomal protein eL42 (AGOS_AFR034W), partial mRNA | blastn | 796 | 71.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Eremothecium | Eremothecium gossypii | |
| 6195723 | 6195723 | PRJNA451191_P_NODE_40745_length_223_cov_1.604938_g40474_i0 | PRJNA451191 | 40745 | 223 | 1.604938 | 3.57901174 | Ascolacicola | 99679 | Fungi | Fungi | 412 | 7.88e-111 | NTclustered | gi|2877525104|gb|PQ844522.1| | 99680 | g40474 | i0 | 100 | 100.008968609865 | 223 | 0 | 100 | 0 | 1 | 223 | 859 | 637 | Ascolacicola aquatica strain KUNCC:23-16631 small subunit ribosomal RNA gene, partial sequence | blastn | 22302 | 412 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Ascolacicola | Ascolacicola aquatica | ||
| 6818254 | 6818254 | PRJNA451191_P_NODE_34286_length_243_cov_1.428571_g34015_i0 | PRJNA451191 | 34286 | 243 | 1.428571 | 3.47142753 | Plenodomus biglobosus | 220672 | Fungi | Fungi | 420 | 5.21e-113 | NTclustered | gi|702073470|emb|FO905844.1| | 225344 | g34015 | i0 | 97.942 | 95.7818930041152 | 243 | 4 | 100 | 1 | 1 | 243 | 17041 | 17282 | Leptosphaeria biglobosa Thlaspii ibcn65_scaffold00057 complete sequence | blastn | 23275 | 420 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Leptosphaeriaceae | Plenodomus | Plenodomus biglobosus | |
| 8745659 | 8745659 | PRJNA451191_P_NODE_30587_length_257_cov_1.326531_g30316_i0 | PRJNA451191 | 30587 | 257 | 1.326531 | 3.40918467 | Pleosporales | 92860 | Fungi | Fungi | 359 | 1.23e-94 | NTclustered | gi|2228964925|ref|NC_062622.1| | 95742 | g30316 | i0 | 91.829 | 102.035019455253 | 257 | 21 | 100 | 0 | 1 | 257 | 23629 | 23885 | Curvularia clavata mitochondrion, complete genome | blastn | 26223 | 359 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Curvularia | Curvularia clavata | |
| 10020906 | 10020906 | PRJNA451191_P_NODE_35628_length_238_cov_2.531073_g35357_i0 | PRJNA451191 | 35628 | 238 | 2.531073 | 6.02395374 | Ascomycota | 4890 | Fungi | Fungi | 440 | 3.899999999999999e-119 | NTclustered | gi|2324126172|gb|OP750342.1| | 13684 | g35357 | i0 | 100 | 106.004201680672 | 238 | 0 | 100 | 0 | 1 | 238 | 55 | 292 | Parastagonospora nodorum isolate DTP-4 small subunit ribosomal RNA gene, partial sequence | blastn | 25229 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora nodorum | |
| 13194369 | 13194369 | PRJNA451191_P_NODE_41571_length_221_cov_1.375000_g41300_i0 | PRJNA451191 | 41571 | 221 | 1.375 | 3.03875 | Golovinomyces sordidus | 62717 | Fungi | Fungi | 403 | 4.69e-108 | NTclustered | gi|28188930|dbj|AB077657.1| | 62717 | g41300 | i0 | 99.55 | 100.420814479638 | 222 | 0 | 100 | 1 | 1 | 221 | 415 | 636 | Golovinomyces sordidus gene for 28S rRNA, partial sequence, isolate: MUMHn41 | blastn | 22193 | 403 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Golovinomyces | Golovinomyces sordidus | |
| 16395349 | 16395349 | PRJNA451191_P_NODE_56393_length_194_cov_2.699248_g56122_i0 | PRJNA451191 | 56393 | 194 | 2.699248 | 5.23654112 | Opisthokonta | 33154 | Fungi | Fungi | 359 | 8.809999999999999e-95 | NTclustered | gi|154563029|gb|EF590320.2| | 13684 | g56122 | i0 | 100 | 122.510309278351 | 194 | 0 | 100 | 0 | 1 | 194 | 1656 | 1463 | Phaeosphaeria nodorum strain S-80-603 large subunit ribosomal RNA gene, partial sequence | blastn | 23767 | 359 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora nodorum | |
| 17670286 | 17670286 | PRJNA451191_P_NODE_27014_length_273_cov_2.891509_g26743_i0 | PRJNA451191 | 27014 | 273 | 2.891509 | 7.89381957 | Golovinomyces | 184027 | Fungi | Fungi | 483 | 7.5e-132 | NTclustered | gi|1829011279|dbj|LC516963.1| | 184028 | g26743 | i0 | 98.889 | 98.8791208791209 | 270 | 3 | 99 | 0 | 4 | 273 | 26 | 295 | Golovinomyces adenophorae MUMH<JPN>144 genes for 18S rRNA, ITS1, partial sequence | blastn | 26994 | 483 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Golovinomyces | Golovinomyces adenophorae | |
| 17670375 | 17670375 | PRJNA451191_P_NODE_56614_length_192_cov_3.396947_g56343_i0 | PRJNA451191 | 56614 | 192 | 3.396947 | 6.52213824 | Ascomycota | 4890 | Fungi | Fungi | 355 | 1.13e-93 | NTclustered | gi|1772639949|gb|MN644567.1| | 45271 | g56343 | i0 | 100 | 106.885416666667 | 192 | 0 | 100 | 0 | 1 | 192 | 789 | 598 | Pseudallescheria ellipsoidea voucher research collection Farrer lab 84 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 20522 | 355 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Microascaceae | Pseudallescheria | Pseudallescheria ellipsoidea | |
| 24044607 | 24044607 | PRJNA451191_P_NODE_52119_length_204_cov_4.370629_g51848_i0 | PRJNA451191 | 52119 | 204 | 4.370629 | 8.91608316 | Hypocreales | 5125 | Fungi | Fungi | 363 | 7.239999999999998e-96 | NTclustered | gi|1859735559|gb|MT644877.1| | 29855 | g51848 | i0 | 99.01 | 99.2696078431373 | 202 | 2 | 99 | 0 | 3 | 204 | 3933 | 3732 | Nectria cinnabarina isolate DM1152 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 | 20251 | 366 | 0.991803278688525 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Nectria | Nectria cinnabarina | |
| 25318797 | 25318797 | PRJNA451191_P_NODE_11160_length_447_cov_3.308290_g10889_i0 | PRJNA451191 | 11160 | 447 | 3.30829 | 14.7880563 | Eukaryota | 2759 | Fungi | Fungi | 616 | 1.22e-171 | NTclustered | gi|28188954|dbj|AB077681.1| | 62708 | g10889 | i0 | 98.291 | 78.8008948545861 | 351 | 6 | 79 | 0 | 97 | 447 | 357 | 7 | Golovinomyces cichoracearum gene for 28S rRNA, partial sequence, isolate: MUMH759 | blastn | 35224 | 616 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Golovinomyces | Golovinomyces cichoracearum |
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);;