contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1020641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1003063 | 1003063 | PRJNA1020641_P_NODE_7461_length_241_cov_0.916667_g7418_i0 | PRJNA1020641 | 7461 | 241 | 0.916667 | 2.20916747 | root | 1 | Root_unresolved | Root_unresolved | 446 | 8.519999999999999e-121 | NTclustered | gi|1280049812|gb|MF072571.1| | 29917 | g7418 | i0 | 100 | 100 | 241 | 0 | 100 | 0 | 1 | 241 | 62 | 302 | Cladosporium cladosporioides strain 007 small subunit ribosomal RNA gene, partial sequence | blastn | 24100 | 446 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 3987147 | 3987147 | PRJNA1020641_P_NODE_5304_length_257_cov_1.146739_g5261_i0 | PRJNA1020641 | 5304 | 257 | 1.146739 | 2.94711923 | Stenella araguata | 93486 | Fungi | Fungi | 449 | 7.1e-122 | NTclustered | gi|283827943|gb|EU019250.2| | 93486 | g5261 | i0 | 98.431 | 87.2295719844358 | 255 | 4 | 99 | 0 | 3 | 257 | 3535 | 3789 | Stenella araguata strain CBS 105.75 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S large subunit ribosomal RNA gene, partial sequence | blastn | 22418 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Stenella | Stenella araguata | |
| 11206195 | 11206195 | PRJNA1020641_P_NODE_2489_length_388_cov_0.888889_g2446_i0 | PRJNA1020641 | 2489 | 388 | 0.888889 | 3.44888932 | Pleosporales | 92860 | Fungi | Fungi | 689 | 0 | NTclustered | gi|31415585|gb|AY293788.1| | 73001 | g2446 | i0 | 98.961 | 99.5567010309278 | 385 | 4 | 99 | 0 | 4 | 388 | 483 | 99 | Phoma herbarum strain ATCC 26648 28S large subunit ribosomal RNA gene, partial sequence | blastn | 38628 | 695 | 0.99136690647482 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Phoma | Phoma herbarum | |
| 23112867 | 23112867 | PRJNA1020641_P_NODE_5959_length_249_cov_0.875000_g5916_i0 | PRJNA1020641 | 5959 | 249 | 0.875 | 2.17875 | Meyerozyma guilliermondii | 4929 | Fungi | Fungi | 176 | 1.28e-39 | NTclustered | gi|533206516|ref|NC_022154.1| | 4929 | g5916 | i0 | 98.02 | 6.67871485943775 | 101 | 2 | 76 | 0 | 149 | 249 | 30188 | 30088 | Meyerozyma guilliermondii strain CBS 2030 mitochondrion, complete genome | blastn | 1663 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma guilliermondii | |
| 23955346 | 23955346 | PRJNA1020641_P_NODE_5579_length_251_cov_0.865169_g5536_i0 | PRJNA1020641 | 5579 | 251 | 0.865169 | 2.17157419 | Opisthokonta | 33154 | Fungi | Fungi | 462 | 8.869999999999999e-126 | NTclustered | gi|2086743560|ref|XR_006253225.1| | 182096 | g5536 | i0 | 100 | 106.334661354582 | 250 | 0 | 99 | 0 | 2 | 251 | 2172 | 1923 | Aspergillus chevalieri 28S ribosomal RNA (ACHE_r70002S), rRNA | blastn | 26690 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri |
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);;