contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJEB66218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3959069 | 3959069 | PRJEB66218_P_NODE_25164_length_755_cov_1.550432_g22948_i0 | PRJEB66218 | 25164 | 755 | 1.550432 | 11.7057616 | root | 1 | Root_unresolved | Root_unresolved | 90.5 | 1.72e-16 | NR | WP_321506807.1 | 1005933 | g22948 | i0 | 37.9 | 2.53907284768212 | 161 | 80 | 62.8 | 6 | 15 | 488 | 2935 | 3078 | WP_321506807.1 DUF3821 domain-containing protein [uncultured Methanoregula sp.] | diamond | 1917 | 90.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 26781029 | 26781029 | PRJEB66218_P_NODE_97601_length_311_cov_1.804000_g95173_i0 | PRJEB66218 | 97601 | 311 | 1.804 | 5.61044 | Natrinema soli | 1930624 | Archaea | Archaea | 60.8 | 3.35e-8 | NR | WP_273737973.1 | 1930624 | g95173 | i0 | 60 | 2.56591639871383 | 45 | 18 | 43.4 | 0 | 310 | 176 | 351 | 395 | WP_273737973.1 cystathionine gamma-synthase [Natrinema soli] | diamond | 798 | 60.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema soli | |
| 27026845 | 27026845 | PRJEB66218_P_NODE_34962_length_607_cov_4.576923_g32586_i0 | PRJEB66218 | 34962 | 607 | 4.576923 | 27.78192261 | Methanoculleus | 45989 | Archaea | Archaea | 50.4 | 0.00126 | NR | WP_348532016.1 | 90427 | g32586 | i0 | 28.6 | 1.17627677100494 | 119 | 69 | 58.8 | 3 | 222 | 578 | 62 | 164 | WP_348532016.1 kelch repeat-containing protein, partial [Methanoculleus sp.] | diamond | 714 | 50.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 27602964 | 27602964 | PRJEB66218_P_NODE_38344_length_571_cov_1.849020_g35949_i0 | PRJEB66218 | 38344 | 571 | 1.84902 | 10.5579042 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 58.2 | 3.86e-6 | NR | MDD1719583.1 | 2485498 | g35949 | i0 | 36 | 1.38704028021016 | 89 | 55 | 45.7 | 1 | 301 | 561 | 66 | 154 | MDD1719583.1 hypothetical protein [Methanoregulaceae archaeon] | diamond | 792 | 58.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 29686319 | 29686319 | PRJEB66218_P_NODE_30_length_15996_cov_27.932852_g25_i0 | PRJEB66218 | 30 | 15996 | 27.932852 | 4468.13900592 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 97.8 | 4.24e-16 | NR | RPI38806.1 | 2485498 | g25 | i0 | 31.5 | 0.0481995498874719 | 257 | 156 | 4.7 | 9 | 15465 | 14707 | 89 | 329 | RPI38806.1 MAG: hypothetical protein EHM53_07905 [Methanoregulaceae archaeon] | diamond | 771 | 97.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 29939471 | 29939471 | PRJEB66218_P_NODE_73551_length_372_cov_3.710611_g71126_i0 | PRJEB66218 | 73551 | 372 | 3.710611 | 13.80347292 | Methanoregula sp. | 2052170 | Archaea | Archaea | 70.5 | 3.22e-11 | NR | MDD1700180.1 | 2052170 | g71126 | i0 | 34.5 | 0.959677419354839 | 119 | 70 | 91.1 | 3 | 22 | 360 | 285 | 401 | MDD1700180.1 PKD domain-containing protein [Methanoregula sp.] | diamond | 357 | 70.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 30785198 | 30785198 | PRJEB66218_P_NODE_71434_length_379_cov_2.754717_g69010_i0 | PRJEB66218 | 71434 | 379 | 2.754717 | 10.44037743 | root | 1 | Root_unresolved | Root_unresolved | 94.4 | 3.1200000000000004e-21 | NR | WP_006601361.1 | 2246 | g69010 | i0 | 53 | 7.50395778364116 | 115 | 44 | 90.2 | 4 | 37 | 378 | 3 | 108 | WP_006601361.1 cysteine hydrolase family protein [Haloferax volcanii] | diamond | 2844 | 94.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 30823944 | 30823944 | PRJEB66218_P_NODE_235834_length_203_cov_0.915493_g233403_i0 | PRJEB66218 | 235834 | 203 | 0.915493 | 1.85845079 | Methanoculleus frigidifontis | 2584085 | Archaea | Archaea | 67.4 | 4.28e-11 | NR | WP_301663031.1 | 2584085 | g233403 | i0 | 44.8 | 1.98029556650246 | 67 | 37 | 99 | 0 | 201 | 1 | 131 | 197 | WP_301663031.1 glycosyltransferase [Methanoculleus frigidifontis] | diamond | 402 | 67.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus frigidifontis | |
| 31171169 | 31171169 | PRJEB66218_P_NODE_135475_length_256_cov_1.000000_g133046_i0 | PRJEB66218 | 135475 | 256 | 1 | 2.56 | Methanomicrobiales archaeon HGW-Methanomicrobiales-4 | 2013820 | Archaea | Archaea | 46.6 | 0.00178 | NR | PKL60559.1 | 2013820 | g133046 | i0 | 45.3 | 0.62109375 | 53 | 20 | 51.6 | 2 | 12 | 143 | 85 | 137 | PKL60559.1 MAG: mechanosensitive ion channel protein MscS [Methanomicrobiales archaeon HGW-Methanomicrobiales-4] | diamond | 159 | 46.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon HGW-Methanomicrobiales-4 | |||
| 31740658 | 31740658 | PRJEB66218_P_NODE_35877_length_597_cov_2.761194_g33494_i0 | PRJEB66218 | 35877 | 597 | 2.761194 | 16.48432818 | Methanoculleus sp. | 90427 | Archaea | Archaea | 78.2 | 5.36e-13 | NR | WP_346733691.1 | 90427 | g33494 | i0 | 35.6 | 0.748743718592965 | 149 | 82 | 73.9 | 5 | 458 | 18 | 162 | 298 | WP_346733691.1 kelch repeat-containing protein [Methanoculleus sp.] | diamond | 447 | 78.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 31835537 | 31835537 | PRJEB66218_P_NODE_90197_length_327_cov_1.710526_g87770_i0 | PRJEB66218 | 90197 | 327 | 1.710526 | 5.59342002 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 66.2 | 4.08e-10 | NR | NJD76986.1 | 2032688 | g87770 | i0 | 30.8 | 1.96330275229358 | 107 | 66 | 98.2 | 2 | 321 | 1 | 120 | 218 | NJD76986.1 hypothetical protein [Candidatus Methanoperedens sp.] | diamond | 642 | 66.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. |
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);;