contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA315399" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 382424 | 382424 | PRJNA315399_P_NODE_302421_length_178_cov_12.099291_g301973_i0 | PRJNA315399 | 302421 | 178 | 12.099291 | 21.53673798 | Methanosarcina acetivorans | 2214 | Archaea | Archaea | 126 | 8.75e-25 | NTclustered | gi|19918815|gb|AE010299.1| | 188937 | g301973 | i0 | 89.109 | 2.98314606741573 | 101 | 11 | 96 | 0 | 2 | 102 | 1942577 | 1942677 | Methanosarcina acetivorans str. C2A, complete genome | blastn | 531 | 126 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina acetivorans | |
| 383034 | 383034 | PRJNA315399_P_NODE_400121_length_161_cov_8.000000_g399673_i0 | PRJNA315399 | 400121 | 161 | 8 | 12.88 | Methanothrix sp. | 90426 | Archaea | Archaea | 165 | 1.65e-36 | NTclustered | gi|2133328945|gb|CP086219.1| | 90426 | g399673 | i0 | 86.127 | 2.14906832298137 | 173 | 0 | 93 | 1 | 12 | 160 | 1654308 | 1654136 | MAG: Methanothrix sp. isolate MAG 281 chromosome | blastn | 346 | 165 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 1656394 | 1656394 | PRJNA315399_P_NODE_165942_length_187_cov_5.300000_g165494_i0 | PRJNA315399 | 165942 | 187 | 5.3 | 9.911 | Methanosarcina vacuolata | 2215 | Archaea | Archaea | 99 | 2.03e-16 | NTclustered | gi|805391208|gb|CP009520.1| | 1434123 | g165494 | i0 | 90.541 | 5.17112299465241 | 74 | 7 | 40 | 0 | 10 | 83 | 1458308 | 1458235 | Methanosarcina vacuolata Z-761, complete genome | blastn | 967 | 99 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina vacuolata | |
| 2341578 | 2341578 | PRJNA315399_P_NODE_509862_length_150_cov_4.079646_g509414_i0 | PRJNA315399 | 509862 | 150 | 4.079646 | 6.119469 | Methanothrix | 2222 | Archaea | Archaea | 228 | 1.8899999999999996e-55 | NTclustered | gi|2133328945|gb|CP086219.1| | 90426 | g509414 | i0 | 100 | 1.64 | 123 | 0 | 82 | 0 | 15 | 137 | 2110315 | 2110193 | MAG: Methanothrix sp. isolate MAG 281 chromosome | blastn | 246 | 228 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 2933752 | 2933752 | PRJNA315399_P_NODE_418383_length_159_cov_8.959016_g417935_i0 | PRJNA315399 | 418383 | 159 | 8.959016 | 14.24483544 | Haloferax volcanii | 2246 | Archaea | Archaea | 89.8 | 1e-13 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g417935 | i0 | 79.688 | 4.10062893081761 | 128 | 23 | 81 | 1 | 11 | 138 | 1246443 | 1246319 | Haloferax volcanii DS2, complete sequence | blastn | 652 | 89.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 4210671 | 4210671 | PRJNA315399_P_NODE_464284_length_154_cov_11.504274_g463836_i0 | PRJNA315399 | 464284 | 154 | 11.504274 | 17.71658196 | Halovivax gelatinilyticus | 2961597 | Archaea | Archaea | 58.4 | 2.72e-4 | NTclustered | gi|2273668750|gb|CP101322.1| | 2961597 | g463836 | i0 | 100 | 0.409090909090909 | 31 | 0 | 20 | 0 | 115 | 145 | 2309683 | 2309713 | Halovivax gelatinilyticus strain CGA30 chromosome, complete genome | blastn | 63 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halovivax | Halovivax gelatinilyticus | |
| 5488301 | 5488301 | PRJNA315399_S_NODE_16745_length_296_cov_9.262548_g16544_i0 | PRJNA315399 | 16745 | 296 | 9.262548 | 27.41714208 | Halosegnis marinus | 3034023 | Archaea | Archaea | 54.7 | 0.008 | NTclustered | gi|2463595543|gb|CP119802.1| | 3034023 | g16544 | i0 | 100 | 0.097972972972973 | 29 | 0 | 10 | 0 | 40 | 68 | 560174 | 560202 | Halosegnis marinus strain DT85 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halosegnis | Halosegnis marinus | |
| 6168440 | 6168440 | PRJNA315399_P_NODE_192085_length_185_cov_5.777027_g191637_i0 | PRJNA315399 | 192085 | 185 | 5.777027 | 10.68749995 | Methanosarcina | 2207 | Archaea | Archaea | 196 | 6.9e-46 | NTclustered | gi|1111741292|dbj|AP017646.1| | 2210 | g191637 | i0 | 87.059 | 3.67567567567568 | 170 | 9 | 92 | 1 | 8 | 177 | 1227729 | 1227885 | Methanosarcina thermophila DNA, complete genome, strain: MT-1 | blastn | 680 | 196 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina thermophila | |
| 6759555 | 6759555 | PRJNA315399_P_NODE_210286_length_184_cov_4.448980_g209838_i0 | PRJNA315399 | 210286 | 184 | 4.44898 | 8.1861232 | Halostagnicola larsenii | 353800 | Archaea | Archaea | 56.5 | 0.001 | NTclustered | gi|573479867|gb|CP007055.1| | 797299 | g209838 | i0 | 96.97 | 0.516304347826087 | 33 | 1 | 18 | 0 | 31 | 63 | 574956 | 574924 | Halostagnicola larsenii XH-48, complete genome | blastn | 95 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halostagnicola | Halostagnicola larsenii | |
| 6762569 | 6762569 | PRJNA315399_S_NODE_22566_length_270_cov_3.193133_g22365_i0 | PRJNA315399 | 22566 | 270 | 3.193133 | 8.6214591 | Natronosalvus caseinilyticus | 2953747 | Archaea | Archaea | 110 | 1.45e-19 | NTclustered | gi|2270598574|gb|CP100395.1| | 2953747 | g22365 | i0 | 77.838 | 0.685185185185185 | 185 | 36 | 68 | 5 | 88 | 270 | 10604 | 10423 | Natronosalvus caseinilyticus strain KZCA101 plasmid unnamed, complete sequence | blastn | 185 | 110 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronosalvus | Natronosalvus caseinilyticus | |
| 8035166 | 8035166 | PRJNA315399_P_NODE_219927_length_183_cov_10.328767_g219479_i0 | PRJNA315399 | 219927 | 183 | 10.328767 | 18.90164361 | Methanosarcina acetivorans | 2214 | Archaea | Archaea | 100 | 5.49e-17 | NTclustered | gi|19918815|gb|AE010299.1| | 188937 | g219479 | i0 | 89.744 | 1.30054644808743 | 78 | 8 | 43 | 0 | 7 | 84 | 1232060 | 1232137 | Methanosarcina acetivorans str. C2A, complete genome | blastn | 238 | 100 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina acetivorans | |
| 8718043 | 8718043 | PRJNA315399_P_NODE_115687_length_195_cov_10.860759_g115239_i0 | PRJNA315399 | 115687 | 195 | 10.860759 | 21.17848005 | Halococcus | 2249 | Archaea | Archaea | 143 | 9.72e-30 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g115239 | i0 | 81.461 | 1.99487179487179 | 178 | 30 | 90 | 3 | 8 | 183 | 1117230 | 1117406 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 389 | 143 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 10586732 | 10586732 | PRJNA315399_P_NODE_381589_length_163_cov_24.190476_g381141_i0 | PRJNA315399 | 381589 | 163 | 24.190476 | 39.43047588 | Methanosarcina flavescens | 1715806 | Archaea | Archaea | 78.7 | 2.24e-10 | NTclustered | gi|1491786200|gb|CP032683.1| | 1715806 | g381141 | i0 | 86.301 | 0.447852760736196 | 73 | 9 | 44 | 1 | 84 | 155 | 2457937 | 2458009 | Methanosarcina flavescens strain E03.2 chromosome, complete genome | blastn | 73 | 78.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina flavescens | |
| 11269107 | 11269107 | PRJNA315399_P_NODE_325009_length_176_cov_5.280576_g324561_i0 | PRJNA315399 | 325009 | 176 | 5.280576 | 9.29381376 | Methanosarcina | 2207 | Archaea | Archaea | 100 | 5.23e-17 | NTclustered | gi|805354519|gb|CP009508.1| | 1434118 | g324561 | i0 | 93.939 | 33.7897727272727 | 66 | 4 | 38 | 0 | 6 | 71 | 1108074 | 1108009 | Methanosarcina siciliae C2J, complete genome | blastn | 5947 | 100 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina siciliae | |
| 11861296 | 11861296 | PRJNA315399_P_NODE_338650_length_172_cov_13.622222_g338202_i0 | PRJNA315399 | 338650 | 172 | 13.622222 | 23.43022184 | Methanosarcina barkeri | 2208 | Archaea | Archaea | 222 | 1.04e-53 | NTclustered | gi|805384997|gb|CP009517.1| | 1434107 | g338202 | i0 | 93.878 | 5.12209302325581 | 147 | 9 | 85 | 0 | 14 | 160 | 1520965 | 1521111 | Methanosarcina barkeri 3, complete genome | blastn | 881 | 222 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 13819832 | 13819832 | PRJNA315399_P_NODE_84711_length_208_cov_9.052632_g84263_i0 | PRJNA315399 | 84711 | 208 | 9.052632 | 18.82947456 | Methanosarcina | 2207 | Archaea | Archaea | 132 | 2.27e-26 | NTclustered | gi|805394978|gb|CP009524.1| | 1434099 | g84263 | i0 | 78.142 | 3.75480769230769 | 183 | 38 | 88 | 2 | 15 | 197 | 1856635 | 1856815 | Methanosarcina sp. Kolksee, complete genome | blastn | 781 | 132 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. Kolksee | |
| 16959508 | 16959508 | PRJNA315399_P_NODE_250854_length_182_cov_1.641379_g250406_i0 | PRJNA315399 | 250854 | 182 | 1.641379 | 2.98730978 | Methanosarcina sp. MTP4 | 1434100 | Archaea | Archaea | 122 | 1.16e-23 | NTclustered | gi|805342629|gb|CP009505.1| | 1434100 | g250406 | i0 | 98.571 | 13.4615384615385 | 70 | 0 | 38 | 1 | 101 | 170 | 412987 | 412919 | Methanosarcina sp. MTP4, complete genome | blastn | 2450 | 122 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. MTP4 | |
| 18917513 | 18917513 | PRJNA315399_P_NODE_400735_length_161_cov_6.951613_g400287_i0 | PRJNA315399 | 400735 | 161 | 6.951613 | 11.19209693 | Methanosarcina | 2207 | Archaea | Archaea | 87.9 | 3.67e-13 | NTclustered | gi|827396966|gb|CP008746.1| | 796385 | g400287 | i0 | 87.838 | 2.75776397515528 | 74 | 9 | 46 | 0 | 13 | 86 | 1067825 | 1067752 | Methanosarcina barkeri CM1, complete genome | blastn | 444 | 87.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 19509375 | 19509375 | PRJNA315399_P_NODE_459076_length_155_cov_4.101695_g458628_i0 | PRJNA315399 | 459076 | 155 | 4.101695 | 6.35762725 | Haloarcula japonica | 29282 | Archaea | Archaea | 187 | 3.3499999999999995e-43 | NTclustered | gi|56403960|dbj|AB196145.1| | 29282 | g458628 | i0 | 90.21 | 38.6 | 143 | 14 | 92 | 0 | 1 | 143 | 1965 | 2107 | Haloarcula japonica ftsZ1 gene for cell division protein FtsZ1, complete cds | blastn | 5983 | 187 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula japonica | |
| 22742540 | 22742540 | PRJNA315399_P_NODE_234318_length_183_cov_2.219178_g233870_i0 | PRJNA315399 | 234318 | 183 | 2.219178 | 4.06109574 | Methanosarcina | 2207 | Archaea | Archaea | 99 | 1.97e-16 | NTclustered | gi|805394978|gb|CP009524.1| | 1434099 | g233870 | i0 | 93.939 | 3.68306010928962 | 66 | 2 | 36 | 2 | 11 | 76 | 870814 | 870877 | Methanosarcina sp. Kolksee, complete genome | blastn | 674 | 99 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. Kolksee | |
| 23335410 | 23335410 | PRJNA315399_P_NODE_464079_length_154_cov_13.641026_g463631_i0 | PRJNA315399 | 464079 | 154 | 13.641026 | 21.00718004 | Haloarcula marismortui | 2238 | Archaea | Archaea | 189 | 9.23e-44 | NTclustered | gi|1646147608|gb|CP039138.1| | 272569 | g463631 | i0 | 89.796 | 5.72727272727273 | 147 | 15 | 95 | 0 | 8 | 154 | 713555 | 713701 | Haloarcula marismortui ATCC 43049 chromosome, complete genome | blastn | 882 | 189 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula marismortui | |
| 23335537 | 23335537 | PRJNA315399_P_NODE_484739_length_152_cov_8.426087_g484291_i0 | PRJNA315399 | 484739 | 152 | 8.426087 | 12.80765224 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 99 | 1.57e-16 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g484291 | i0 | 92.647 | 4.15131578947368 | 68 | 5 | 45 | 0 | 4 | 71 | 1898751 | 1898818 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 631 | 99 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis |
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);;