contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax_phylum = "Thermoproteota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1225937 | 1225937 | PRJNA814235_P_NODE_14601_length_498_cov_4.696312_g13314_i0 | PRJNA814235 | 14601 | 498 | 4.696312 | 23.38763376 | Thermoproteati | 1783275 | Archaea | Archaea | 870 | 0 | NTclustered | gi|1497995|gb|U62818.1|UAU62818 | 50856 | g13314 | i0 | 98.193 | 100.008032128514 | 498 | 9 | 100 | 0 | 1 | 498 | 191 | 688 | Unidentified archaeon SCA1173 16S small subunit ribosomal RNA gene, partial sequence | blastn | 49804 | 876 | 0.993150684931507 | Archaea | Thermoproteati | Thermoproteota | unidentified archaeon SCA1173 | ||||||
| 3779251 | 3779251 | PRJNA814235_P_NODE_66923_length_233_cov_1.464286_g65528_i0 | PRJNA814235 | 66923 | 233 | 1.464286 | 3.41178638 | root | 1 | Root_unresolved | Root_unresolved | 412 | 8.299999999999999e-111 | NTclustered | gi|42406209|gb|AY522900.1| | 29281 | g65528 | i0 | 98.707 | 102.562231759657 | 232 | 3 | 99 | 0 | 2 | 233 | 1221 | 990 | Uncultured crenarchaeote clone MAS3 16S ribosomal RNA gene, partial sequence | blastn | 23897 | 412 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 4643817 | 4643817 | PRJNA814235_P_NODE_114604_length_203_cov_1.951807_g113209_i0 | PRJNA814235 | 114604 | 203 | 1.951807 | 3.96216821 | Pyrobaculum neutrophilum | 70771 | Archaea | Archaea | 52.8 | 0.018 | NTclustered | gi|170933697|gb|CP001014.1| | 444157 | g113209 | i0 | 96.774 | 0.152709359605911 | 31 | 1 | 15 | 0 | 161 | 191 | 483618 | 483588 | Pyrobaculum neutrophilum V24Sta, complete genome | blastn | 31 | 52.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum neutrophilum | ||
| 9745059 | 9745059 | PRJNA814235_P_NODE_194948_length_151_cov_2.219298_g193553_i0 | PRJNA814235 | 194948 | 151 | 2.219298 | 3.35113998 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 263 | 5.23e-66 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g193553 | i0 | 98.013 | 46.8675496688742 | 151 | 3 | 100 | 0 | 1 | 151 | 7903 | 8053 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 7077 | 263 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 12707089 | 12707089 | PRJNA814235_P_NODE_77370_length_216_cov_2.480447_g75975_i0 | PRJNA814235 | 77370 | 216 | 2.480447 | 5.35776552 | Thermoproteati | 1783275 | Archaea | Archaea | 361 | 2.79e-95 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g75975 | i0 | 96.759 | 22.1898148148148 | 216 | 7 | 100 | 0 | 1 | 216 | 6809 | 6594 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 4793 | 361 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 16120920 | 16120920 | PRJNA814235_P_NODE_68313_length_230_cov_3.062176_g66918_i0 | PRJNA814235 | 68313 | 230 | 3.062176 | 7.0430048 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 359 | 1.0799999999999999e-94 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g66918 | i0 | 94.828 | 67.504347826087 | 232 | 9 | 99 | 2 | 2 | 230 | 6108 | 5877 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 15526 | 359 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 19078813 | 19078813 | PRJNA814235_P_NODE_54815_length_257_cov_2.690909_g53421_i0 | PRJNA814235 | 54815 | 257 | 2.690909 | 6.91563613 | Thermoproteati | 1783275 | Archaea | Archaea | 436 | 5.52e-118 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g53421 | i0 | 97.276 | 88.7587548638132 | 257 | 7 | 100 | 0 | 1 | 257 | 8109 | 8365 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 22811 | 440 | 0.990909090909091 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 20354044 | 20354044 | PRJNA814235_P_NODE_83216_length_208_cov_2.561404_g81821_i0 | PRJNA814235 | 83216 | 208 | 2.561404 | 5.32772032 | Thermoproteati | 1783275 | Archaea | Archaea | 385 | 1.58e-102 | NTclustered | gi|62901621|gb|AY940186.1| | 29281 | g81821 | i0 | 100 | 99.9663461538462 | 208 | 0 | 100 | 0 | 1 | 208 | 214 | 421 | Uncultured crenarchaeote clone BN1 16S ribosomal RNA gene, partial sequence | blastn | 20793 | 385 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote |
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);;