contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA1111077" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 214769 | 214769 | PRJNA1111077_P_NODE_29201_length_254_cov_1.651934_g28980_i0 | PRJNA1111077 | 29201 | 254 | 1.651934 | 4.19591236 | Haloferax volcanii | 2246 | Archaea | Archaea | 464 | 2.4999999999999994e-126 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g28980 | i0 | 100 | 8.88582677165354 | 251 | 0 | 99 | 0 | 1 | 251 | 2539149 | 2539399 | Haloferax volcanii DS2, complete sequence | blastn | 2257 | 464 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 1021048 | 1021048 | PRJNA1111077_P_NODE_28201_length_258_cov_1.643243_g27980_i0 | PRJNA1111077 | 28201 | 258 | 1.643243 | 4.23956694 | Haloferax | 2251 | Archaea | Archaea | 473 | 4.2299999999999996e-129 | NTclustered | gi|2459773771|gb|CP104741.1| | 2246 | g27980 | i0 | 100 | 8.1046511627907 | 256 | 0 | 99 | 0 | 3 | 258 | 2211043 | 2211298 | Haloferax volcanii strain SVX82 chromosome, complete genome | blastn | 2091 | 473 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 3571709 | 3571709 | PRJNA1111077_P_NODE_29803_length_252_cov_1.268156_g29582_i0 | PRJNA1111077 | 29803 | 252 | 1.268156 | 3.19575312 | Haloferax | 2251 | Archaea | Archaea | 462 | 8.91e-126 | NTclustered | gi|1810670185|gb|CP048738.1| | 2246 | g29582 | i0 | 100 | 106.428571428571 | 250 | 0 | 99 | 0 | 1 | 250 | 2140477 | 2140726 | Haloferax volcanii strain wsp1 chromosome, complete genome | blastn | 26820 | 462 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 4041623 | 4041623 | PRJNA1111077_P_NODE_29004_length_255_cov_1.379121_g28783_i0 | PRJNA1111077 | 29004 | 255 | 1.379121 | 3.51675855 | Haloferax volcanii | 2246 | Archaea | Archaea | 466 | 6.98e-127 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g28783 | i0 | 100 | 15.5372549019608 | 252 | 0 | 99 | 0 | 4 | 255 | 262164 | 261913 | Haloferax volcanii DS2, complete sequence | blastn | 3962 | 466 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 5318045 | 5318045 | PRJNA1111077_P_NODE_8385_length_404_cov_1.604230_g8164_i0 | PRJNA1111077 | 8385 | 404 | 1.60423 | 6.4810892 | Haloferax volcanii | 2246 | Archaea | Archaea | 741 | 0 | NTclustered | gi|291369412|gb|CP001955.1| | 309800 | g8164 | i0 | 100 | 0.992574257425743 | 401 | 0 | 99 | 0 | 1 | 401 | 131240 | 131640 | Haloferax volcanii DS2 plasmid pHV4, complete sequence | blastn | 401 | 741 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 6593081 | 6593081 | PRJNA1111077_P_NODE_36826_length_241_cov_0.916667_g36605_i0 | PRJNA1111077 | 36826 | 241 | 0.916667 | 2.20916747 | Haloferax volcanii | 2246 | Archaea | Archaea | 438 | 1.4299999999999999e-118 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g36605 | i0 | 100 | 4.39834024896266 | 237 | 0 | 98 | 0 | 2 | 238 | 2503787 | 2504023 | Haloferax volcanii DS2, complete sequence | blastn | 1060 | 438 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 9142536 | 9142536 | PRJNA1111077_P_NODE_34228_length_245_cov_0.895349_g34007_i0 | PRJNA1111077 | 34228 | 245 | 0.895349 | 2.19360505 | Haloferax volcanii | 2246 | Archaea | Archaea | 448 | 2.41e-121 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g34007 | i0 | 100 | 14.6 | 242 | 0 | 99 | 0 | 4 | 245 | 2570816 | 2571057 | Haloferax volcanii DS2, complete sequence | blastn | 3577 | 448 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 10418114 | 10418114 | PRJNA1111077_P_NODE_23289_length_276_cov_1.359606_g23068_i0 | PRJNA1111077 | 23289 | 276 | 1.359606 | 3.75251256 | Haloferax volcanii | 2246 | Archaea | Archaea | 508 | 1.2499999999999999e-139 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g23068 | i0 | 100 | 34.7282608695652 | 275 | 0 | 99 | 0 | 2 | 276 | 54556 | 54282 | Haloferax volcanii DS2, complete sequence | blastn | 9585 | 508 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 11224531 | 11224531 | PRJNA1111077_P_NODE_27789_length_259_cov_20.666667_g27568_i0 | PRJNA1111077 | 27789 | 259 | 20.666667 | 53.52666753 | Haloferax | 2251 | Archaea | Archaea | 468 | 1.98e-127 | NTclustered | gi|15277694|gb|AF395888.1| | 2246 | g27568 | i0 | 99.609 | 100.173745173745 | 256 | 1 | 99 | 0 | 4 | 259 | 190 | 445 | Haloferax volcanii signal recognition particle 7S RNA gene sequence | blastn | 25945 | 468 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 12500053 | 12500053 | PRJNA1111077_P_NODE_5830_length_476_cov_1.416873_g5609_i0 | PRJNA1111077 | 5830 | 476 | 1.416873 | 6.74431548 | Haloferax | 2251 | Archaea | Archaea | 867 | 0 | NTclustered | gi|2460995542|gb|CP106966.1| | 2246 | g5609 | i0 | 99.788 | 63.5273109243698 | 472 | 1 | 99 | 0 | 3 | 474 | 450216 | 449745 | Haloferax volcanii strain BNX82 chromosome, complete genome | blastn | 30239 | 872 | 0.994266055045872 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 15048869 | 15048869 | PRJNA1111077_P_NODE_34492_length_244_cov_2.029240_g34271_i0 | PRJNA1111077 | 34492 | 244 | 2.02924 | 4.9513456 | Haloferax | 2251 | Archaea | Archaea | 444 | 3.11e-120 | NTclustered | gi|1810670185|gb|CP048738.1| | 2246 | g34271 | i0 | 100 | 43.922131147541 | 240 | 0 | 98 | 0 | 4 | 243 | 678236 | 677997 | Haloferax volcanii strain wsp1 chromosome, complete genome | blastn | 10717 | 444 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 15517543 | 15517543 | PRJNA1111077_P_NODE_35733_length_242_cov_2.402367_g35512_i0 | PRJNA1111077 | 35733 | 242 | 2.402367 | 5.81372814 | Natronomonas salina | 1710540 | Archaea | Archaea | 95.3 | 3.57e-15 | NTclustered | gi|1865519430|gb|CP058335.1| | 1710540 | g35512 | i0 | 87.805 | 14.4132231404959 | 82 | 8 | 33 | 2 | 51 | 130 | 3102436 | 3102355 | Natronomonas salina strain YPL13 chromosome, complete genome | blastn | 3488 | 95.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas salina | |
| 16323572 | 16323572 | PRJNA1111077_P_NODE_173_length_1827_cov_24.887115_g114_i0 | PRJNA1111077 | 173 | 1827 | 24.887115 | 454.68759105 | Haloferax | 2251 | Archaea | Archaea | 3341 | 0 | NTclustered | gi|1810670185|gb|CP048738.1| | 2246 | g114 | i0 | 99.672 | 93.152162014231 | 1828 | 4 | 100 | 2 | 1 | 1827 | 2379295 | 2381121 | Haloferax volcanii strain wsp1 chromosome, complete genome | blastn | 170189 | 3369 | 0.99168892846542 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 18066218 | 18066218 | PRJNA1111077_P_NODE_18155_length_294_cov_2.036199_g17934_i0 | PRJNA1111077 | 18155 | 294 | 2.036199 | 5.98642506 | Haloferax volcanii | 2246 | Archaea | Archaea | 534 | 2.2199999999999998e-147 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g17934 | i0 | 99.658 | 42.7074829931973 | 292 | 1 | 99 | 0 | 1 | 292 | 2419959 | 2420250 | Haloferax volcanii DS2, complete sequence | blastn | 12556 | 534 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 19340849 | 19340849 | PRJNA1111077_P_NODE_36016_length_242_cov_0.911243_g35795_i0 | PRJNA1111077 | 36016 | 242 | 0.911243 | 2.20520806 | Haloferax volcanii | 2246 | Archaea | Archaea | 442 | 1.1099999999999995e-119 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g35795 | i0 | 100 | 85.0619834710744 | 239 | 0 | 99 | 0 | 1 | 239 | 775110 | 774872 | Haloferax volcanii DS2, complete sequence | blastn | 20585 | 442 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 21423042 | 21423042 | PRJNA1111077_P_NODE_12677_length_333_cov_1.750000_g12456_i0 | PRJNA1111077 | 12677 | 333 | 1.75 | 5.8275 | Haloferax | 2251 | Archaea | Archaea | 604 | 1.9199999999999991e-168 | NTclustered | gi|1810670185|gb|CP048738.1| | 2246 | g12456 | i0 | 99.697 | 9.16516516516517 | 330 | 1 | 99 | 0 | 2 | 331 | 3511425 | 3511754 | Haloferax volcanii strain wsp1 chromosome, complete genome | blastn | 3052 | 610 | 0.99016393442623 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 23166914 | 23166914 | PRJNA1111077_P_NODE_19_length_3127_cov_12.628029_g15_i0 | PRJNA1111077 | 19 | 3127 | 12.628029 | 394.87846683 | Haloferax volcanii | 2246 | Archaea | Archaea | 5764 | 0 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g15 | i0 | 99.968 | 175.630316597378 | 3124 | 1 | 99 | 0 | 4 | 3127 | 1599834 | 1602957 | Haloferax volcanii DS2, complete sequence | blastn | 549196 | 5764 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 23973468 | 23973468 | PRJNA1111077_P_NODE_31159_length_249_cov_3.000000_g30938_i0 | PRJNA1111077 | 31159 | 249 | 3 | 7.47 | Haloferax | 2251 | Archaea | Archaea | 451 | 1.9e-122 | NTclustered | gi|1810670185|gb|CP048738.1| | 2246 | g30938 | i0 | 100 | 18.7429718875502 | 244 | 0 | 98 | 0 | 3 | 246 | 2317433 | 2317190 | Haloferax volcanii strain wsp1 chromosome, complete genome | blastn | 4667 | 451 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 23973553 | 23973553 | PRJNA1111077_P_NODE_7839_length_416_cov_2.008746_g7618_i0 | PRJNA1111077 | 7839 | 416 | 2.008746 | 8.35638336 | Haloferax | 2251 | Archaea | Archaea | 761 | 0 | NTclustered | gi|2459773771|gb|CP104741.1| | 2246 | g7618 | i0 | 100 | 53.5504807692308 | 412 | 0 | 99 | 0 | 2 | 413 | 2632274 | 2632685 | Haloferax volcanii strain SVX82 chromosome, complete genome | blastn | 22277 | 761 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 24440296 | 24440296 | PRJNA1111077_P_NODE_11740_length_346_cov_1.318681_g11519_i0 | PRJNA1111077 | 11740 | 346 | 1.318681 | 4.56263626 | Haloferax volcanii | 2246 | Archaea | Archaea | 634 | 2.5599999999999996e-177 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g11519 | i0 | 100 | 69.4537572254335 | 343 | 0 | 99 | 0 | 1 | 343 | 798169 | 797827 | Haloferax volcanii DS2, complete sequence | blastn | 24031 | 634 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 25247391 | 25247391 | PRJNA1111077_P_NODE_14060_length_316_cov_1.246914_g13839_i0 | PRJNA1111077 | 14060 | 316 | 1.246914 | 3.94024824 | Haloferax | 2251 | Archaea | Archaea | 584 | 2.359999999999999e-162 | NTclustered | gi|149030|gb|M62816.1|HLFSLP | 2246 | g13839 | i0 | 100 | 4.74050632911392 | 316 | 0 | 100 | 0 | 1 | 316 | 1054 | 739 | H.volcanii S-layer protein gene, complete cds | blastn | 1498 | 584 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 25247424 | 25247424 | PRJNA1111077_P_NODE_17660_length_297_cov_2.017857_g17439_i0 | PRJNA1111077 | 17660 | 297 | 2.017857 | 5.99303529 | Haloferax | 2251 | Archaea | Archaea | 542 | 1.34e-149 | NTclustered | gi|909823395|gb|CP011947.1| | 35746 | g17439 | i0 | 100 | 87.5791245791246 | 293 | 0 | 99 | 0 | 3 | 295 | 773727 | 773435 | Haloferax gibbonsii strain ARA6, complete genome | blastn | 26011 | 542 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax gibbonsii |
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);;