contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA606583" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2421855 | 2421855 | PRJNA606583_P_NODE_4322_length_639_cov_2.440199_g3953_i0 | PRJNA606583 | 4322 | 639 | 2.440199 | 15.59287161 | Thermoproteati | 1783275 | Archaea | Archaea | 957 | 0 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g3953 | i0 | 94.286 | 39.9859154929577 | 630 | 29 | 98 | 5 | 12 | 638 | 6179 | 6804 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 25551 | 957 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 7524129 | 7524129 | PRJNA606583_P_NODE_25006_length_223_cov_3.688172_g24577_i0 | PRJNA606583 | 25006 | 223 | 3.688172 | 8.22462356 | Nitrososphaera | 497726 | Archaea | Archaea | 357 | 3.75e-94 | NTclustered | gi|647810480|gb|CP007536.1| | 926571 | g24577 | i0 | 95.536 | 115.363228699552 | 224 | 9 | 100 | 1 | 1 | 223 | 892346 | 892123 | Nitrososphaera viennensis EN76, complete genome | blastn | 25726 | 357 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera viennensis | ||
| 10787799 | 10787799 | PRJNA606583_P_NODE_16209_length_311_cov_2.927007_g15780_i0 | PRJNA606583 | 16209 | 311 | 2.927007 | 9.10299177 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 507 | 5.16e-139 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g15780 | i0 | 96.129 | 107.659163987138 | 310 | 12 | 99 | 0 | 1 | 310 | 849022 | 848713 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 33482 | 507 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 10787898 | 10787898 | PRJNA606583_P_NODE_32929_length_180_cov_1.615385_g32500_i0 | PRJNA606583 | 32929 | 180 | 1.615385 | 2.907693 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 278 | 2.31e-70 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g32500 | i0 | 94.475 | 7.38333333333333 | 181 | 9 | 100 | 1 | 1 | 180 | 3035528 | 3035708 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 1329 | 278 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 12625631 | 12625631 | PRJNA606583_P_NODE_5970_length_555_cov_3.428571_g5566_i0 | PRJNA606583 | 5970 | 555 | 3.428571 | 19.02856905 | Thermoproteati | 1783275 | Archaea | Archaea | 959 | 0 | NTclustered | gi|220683870|gb|FJ468481.1| | 29281 | g5566 | i0 | 98.179 | 102.495495495495 | 549 | 10 | 99 | 0 | 7 | 555 | 1435 | 887 | Uncultured crenarchaeote clone M72 16S ribosomal RNA gene, partial sequence | blastn | 56885 | 959 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 16448841 | 16448841 | PRJNA606583_P_NODE_14513_length_336_cov_2.862876_g14085_i0 | PRJNA606583 | 14513 | 336 | 2.862876 | 9.61926336 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 575 | 1.5199999999999994e-159 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g14085 | i0 | 97.612 | 32.2380952380952 | 335 | 8 | 99 | 0 | 2 | 336 | 849395 | 849061 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 10832 | 579 | 0.993091537132988 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 20273121 | 20273121 | PRJNA606583_P_NODE_636_length_1306_cov_2.607565_g492_i0 | PRJNA606583 | 636 | 1306 | 2.607565 | 34.0547989 | Nitrososphaera | 497726 | Archaea | Archaea | 2041 | 0 | NTclustered | gi|507148386|ref|NR_103189.1| | 497727 | g492 | i0 | 94.87 | 97.8728943338438 | 1306 | 67 | 100 | 0 | 1 | 1306 | 2911 | 1606 | Candidatus Nitrososphaera gargensis strain Ga9.2 23S ribosomal RNA gene, complete sequence | blastn | 127822 | 2041 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Candidatus Nitrososphaera gargensis |
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);;