contig_metadata
12 rows where bioproject = "PRJNA429937" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10629543 | 10629543 | PRJNA429937_P_NODE_113529_length_265_cov_3.012712_g90906_i0 | PRJNA429937 | 113529 | 265 | 3.012712 | 7.9836868 | Haloarcula regularis | 3033392 | Archaea | Archaea | 198 | 2.94e-46 | NTclustered | gi|2463595546|gb|CP119795.1| | 3033392 | g90906 | i0 | 88.485 | 0.9660377358490572 | 165 | 17 | 96 | 2 | 102 | 265 | 99853 | 99690 | Haloarcula regularis strain SYNS111 plasmid unnamed1, complete sequence | blastn | 256 | 198 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 11905897 | 11905897 | PRJNA429937_P_NODE_62550_length_435_cov_3.105911_g42350_i0 | PRJNA429937 | 62550 | 435 | 3.105911 | 13.510712850000001 | Haloarcula regularis | 3033392 | Archaea | Archaea | 298 | 4.89e-76 | NTclustered | gi|2463595546|gb|CP119795.1| | 3033392 | g42350 | i0 | 85.763 | 1.59080459770115 | 295 | 26 | 65 | 9 | 154 | 435 | 99562 | 99853 | Haloarcula regularis strain SYNS111 plasmid unnamed1, complete sequence | blastn | 692 | 298 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 11906008 | 11906008 | PRJNA429937_P_NODE_69010_length_407_cov_2.304233_g47626_i0 | PRJNA429937 | 69010 | 407 | 2.304233 | 9.37822831 | Haloarcula regularis | 3033392 | Archaea | Archaea | 198 | 4.74e-46 | NTclustered | gi|2463595546|gb|CP119795.1| | 3033392 | g47626 | i0 | 88.485 | 0.734643734643735 | 165 | 17 | 73 | 2 | 1 | 164 | 99690 | 99853 | Haloarcula regularis strain SYNS111 plasmid unnamed1, complete sequence | blastn | 299 | 198 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 20829041 | 20829041 | PRJNA429937_P_NODE_75537_length_381_cov_5.377841_g53418_i0 | PRJNA429937 | 75537 | 381 | 5.377841 | 20.48957421 | Halorubrum sp. CSM-61 | 2485838 | Archaea | Archaea | 245 | 4.61e-78 | NR | WP_123619210.1 | 2485838 | g53418 | i0 | 95.1 | 0.960629921259842 | 122 | 6 | 96.1 | 0 | 14 | 379 | 34 | 155 | WP_123619210.1 galactonate dehydratase [Halorubrum sp. CSM-61] | diamond | 366 | 245 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. CSM-61 | |
| 24653019 | 24653019 | PRJNA429937_P_NODE_42300_length_552_cov_3.936902_g26907_i0 | PRJNA429937 | 42300 | 552 | 3.936902 | 21.73169904 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 477 | 7.56e-130 | NTclustered | gi|2388573995|gb|CP113312.1| | 2032688 | g26907 | i0 | 88.776 | 0.710144927536232 | 392 | 40 | 71 | 4 | 163 | 552 | 14392 | 14781 | MAG: Candidatus Methanoperedens sp. isolate v3 plasmid unnamed | blastn | 392 | 477 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 29776249 | 29776249 | PRJNA429937_P_NODE_57171_length_461_cov_4.319444_g2639_i3 | PRJNA429937 | 57171 | 461 | 4.319444 | 19.91263684 | root | 1 | Root_unresolved | Root_unresolved | 114 | 2.61e-26 | NR | WP_336247442.1 | 2223 | g2639 | i3 | 52.5 | 1.8351409978308 | 141 | 57 | 85.9 | 3 | 396 | 1 | 245 | 384 | WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] | diamond | 846 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 29871123 | 29871123 | PRJNA429937_P_NODE_10431_length_1122_cov_2.154620_g6122_i0 | PRJNA429937 | 10431 | 1122 | 2.15462 | 24.1748364 | root | 1 | Root_unresolved | Root_unresolved | 216 | 6.999999999999999e-62 | NR | MCX6692367.1 | 2052170 | g6122 | i0 | 40.7 | 3.42513368983957 | 317 | 158 | 78.3 | 7 | 1 | 879 | 88 | 398 | MCX6692367.1 IS1380 family transposase [Methanoregula sp.] | diamond | 3843 | 218 | 0.990825688073395 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 30092072 | 30092072 | PRJNA429937_P_NODE_51812_length_490_cov_4.377440_g2639_i2 | PRJNA429937 | 51812 | 490 | 4.37744 | 21.449456 | root | 1 | Root_unresolved | Root_unresolved | 116 | 1.06e-26 | NR | WP_336247442.1 | 2223 | g2639 | i2 | 52.5 | 1.7265306122449 | 141 | 57 | 80.8 | 3 | 396 | 1 | 245 | 384 | WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] | diamond | 846 | 116 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 30345536 | 30345536 | PRJNA429937_P_NODE_4472_length_1596_cov_4.192087_g2639_i0 | PRJNA429937 | 4472 | 1596 | 4.192087 | 66.90570852 | root | 1 | Root_unresolved | Root_unresolved | 330 | 9.56e-102 | NR | WP_336247442.1 | 2223 | g2639 | i0 | 66.9 | 1.05639097744361 | 281 | 83 | 51.1 | 3 | 1596 | 781 | 245 | 524 | WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] | diamond | 1686 | 330 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 30755821 | 30755821 | PRJNA429937_P_NODE_72754_length_392_cov_2.851240_g50898_i0 | PRJNA429937 | 72754 | 392 | 2.85124 | 11.1768608 | root | 1 | Root_unresolved | Root_unresolved | 143 | 7.079999999999999e-37 | NR | HVN73417.1 | 2052170 | g50898 | i0 | 61.6 | 25.3316326530612 | 112 | 43 | 85.7 | 0 | 18 | 353 | 590 | 701 | HVN73417.1 xanthine dehydrogenase family protein molybdopterin-binding subunit [Methanoregula sp.] | diamond | 9930 | 144 | 0.993055555555556 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 31482969 | 31482969 | PRJNA429937_P_NODE_50296_length_499_cov_4.359574_g2639_i1 | PRJNA429937 | 50296 | 499 | 4.359574 | 21.75427426 | root | 1 | Root_unresolved | Root_unresolved | 114 | 4.1e-26 | NR | WP_336247442.1 | 2223 | g2639 | i1 | 52.5 | 1.69539078156313 | 141 | 57 | 79.4 | 3 | 104 | 499 | 245 | 384 | WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] | diamond | 846 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 32527059 | 32527059 | PRJNA429937_P_NODE_64439_length_426_cov_4.680101_g2639_i4 | PRJNA429937 | 64439 | 426 | 4.680101 | 19.93723026 | root | 1 | Root_unresolved | Root_unresolved | 130 | 4.3199999999999996e-32 | NR | WP_336247442.1 | 2223 | g2639 | i4 | 55.6 | 2.12676056338028 | 151 | 57 | 100 | 3 | 426 | 1 | 235 | 384 | WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] | diamond | 906 | 130 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii |
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);;