contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA999747" and tax_phylum = "Mucoromycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1274176 | 1274176 | PRJNA999747_S_NODE_1161_length_277_cov_3.394309_g1129_i0 | PRJNA999747 | 1161 | 277 | 3.394309 | 9.40223593 | Mucorales | 4827 | Fungi | Fungi | 71.3 | 7.04e-8 | NTclustered | gi|82398553|gb|DQ273817.1| | 4846 | g1129 | i0 | 84 | 3.01805054151625 | 75 | 10 | 27 | 2 | 11 | 84 | 1587 | 1660 | Rhizopus stolonifer isolate AFTOL-ID 632 28S ribosomal RNA gene, partial sequence | blastn | 836 | 71.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus stolonifer | |
| 14027991 | 14027991 | PRJNA999747_S_NODE_1271_length_268_cov_193.738397_g1239_i0 | PRJNA999747 | 1271 | 268 | 193.738397 | 519.21890396 | Fungi | 4751 | Fungi | Fungi | 449 | 7.450000000000001e-122 | NTclustered | gi|658131632|emb|HF968958.1| | 4874 | g1239 | i0 | 99.197 | 104.537313432836 | 249 | 2 | 93 | 0 | 4 | 252 | 2008 | 2256 | Gigaspora margarita partial 28S rRNA gene, strain BEG34, isolate spore 4, clone BL2_6_26 | blastn | 28016 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 16283324 | 16283324 | PRJNA999747_S_NODE_2113_length_209_cov_71.865169_g2081_i0 | PRJNA999747 | 2113 | 209 | 71.865169 | 150.19820321 | uncultured Glomeromycotina | 241622 | Fungi | Fungi | 357 | 3.47e-94 | NTclustered | gi|2415612110|gb|MZ480635.1| | 241622 | g2081 | i0 | 97.596 | 98.7751196172249 | 208 | 5 | 99 | 0 | 2 | 209 | 68 | 275 | Uncultured Glomeromycotina clone CHTACBSHOTU0885 small subunit ribosomal RNA gene, partial sequence | blastn | 20644 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | uncultured Glomeromycotina | |||||
| 25206668 | 25206668 | PRJNA999747_S_NODE_1280_length_267_cov_20.127119_g1248_i0 | PRJNA999747 | 1280 | 267 | 20.127119 | 53.73940773 | Diversispora sp. EE1 | 1202552 | Fungi | Fungi | 100 | 8.6e-17 | NTclustered | gi|442866411|emb|HE863895.1| | 1202552 | g1248 | i0 | 77.66 | 30.7116104868914 | 188 | 26 | 66 | 12 | 4 | 178 | 1390 | 1574 | Diversispora sp. EE1 genomic DNA containing 28S rRNA gene, strain EE1, isolate spore 3, clone AL2_45_24 | blastn | 8200 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Diversisporaceae | Diversispora | Diversispora sp. EE1 |
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);;