contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA550047" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1790389 | 1790389 | PRJNA550047_P_NODE_301002_length_297_cov_7.236607_g299033_i0 | PRJNA550047 | 301002 | 297 | 7.236607 | 21.49272279 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 315 | 3.19e-81 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g299033 | i0 | 85.953 | 1.00673400673401 | 299 | 36 | 99 | 4 | 1 | 294 | 2124246 | 2124543 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 299 | 315 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 4343425 | 4343425 | PRJNA550047_P_NODE_430964_length_253_cov_11.311111_g428992_i0 | PRJNA550047 | 430964 | 253 | 11.311111 | 28.61711083 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 222 | 1.65e-53 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g428992 | i0 | 99.187 | 0.486166007905138 | 123 | 1 | 49 | 0 | 131 | 253 | 1197078 | 1197200 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 123 | 222 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 4345452 | 4345452 | PRJNA550047_P_NODE_596344_length_199_cov_7.865079_g594371_i0 | PRJNA550047 | 596344 | 199 | 7.865079 | 15.65150721 | Candidatus Nitrosocosmicus franklandianus | 1798806 | Archaea | Archaea | 255 | 1.23e-63 | NTclustered | gi|1599533355|emb|LR216287.1| | 1798806 | g594371 | i0 | 90.674 | 51.2361809045226 | 193 | 17 | 97 | 1 | 1 | 193 | 1595 | 1404 | Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN | blastn | 10196 | 255 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus franklandianus | ||
| 5617478 | 5617478 | PRJNA550047_P_NODE_206345_length_325_cov_11.980159_g204377_i0 | PRJNA550047 | 206345 | 325 | 11.980159 | 38.93551675 | Candidatus Nitrosocosmicus franklandianus | 1798806 | Archaea | Archaea | 520 | 6.969999999999998e-143 | NTclustered | gi|1599533355|emb|LR216287.1| | 1798806 | g204377 | i0 | 95.679 | 20.0338461538462 | 324 | 12 | 99 | 2 | 2 | 325 | 2025 | 2346 | Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN | blastn | 6511 | 520 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus franklandianus | ||
| 10721580 | 10721580 | PRJNA550047_P_NODE_521229_length_223_cov_11.146667_g519256_i0 | PRJNA550047 | 521229 | 223 | 11.146667 | 24.85706741 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 377 | 2.88e-100 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g519256 | i0 | 97.309 | 1 | 223 | 5 | 100 | 1 | 1 | 223 | 1645699 | 1645478 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 223 | 377 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 11325060 | 11325060 | PRJNA550047_P_NODE_527389_length_221_cov_9.378378_g525416_i0 | PRJNA550047 | 527389 | 221 | 9.378378 | 20.72621538 | Nitrosopumilus | 338191 | Archaea | Archaea | 89.8 | 1.49e-13 | NTclustered | gi|507148339|ref|NR_103142.1| | 338192 | g525416 | i0 | 87.342 | 34.7737556561086 | 79 | 8 | 36 | 2 | 85 | 163 | 514 | 438 | Nitrosopumilus maritimus strain SCM1 23S ribosomal RNA gene, complete sequence | blastn | 7685 | 89.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus maritimus | ||
| 16423128 | 16423128 | PRJNA550047_P_NODE_203413_length_337_cov_8.799242_g201451_i0 | PRJNA550047 | 203413 | 337 | 8.799242 | 29.65344554 | Archaea | 2157 | Archaea | Archaea | 595 | 1.1699999999999996e-165 | NTclustered | gi|47155798|gb|AY601291.1| | 29281 | g201451 | i0 | 98.521 | 100.287833827893 | 338 | 4 | 100 | 1 | 1 | 337 | 21 | 358 | Uncultured crenarchaeote clone GFS3-135i 16S ribosomal RNA gene, partial sequence | blastn | 33797 | 595 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 20915661 | 20915661 | PRJNA550047_P_NODE_197837_length_343_cov_13.711111_g195876_i0 | PRJNA550047 | 197837 | 343 | 13.711111 | 47.02911073 | Candidatus Nitrososphaera evergladensis | 1459637 | Archaea | Archaea | 73.1 | 2.49e-8 | NTclustered | gi|665992324|gb|CP007174.1| | 1459636 | g195876 | i0 | 80.645 | 0.556851311953353 | 93 | 18 | 27 | 0 | 33 | 125 | 1288267 | 1288175 | Candidatus Nitrososphaera evergladensis SR1, complete genome | blastn | 191 | 73.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Candidatus Nitrososphaera evergladensis | ||
| 21524108 | 21524108 | PRJNA550047_P_NODE_539637_length_217_cov_7.861111_g537664_i0 | PRJNA550047 | 539637 | 217 | 7.861111 | 17.05861087 | root | 1 | Root_unresolved | Root_unresolved | 401 | 1.6499999999999994e-107 | NTclustered | gi|373125855|gb|JN567036.1| | 29281 | g537664 | i0 | 100 | 103 | 217 | 0 | 100 | 0 | 1 | 217 | 576 | 792 | Uncultured crenarchaeote clone DDOUBD11 16S ribosomal RNA gene, partial sequence | blastn | 22351 | 401 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 24073077 | 24073077 | PRJNA550047_P_NODE_342899_length_288_cov_4.516279_g340929_i0 | PRJNA550047 | 342899 | 288 | 4.516279 | 13.00688352 | Nitrososphaera | 497726 | Archaea | Archaea | 486 | 6.159999999999999e-133 | NTclustered | gi|300521484|gb|GU797787.1| | 497727 | g340929 | i0 | 97.213 | 103.006944444444 | 287 | 8 | 99 | 0 | 1 | 287 | 2135 | 1849 | Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence | blastn | 29666 | 486 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Candidatus Nitrososphaera gargensis | ||
| 25348402 | 25348402 | PRJNA550047_P_NODE_552140_length_213_cov_5.664286_g550167_i0 | PRJNA550047 | 552140 | 213 | 5.664286 | 12.06492918 | Thermoproteati | 1783275 | Archaea | Archaea | 388 | 1.26e-103 | NTclustered | gi|153865719|gb|EF450813.1| | 29281 | g550167 | i0 | 99.531 | 99.9906103286385 | 213 | 1 | 100 | 0 | 1 | 213 | 315 | 103 | Uncultured crenarchaeote clone CBS16S4-1-17 16S ribosomal RNA gene, partial sequence | blastn | 21298 | 388 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote |
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);;