contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA493827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1747766 | 1747766 | PRJNA493827_P_NODE_37922_length_595_cov_2009.312261_g35753_i0 | PRJNA493827 | 37922 | 595 | 2009.312261 | 11955.40795295 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 1011 | 0 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g35753 | i0 | 97.623 | 278.505882352941 | 589 | 14 | 99 | 0 | 7 | 595 | 3117883 | 3117295 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 165711 | 1011 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 2381047 | 2381047 | PRJNA493827_P_NODE_228582_length_242_cov_0.911243_g226384_i0 | PRJNA493827 | 228582 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 448 | 2.3799999999999995e-121 | NTclustered | gi|216917|dbj|D12983.1|PYWPOL | 2261 | g226384 | i0 | 100 | 6 | 242 | 0 | 100 | 0 | 1 | 242 | 343 | 584 | Pyrococcus furiosus pol gene for DNA polymerase, complete cds | blastn | 1452 | 448 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus furiosus | ||
| 3023221 | 3023221 | PRJNA493827_P_NODE_234663_length_241_cov_0.916667_g232465_i0 | PRJNA493827 | 234663 | 241 | 0.916667 | 2.20916747 | Halobacterium noricense | 223182 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|2168244610|gb|CP089468.1| | 223182 | g232465 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 22 | 49 | 919412 | 919385 | Halobacterium noricense strain JCM 15102 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium noricense | |
| 6850921 | 6850921 | PRJNA493827_P_NODE_55426_length_475_cov_3.696517_g53234_i0 | PRJNA493827 | 55426 | 475 | 3.696517 | 17.55845575 | Methanobrevibacter olleyae | 294671 | Archaea | Archaea | 54.7 | 0.013 | NTclustered | gi|998157363|gb|CP014265.1| | 294671 | g53234 | i0 | 90.476 | 0.0884210526315789 | 42 | 2 | 8 | 2 | 349 | 388 | 701659 | 701618 | Methanobrevibacter olleyae strain YLM1 chromosome, complete genome | blastn | 42 | 54.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter olleyae | |
| 10033321 | 10033321 | PRJNA493827_P_NODE_142008_length_287_cov_1.079439_g139810_i0 | PRJNA493827 | 142008 | 287 | 1.079439 | 3.09798993 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 514 | 2.82e-141 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g139810 | i0 | 98.955 | 22.5087108013937 | 287 | 3 | 100 | 0 | 1 | 287 | 848628 | 848342 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 6460 | 514 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 13225877 | 13225877 | PRJNA493827_P_NODE_219451_length_244_cov_0.900585_g217253_i0 | PRJNA493827 | 219451 | 244 | 0.900585 | 2.1974274 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 318 | 1.9699999999999998e-82 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g217253 | i0 | 90.164 | 49.7745901639344 | 244 | 24 | 100 | 0 | 1 | 244 | 3096585 | 3096342 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 12145 | 318 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 15133379 | 15133379 | PRJNA493827_P_NODE_203472_length_247_cov_0.885057_g201274_i0 | PRJNA493827 | 203472 | 247 | 0.885057 | 2.18609079 | Haloterrigena | 121871 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|284012950|gb|CP001860.1| | 543526 | g201274 | i0 | 100 | 0.226720647773279 | 28 | 0 | 11 | 0 | 12 | 39 | 3071345 | 3071318 | Haloterrigena turkmenica DSM 5511, complete genome | blastn | 56 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Haloterrigena | Haloterrigena turkmenica | |
| 15773903 | 15773903 | PRJNA493827_P_NODE_183333_length_251_cov_1.730337_g181135_i0 | PRJNA493827 | 183333 | 251 | 1.730337 | 4.34314587 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 111 | 3.7e-20 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g181135 | i0 | 91.358 | 0.322709163346614 | 81 | 7 | 32 | 0 | 1 | 81 | 3092663 | 3092743 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 81 | 111 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 17682996 | 17682996 | PRJNA493827_P_NODE_189614_length_250_cov_0.870056_g187416_i0 | PRJNA493827 | 189614 | 250 | 0.870056 | 2.17514 | Halorubrum | 56688 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|1041620700|dbj|AP017569.1| | 29284 | g187416 | i0 | 94.118 | 0.272 | 34 | 2 | 14 | 0 | 136 | 169 | 1743150 | 1743183 | Halorubrum trapanicum DNA, complete genome, strain: CBA1232 | blastn | 68 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum trapanicum | |
| 20231137 | 20231137 | PRJNA493827_P_NODE_124396_length_306_cov_2.484979_g122198_i0 | PRJNA493827 | 124396 | 306 | 2.484979 | 7.60403574 | Pyrococcus | 2260 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|18980902|gb|AE009950.1| | 186497 | g122198 | i0 | 90.698 | 0.401960784313726 | 43 | 2 | 14 | 2 | 149 | 191 | 1558384 | 1558344 | Pyrococcus furiosus DSM 3638, complete genome | blastn | 123 | 56.5 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus furiosus | ||
| 20231783 | 20231783 | PRJNA493827_P_NODE_212596_length_245_cov_0.895349_g210398_i0 | PRJNA493827 | 212596 | 245 | 0.895349 | 2.19360505 | Halogeometricum | 60846 | Archaea | Archaea | 80.5 | 1.01e-10 | NTclustered | gi|1810666233|gb|CP048739.1| | 60847 | g210398 | i0 | 89.062 | 1.7469387755102 | 64 | 7 | 26 | 0 | 27 | 90 | 3768555 | 3768492 | Halogeometricum borinquense strain wsp4 chromosome, complete genome | blastn | 428 | 80.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halogeometricum | Halogeometricum borinquense | |
| 20875808 | 20875808 | PRJNA493827_P_NODE_84697_length_373_cov_3.283333_g82499_i0 | PRJNA493827 | 84697 | 373 | 3.283333 | 12.24683209 | uncultured archaeon | 115547 | Archaea | Archaea | 52.8 | 0.035 | NTclustered | gi|1148938192|gb|KY476683.1| | 115547 | g82499 | i0 | 100 | 0.150134048257373 | 28 | 0 | 8 | 0 | 330 | 357 | 10671 | 10698 | Uncultured archaeon clone rifcsphigho2_01_scaffold_8552_curated genomic sequence | blastn | 56 | 52.8 | 1 | Archaea | uncultured archaeon | ||||||||
| 23425321 | 23425321 | PRJNA493827_P_NODE_41179_length_567_cov_1.427126_g38996_i0 | PRJNA493827 | 41179 | 567 | 1.427126 | 8.09180442 | uncultured archaeon | 115547 | Archaea | Archaea | 56.5 | 0.004 | NTclustered | gi|765560206|gb|KP308707.1| | 115547 | g38996 | i0 | 94.595 | 0.178130511463845 | 37 | 0 | 7 | 2 | 262 | 298 | 10611 | 10645 | Uncultured archaeon clone gwa2_scaffold_17898 genomic sequence | blastn | 101 | 56.5 | 1 | Archaea | uncultured archaeon | ||||||||
| 23425563 | 23425563 | PRJNA493827_P_NODE_50819_length_500_cov_1.086651_g48629_i0 | PRJNA493827 | 50819 | 500 | 1.086651 | 5.433255 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 645 | 1.7599999999999993e-180 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g48629 | i0 | 94.313 | 76.464 | 422 | 23 | 84 | 1 | 1 | 422 | 3123813 | 3124233 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 38232 | 645 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 24697072 | 24697072 | PRJNA493827_P_NODE_172440_length_260_cov_1.700535_g170242_i0 | PRJNA493827 | 172440 | 260 | 1.700535 | 4.421391 | Halorubrum ezzemoulense | 337243 | Archaea | Archaea | 76.8 | 1.41e-9 | NTclustered | gi|1565814486|gb|CP034940.1| | 337243 | g170242 | i0 | 84.706 | 22.1115384615385 | 85 | 4 | 33 | 7 | 122 | 206 | 595253 | 595178 | Halorubrum ezzemoulense strain Fb21 chromosome, complete genome | blastn | 5749 | 76.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum ezzemoulense | |
| 24699484 | 24699484 | PRJNA493827_P_NODE_63200_length_440_cov_28.869210_g61003_i0 | PRJNA493827 | 63200 | 440 | 28.86921 | 127.024524 | Nitrosopumilus oxyclinae | 1959104 | Archaea | Archaea | 54.7 | 0.012 | NTclustered | gi|1869222960|gb|CP026994.1| | 1959104 | g61003 | i0 | 96.97 | 0.075 | 33 | 0 | 8 | 1 | 69 | 101 | 1404635 | 1404666 | Nitrosopumilus oxyclinae strain HCE1 chromosome, complete genome | blastn | 33 | 54.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus oxyclinae | ||
| 24699909 | 24699909 | PRJNA493827_P_NODE_80120_length_385_cov_0.987179_g77922_i0 | PRJNA493827 | 80120 | 385 | 0.987179 | 3.80063915 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 52.8 | 0.037 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g77922 | i0 | 100 | 0.0727272727272727 | 28 | 0 | 7 | 0 | 183 | 210 | 496501 | 496528 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii |
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);;