contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1174207" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 315552 | 315552 | PRJNA1174207_P_NODE_21481_length_308_cov_1.510638_g20952_i0 | PRJNA1174207 | 21481 | 308 | 1.510638 | 4.65276504 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 566 | 8.299999999999999e-157 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g20952 | i0 | 100 | 18.9058441558442 | 306 | 0 | 99 | 0 | 3 | 308 | 739198 | 739503 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 5823 | 566 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 2866770 | 2866770 | PRJNA1174207_P_NODE_5203_length_744_cov_2.572280_g4705_i0 | PRJNA1174207 | 5203 | 744 | 2.57228 | 19.1377632 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 1062 | 0 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g4705 | i0 | 98.988 | 70.0201612903226 | 593 | 6 | 99 | 0 | 2 | 594 | 739205 | 738613 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 52095 | 1062 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 6143506 | 6143506 | PRJNA1174207_P_NODE_30045_length_264_cov_2.267016_g29516_i0 | PRJNA1174207 | 30045 | 264 | 2.267016 | 5.98492224 | Candidatus Nitrosotenuis | 1825023 | Archaea | Archaea | 486 | 5.579999999999999e-133 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g29516 | i0 | 100 | 102.280303030303 | 263 | 0 | 99 | 0 | 2 | 264 | 741303 | 741041 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 27002 | 486 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 6693914 | 6693914 | PRJNA1174207_P_NODE_8246_length_549_cov_4.002101_g7722_i0 | PRJNA1174207 | 8246 | 549 | 4.002101 | 21.97153449 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 1009 | 0 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g7722 | i0 | 99.818 | 97.2823315118397 | 549 | 1 | 100 | 0 | 1 | 549 | 740752 | 740204 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 53408 | 1009 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 9243523 | 9243523 | PRJNA1174207_P_NODE_27408_length_275_cov_2.103960_g26879_i0 | PRJNA1174207 | 27408 | 275 | 2.10396 | 5.78589 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 359 | 1.33e-94 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g26879 | i0 | 90.441 | 1.99272727272727 | 272 | 26 | 99 | 0 | 3 | 274 | 1495875 | 1495604 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 548 | 359 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 16343068 | 16343068 | PRJNA1174207_P_NODE_22813_length_297_cov_4.169643_g22284_i0 | PRJNA1174207 | 22813 | 297 | 4.169643 | 12.38383971 | Methanosarcina | 2207 | Archaea | Archaea | 549 | 8.029999999999997e-152 | NTclustered | gi|827396966|gb|CP008746.1| | 796385 | g22284 | i0 | 100 | 40.2592592592593 | 297 | 0 | 100 | 0 | 1 | 297 | 4158835 | 4158539 | Methanosarcina barkeri CM1, complete genome | blastn | 11957 | 549 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 20167049 | 20167049 | PRJNA1174207_P_NODE_38656_length_244_cov_2.690058_g38127_i0 | PRJNA1174207 | 38656 | 244 | 2.690058 | 6.56374152 | root | 1 | Root_unresolved | Root_unresolved | 446 | 8.639999999999999e-121 | NTclustered | gi|325984387|gb|JF262284.1| | 29281 | g38127 | i0 | 99.59 | 100 | 244 | 1 | 100 | 0 | 1 | 244 | 571 | 814 | Uncultured crenarchaeote clone YLA147 16S ribosomal RNA gene, partial sequence | blastn | 24400 | 446 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 22717677 | 22717677 | PRJNA1174207_P_NODE_42138_length_237_cov_2.487805_g41609_i0 | PRJNA1174207 | 42138 | 237 | 2.487805 | 5.89609785 | Candidatus Nitrosotenuis | 1825023 | Archaea | Archaea | 438 | 1.4e-118 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g41609 | i0 | 100 | 98.2995780590717 | 237 | 0 | 100 | 0 | 1 | 237 | 738442 | 738206 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 23297 | 438 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae |
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);;