contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJEB11748" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14694 | 14694 | PRJEB11748_P_NODE_141861_length_346_cov_1.505263_g139682_i0 | PRJEB11748 | 141861 | 346 | 1.505263 | 5.20820998 | Halorubrum ruber | 2982524 | Archaea | Archaea | 54.7 | 0.009 | NTclustered | gi|2031421124|gb|CP073695.1| | 2982524 | g139682 | i0 | 100 | 0.0838150289017341 | 29 | 0 | 8 | 0 | 104 | 132 | 632879 | 632851 | Halorubrum ruber strain MBLA0099 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum ruber | |
| 1293759 | 1293759 | PRJEB11748_P_NODE_52502_length_590_cov_18.139887_g50393_i0 | PRJEB11748 | 52502 | 590 | 18.139887 | 107.0253333 | Methanothrix soehngenii | 2223 | Archaea | Archaea | 926 | 0 | NTclustered | gi|328927127|gb|CP002565.1| | 990316 | g50393 | i0 | 99.412 | 86.1372881355932 | 510 | 3 | 95 | 0 | 12 | 521 | 293673 | 293164 | Methanosaeta concilii GP-6, complete genome | blastn | 50821 | 926 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 3844829 | 3844829 | PRJEB11748_P_NODE_352304_length_196_cov_14.125926_g350121_i0 | PRJEB11748 | 352304 | 196 | 14.125926 | 27.68681496 | Methanothrix soehngenii | 2223 | Archaea | Archaea | 322 | 1.17e-83 | NTclustered | gi|328927127|gb|CP002565.1| | 990316 | g350121 | i0 | 100 | 2.46938775510204 | 174 | 0 | 89 | 0 | 23 | 196 | 1669426 | 1669599 | Methanosaeta concilii GP-6, complete genome | blastn | 484 | 322 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 6393577 | 6393577 | PRJEB11748_P_NODE_177366_length_304_cov_9.020576_g175183_i0 | PRJEB11748 | 177366 | 304 | 9.020576 | 27.42255104 | Haloarcula marina | 2961574 | Archaea | Archaea | 52.8 | 0.028 | NTclustered | gi|2269702775|gb|CP100404.1| | 2961574 | g175183 | i0 | 100 | 0.184210526315789 | 28 | 0 | 9 | 0 | 35 | 62 | 204110 | 204137 | Haloarcula marina strain DT1 chromosome, complete genome | blastn | 56 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula marina | |
| 6394419 | 6394419 | PRJEB11748_P_NODE_221426_length_266_cov_7.131707_g219243_i0 | PRJEB11748 | 221426 | 266 | 7.131707 | 18.97034062 | Methanothrix soehngenii | 2223 | Archaea | Archaea | 435 | 2.07e-117 | NTclustered | gi|328927127|gb|CP002565.1| | 990316 | g219243 | i0 | 98.77 | 0.917293233082707 | 244 | 3 | 92 | 0 | 1 | 244 | 1592802 | 1593045 | Methanosaeta concilii GP-6, complete genome | blastn | 244 | 435 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 6394582 | 6394582 | PRJEB11748_P_NODE_230486_length_260_cov_1.502513_g228303_i0 | PRJEB11748 | 230486 | 260 | 1.502513 | 3.9065338 | Halosimplex litoreum | 1198301 | Archaea | Archaea | 62.1 | 3.94e-5 | NTclustered | gi|1943741857|gb|CP065856.1| | 1198301 | g228303 | i0 | 85 | 0.230769230769231 | 60 | 9 | 23 | 0 | 23 | 82 | 1725756 | 1725815 | Halosimplex litoreum strain YGH94 chromosome, complete genome | blastn | 60 | 62.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex litoreum | |
| 7668672 | 7668672 | PRJEB11748_P_NODE_231187_length_259_cov_5.030303_g229004_i0 | PRJEB11748 | 231187 | 259 | 5.030303 | 13.02848477 | Haloglomus halophilum | 2962672 | Archaea | Archaea | 135 | 2.28e-27 | NTclustered | gi|2273560679|gb|CP101166.1| | 2962672 | g229004 | i0 | 81.437 | 36.4980694980695 | 167 | 29 | 64 | 2 | 52 | 217 | 3861290 | 3861455 | Haloglomus halophilum strain ZY41 chromosome, complete genome | blastn | 9453 | 135 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Haloglomus | Haloglomus halophilum | |
| 8942773 | 8942773 | PRJEB11748_P_NODE_196948_length_286_cov_4.808889_g194765_i0 | PRJEB11748 | 196948 | 286 | 4.808889 | 13.75342254 | Methanoregula boonei | 358766 | Archaea | Archaea | 143 | 1.52e-29 | NTclustered | gi|153998101|gb|CP000780.1| | 456442 | g194765 | i0 | 78.761 | 0.79020979020979 | 226 | 39 | 77 | 9 | 10 | 230 | 1234826 | 1234605 | Methanoregula boonei 6A8 chromosome, complete genome | blastn | 226 | 143 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula boonei | |
| 11497028 | 11497028 | PRJEB11748_P_NODE_378510_length_180_cov_12.739496_g376327_i0 | PRJEB11748 | 378510 | 180 | 12.739496 | 22.9310928 | Halosimplex rarum | 3396619 | Archaea | Archaea | 106 | 1.16e-18 | NTclustered | gi|2908454640|gb|CP180412.1| | 3396619 | g376327 | i0 | 83.333 | 10.7055555555556 | 114 | 19 | 63 | 0 | 21 | 134 | 1073703 | 1073816 | Halosimplex sp. TS25 chromosome, complete genome | blastn | 1927 | 106 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex rarum | |
| 12770384 | 12770384 | PRJEB11748_P_NODE_251231_length_246_cov_2.529730_g249048_i0 | PRJEB11748 | 251231 | 246 | 2.52973 | 6.2231358 | Halorussus vallis | 2953749 | Archaea | Archaea | 62.1 | 3.69e-5 | NTclustered | gi|2263966384|gb|CP100000.1| | 2953749 | g249048 | i0 | 97.222 | 0.146341463414634 | 36 | 1 | 15 | 0 | 203 | 238 | 3454872 | 3454837 | Halorussus vallis strain XZYJT10 chromosome, complete genome | blastn | 36 | 62.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus vallis | |
| 13737345 | 13737345 | PRJEB11748_P_NODE_253811_length_244_cov_8.224044_g251628_i0 | PRJEB11748 | 253811 | 244 | 8.224044 | 20.06666736 | Methanothrix | 2222 | Archaea | Archaea | 405 | 1.47e-108 | NTclustered | gi|2133328945|gb|CP086219.1| | 90426 | g251628 | i0 | 99.111 | 1.95901639344262 | 225 | 2 | 92 | 0 | 19 | 243 | 2168994 | 2169218 | MAG: Methanothrix sp. isolate MAG 281 chromosome | blastn | 478 | 405 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 16286438 | 16286438 | PRJEB11748_P_NODE_243773_length_251_cov_1.573684_g241590_i0 | PRJEB11748 | 243773 | 251 | 1.573684 | 3.94994684 | Methanothrix | 2222 | Archaea | Archaea | 396 | 9.119999999999996e-106 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g241590 | i0 | 99.091 | 126.852589641434 | 220 | 2 | 88 | 0 | 1 | 220 | 1464 | 1245 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 31840 | 396 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 20111034 | 20111034 | PRJEB11748_P_NODE_338136_length_203_cov_2.647887_g335953_i0 | PRJEB11748 | 338136 | 203 | 2.647887 | 5.37521061 | Methanothrix | 2222 | Archaea | Archaea | 320 | 4.39e-83 | NTclustered | gi|2133328945|gb|CP086219.1| | 90426 | g335953 | i0 | 97.849 | 1.83251231527094 | 186 | 3 | 91 | 1 | 1 | 185 | 1363121 | 1363306 | MAG: Methanothrix sp. isolate MAG 281 chromosome | blastn | 372 | 320 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 20419221 | 20419221 | PRJEB11748_P_NODE_345357_length_200_cov_7.625899_g343174_i0 | PRJEB11748 | 345357 | 200 | 7.625899 | 15.251798 | Salinilacihabitans rarus | 2961596 | Archaea | Archaea | 56.5 | 0.001 | NTclustered | gi|2273363716|gb|CP100762.1| | 2961596 | g343174 | i0 | 94.444 | 0.18 | 36 | 2 | 18 | 0 | 108 | 143 | 2281372 | 2281407 | Salinilacihabitans rarus strain AD-4 chromosome, complete genome | blastn | 36 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Salinilacihabitans | Salinilacihabitans rarus | |
| 21385357 | 21385357 | PRJEB11748_P_NODE_167337_length_315_cov_2.744094_g165154_i0 | PRJEB11748 | 167337 | 315 | 2.744094 | 8.6438961 | Methanothrix | 2222 | Archaea | Archaea | 527 | 4.02e-145 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g165154 | i0 | 98.339 | 19.3396825396825 | 301 | 4 | 96 | 1 | 15 | 315 | 1874 | 1575 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 6092 | 527 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 21695390 | 21695390 | PRJEB11748_P_NODE_353778_length_196_cov_2.251852_g351595_i0 | PRJEB11748 | 353778 | 196 | 2.251852 | 4.41362992 | Natronomonas pharaonis | 2257 | Archaea | Archaea | 52.8 | 0.017 | NTclustered | gi|76556520|emb|CR936257.1| | 348780 | g351595 | i0 | 100 | 0.142857142857143 | 28 | 0 | 14 | 0 | 69 | 96 | 1491482 | 1491455 | Natronomonas pharaonis DSM 2160 complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas pharaonis | |
| 23936391 | 23936391 | PRJEB11748_P_NODE_274959_length_232_cov_3.771930_g272776_i0 | PRJEB11748 | 274959 | 232 | 3.77193 | 8.7508776 | Methanothrix | 2222 | Archaea | Archaea | 303 | 5.19e-78 | NTclustered | gi|2133328945|gb|CP086219.1| | 90426 | g272776 | i0 | 91.403 | 1.9051724137931 | 221 | 19 | 95 | 0 | 1 | 221 | 796124 | 795904 | MAG: Methanothrix sp. isolate MAG 281 chromosome | blastn | 442 | 303 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 25210367 | 25210367 | PRJEB11748_P_NODE_312840_length_213_cov_10.085526_g310657_i0 | PRJEB11748 | 312840 | 213 | 10.085526 | 21.48217038 | Halanaeroarchaeum | 1656823 | Archaea | Archaea | 342 | 9.929999999999999e-90 | NTclustered | gi|822660691|gb|CP008874.1| | 1604004 | g310657 | i0 | 99.468 | 132.43661971831 | 188 | 1 | 88 | 0 | 1 | 188 | 1930577 | 1930390 | Halanaeroarchaeum sulfurireducens strain HSR2, complete genome | blastn | 28209 | 342 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sulfurireducens |
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);;