contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA630162" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 601827 | 601827 | PRJNA630162_P_NODE_157541_length_163_cov_0.912281_g156018_i0 | PRJNA630162 | 157541 | 163 | 0.912281 | 1.48701803 | Candidatus Nitrosocosmicus franklandianus | 1798806 | Archaea | Archaea | 54.7 | 0.004 | NTclustered | gi|1599533355|emb|LR216287.1| | 1798806 | g156018 | i0 | 94.444 | 0.220858895705521 | 36 | 1 | 21 | 1 | 71 | 105 | 44829 | 44864 | Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN | blastn | 36 | 54.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus franklandianus | ||
| 4430425 | 4430425 | PRJNA630162_P_NODE_84984_length_196_cov_1.789116_g83461_i0 | PRJNA630162 | 84984 | 196 | 1.789116 | 3.50666736 | Nitrosarchaeum sp. AC2 | 2259673 | Archaea | Archaea | 342 | 8.979999999999999e-90 | NTclustered | gi|1869229208|gb|CP030847.1| | 2259673 | g83461 | i0 | 98.454 | 34.2142857142857 | 194 | 3 | 99 | 0 | 1 | 194 | 1087630 | 1087823 | Nitrosarchaeum sp. AC2 chromosome, complete genome | blastn | 6706 | 342 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. AC2 | ||
| 6980781 | 6980781 | PRJNA630162_P_NODE_40786_length_278_cov_3.087336_g39263_i0 | PRJNA630162 | 40786 | 278 | 3.087336 | 8.58279408 | Nitrosarchaeum sp. AC2 | 2259673 | Archaea | Archaea | 468 | 2.14e-127 | NTclustered | gi|1869229208|gb|CP030847.1| | 2259673 | g39263 | i0 | 97.786 | 50.6654676258993 | 271 | 6 | 97 | 0 | 3 | 273 | 1087115 | 1087385 | Nitrosarchaeum sp. AC2 chromosome, complete genome | blastn | 14085 | 468 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. AC2 | ||
| 9530916 | 9530916 | PRJNA630162_P_NODE_52908_length_242_cov_2.331606_g51385_i0 | PRJNA630162 | 52908 | 242 | 2.331606 | 5.64248652 | Candidatus Nitrosotalea okcheonensis | 1903276 | Archaea | Archaea | 348 | 2.48e-91 | NTclustered | gi|1279331958|emb|LT841358.1| | 1903276 | g51385 | i0 | 99.476 | 52.7561983471074 | 191 | 1 | 98 | 0 | 1 | 191 | 994017 | 994207 | Nitrosotalea sp. CS isolate NCS1 genome assembly, chromosome: 1 | blastn | 12767 | 348 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosotaleales | Nitrosotaleaceae | Nitrosotalea | Candidatus Nitrosotalea okcheonensis | ||
| 9531351 | 9531351 | PRJNA630162_P_NODE_97528_length_187_cov_1.500000_g96005_i0 | PRJNA630162 | 97528 | 187 | 1.5 | 2.805 | Nitrosotalea devaniterrae | 1078905 | Archaea | Archaea | 333 | 5.1e-87 | NTclustered | gi|1003583480|emb|LN890280.1| | 1078905 | g96005 | i0 | 99.454 | 25.4652406417112 | 183 | 1 | 98 | 0 | 1 | 183 | 1345094 | 1345276 | Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 | blastn | 4762 | 333 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosotaleales | Nitrosotaleaceae | Nitrosotalea | Nitrosotalea devaniterrae | ||
| 10806858 | 10806858 | PRJNA630162_P_NODE_78949_length_202_cov_3.496732_g77426_i0 | PRJNA630162 | 78949 | 202 | 3.496732 | 7.06339864 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 355 | 1.2e-93 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g77426 | i0 | 99.487 | 17.8465346534653 | 195 | 1 | 97 | 0 | 2 | 196 | 848236 | 848042 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 3605 | 355 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 11354524 | 11354524 | PRJNA630162_P_NODE_118389_length_175_cov_1.896825_g116866_i0 | PRJNA630162 | 118389 | 175 | 1.896825 | 3.31944375 | Nitrosotalea | 1078904 | Archaea | Archaea | 231 | 1.76e-56 | NTclustered | gi|1003583480|emb|LN890280.1| | 1078905 | g116866 | i0 | 91.176 | 52.4 | 170 | 15 | 97 | 0 | 6 | 175 | 1345521 | 1345352 | Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 | blastn | 9170 | 231 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosotaleales | Nitrosotaleaceae | Nitrosotalea | Nitrosotalea devaniterrae | ||
| 12630687 | 12630687 | PRJNA630162_P_NODE_75830_length_206_cov_3.853503_g74307_i0 | PRJNA630162 | 75830 | 206 | 3.853503 | 7.93821618 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 374 | 3.3799999999999997e-99 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g74307 | i0 | 100 | 21.8883495145631 | 202 | 0 | 98 | 0 | 5 | 206 | 848425 | 848626 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 4509 | 374 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 17180392 | 17180392 | PRJNA630162_P_NODE_52634_length_243_cov_1.262887_g51111_i0 | PRJNA630162 | 52634 | 243 | 1.262887 | 3.06881541 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 411 | 3.14e-110 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g51111 | i0 | 97.119 | 19.761316872428 | 243 | 7 | 100 | 0 | 1 | 243 | 849305 | 849547 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 4802 | 411 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 18453734 | 18453734 | PRJNA630162_P_NODE_146315_length_165_cov_1.750000_g144792_i0 | PRJNA630162 | 146315 | 165 | 1.75 | 2.8875 | Nitrosotalea devaniterrae | 1078905 | Archaea | Archaea | 276 | 7.52e-70 | NTclustered | gi|1003583480|emb|LN890280.1| | 1078905 | g144792 | i0 | 97.516 | 21.2181818181818 | 161 | 4 | 98 | 0 | 5 | 165 | 1346387 | 1346227 | Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 | blastn | 3501 | 276 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosotaleales | Nitrosotaleaceae | Nitrosotalea | Nitrosotalea devaniterrae | ||
| 18454613 | 18454613 | PRJNA630162_P_NODE_69255_length_213_cov_2.097561_g67732_i0 | PRJNA630162 | 69255 | 213 | 2.097561 | 4.46780493 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 206 | 1.36e-48 | NTclustered | gi|2621701204|emb|OY759726.1| | 2024843 | g67732 | i0 | 94.074 | 30.2065727699531 | 135 | 8 | 63 | 0 | 41 | 175 | 1441143 | 1441009 | MAG: Nitrosopumilus sp. isolate 673f8e26-873e-4515-b19f-a0e48533455e genome assembly, chromosome: 1 | blastn | 6434 | 206 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 19002564 | 19002564 | PRJNA630162_P_NODE_107495_length_181_cov_1.560606_g105972_i0 | PRJNA630162 | 107495 | 181 | 1.560606 | 2.82469686 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 318 | 1.37e-82 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g105972 | i0 | 100 | 84.3314917127072 | 172 | 0 | 95 | 0 | 1 | 172 | 848031 | 847860 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 15264 | 318 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 21553235 | 21553235 | PRJNA630162_P_NODE_166377_length_158_cov_2.091743_g164854_i0 | PRJNA630162 | 166377 | 158 | 2.091743 | 3.30495394 | Candidatus Nitrosotenuis | 1825023 | Archaea | Archaea | 274 | 2.56e-69 | NTclustered | gi|2551106379|gb|CP130341.1| | 1353246 | g164854 | i0 | 98.701 | 4.53164556962025 | 154 | 2 | 97 | 0 | 5 | 158 | 1484999 | 1484846 | Candidatus Nitrosotenuis chungbukensis strain MY2 chromosome, complete genome | blastn | 716 | 274 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis chungbukensis | |||||
| 23555091 | 23555091 | PRJNA630162_P_NODE_63699_length_221_cov_3.645349_g62176_i0 | PRJNA630162 | 63699 | 221 | 3.645349 | 8.05622129 | Nitrosarchaeum sp. AC2 | 2259673 | Archaea | Archaea | 355 | 1.33e-93 | NTclustered | gi|1869229208|gb|CP030847.1| | 2259673 | g62176 | i0 | 95.89 | 57.6651583710407 | 219 | 9 | 99 | 0 | 1 | 219 | 1086142 | 1086360 | Nitrosarchaeum sp. AC2 chromosome, complete genome | blastn | 12744 | 355 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. AC2 | ||
| 24828627 | 24828627 | PRJNA630162_P_NODE_50820_length_247_cov_2.595960_g49297_i0 | PRJNA630162 | 50820 | 247 | 2.59596 | 6.4120212 | Nitrosarchaeum sp. AC2 | 2259673 | Archaea | Archaea | 422 | 1.48e-113 | NTclustered | gi|1869229208|gb|CP030847.1| | 2259673 | g49297 | i0 | 98.333 | 82.3967611336032 | 240 | 4 | 97 | 0 | 2 | 241 | 1085118 | 1085357 | Nitrosarchaeum sp. AC2 chromosome, complete genome | blastn | 20352 | 422 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. AC2 |
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);;