contig_metadata
11 rows where bioproject = "PRJNA379145" and tax_phylum = "Nitrososphaerota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26885284 | 26885284 | PRJNA379145_P_NODE_32081_length_387_cov_2.870056_g29948_i0 | PRJNA379145 | 32081 | 387 | 2.870056 | 11.10711672 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 82.4 | 2.12e-15 | NR | HSA76153.1 | 2026886 | g29948 | i0 | 37.3 | 0.976744186046512 | 126 | 75 | 96.9 | 3 | 10 | 384 | 51 | 173 | HSA76153.1 hypothetical protein [Nitrosarchaeum sp.] | diamond | 378 | 82.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 27011589 | 27011589 | PRJNA379145_P_NODE_31162_length_400_cov_2.291553_g29033_i0 | PRJNA379145 | 31162 | 400 | 2.291553 | 9.166212 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 56.2 | 4.28e-6 | NR | MDG6921989.1 | 2026795 | g29033 | i0 | 30.3 | 0.8925 | 119 | 69 | 81.8 | 6 | 7 | 333 | 501 | 615 | MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 357 | 56.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 27548845 | 27548845 | PRJNA379145_P_NODE_59204_length_192_cov_1.358491_g57050_i0 | PRJNA379145 | 59204 | 192 | 1.358491 | 2.60830272 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 46.2 | 2.96e-4 | NR | HEY7082467.1 | 2169593 | g57050 | i0 | 40.8 | 1.734375 | 49 | 29 | 76.6 | 0 | 192 | 46 | 23 | 71 | HEY7082467.1 protease inhibitor I42 family protein [Nitrososphaeraceae archaeon] | diamond | 333 | 46.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 28653983 | 28653983 | PRJNA379145_P_NODE_17947_length_646_cov_2.089723_g16173_i0 | PRJNA379145 | 17947 | 646 | 2.089723 | 13.49961058 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 84.3 | 8.28e-15 | NR | MDG6921989.1 | 2026795 | g16173 | i0 | 31.5 | 0.914860681114551 | 197 | 126 | 89.2 | 5 | 7 | 582 | 1365 | 1557 | MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 591 | 84.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 30391351 | 30391351 | PRJNA379145_P_NODE_23793_length_517_cov_2.712810_g21798_i0 | PRJNA379145 | 23793 | 517 | 2.71281 | 14.0252277 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 76.3 | 1.17e-12 | NR | HSA76153.1 | 2026886 | g21798 | i0 | 34.9 | 0.980657640232108 | 169 | 94 | 90.5 | 8 | 9 | 476 | 283 | 448 | HSA76153.1 hypothetical protein [Nitrosarchaeum sp.] | diamond | 507 | 76.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 31370777 | 31370777 | PRJNA379145_P_NODE_47956_length_245_cov_2.443396_g45803_i0 | PRJNA379145 | 47956 | 245 | 2.443396 | 5.9863202 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 55.1 | 1.76e-6 | NR | MDG6921989.1 | 2026795 | g45803 | i0 | 40.8 | 0.930612244897959 | 76 | 45 | 93.1 | 0 | 238 | 11 | 652 | 727 | MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 228 | 55.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 31419180 | 31419180 | PRJNA379145_P_NODE_2776_length_1676_cov_11.371272_g2394_i0 | PRJNA379145 | 2776 | 1676 | 11.371272 | 190.58251872 | Nitrosotalea | 1078904 | Archaea | Archaea | 304 | 1.41e-93 | NR | 6VCF_A | 1078905 | g2394 | i0 | 36.7 | 4.17780429594272 | 466 | 269 | 82.2 | 12 | 294 | 1670 | 25 | 471 | 6VCF_A Chain A, carotenoid cleavage dioxygenase [Nitrosotalea devaniterrae] | diamond | 7002 | 304 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosotaleales | Nitrosotaleaceae | Nitrosotalea | Nitrosotalea devaniterrae | ||
| 31482756 | 31482756 | PRJNA379145_P_NODE_2816_length_1668_cov_2.156575_g2429_i0 | PRJNA379145 | 2816 | 1668 | 2.156575 | 35.971671 | Nitrosotalea | 1078904 | Archaea | Archaea | 300 | 5.61e-92 | NR | 6VCF_A | 1078905 | g2429 | i0 | 36.8 | 3.46043165467626 | 481 | 271 | 84.4 | 12 | 237 | 1643 | 13 | 472 | 6VCF_A Chain A, carotenoid cleavage dioxygenase [Nitrosotalea devaniterrae] | diamond | 5772 | 300 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosotaleales | Nitrosotaleaceae | Nitrosotalea | Nitrosotalea devaniterrae | ||
| 31592075 | 31592075 | PRJNA379145_P_NODE_17676_length_653_cov_5.219355_g15913_i0 | PRJNA379145 | 17676 | 653 | 5.219355 | 34.08238815 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 48.9 | 0.0055 | NR | MCL4519602.1 | 2026795 | g15913 | i0 | 31.3 | 0.294027565084227 | 64 | 44 | 29.4 | 0 | 444 | 635 | 169 | 232 | MCL4519602.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 192 | 48.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 32761612 | 32761612 | PRJNA379145_P_NODE_51800_length_224_cov_1.392670_g49646_i0 | PRJNA379145 | 51800 | 224 | 1.39267 | 3.1195808 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 69.7 | 6.07e-12 | NR | HEX6294714.1 | 2169593 | g49646 | i0 | 47.8 | 2.77232142857143 | 69 | 36 | 92.4 | 0 | 224 | 18 | 27 | 95 | HEX6294714.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 621 | 69.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 32887421 | 32887421 | PRJNA379145_P_NODE_4840_length_1354_cov_5.803179_g2737_i1 | PRJNA379145 | 4840 | 1354 | 5.803179 | 78.57504366 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 127 | 4.28e-27 | NR | MDG6921989.1 | 2026795 | g2737 | i1 | 34.7 | 0.580502215657312 | 262 | 165 | 57.2 | 5 | 9 | 782 | 1298 | 1557 | MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 786 | 127 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota 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);;