contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA743294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1198277 | 1198277 | PRJNA743294_P_NODE_13461_length_435_cov_4.477901_g13005_i0 | PRJNA743294 | 13461 | 435 | 4.477901 | 19.47886935 | Methanosarcina | 2207 | Archaea | Archaea | 732 | 0 | NTclustered | gi|2047643091|dbj|AP019780.1| | 2209 | g13005 | i0 | 97.011 | 223.76091954023 | 435 | 13 | 100 | 0 | 1 | 435 | 2736599 | 2737033 | Methanosarcina mazei TMA DNA, complete genome | blastn | 97336 | 732 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina mazei | |
| 1198313 | 1198313 | PRJNA743294_P_NODE_33481_length_290_cov_1.142857_g33025_i0 | PRJNA743294 | 33481 | 290 | 1.142857 | 3.3142853 | Methanosarcina | 2207 | Archaea | Archaea | 52.8 | 0.027 | NTclustered | gi|805394978|gb|CP009524.1| | 1434099 | g33025 | i0 | 91.892 | 0.255172413793103 | 37 | 3 | 13 | 0 | 104 | 140 | 3968026 | 3967990 | Methanosarcina sp. Kolksee, complete genome | blastn | 74 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. Kolksee | |
| 8851317 | 8851317 | PRJNA743294_P_NODE_18447_length_376_cov_3.029703_g17991_i0 | PRJNA743294 | 18447 | 376 | 3.029703 | 11.39168328 | Methanosarcina | 2207 | Archaea | Archaea | 628 | 1.2999999999999994e-175 | NTclustered | gi|805339246|gb|CP009504.1| | 1434102 | g17991 | i0 | 97.059 | 228.186170212766 | 374 | 10 | 99 | 1 | 3 | 376 | 43940 | 43568 | Methanosarcina sp. WH1, complete genome | blastn | 85798 | 628 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. WH1 | |
| 10126985 | 10126985 | PRJNA743294_P_NODE_13788_length_430_cov_3.546218_g13332_i0 | PRJNA743294 | 13788 | 430 | 3.546218 | 15.2487374 | Methanosarcina | 2207 | Archaea | Archaea | 580 | 4.2799999999999996e-161 | NTclustered | gi|1491786200|gb|CP032683.1| | 1715806 | g13332 | i0 | 96.839 | 185 | 348 | 10 | 100 | 1 | 83 | 430 | 464014 | 463668 | Methanosarcina flavescens strain E03.2 chromosome, complete genome | blastn | 79550 | 580 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina flavescens | |
| 12677926 | 12677926 | PRJNA743294_P_NODE_32970_length_291_cov_3.330275_g32514_i0 | PRJNA743294 | 32970 | 291 | 3.330275 | 9.69110025 | Methanosarcina | 2207 | Archaea | Archaea | 499 | 8.01e-137 | NTclustered | gi|805384997|gb|CP009517.1| | 1434107 | g32514 | i0 | 97.595 | 213.838487972509 | 291 | 7 | 100 | 0 | 1 | 291 | 56203 | 56493 | Methanosarcina barkeri 3, complete genome | blastn | 62227 | 499 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 13952262 | 13952262 | PRJNA743294_P_NODE_28611_length_310_cov_2.341772_g28155_i0 | PRJNA743294 | 28611 | 310 | 2.341772 | 7.2594932 | root | 1 | Root_unresolved | Root_unresolved | 573 | 4.999999999999998e-159 | NTclustered | gi|1808683266|gb|MT052672.1| | 2213 | g28155 | i0 | 100 | 100 | 310 | 0 | 100 | 0 | 1 | 310 | 344 | 653 | Methanosarcina sp. strain WLC-01 16S ribosomal RNA gene, partial sequence | blastn | 31000 | 573 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 14750987 | 14750987 | PRJNA743294_P_NODE_37752_length_275_cov_2.970297_g37296_i0 | PRJNA743294 | 37752 | 275 | 2.970297 | 8.16831675 | Methanosarcina sp. MTP4 | 1434100 | Archaea | Archaea | 243 | 1.4000000000000001e-59 | NTclustered | gi|805342629|gb|CP009505.1| | 1434100 | g37296 | i0 | 82.847 | 51.1018181818182 | 274 | 43 | 99 | 4 | 2 | 273 | 3650033 | 3650304 | Methanosarcina sp. MTP4, complete genome | blastn | 14053 | 243 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. MTP4 | |
| 19849140 | 19849140 | PRJNA743294_P_NODE_44676_length_256_cov_2.934426_g44220_i0 | PRJNA743294 | 44676 | 256 | 2.934426 | 7.51213056 | Methanosarcina siciliae | 38027 | Archaea | Archaea | 159 | 1.33e-34 | NTclustered | gi|805346097|gb|CP009506.1| | 1434120 | g44220 | i0 | 79.008 | 2.609375 | 262 | 34 | 100 | 11 | 1 | 256 | 458725 | 458971 | Methanosarcina siciliae T4/M, complete genome | blastn | 668 | 159 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina siciliae | |
| 21600551 | 21600551 | PRJNA743294_P_NODE_59817_length_223_cov_4.313333_g59361_i0 | PRJNA743294 | 59817 | 223 | 4.313333 | 9.61873259 | root | 1 | Root_unresolved | Root_unresolved | 399 | 6.139999999999999e-107 | NTclustered | gi|313766567|gb|HQ591417.1| | 2208 | g59361 | i0 | 99.099 | 113.511210762332 | 222 | 2 | 99 | 0 | 2 | 223 | 1105 | 884 | Methanosarcina barkeri strain TR-Z13 16S ribosomal RNA gene, partial sequence | blastn | 25313 | 399 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri |
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);;