contig_metadata
7 rows where bioproject = "PRJEB14175", tax_kingdom = "Fungi" and tax_phylum = "Olpidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25510185 | 25510185 | PRJEB14175_P_NODE_53561_length_508_cov_5951.612975_g51315_i0 | PRJEB14175 | 53561 | 508 | 5951.612975 | 30234.193913 | Olpidium brassicae | 70189 | Fungi | Fungi | 654 | 0 | NTclustered | gi|311235549|ref|NG_027564.1| | 70189 | g51315 | i0 | 90 | 100.248031496063 | 510 | 45 | 100 | 6 | 1 | 508 | 2093 | 1588 | Olpidium brassicae DUKE DUH0009361 28S rRNA gene, partial sequence; from reference material | blastn | 50926 | 654 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium brassicae | |
| 25879075 | 25879075 | PRJEB14175_P_NODE_110395_length_336_cov_16562.767273_g108129_i0 | PRJEB14175 | 110395 | 336 | 16562.767273 | 55650.89803728 | Fungi | 4751 | Fungi | Fungi | 213 | 1.37e-50 | NTclustered | gi|311235549|ref|NG_027564.1| | 70189 | g108129 | i0 | 98.361 | 54.1666666666667 | 122 | 1 | 56 | 1 | 1 | 122 | 2335 | 2215 | Olpidium brassicae DUKE DUH0009361 28S rRNA gene, partial sequence; from reference material | blastn | 18200 | 215 | 0.990697674418605 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium brassicae | |
| 25883730 | 25883730 | PRJEB14175_P_NODE_93803_length_372_cov_2.138264_g91537_i0 | PRJEB14175 | 93803 | 372 | 2.138264 | 7.95434208 | Fungi | 4751 | Fungi | Fungi | 243 | 1.9600000000000002e-59 | NTclustered | gi|311235549|ref|NG_027564.1| | 70189 | g91537 | i0 | 88.35 | 60.5161290322581 | 206 | 18 | 55 | 6 | 2 | 206 | 1638 | 1838 | Olpidium brassicae DUKE DUH0009361 28S rRNA gene, partial sequence; from reference material | blastn | 22512 | 243 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium brassicae | |
| 26015531 | 26015531 | PRJEB14175_P_NODE_113316_length_331_cov_5.529630_g111050_i0 | PRJEB14175 | 113316 | 331 | 5.52963 | 18.3030753 | Fungi | 4751 | Fungi | Fungi | 215 | 3.76e-51 | NTclustered | gi|311235549|ref|NG_027564.1| | 70189 | g111050 | i0 | 98.361 | 48.7129909365559 | 122 | 2 | 37 | 0 | 23 | 144 | 3116 | 3237 | Olpidium brassicae DUKE DUH0009361 28S rRNA gene, partial sequence; from reference material | blastn | 16124 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium brassicae | |
| 26190869 | 26190869 | PRJEB14175_P_NODE_57382_length_490_cov_6677.412587_g55132_i0 | PRJEB14175 | 57382 | 490 | 6677.412587 | 32719.3216763 | Olpidium brassicae | 70189 | Fungi | Fungi | 736 | 0 | NTclustered | gi|311235549|ref|NG_027564.1| | 70189 | g55132 | i0 | 93.878 | 100.167346938776 | 490 | 27 | 100 | 2 | 1 | 490 | 2093 | 1607 | Olpidium brassicae DUKE DUH0009361 28S rRNA gene, partial sequence; from reference material | blastn | 49082 | 736 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium brassicae | |
| 26321009 | 26321009 | PRJEB14175_P_NODE_182735_length_242_cov_3.337017_g180468_i0 | PRJEB14175 | 182735 | 242 | 3.337017 | 8.07558114 | Olpidium bornovanus | 278681 | Fungi | Fungi | 144 | 4.62e-41 | NR | KAG5458586.1 | 278681 | g180468 | i0 | 88.8 | 1.98347107438017 | 80 | 9 | 99.2 | 0 | 240 | 1 | 115 | 194 | KAG5458586.1 MAG: DHS-like NAD/FAD-binding domain-containing protein [Olpidium bornovanus] | diamond | 480 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 33132108 | 33132108 | PRJEB14175_P_NODE_72231_length_433_cov_2.782258_g69972_i0 | PRJEB14175 | 72231 | 433 | 2.782258 | 12.04717714 | Olpidium bornovanus | 278681 | Fungi | Fungi | 100 | 2.84e-24 | NR | KAG5458609.1 | 278681 | g69972 | i0 | 74.1 | 0.561200923787529 | 81 | 21 | 56.1 | 0 | 376 | 134 | 1 | 81 | KAG5458609.1 MAG: tropomyosin, partial [Olpidium bornovanus] | diamond | 243 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus |
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);;