contig_metadata
12 rows where bioproject = "PRJNA498309" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1109106 | 1109106 | PRJNA498309_P_NODE_82001_length_244_cov_2.434783_g79852_i0 | PRJNA498309 | 82001 | 244 | 2.434783 | 5.94087052 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 435 | 1.87e-117 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g79852 | i0 | 98.77 | 60.5983606557377 | 244 | 3 | 100 | 0 | 1 | 244 | 847937 | 848180 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 14786 | 435 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 4936885 | 4936885 | PRJNA498309_P_NODE_26344_length_560_cov_1.906310_g24391_i0 | PRJNA498309 | 26344 | 560 | 1.90631 | 10.675336 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 603 | 1.2099999999999996e-167 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g24391 | i0 | 87.337 | 54.4767857142857 | 537 | 55 | 94 | 12 | 4 | 531 | 847780 | 848312 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 30507 | 603 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 13235263 | 13235263 | PRJNA498309_P_NODE_86911_length_229_cov_1.703125_g84762_i0 | PRJNA498309 | 86911 | 229 | 1.703125 | 3.90015625 | Nitrosopumilus sp. K4 | 2795383 | Archaea | Archaea | 176 | 1.16e-39 | NTclustered | gi|2028944715|gb|CP067007.1| | 2795383 | g84762 | i0 | 82.212 | 1.81659388646288 | 208 | 33 | 90 | 4 | 23 | 228 | 201168 | 201373 | Nitrosopumilus sp. K4 chromosome, complete genome | blastn | 416 | 176 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. K4 | ||
| 23434065 | 23434065 | PRJNA498309_P_NODE_97099_length_201_cov_1.890244_g94950_i0 | PRJNA498309 | 97099 | 201 | 1.890244 | 3.79939044 | Candidatus Nitrosopumilus sediminis | 1229909 | Archaea | Archaea | 202 | 1.6399999999999998e-47 | NTclustered | gi|407047065|gb|CP003843.1| | 1229909 | g94950 | i0 | 86.096 | 4.90049751243781 | 187 | 26 | 93 | 0 | 15 | 201 | 746224 | 746410 | Candidatus Nitrosopumilus sp. AR2, complete genome | blastn | 985 | 202 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Candidatus Nitrosopumilus sediminis | ||
| 27393239 | 27393239 | PRJNA498309_P_NODE_109743_length_173_cov_2.058824_g107594_i0 | PRJNA498309 | 109743 | 173 | 2.058824 | 3.56176552 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 47 | 5.44e-5 | NR | MDW0342578.1 | 2169593 | g107594 | i0 | 100 | 0.38150289017341 | 22 | 0 | 38.2 | 0 | 66 | 1 | 1 | 22 | MDW0342578.1 histidine phosphatase family protein [Nitrososphaeraceae archaeon] | diamond | 66 | 47 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 27393267 | 27393267 | PRJNA498309_P_NODE_95903_length_204_cov_2.089820_g93754_i0 | PRJNA498309 | 95903 | 204 | 2.08982 | 4.2632328 | Thaumarchaeota archaeon 13_1_4 | 2026795 | Archaea | Archaea | 101 | 2.1499999999999994e-23 | NR | OLB89683.1 | 1805393 | g93754 | i0 | 85.7 | 2.47058823529412 | 56 | 8 | 82.4 | 0 | 170 | 3 | 2 | 57 | OLB89683.1 MAG: threonine ammonia-lyase [Thaumarchaeota archaeon 13_1_40CM_38_12] | diamond | 504 | 101 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Thaumarchaeota archaeon 13_1_40CM_38_12 | ||||||
| 27456478 | 27456478 | PRJNA498309_S_NODE_22483_length_409_cov_7.831551_g20344_i0 | PRJNA498309 | 22483 | 409 | 7.831551 | 32.03104359 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 135 | 1.15e-33 | NR | MDW0176774.1 | 2169593 | g20344 | i0 | 55.7 | 0.894865525672372 | 122 | 54 | 89.5 | 0 | 23 | 388 | 141 | 262 | MDW0176774.1 DDE-type integrase/transposase/recombinase [Nitrososphaeraceae archaeon] | diamond | 366 | 135 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 29382305 | 29382305 | PRJNA498309_P_NODE_44589_length_408_cov_2.010782_g42459_i0 | PRJNA498309 | 44589 | 408 | 2.010782 | 8.20399056 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 44.7 | 0.0437 | NR | MDR0470364.1 | 2026795 | g42459 | i0 | 34.7 | 0.551470588235294 | 75 | 48 | 55.1 | 1 | 45 | 269 | 489 | 562 | MDR0470364.1 MobA/MobL family protein [Nitrososphaerota archaeon] | diamond | 225 | 44.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 29666028 | 29666028 | PRJNA498309_P_NODE_14090_length_789_cov_26.085106_g12480_i0 | PRJNA498309 | 14090 | 789 | 26.085106 | 205.81148634 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 192 | 1.46e-58 | NR | MDW0136151.1 | 2169593 | g12480 | i0 | 97 | 1.50570342205323 | 99 | 3 | 37.6 | 0 | 491 | 787 | 1 | 99 | MDW0136151.1 response regulator [Nitrososphaeraceae archaeon] | diamond | 1188 | 192 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 30013965 | 30013965 | PRJNA498309_P_NODE_90611_length_218_cov_1.972376_g88462_i0 | PRJNA498309 | 90611 | 218 | 1.972376 | 4.29977968 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 81.3 | 7.27e-16 | NR | MDW0176774.1 | 2169593 | g88462 | i0 | 55.9 | 0.935779816513762 | 68 | 30 | 93.6 | 0 | 217 | 14 | 150 | 217 | MDW0176774.1 DDE-type integrase/transposase/recombinase [Nitrososphaeraceae archaeon] | diamond | 204 | 81.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 30060779 | 30060779 | PRJNA498309_P_NODE_107931_length_177_cov_1.364286_g105782_i0 | PRJNA498309 | 107931 | 177 | 1.364286 | 2.41478622 | Archaea | 2157 | Archaea | Archaea | 103 | 7.300000000000001e-27 | NR | TLY05125.1 | 2026795 | g105782 | i0 | 89.7 | 4.91525423728814 | 58 | 6 | 98.3 | 0 | 175 | 2 | 10 | 67 | TLY05125.1 MAG: dihydroxy-acid dehydratase, partial [Nitrososphaerota archaeon] | diamond | 870 | 104 | 0.990384615384615 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 30393440 | 30393440 | PRJNA498309_P_NODE_56253_length_344_cov_23.967427_g54105_i0 | PRJNA498309 | 56253 | 344 | 23.967427 | 82.44794888 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 152 | 6.72e-41 | NR | MDW0246809.1 | 2169593 | g54105 | i0 | 94.9 | 0.680232558139535 | 78 | 4 | 68 | 0 | 100 | 333 | 21 | 98 | MDW0246809.1 CoA-binding protein [Nitrososphaeraceae archaeon] | diamond | 234 | 152 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae 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);;