contig_metadata
8 rows where bioproject = "PRJEB11748" and tax_phylum = "Candidatus Methanomethylicota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22971045 | 22971045 | PRJEB11748_P_NODE_385279_length_175_cov_11.464912_g383096_i0 | PRJEB11748 | 385279 | 175 | 11.464912 | 20.063596 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 103 | 5.46e-24 | NR | MEM2002060.1 | 3058293 | g383096 | i0 | 100 | 0.857142857142857 | 50 | 0 | 85.7 | 0 | 173 | 24 | 845 | 894 | MEM2002060.1 RNase H-like domain-containing protein [Candidatus Methanomethylicaceae archaeon] | diamond | 150 | 103 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 26779624 | 26779624 | PRJEB11748_P_NODE_106841_length_403_cov_8.418129_g104667_i0 | PRJEB11748 | 106841 | 403 | 8.418129 | 33.92505987 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 91.3 | 2.03e-21 | NR | MEM2002058.1 | 3058293 | g104667 | i0 | 100 | 0.327543424317618 | 44 | 0 | 32.8 | 0 | 287 | 156 | 1 | 44 | MEM2002058.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 132 | 91.3 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 27475143 | 27475143 | PRJEB11748_P_NODE_116123_length_385_cov_11.280864_g113949_i0 | PRJEB11748 | 116123 | 385 | 11.280864 | 43.4313264 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 233 | 4.95e-71 | NR | MEM2002059.1 | 3058293 | g113949 | i0 | 90.8 | 0.935064935064935 | 120 | 11 | 93.5 | 0 | 360 | 1 | 230 | 349 | MEM2002059.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 360 | 233 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 29054029 | 29054029 | PRJEB11748_P_NODE_154768_length_329_cov_8.134328_g152586_i0 | PRJEB11748 | 154768 | 329 | 8.134328 | 26.76193912 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 204 | 2.12e-58 | NR | MEM2002060.1 | 3058293 | g152586 | i0 | 97 | 0.90273556231003 | 99 | 3 | 90.3 | 0 | 16 | 312 | 722 | 820 | MEM2002060.1 RNase H-like domain-containing protein [Candidatus Methanomethylicaceae archaeon] | diamond | 297 | 204 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 29495998 | 29495998 | PRJEB11748_P_NODE_260430_length_240_cov_12.273743_g258247_i0 | PRJEB11748 | 260430 | 240 | 12.273743 | 29.4569832 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 137 | 2.61e-35 | NR | MEM2002060.1 | 3058293 | g258247 | i0 | 89 | 0.9125 | 73 | 7 | 90 | 1 | 237 | 22 | 7 | 79 | MEM2002060.1 RNase H-like domain-containing protein [Candidatus Methanomethylicaceae archaeon] | diamond | 219 | 137 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 30127264 | 30127264 | PRJEB11748_P_NODE_106812_length_403_cov_9.614035_g104638_i0 | PRJEB11748 | 106812 | 403 | 9.614035 | 38.74456105 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 213 | 4.48e-61 | NR | MEM2002060.1 | 3058293 | g104638 | i0 | 92.7 | 0.818858560794045 | 110 | 8 | 81.9 | 0 | 379 | 50 | 1035 | 1144 | MEM2002060.1 RNase H-like domain-containing protein [Candidatus Methanomethylicaceae archaeon] | diamond | 330 | 213 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 30885976 | 30885976 | PRJEB11748_P_NODE_313234_length_213_cov_4.796053_g311051_i0 | PRJEB11748 | 313234 | 213 | 4.796053 | 10.21559289 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 142 | 8.79e-38 | NR | MEM2002059.1 | 3058293 | g311051 | i0 | 98.4 | 0.901408450704225 | 64 | 1 | 90.1 | 0 | 212 | 21 | 340 | 403 | MEM2002059.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 192 | 142 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 32593870 | 32593870 | PRJEB11748_P_NODE_269880_length_235_cov_2.724138_g267697_i0 | PRJEB11748 | 269880 | 235 | 2.724138 | 6.4017243 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 146 | 1.3799999999999999e-38 | NR | MEM2002060.1 | 3058293 | g267697 | i0 | 93.3 | 0.957446808510638 | 75 | 5 | 95.7 | 0 | 226 | 2 | 165 | 239 | MEM2002060.1 RNase H-like domain-containing protein [Candidatus Methanomethylicaceae archaeon] | diamond | 225 | 146 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae 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);;