contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA674048" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4994274 | 4994274 | PRJNA674048_P_NODE_23644_length_181_cov_1.181818_g23441_i0 | PRJNA674048 | 23644 | 181 | 1.181818 | 2.13909058 | root | 1 | Root_unresolved | Root_unresolved | 335 | 1.36e-87 | NTclustered | gi|253971047|gb|GQ249655.1| | 29281 | g23441 | i0 | 100 | 99.9889502762431 | 181 | 0 | 100 | 0 | 1 | 181 | 317 | 497 | Uncultured crenarchaeote clone D06-arc 16S ribosomal RNA gene, partial sequence | blastn | 18098 | 335 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 6270001 | 6270001 | PRJNA674048_P_NODE_29445_length_166_cov_0.888889_g29242_i0 | PRJNA674048 | 29445 | 166 | 0.888889 | 1.47555574 | Halalkalicoccus | 332246 | Archaea | Archaea | 292 | 7.52e-75 | NTclustered | gi|507148368|ref|NR_103171.1| | 413810 | g29242 | i0 | 98.78 | 178.030120481928 | 164 | 2 | 99 | 0 | 3 | 166 | 1262 | 1099 | Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence | blastn | 29553 | 292 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 6270036 | 6270036 | PRJNA674048_P_NODE_31645_length_163_cov_0.912281_g31442_i0 | PRJNA674048 | 31645 | 163 | 0.912281 | 1.48701803 | Haloarcula | 2237 | Archaea | Archaea | 132 | 1.7e-26 | NTclustered | gi|343781660|gb|CP002921.1| | 634497 | g31442 | i0 | 84.733 | 5.77914110429448 | 131 | 20 | 80 | 0 | 30 | 160 | 2336111 | 2336241 | Haloarcula hispanica ATCC 33960 chromosome I, complete sequence | blastn | 942 | 132 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula hispanica | |
| 19017566 | 19017566 | PRJNA674048_P_NODE_14895_length_232_cov_2.841530_g14692_i0 | PRJNA674048 | 14895 | 232 | 2.84153 | 6.5923496 | root | 1 | Root_unresolved | Root_unresolved | 429 | 8.2e-116 | NTclustered | gi|3108087|gb|AF058730.1| | 75624 | g14692 | i0 | 100 | 100 | 232 | 0 | 100 | 0 | 1 | 232 | 481 | 712 | Uncultured crenarchaeote KBSNat20 16S ribosomal RNA gene, partial sequence | blastn | 23200 | 429 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote KBSNat20 | ||||||
| 21045703 | 21045703 | PRJNA674048_P_NODE_30577_length_164_cov_1.808696_g30374_i0 | PRJNA674048 | 30577 | 164 | 1.808696 | 2.96626144 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 303 | 3.42e-78 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g30374 | i0 | 100 | 19.4024390243902 | 164 | 0 | 100 | 0 | 1 | 164 | 848071 | 848234 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 3182 | 303 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 21568154 | 21568154 | PRJNA674048_P_NODE_27277_length_169_cov_0.866667_g27074_i0 | PRJNA674048 | 27277 | 169 | 0.866667 | 1.46466723 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 313 | 5.859999999999999e-81 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g27074 | i0 | 100 | 85.3846153846154 | 169 | 0 | 100 | 0 | 1 | 169 | 847994 | 847826 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 14430 | 313 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 22843268 | 22843268 | PRJNA674048_P_NODE_10418_length_291_cov_0.979339_g10215_i0 | PRJNA674048 | 10418 | 291 | 0.979339 | 2.84987649 | Halalkalicoccus | 332246 | Archaea | Archaea | 483 | 8.069999999999998e-132 | NTclustered | gi|507148368|ref|NR_103171.1| | 413810 | g10215 | i0 | 96.564 | 77.7938144329897 | 291 | 10 | 100 | 0 | 1 | 291 | 383 | 93 | Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence | blastn | 22638 | 483 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 25392378 | 25392378 | PRJNA674048_P_NODE_18820_length_204_cov_1.270968_g18617_i0 | PRJNA674048 | 18820 | 204 | 1.270968 | 2.59277472 | Archaea | 2157 | Archaea | Archaea | 377 | 2.59e-100 | NTclustered | gi|315585451|gb|HQ647201.1| | 29281 | g18617 | i0 | 100 | 102 | 204 | 0 | 100 | 0 | 1 | 204 | 62 | 265 | Uncultured crenarchaeote clone Hm5_rock_SK477 16S ribosomal RNA gene, partial sequence | blastn | 20808 | 377 | 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);;