contig_metadata
9 rows where bioproject = "PRJNA217180" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26852724 | 26852724 | PRJNA217180_P_NODE_15021_length_162_cov_0.902655_g14921_i0 | PRJNA217180 | 15021 | 162 | 0.902655 | 1.4623011 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 68.9 | 6.95e-12 | NR | MBM3896806.1 | 2026795 | g14921 | i0 | 58.5 | 0.981481481481482 | 53 | 22 | 98.1 | 0 | 161 | 3 | 332 | 384 | MBM3896806.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 159 | 68.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 27344827 | 27344827 | PRJNA217180_P_NODE_15283_length_161_cov_0.910714_g15183_i0 | PRJNA217180 | 15283 | 161 | 0.910714 | 1.46624954 | Archaea | 2157 | Archaea | Archaea | 50.4 | 2.28e-5 | NR | HWY36640.1 | 2202732 | g15183 | i0 | 55.8 | 1.75155279503106 | 43 | 18 | 78.3 | 1 | 6 | 131 | 30 | 72 | HWY36640.1 hypothetical protein [Nitrosopumilaceae archaeon] | diamond | 282 | 50.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 27484783 | 27484783 | PRJNA217180_P_NODE_12943_length_166_cov_0.871795_g12843_i0 | PRJNA217180 | 12943 | 166 | 0.871795 | 1.4471797 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 67 | 3.49e-11 | NR | HJS83577.1 | 1971748 | g12843 | i0 | 49.1 | 0.957831325301205 | 53 | 27 | 95.8 | 0 | 164 | 6 | 403 | 455 | HJS83577.1 invasin domain 3-containing protein [Nitrososphaera sp.] | diamond | 159 | 67 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 27769181 | 27769181 | PRJNA217180_P_NODE_14304_length_163_cov_0.894737_g14204_i0 | PRJNA217180 | 14304 | 163 | 0.894737 | 1.45842131 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 47 | 3.34e-4 | NR | RDJ35336.1 | 2056631 | g14204 | i0 | 36.4 | 1.01226993865031 | 55 | 34 | 99.4 | 1 | 162 | 1 | 42 | 96 | RDJ35336.1 MAG: hypothetical protein DWQ19_11010 [Thermoproteota archaeon] | diamond | 165 | 47 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 29063584 | 29063584 | PRJNA217180_P_NODE_13388_length_165_cov_0.879310_g13288_i0 | PRJNA217180 | 13388 | 165 | 0.87931 | 1.4508615 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 47.8 | 2.11e-4 | NR | MCJ7638148.1 | 2169593 | g13288 | i0 | 57.1 | 1.45454545454545 | 35 | 15 | 63.6 | 0 | 3 | 107 | 177 | 211 | MCJ7638148.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 240 | 47.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 29333849 | 29333849 | PRJNA217180_P_NODE_15029_length_162_cov_0.902655_g14929_i0 | PRJNA217180 | 15029 | 162 | 0.902655 | 1.4623011 | Thermoproteati | 1783275 | Archaea | Archaea | 56.6 | 1.32e-7 | NR | WP_342788287.1 | 51678 | g14929 | i0 | 51 | 4.57407407407407 | 49 | 24 | 90.7 | 0 | 155 | 9 | 211 | 259 | WP_342788287.1 GDP-mannose dehydrogenase [Desulfurococcus sp.] | diamond | 741 | 57 | 0.992982456140351 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Desulfurococcus | Desulfurococcus sp. | ||
| 30453376 | 30453376 | PRJNA217180_P_NODE_13893_length_164_cov_0.886957_g13793_i0 | PRJNA217180 | 13893 | 164 | 0.886957 | 1.45460948 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 41.6 | 0.0161 | NR | MCL4436369.1 | 2026795 | g13793 | i0 | 46.3 | 2.83536585365854 | 41 | 21 | 73.2 | 1 | 35 | 154 | 1 | 41 | MCL4436369.1 nickel-responsive transcriptional regulator NikR [Nitrososphaerota archaeon] | diamond | 465 | 41.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 31685701 | 31685701 | PRJNA217180_P_NODE_9037_length_195_cov_1.109589_g8937_i0 | PRJNA217180 | 9037 | 195 | 1.109589 | 2.16369855 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 43.9 | 0.00149 | NR | HSE99736.1 | 2169593 | g8937 | i0 | 77.8 | 0.415384615384615 | 27 | 5 | 40 | 1 | 79 | 2 | 1 | 27 | HSE99736.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 81 | 43.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 32603211 | 32603211 | PRJNA217180_P_NODE_11760_length_172_cov_1.308943_g11660_i0 | PRJNA217180 | 11760 | 172 | 1.308943 | 2.25138196 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 49.7 | 2.04e-5 | NR | MDE1868209.1 | 2026795 | g11660 | i0 | 45.5 | 0.959302325581395 | 55 | 29 | 95.9 | 1 | 170 | 6 | 83 | 136 | MDE1868209.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 165 | 49.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon |
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);;