contig_metadata
10 rows where bioproject = "PRJNA922890" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6001911 | 6001911 | PRJNA922890_P_NODE_82645_length_228_cov_1.301887_g82235_i0 | PRJNA922890 | 82645 | 228 | 1.301887 | 2.96830236 | root | 1 | Root_unresolved | Root_unresolved | 118 | 7.56e-31 | NR | RYH18875.1 | 1906665 | g82235 | i0 | 76 | 3.89473684210526 | 75 | 16 | 98.7 | 1 | 3 | 227 | 155 | 227 | RYH18875.1 MAG: hypothetical protein EON65_26770 [archaeon] | diamond | 888 | 118 | 1 | Archaea | archaeon | ||||||||
| 26707822 | 26707822 | PRJNA922890_P_NODE_74201_length_233_cov_0.878049_g73791_i0 | PRJNA922890 | 74201 | 233 | 0.878049 | 2.04585417 | archaeon | 1906665 | Archaea | Archaea | 52.4 | 1.32e-5 | NR | RYG69840.1 | 1906665 | g73791 | i0 | 42.1 | 0.978540772532189 | 76 | 43 | 97.9 | 1 | 233 | 6 | 459 | 533 | RYG69840.1 MAG: hypothetical protein EON64_01705 [archaeon] | diamond | 228 | 52.4 | 1 | Archaea | archaeon | ||||||||
| 27372673 | 27372673 | PRJNA922890_P_NODE_76523_length_231_cov_1.438272_g76113_i0 | PRJNA922890 | 76523 | 231 | 1.438272 | 3.32240832 | archaeon | 1906665 | Archaea | Archaea | 121 | 5.2e-30 | NR | RYG69930.1 | 1906665 | g76113 | i0 | 73.1 | 1.01298701298701 | 78 | 19 | 98.7 | 1 | 230 | 3 | 442 | 519 | RYG69930.1 MAG: hypothetical protein EON64_01505 [archaeon] | diamond | 234 | 121 | 1 | Archaea | archaeon | ||||||||
| 28414447 | 28414447 | PRJNA922890_P_NODE_57306_length_258_cov_1.534392_g56896_i0 | PRJNA922890 | 57306 | 258 | 1.534392 | 3.95873136 | archaeon | 1906665 | Archaea | Archaea | 99.4 | 6e-25 | NR | RYH00022.1 | 1906665 | g56896 | i0 | 60 | 0.930232558139535 | 80 | 31 | 93 | 1 | 19 | 258 | 1 | 79 | RYH00022.1 MAG: hypothetical protein EON65_49750 [archaeon] | diamond | 240 | 99.4 | 1 | Archaea | archaeon | ||||||||
| 29077500 | 29077500 | PRJNA922890_P_NODE_70228_length_235_cov_0.867470_g69818_i0 | PRJNA922890 | 70228 | 235 | 0.86747 | 2.0385545 | archaeon | 1906665 | Archaea | Archaea | 113 | 3.95e-27 | NR | MDP2437394.1 | 1906665 | g69818 | i0 | 68.5 | 0.931914893617021 | 73 | 23 | 93.2 | 0 | 17 | 235 | 30 | 102 | MDP2437394.1 argininosuccinate lyase [archaeon] | diamond | 219 | 113 | 1 | Archaea | archaeon | ||||||||
| 29140733 | 29140733 | PRJNA922890_P_NODE_66529_length_237_cov_1.648810_g66119_i0 | PRJNA922890 | 66529 | 237 | 1.64881 | 3.9076797 | Candidatus Marsarchaeota archaeon | 2823144 | Archaea | Archaea | 77 | 1.99e-14 | NR | MCL4382152.1 | 2823144 | g66119 | i0 | 55.8 | 2.92405063291139 | 77 | 33 | 96.2 | 1 | 230 | 3 | 236 | 312 | MCL4382152.1 polyprenyl synthetase family protein [Candidatus Marsarchaeota archaeon] | diamond | 693 | 77 | 1 | Archaea | Thermoproteati | Candidatus Marsarchaeota | Candidatus Marsarchaeota archaeon | ||||||
| 29172232 | 29172232 | PRJNA922890_P_NODE_72089_length_234_cov_0.872727_g71679_i0 | PRJNA922890 | 72089 | 234 | 0.872727 | 2.04218118 | Natronorubrum daqingense | 588898 | Archaea | Archaea | 70.1 | 9.16e-13 | NR | WP_076584130.1 | 588898 | g71679 | i0 | 50 | 0.974358974358974 | 76 | 38 | 97.4 | 0 | 233 | 6 | 103 | 178 | WP_076584130.1 hypothetical protein [Natronorubrum daqingense] | diamond | 228 | 70.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum daqingense | |
| 29771809 | 29771809 | PRJNA922890_P_NODE_45351_length_289_cov_1.327273_g44941_i0 | PRJNA922890 | 45351 | 289 | 1.327273 | 3.83581897 | archaeon | 1906665 | Archaea | Archaea | 53.1 | 1.77e-6 | NR | MCQ2818358.1 | 1906665 | g44941 | i0 | 33 | 0.913494809688581 | 88 | 59 | 91.3 | 0 | 19 | 282 | 14 | 101 | MCQ2818358.1 hypothetical protein [archaeon] | diamond | 264 | 53.1 | 1 | Archaea | archaeon | ||||||||
| 30182595 | 30182595 | PRJNA922890_P_NODE_43572_length_295_cov_0.955752_g43162_i0 | PRJNA922890 | 43572 | 295 | 0.955752 | 2.8194684 | archaeon | 1906665 | Archaea | Archaea | 162 | 2.06e-46 | NR | RYH05140.1 | 1906665 | g43162 | i0 | 77.1 | 0.976271186440678 | 96 | 22 | 97.6 | 0 | 2 | 289 | 142 | 237 | RYH05140.1 MAG: hypothetical protein EON65_45550 [archaeon] | diamond | 288 | 162 | 1 | Archaea | archaeon | ||||||||
| 31857828 | 31857828 | PRJNA922890_P_NODE_64357_length_242_cov_1.421965_g63947_i0 | PRJNA922890 | 64357 | 242 | 1.421965 | 3.4411553 | archaeon | 1906665 | Archaea | Archaea | 67.4 | 7.58e-11 | NR | MCQ2819683.1 | 1906665 | g63947 | i0 | 48.1 | 0.954545454545455 | 77 | 38 | 94.2 | 2 | 232 | 5 | 659 | 734 | MCQ2819683.1 TBC domain-containing protein [archaeon] | diamond | 231 | 67.4 | 1 | Archaea | archaeon |
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);;