contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6742231 | 6742231 | PRJNA168635_P_NODE_26746_length_167_cov_2.635593_g26330_i0 | PRJNA168635 | 26746 | 167 | 2.635593 | 4.40144031 | Nitrosarchaeum sp. AC2 | 2259673 | Archaea | Archaea | 298 | 1.63e-76 | NTclustered | gi|1869229208|gb|CP030847.1| | 2259673 | g26330 | i0 | 98.802 | 87.4071856287425 | 167 | 2 | 100 | 0 | 1 | 167 | 1085478 | 1085644 | Nitrosarchaeum sp. AC2 chromosome, complete genome | blastn | 14597 | 298 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. AC2 | ||
| 8017762 | 8017762 | PRJNA168635_P_NODE_19067_length_185_cov_5.345588_g18651_i0 | PRJNA168635 | 19067 | 185 | 5.345588 | 9.8893378 | Nitrosarchaeum sp. AC2 | 2259673 | Archaea | Archaea | 315 | 1.8199999999999998e-81 | NTclustered | gi|1869229208|gb|CP030847.1| | 2259673 | g18651 | i0 | 97.814 | 66.9783783783784 | 183 | 3 | 98 | 1 | 4 | 185 | 1086793 | 1086611 | Nitrosarchaeum sp. AC2 chromosome, complete genome | blastn | 12391 | 315 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. AC2 | ||
| 10568445 | 10568445 | PRJNA168635_P_NODE_16809_length_195_cov_1.664384_g16393_i0 | PRJNA168635 | 16809 | 195 | 1.664384 | 3.2455488 | Vulcanisaeta moutnovskia | 985052 | Archaea | Archaea | 52.8 | 0.017 | NTclustered | gi|323706731|gb|CP002529.1| | 985053 | g16393 | i0 | 100 | 0.143589743589744 | 28 | 0 | 14 | 0 | 48 | 75 | 336127 | 336100 | Vulcanisaeta moutnovskia 768-28, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Vulcanisaeta | Vulcanisaeta moutnovskia | ||
| 11257479 | 11257479 | PRJNA168635_P_NODE_19429_length_184_cov_2.074074_g19013_i0 | PRJNA168635 | 19429 | 184 | 2.074074 | 3.81629616 | Nitrosopumilaceae | 338190 | Archaea | Archaea | 204 | 4.09e-48 | NTclustered | gi|2578657680|emb|OY734804.1| | 517606 | g19013 | i0 | 97.5 | 27.4891304347826 | 120 | 2 | 65 | 1 | 1 | 119 | 2021562 | 2021681 | MAG: uncultured Candidatus Nitrosopumilus sp. isolate 747c7c57-5778-48a1-9692-2c317674f599 genome assembly, chromosome: 1 | blastn | 5058 | 204 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | uncultured Candidatus Nitrosopumilus sp. | ||
| 12532939 | 12532939 | PRJNA168635_P_NODE_31190_length_163_cov_0.912281_g30774_i0 | PRJNA168635 | 31190 | 163 | 0.912281 | 1.48701803 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 291 | 2.64e-74 | NTclustered | gi|1599533355|emb|LR216287.1| | 1798806 | g30774 | i0 | 98.773 | 15.2024539877301 | 163 | 2 | 100 | 0 | 1 | 163 | 184 | 22 | Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN | blastn | 2478 | 291 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus franklandianus | ||
| 23316545 | 23316545 | PRJNA168635_P_NODE_20039_length_182_cov_1.857143_g19623_i0 | PRJNA168635 | 20039 | 182 | 1.857143 | 3.38000026 | Nitrosarchaeum sp. AC2 | 2259673 | Archaea | Archaea | 309 | 8.32e-80 | NTclustered | gi|1869229208|gb|CP030847.1| | 2259673 | g19623 | i0 | 98.305 | 15.532967032967 | 177 | 2 | 97 | 1 | 1 | 176 | 1087096 | 1086920 | Nitrosarchaeum sp. AC2 chromosome, complete genome | blastn | 2827 | 309 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. AC2 | ||
| 25280222 | 25280222 | PRJNA168635_P_NODE_14960_length_208_cov_1.301887_g14544_i0 | PRJNA168635 | 14960 | 208 | 1.301887 | 2.70792496 | Nitrosopumilaceae | 338190 | Archaea | Archaea | 357 | 3.4499999999999996e-94 | NTclustered | gi|1869221159|gb|CP026993.1| | 1470066 | g14544 | i0 | 97.596 | 100.754807692308 | 208 | 5 | 100 | 0 | 1 | 208 | 593491 | 593698 | Nitrosopumilus cobalaminigenes strain HCA1 chromosome, complete genome | blastn | 20957 | 357 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus cobalaminigenes |
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);;