contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax_clade = "Stenosarchaea group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 794316 | 794316 | PRJNA799842_P_NODE_187881_length_241_cov_0.916667_g186308_i0 | PRJNA799842 | 187881 | 241 | 0.916667 | 2.20916747 | Methanothrix sp. | 90426 | Archaea | Archaea | 278 | 3.29e-70 | NTclustered | gi|2626216449|emb|OY821645.1| | 90426 | g186308 | i0 | 87.764 | 4.64730290456432 | 237 | 29 | 98 | 0 | 1 | 237 | 1536713 | 1536949 | MAG: Methanothrix sp. isolate d1628e35-7b52-4540-a147-c2ca1342adce genome assembly, chromosome: 1 | blastn | 1120 | 278 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 2071595 | 2071595 | PRJNA799842_P_NODE_85622_length_312_cov_2.255230_g84049_i0 | PRJNA799842 | 85622 | 312 | 2.25523 | 7.0363176 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 577 | 3.89e-160 | NTclustered | gi|254971282|ref|NR_028200.1| | 224402 | g84049 | i0 | 100 | 97.6282051282051 | 312 | 0 | 100 | 0 | 1 | 312 | 1442 | 1131 | Halococcus qingdaonensis strain CM5 16S ribosomal RNA, complete sequence | blastn | 30460 | 577 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 5046840 | 5046840 | PRJNA799842_P_NODE_130984_length_255_cov_1.258242_g129411_i0 | PRJNA799842 | 130984 | 255 | 1.258242 | 3.2085171 | Halobacteriales | 2235 | Archaea | Archaea | 472 | 1.5e-128 | NTclustered | gi|1675273172|gb|MN000365.1| | 29284 | g129411 | i0 | 100 | 100 | 255 | 0 | 100 | 0 | 1 | 255 | 141 | 395 | Halorubrum trapanicum strain ISD451 16S ribosomal RNA gene, partial sequence | blastn | 25500 | 472 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum trapanicum | |
| 9722531 | 9722531 | PRJNA799842_P_NODE_21108_length_654_cov_1.521515_g19598_i0 | PRJNA799842 | 21108 | 654 | 1.521515 | 9.9507081 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 1192 | 0 | NTclustered | gi|2221493270|gb|CP095009.1| | 179637 | g19598 | i0 | 99.541 | 147.807339449541 | 654 | 3 | 100 | 0 | 1 | 654 | 172534 | 171881 | Halococcus dombrowskii strain H4 plasmid unnamed4, complete sequence | blastn | 96666 | 1192 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 12699344 | 12699344 | PRJNA799842_P_NODE_92390_length_302_cov_1.008734_g90817_i0 | PRJNA799842 | 92390 | 302 | 1.008734 | 3.04637668 | Natronomonadaceae | 3402413 | Archaea | Archaea | 531 | 2.9599999999999993e-146 | NTclustered | gi|339777447|gb|HQ738834.1| | 1053638 | g90817 | i0 | 98.344 | 99.9569536423841 | 302 | 5 | 100 | 0 | 1 | 302 | 1298 | 997 | Halomarina sp. TRM46053 16S ribosomal RNA gene, partial sequence | blastn | 30187 | 536 | 0.990671641791045 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina sp. TRM46053 | |
| 15247876 | 15247876 | PRJNA799842_P_NODE_67572_length_347_cov_1.562044_g65999_i0 | PRJNA799842 | 67572 | 347 | 1.562044 | 5.42029268 | Halobacteriales | 2235 | Archaea | Archaea | 636 | 7.13e-178 | NTclustered | gi|407907317|gb|JX481744.1| | 2250 | g65999 | i0 | 99.712 | 99.9423631123919 | 347 | 1 | 100 | 0 | 1 | 347 | 505 | 851 | Halococcus morrhuae strain 123 16S ribosomal RNA gene, partial sequence | blastn | 34680 | 636 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus morrhuae | |
| 16096292 | 16096292 | PRJNA799842_P_NODE_158953_length_247_cov_0.885057_g157380_i0 | PRJNA799842 | 158953 | 247 | 0.885057 | 2.18609079 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 418 | 1.9099999999999998e-112 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g157380 | i0 | 97.166 | 11.82995951417 | 247 | 7 | 100 | 0 | 1 | 247 | 445661 | 445907 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 2922 | 418 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 16097297 | 16097297 | PRJNA799842_P_NODE_37453_length_468_cov_1.475949_g35882_i0 | PRJNA799842 | 37453 | 468 | 1.475949 | 6.90744132 | Halocatena marina | 2934937 | Archaea | Archaea | 760 | 0 | NTclustered | gi|2324023557|gb|CP109979.1| | 2934937 | g35882 | i0 | 95.94 | 123.491452991453 | 468 | 19 | 100 | 0 | 1 | 468 | 881984 | 882451 | Halocatena marina strain QDMS1 chromosome, complete genome | blastn | 57794 | 760 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halocatena | Halocatena marina | |
| 20345323 | 20345323 | PRJNA799842_P_NODE_16516_length_756_cov_1.500732_g15087_i0 | PRJNA799842 | 16516 | 756 | 1.500732 | 11.34553392 | Halococcus | 2249 | Archaea | Archaea | 1367 | 0 | NTclustered | gi|288192|emb|X72588.1| | 2250 | g15087 | i0 | 99.339 | 169.800264550265 | 756 | 4 | 100 | 1 | 1 | 756 | 5024 | 4270 | H.morrhuae ribosomal RNA operon and flanking regions | blastn | 128369 | 1375 | 0.99418181818181794 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus morrhuae | |
| 23746041 | 23746041 | PRJNA799842_P_NODE_131859_length_254_cov_1.276243_g130286_i0 | PRJNA799842 | 131859 | 254 | 1.276243 | 3.24165722 | Methanolapillus millepedarum | 3028296 | Archaea | Archaea | 54.7 | 0.006 | NTclustered | gi|2591776341|gb|CP131060.1| | 3028296 | g130286 | i0 | 96.97 | 0.12992125984252 | 33 | 0 | 13 | 1 | 54 | 86 | 161923 | 161954 | Methanolapillus millepedarum strain Ac7 chromosome, complete genome | blastn | 33 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolapillus | Methanolapillus millepedarum |
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);;