contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 892903 | 892903 | PRJNA911178_P_NODE_299621_length_234_cov_28.142857_g297147_i0 | PRJNA911178 | 299621 | 234 | 28.142857 | 65.85428538 | Gromochytrium mamkaevae | 1486924 | Fungi | Fungi | 87.9 | 5.74e-13 | NTclustered | gi|612507318|gb|KF586842.1| | 1486924 | g297147 | i0 | 96.226 | 7.11965811965812 | 53 | 2 | 23 | 0 | 182 | 234 | 6129 | 6181 | Gromochytrium mamkaevae strain CALU x-51 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 1666 | 87.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Gromochytriales | Gromochytriaceae | Gromochytrium | Gromochytrium mamkaevae | |
| 3444228 | 3444228 | PRJNA911178_P_NODE_71443_length_417_cov_2.889535_g68981_i0 | PRJNA911178 | 71443 | 417 | 2.889535 | 12.04936095 | Rhizophydium sp. | 2012224 | Fungi | Fungi | 276 | 2.19e-69 | NTclustered | gi|1866582435|gb|MT730610.1| | 2012224 | g68981 | i0 | 80.238 | 94.7002398081535 | 420 | 40 | 99 | 25 | 2 | 414 | 4379 | 3996 | Rhizophydium sp. isolate ARG035 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 | 39490 | 276 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Rhizophydiaceae | Rhizophydium | Rhizophydium sp. | |
| 5994718 | 5994718 | PRJNA911178_P_NODE_124865_length_329_cov_2.031250_g122393_i0 | PRJNA911178 | 124865 | 329 | 2.03125 | 6.6828125 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 603 | 6.819999999999999e-168 | NTclustered | gi|82398309|gb|DQ273787.1| | 64517 | g122393 | i0 | 99.696 | 100.109422492401 | 329 | 1 | 100 | 0 | 1 | 329 | 1565 | 1893 | Rhizophlyctis rosea isolate AFTOL-ID 43 28S ribosomal RNA gene, partial sequence | blastn | 32936 | 603 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 7627641 | 7627641 | PRJNA911178_P_NODE_126886_length_327_cov_1.500000_g124414_i0 | PRJNA911178 | 126886 | 327 | 1.5 | 4.905 | Endochytrium | 109937 | Fungi | Fungi | 200 | 1.0399999999999999e-46 | NTclustered | gi|1866582723|gb|MT730898.1| | 2011712 | g124414 | i0 | 81.124 | 77.0886850152905 | 249 | 47 | 76 | 0 | 75 | 323 | 4052 | 3804 | Cladochytriales sp. isolate JEL0931 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 | 25208 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriales sp. | |||
| 13646198 | 13646198 | PRJNA911178_P_NODE_254291_length_248_cov_1.702857_g251817_i0 | PRJNA911178 | 254291 | 248 | 1.702857 | 4.22308536 | Feramyces austinii | 2170546 | Fungi | Fungi | 409 | 1.16e-109 | NTclustered | gi|1388116306|gb|MH043840.1| | 2170546 | g251817 | i0 | 100 | 30.7258064516129 | 221 | 0 | 89 | 0 | 21 | 241 | 1 | 221 | Feramyces austinii strain WSF3a Glycosyl hydrolase family 130 mRNA, partial cds | blastn | 7620 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Feramyces | Feramyces austinii | |
| 20020212 | 20020212 | PRJNA911178_P_NODE_90436_length_377_cov_1.250000_g87966_i0 | PRJNA911178 | 90436 | 377 | 1.25 | 4.7125 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 477 | 5e-130 | NTclustered | gi|2432131711|ref|XM_053109357.1| | 110093 | g87966 | i0 | 90.191 | 96.2705570291777 | 367 | 35 | 97 | 1 | 6 | 372 | 568 | 203 | Polychytrium aggregatum calmodulin (BJ171DRAFT_488251), mRNA | blastn | 36294 | 477 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum |
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);;