contig_metadata
11 rows where tax_clade = "Marine Group I" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181131 | 181131 | PRJNA1067370_P_NODE_77081_length_254_cov_1.464088_g76532_i0 | PRJNA1067370 | 77081 | 254 | 1.464088 | 3.71878352 | Marine Group I thaumarchaeote | 2511932 | Archaea | Archaea | 185 | 2.1799999999999994e-42 | NTclustered | gi|2277046463|gb|CP054849.1| | 2511932 | g76532 | i0 | 87.654 | 23.1181102362205 | 162 | 16 | 63 | 4 | 91 | 250 | 242268 | 242427 | MAG: Marine Group I thaumarchaeote isolate JZB445 chromosome | blastn | 5872 | 185 | 1 | Archaea | Marine Group I | Thermoproteati | Nitrososphaerota | Marine Group I thaumarchaeote | |||||
| 17756774 | 17756774 | PRJNA690592_S_NODE_1054_length_2014_cov_8.033488_g853_i0 | PRJNA690592 | 1054 | 2014 | 8.033488 | 161.79444832 | Marine Group I thaumarchaeote | 2511932 | Archaea | Archaea | 135 | 6.79e-29 | NR | NWJ43849.1 | 2511932 | g853 | i0 | 26.3 | 0.674776564051639 | 453 | 265 | 66.4 | 10 | 1855 | 518 | 63 | 453 | NWJ43849.1 aminopeptidase N [Marine Group I thaumarchaeote] | diamond | 1359 | 135 | 1 | Archaea | Marine Group I | Thermoproteati | Nitrososphaerota | Marine Group I thaumarchaeote | |||||
| 20677000 | 20677000 | PRJNA1120203_P_NODE_92637_length_246_cov_0.890173_g91621_i0 | PRJNA1120203 | 92637 | 246 | 0.890173 | 2.18982558 | Marine Group I thaumarchaeote | 2511932 | Archaea | Archaea | 331 | 2.55e-86 | NTclustered | gi|2277046463|gb|CP054849.1| | 2511932 | g91621 | i0 | 91.057 | 1 | 246 | 20 | 99 | 2 | 1 | 245 | 595340 | 595096 | MAG: Marine Group I thaumarchaeote isolate JZB445 chromosome | blastn | 246 | 331 | 1 | Archaea | Marine Group I | Thermoproteati | Nitrososphaerota | Marine Group I thaumarchaeote | |||||
| 28062677 | 28062677 | PRJNA719595_P_NODE_6405_length_253_cov_0.866667_g6370_i0 | PRJNA719595 | 6405 | 253 | 0.866667 | 2.19266751 | Marine Group I thaumarchaeote | 2511932 | Archaea | Archaea | 64.3 | 8.14e-11 | NR | NWJ43781.1 | 2511932 | g6370 | i0 | 68.6 | 0.41501976284585 | 35 | 11 | 41.5 | 0 | 110 | 6 | 2 | 36 | NWJ43781.1 hypothetical protein [Marine Group I thaumarchaeote] | diamond | 105 | 64.3 | 1 | Archaea | Marine Group I | Thermoproteati | Nitrososphaerota | Marine Group I thaumarchaeote | |||||
| 28193890 | 28193890 | PRJNA946307_P_NODE_91266_length_188_cov_1.841727_g90392_i0 | PRJNA946307 | 91266 | 188 | 1.841727 | 3.46244676 | Marine Group I thaumarchaeote | 2511932 | Archaea | Archaea | 48.1 | 2.2e-4 | NR | NWK05358.1 | 2511932 | g90392 | i0 | 38.7 | 0.98936170212766 | 62 | 33 | 91 | 2 | 3 | 173 | 64 | 125 | NWK05358.1 MBL fold metallo-hydrolase [Marine Group I thaumarchaeote] | diamond | 186 | 48.1 | 1 | Archaea | Marine Group I | Thermoproteati | Nitrososphaerota | Marine Group I thaumarchaeote | |||||
| 29409876 | 29409876 | PRJNA1237347_P_NODE_387989_length_285_cov_1.089623_g381416_i0 | PRJNA1237347 | 387989 | 285 | 1.089623 | 3.10542555 | Marine Group I thaumarchaeote | 2511932 | Archaea | Archaea | 51.6 | 4.69e-5 | NR | NWJ43690.1 | 2511932 | g381416 | i0 | 29.2 | 1.11578947368421 | 106 | 59 | 95.8 | 4 | 6 | 278 | 518 | 622 | NWJ43690.1 T9SS type A sorting domain-containing protein [Marine Group I thaumarchaeote] | diamond | 318 | 51.6 | 1 | Archaea | Marine Group I | Thermoproteati | Nitrososphaerota | Marine Group I thaumarchaeote | |||||
| 29723309 | 29723309 | PRJNA1148190_P_NODE_337550_length_305_cov_1.327586_g326377_i0 | PRJNA1148190 | 337550 | 305 | 1.327586 | 4.0491373 | Marine Group I thaumarchaeote | 2511932 | Archaea | Archaea | 69.3 | 8.53e-12 | NR | NWJ43786.1 | 2511932 | g326377 | i0 | 60.9 | 2.0655737704918 | 69 | 25 | 67.9 | 2 | 303 | 97 | 45 | 111 | NWJ43786.1 hypothetical protein [Marine Group I thaumarchaeote] | diamond | 630 | 69.3 | 1 | Archaea | Marine Group I | Thermoproteati | Nitrososphaerota | Marine Group I thaumarchaeote | |||||
| 30065336 | 30065336 | PRJEB64798_P_NODE_70892_length_229_cov_19.738889_g69127_i0 | PRJEB64798 | 70892 | 229 | 19.738889 | 45.20205581 | Marine Group I thaumarchaeote | 2511932 | Archaea | Archaea | 122 | 2.55e-30 | NR | NWJ43438.1 | 2511932 | g69127 | i0 | 72.4 | 10.9519650655022 | 76 | 21 | 99.6 | 0 | 2 | 229 | 432 | 507 | NWJ43438.1 hypothetical protein [Marine Group I thaumarchaeote] | diamond | 2508 | 122 | 1 | Archaea | Marine Group I | Thermoproteati | Nitrososphaerota | Marine Group I thaumarchaeote | |||||
| 31176555 | 31176555 | PRJNA1148190_P_NODE_320755_length_311_cov_1.626050_g309582_i0 | PRJNA1148190 | 320755 | 311 | 1.62605 | 5.0570155 | Marine Group I thaumarchaeote | 2511932 | Archaea | Archaea | 48.1 | 1.83e-4 | NR | NWJ43962.1 | 2511932 | g309582 | i0 | 35.1 | 1.94855305466238 | 74 | 47 | 70.4 | 1 | 310 | 92 | 36 | 109 | NWJ43962.1 hypothetical protein [Marine Group I thaumarchaeote] | diamond | 606 | 48.1 | 1 | Archaea | Marine Group I | Thermoproteati | Nitrososphaerota | Marine Group I thaumarchaeote | |||||
| 31211752 | 31211752 | PRJNA345071_P_NODE_11135_length_232_cov_2.597484_g11095_i0 | PRJNA345071 | 11135 | 232 | 2.597484 | 6.02616288 | Marine Group I thaumarchaeote | 2511932 | Archaea | Archaea | 51.6 | 2.41e-5 | NR | NWJ99825.1 | 2511932 | g11095 | i0 | 57.6 | 0.426724137931034 | 33 | 14 | 42.7 | 0 | 216 | 118 | 28 | 60 | NWJ99825.1 hypothetical protein [Marine Group I thaumarchaeote] | diamond | 99 | 51.6 | 1 | Archaea | Marine Group I | Thermoproteati | Nitrososphaerota | Marine Group I thaumarchaeote | |||||
| 31918711 | 31918711 | PRJNA792582_P_NODE_9977_length_537_cov_1.879310_g9173_i0 | PRJNA792582 | 9977 | 537 | 1.87931 | 10.0918947 | Marine Group I thaumarchaeote | 2511932 | Archaea | Archaea | 52 | 3.56e-4 | NR | NWJ99825.1 | 2511932 | g9173 | i0 | 57.6 | 0.184357541899441 | 33 | 14 | 18.4 | 0 | 524 | 426 | 28 | 60 | NWJ99825.1 hypothetical protein [Marine Group I thaumarchaeote] | diamond | 99 | 52 | 1 | Archaea | Marine Group I | Thermoproteati | Nitrososphaerota | Marine Group I thaumarchaeote |
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);;