contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1059246" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5279564 | 5279564 | PRJNA1059246_P_NODE_19925_length_510_cov_2.151030_g19307_i0 | PRJNA1059246 | 19925 | 510 | 2.15103 | 10.970253 | Haloterrigena salinisoli | 3132747 | Archaea | Archaea | 52.8 | 0.05 | NTclustered | gi|2706837818|gb|CP149787.1| | 3132747 | g19307 | i0 | 100 | 0.0549019607843137 | 28 | 0 | 5 | 0 | 405 | 432 | 831195 | 831168 | Haloterrigena salinisoli strain KLK7 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Haloterrigena | Haloterrigena salinisoli | |
| 10380111 | 10380111 | PRJNA1059246_P_NODE_18769_length_529_cov_2.109649_g18152_i0 | PRJNA1059246 | 18769 | 529 | 2.109649 | 11.16004321 | Haloferax gibbonsii | 35746 | Archaea | Archaea | 60.2 | 3.1e-4 | NTclustered | gi|909826707|gb|CP011949.1| | 35746 | g18152 | i0 | 100 | 0.741020793950851 | 32 | 0 | 6 | 0 | 307 | 338 | 282967 | 282998 | Haloferax gibbonsii strain ARA6 plasmid pHG2, complete sequence | blastn | 392 | 60.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax gibbonsii | |
| 10380183 | 10380183 | PRJNA1059246_P_NODE_23529_length_463_cov_1.730769_g22905_i0 | PRJNA1059246 | 23529 | 463 | 1.730769 | 8.01346047 | Methanolapillus ohkumae | 3028298 | Archaea | Archaea | 52.8 | 0.045 | NTclustered | gi|2591778106|gb|CP131061.1| | 3028298 | g22905 | i0 | 100 | 0.060475161987041 | 28 | 0 | 6 | 0 | 256 | 283 | 901472 | 901499 | Methanolapillus ohkumae strain Am2 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolapillus | Methanolapillus ohkumae | |
| 10380309 | 10380309 | PRJNA1059246_P_NODE_33489_length_375_cov_1.003311_g32863_i0 | PRJNA1059246 | 33489 | 375 | 1.003311 | 3.76241625 | Natronorubrum daqingense | 588898 | Archaea | Archaea | 56.5 | 0.003 | NTclustered | gi|1134979927|gb|CP019327.1| | 588898 | g32863 | i0 | 92.308 | 0.104 | 39 | 3 | 10 | 0 | 155 | 193 | 906620 | 906582 | Natronorubrum daqingense strain JX313, complete sequence | blastn | 39 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum daqingense | |
| 16313951 | 16313951 | PRJNA1059246_P_NODE_47833_length_299_cov_0.867257_g47207_i0 | PRJNA1059246 | 47833 | 299 | 0.867257 | 2.59309843 | Halobacterium | 2239 | Archaea | Archaea | 54.7 | 0.008 | NTclustered | gi|573484043|gb|CP007060.1| | 751944 | g47207 | i0 | 100 | 0.193979933110368 | 29 | 0 | 10 | 0 | 44 | 72 | 2343187 | 2343215 | Halobacterium sp. DL1, complete genome | blastn | 58 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. DL1 | |
| 16754330 | 16754330 | PRJNA1059246_P_NODE_64634_length_248_cov_1.394286_g64008_i0 | PRJNA1059246 | 64634 | 248 | 1.394286 | 3.45782928 | Haloquadratum walsbyi | 293091 | Archaea | Archaea | 60.2 | 1.34e-4 | NTclustered | gi|109624723|emb|AM180088.1| | 362976 | g64008 | i0 | 100 | 0.491935483870968 | 32 | 0 | 13 | 0 | 1 | 32 | 1275095 | 1275064 | Haloquadratum walsbyi DSM 16790 complete genome | blastn | 122 | 60.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloquadratum | Haloquadratum walsbyi | |
| 18029156 | 18029156 | PRJNA1059246_P_NODE_68615_length_245_cov_0.895349_g67989_i0 | PRJNA1059246 | 68615 | 245 | 0.895349 | 2.19360505 | Halorussus pelagicus | 2505977 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|1560271289|gb|CP035119.1| | 2505977 | g67989 | i0 | 96.774 | 0.126530612244898 | 31 | 1 | 13 | 0 | 75 | 105 | 2317467 | 2317497 | Halorussus pelagicus strain RC-68 chromosome, complete genome | blastn | 31 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus pelagicus | |
| 18029221 | 18029221 | PRJNA1059246_P_NODE_7975_length_863_cov_2.401266_g7465_i0 | PRJNA1059246 | 7975 | 863 | 2.401266 | 20.72292558 | Haloarcula ordinaria | 3033390 | Archaea | Archaea | 58.4 | 0.002 | NTclustered | gi|2463595535|gb|CP119789.1| | 3033390 | g7465 | i0 | 94.737 | 0.0440324449594438 | 38 | 0 | 4 | 2 | 566 | 602 | 1318926 | 1318962 | Haloarcula ordinaria strain ZS-22-S1 chromosome, complete genome | blastn | 38 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula ordinaria | |
| 19302746 | 19302746 | PRJNA1059246_P_NODE_35596_length_361_cov_1.756944_g34970_i0 | PRJNA1059246 | 35596 | 361 | 1.756944 | 6.34256784 | Haloarcula ordinaria | 3033390 | Archaea | Archaea | 54.7 | 0.01 | NTclustered | gi|2463595535|gb|CP119789.1| | 3033390 | g34970 | i0 | 100 | 0.0803324099722992 | 29 | 0 | 8 | 0 | 313 | 341 | 649164 | 649136 | Haloarcula ordinaria strain ZS-22-S1 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula ordinaria | |
| 23129165 | 23129165 | PRJNA1059246_P_NODE_22559_length_475_cov_1.067164_g21937_i0 | PRJNA1059246 | 22559 | 475 | 1.067164 | 5.069029 | Natrinema sp. J7-2 | 406552 | Archaea | Archaea | 60.2 | 2.76e-4 | NTclustered | gi|397680883|gb|CP003412.1| | 406552 | g21937 | i0 | 97.143 | 0.642105263157895 | 35 | 1 | 7 | 0 | 270 | 304 | 1516063 | 1516097 | Natrinema sp. J7-2, complete genome | blastn | 305 | 60.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema sp. J7-2 |
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);;