contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA1245487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2901979 | 2901979 | PRJNA1245487_P_NODE_21223_length_245_cov_0.906977_g20885_i0 | PRJNA1245487 | 21223 | 245 | 0.906977 | 2.22209365 | Haloferax volcanii | 2246 | Archaea | Archaea | 453 | 5.1900000000000006e-123 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g20885 | i0 | 100 | 32.0979591836735 | 245 | 0 | 100 | 0 | 1 | 245 | 2803051 | 2803295 | Haloferax volcanii DS2, complete sequence | blastn | 7864 | 453 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 4178337 | 4178337 | PRJNA1245487_P_NODE_18904_length_254_cov_1.657459_g18566_i0 | PRJNA1245487 | 18904 | 254 | 1.657459 | 4.20994586 | Haloferax volcanii | 2246 | Archaea | Archaea | 470 | 5.37e-128 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g18566 | i0 | 100 | 35.3503937007874 | 254 | 0 | 100 | 0 | 1 | 254 | 2251249 | 2250996 | Haloferax volcanii DS2, complete sequence | blastn | 8979 | 470 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 4879395 | 4879395 | PRJNA1245487_P_NODE_17164_length_269_cov_1.933673_g16826_i0 | PRJNA1245487 | 17164 | 269 | 1.933673 | 5.20158037 | Haloferax | 2251 | Archaea | Archaea | 497 | 2.63e-136 | NTclustered | gi|2459773771|gb|CP104741.1| | 2246 | g16826 | i0 | 100 | 5 | 269 | 0 | 100 | 0 | 1 | 269 | 2262589 | 2262857 | Haloferax volcanii strain SVX82 chromosome, complete genome | blastn | 1345 | 497 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 5454490 | 5454490 | PRJNA1245487_P_NODE_12265_length_332_cov_2.015444_g11927_i0 | PRJNA1245487 | 12265 | 332 | 2.015444 | 6.69127408 | Haloferax volcanii | 2246 | Archaea | Archaea | 614 | 3.1799999999999995e-171 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g11927 | i0 | 100 | 25.5843373493976 | 332 | 0 | 100 | 0 | 1 | 332 | 684936 | 684605 | Haloferax volcanii DS2, complete sequence | blastn | 8494 | 614 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 5454582 | 5454582 | PRJNA1245487_P_NODE_19425_length_252_cov_0.871508_g19087_i0 | PRJNA1245487 | 19425 | 252 | 0.871508 | 2.19620016 | Haloferax volcanii | 2246 | Archaea | Archaea | 466 | 6.89e-127 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g19087 | i0 | 100 | 106.146825396825 | 252 | 0 | 100 | 0 | 1 | 252 | 776964 | 776713 | Haloferax volcanii DS2, complete sequence | blastn | 26749 | 466 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 6154234 | 6154234 | PRJNA1245487_P_NODE_65_length_2629_cov_13.859155_g39_i0 | PRJNA1245487 | 65 | 2629 | 13.859155 | 364.35718495 | Haloferax | 2251 | Archaea | Archaea | 4848 | 0 | NTclustered | gi|470486003|ref|NR_076729.1| | 2246 | g39 | i0 | 99.962 | 181.346519589197 | 2629 | 0 | 99 | 1 | 2 | 2629 | 2652 | 24 | Haloferax volcanii strain DS2 23S ribosomal RNA gene, complete sequence | blastn | 476760 | 4848 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 8704128 | 8704128 | PRJNA1245487_P_NODE_15607_length_285_cov_2.533019_g15269_i0 | PRJNA1245487 | 15607 | 285 | 2.533019 | 7.21910415 | Haloferax | 2251 | Archaea | Archaea | 527 | 3.59e-145 | NTclustered | gi|1810670185|gb|CP048738.1| | 2246 | g15269 | i0 | 100 | 101.814035087719 | 285 | 0 | 100 | 0 | 1 | 285 | 390352 | 390068 | Haloferax volcanii strain wsp1 chromosome, complete genome | blastn | 29017 | 527 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 8704249 | 8704249 | PRJNA1245487_P_NODE_23427_length_206_cov_4.691729_g23089_i0 | PRJNA1245487 | 23427 | 206 | 4.691729 | 9.66496174 | Haloferax | 2251 | Archaea | Archaea | 381 | 2.0199999999999994e-101 | NTclustered | gi|149030|gb|M62816.1|HLFSLP | 2246 | g23089 | i0 | 100 | 5.29126213592233 | 206 | 0 | 100 | 0 | 1 | 206 | 1921 | 2126 | H.volcanii S-layer protein gene, complete cds | blastn | 1090 | 381 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 9279346 | 9279346 | PRJNA1245487_P_NODE_19588_length_251_cov_0.876404_g19250_i0 | PRJNA1245487 | 19588 | 251 | 0.876404 | 2.19977404 | Haloferax volcanii | 2246 | Archaea | Archaea | 464 | 2.47e-126 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g19250 | i0 | 100 | 90.605577689243 | 251 | 0 | 100 | 0 | 1 | 251 | 516536 | 516286 | Haloferax volcanii DS2, complete sequence | blastn | 22742 | 464 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 10555108 | 10555108 | PRJNA1245487_P_NODE_10229_length_372_cov_1.565217_g9891_i0 | PRJNA1245487 | 10229 | 372 | 1.565217 | 5.82260724 | Haloferax volcanii | 2246 | Archaea | Archaea | 688 | 0 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g9891 | i0 | 100 | 4.95430107526882 | 372 | 0 | 100 | 0 | 1 | 372 | 1924214 | 1923843 | Haloferax volcanii DS2, complete sequence | blastn | 1843 | 688 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 12529916 | 12529916 | PRJNA1245487_P_NODE_14330_length_300_cov_19.925110_g13992_i0 | PRJNA1245487 | 14330 | 300 | 19.92511 | 59.77533 | Haloferax | 2251 | Archaea | Archaea | 555 | 1.7399999999999995e-153 | NTclustered | gi|15277694|gb|AF395888.1| | 2246 | g13992 | i0 | 100 | 66.5766666666667 | 300 | 0 | 100 | 0 | 1 | 300 | 199 | 498 | Haloferax volcanii signal recognition particle 7S RNA gene sequence | blastn | 19973 | 555 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 13804653 | 13804653 | PRJNA1245487_P_NODE_13351_length_314_cov_40.265560_g13013_i0 | PRJNA1245487 | 13351 | 314 | 40.26556 | 126.4338584 | Haloferax | 2251 | Archaea | Archaea | 575 | 1.4099999999999994e-159 | NTclustered | gi|1810670185|gb|CP048738.1| | 2246 | g13013 | i0 | 99.682 | 178.468152866242 | 314 | 1 | 100 | 0 | 1 | 314 | 2384347 | 2384034 | Haloferax volcanii strain wsp1 chromosome, complete genome | blastn | 56039 | 580 | 0.991379310344828 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 13804866 | 13804866 | PRJNA1245487_P_NODE_3991_length_628_cov_49.425225_g3663_i0 | PRJNA1245487 | 3991 | 628 | 49.425225 | 310.390413 | Haloferax | 2251 | Archaea | Archaea | 1158 | 0 | NTclustered | gi|2460995542|gb|CP106966.1| | 2246 | g3663 | i0 | 100 | 99.6194267515924 | 627 | 0 | 99 | 0 | 1 | 627 | 1587961 | 1588587 | Haloferax volcanii strain BNX82 chromosome, complete genome | blastn | 62561 | 1158 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 14380214 | 14380214 | PRJNA1245487_P_NODE_16112_length_280_cov_1.342995_g15774_i0 | PRJNA1245487 | 16112 | 280 | 1.342995 | 3.760386 | Haloferax volcanii | 2246 | Archaea | Archaea | 518 | 2.12e-142 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g15774 | i0 | 100 | 40.2357142857143 | 280 | 0 | 100 | 0 | 1 | 280 | 1190999 | 1190720 | Haloferax volcanii DS2, complete sequence | blastn | 11266 | 518 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 15079105 | 15079105 | PRJNA1245487_P_NODE_6432_length_490_cov_2.244604_g6096_i0 | PRJNA1245487 | 6432 | 490 | 2.244604 | 10.9985596 | Haloferax | 2251 | Archaea | Archaea | 905 | 0 | NTclustered | gi|149030|gb|M62816.1|HLFSLP | 2246 | g6096 | i0 | 100 | 5.03061224489796 | 490 | 0 | 100 | 0 | 1 | 490 | 2568 | 2079 | H.volcanii S-layer protein gene, complete cds | blastn | 2465 | 905 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 15079180 | 15079180 | PRJNA1245487_P_NODE_9512_length_390_cov_1.899054_g9174_i0 | PRJNA1245487 | 9512 | 390 | 1.899054 | 7.4063106 | Haloferax | 2251 | Archaea | Archaea | 721 | 0 | NTclustered | gi|149030|gb|M62816.1|HLFSLP | 2246 | g9174 | i0 | 100 | 4.68974358974359 | 390 | 0 | 100 | 0 | 1 | 390 | 1526 | 1915 | H.volcanii S-layer protein gene, complete cds | blastn | 1829 | 721 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 16353716 | 16353716 | PRJNA1245487_P_NODE_15273_length_289_cov_1.606481_g14935_i0 | PRJNA1245487 | 15273 | 289 | 1.606481 | 4.64273009 | Haloferax | 2251 | Archaea | Archaea | 534 | 2.18e-147 | NTclustered | gi|149030|gb|M62816.1|HLFSLP | 2246 | g14935 | i0 | 100 | 4.98615916955017 | 289 | 0 | 100 | 0 | 1 | 289 | 732 | 444 | H.volcanii S-layer protein gene, complete cds | blastn | 1441 | 534 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 17629336 | 17629336 | PRJNA1245487_P_NODE_8314_length_423_cov_7.422857_g7976_i0 | PRJNA1245487 | 8314 | 423 | 7.422857 | 31.39868511 | Haloferax | 2251 | Archaea | Archaea | 749 | 0 | NTclustered | gi|2459773771|gb|CP104741.1| | 2246 | g7976 | i0 | 98.582 | 55.4089834515366 | 423 | 6 | 100 | 0 | 1 | 423 | 2632255 | 2632677 | Haloferax volcanii strain SVX82 chromosome, complete genome | blastn | 23438 | 749 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 18902827 | 18902827 | PRJNA1245487_P_NODE_1675_length_923_cov_44.589412_g1403_i0 | PRJNA1245487 | 1675 | 923 | 44.589412 | 411.56027276 | Haloferacaceae | 1644056 | Archaea | Archaea | 1705 | 0 | NTclustered | gi|174702|gb|K00421.1|HALRR16S | 2246 | g1403 | i0 | 100 | 103.861321776815 | 923 | 0 | 100 | 0 | 1 | 923 | 934 | 12 | Halobacterium volcanii 16S ribosomal RNA | blastn | 95864 | 1705 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 24577404 | 24577404 | PRJNA1245487_P_NODE_18920_length_254_cov_1.447514_g18582_i0 | PRJNA1245487 | 18920 | 254 | 1.447514 | 3.67668556 | Haloferax volcanii | 2246 | Archaea | Archaea | 462 | 8.989999999999999e-126 | NTclustered | gi|61815530|gb|AY738618.1| | 309800 | g18582 | i0 | 100 | 30.0433070866142 | 250 | 0 | 98 | 0 | 5 | 254 | 291 | 42 | Haloferax volcanii DS2 DnaK chaperone system gene cluster, complete sequence; and conserved hypothetical protein gene, complete cds | blastn | 7631 | 462 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii |
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);;