contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 380796 | 380796 | PRJNA315314_S_NODE_19421_length_187_cov_4.044304_g19100_i0 | PRJNA315314 | 19421 | 187 | 4.044304 | 7.56284848 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 285 | 1.45e-72 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g19100 | i0 | 97.041 | 155.299465240642 | 169 | 5 | 90 | 0 | 19 | 187 | 2645218 | 2645050 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 29041 | 285 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 380929 | 380929 | PRJNA315314_S_NODE_27961_length_159_cov_5.684615_g27640_i0 | PRJNA315314 | 27961 | 159 | 5.684615 | 9.03853785 | Candidatus Nitrosotenuis aquarius | 1846278 | Archaea | Archaea | 289 | 9.22e-74 | NTclustered | gi|1279207014|gb|CP024808.1| | 1846278 | g27640 | i0 | 99.371 | 8.09433962264151 | 159 | 1 | 100 | 0 | 1 | 159 | 291672 | 291514 | Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome | blastn | 1287 | 289 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis aquarius | |||||
| 2340537 | 2340537 | PRJNA315314_S_NODE_18002_length_194_cov_3.824242_g17681_i0 | PRJNA315314 | 18002 | 194 | 3.824242 | 7.41902948 | Candidatus Nitrosotenuis | 1825023 | Archaea | Archaea | 342 | 8.869999999999999e-90 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g17681 | i0 | 98.454 | 39.4845360824742 | 194 | 3 | 100 | 0 | 1 | 194 | 738936 | 739129 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 7660 | 342 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 5484310 | 5484310 | PRJNA315314_S_NODE_23045_length_173_cov_14.256944_g22724_i0 | PRJNA315314 | 23045 | 173 | 14.256944 | 24.66451312 | Nanoarchaeum equitans | 160232 | Archaea | Archaea | 56.5 | 0.001 | NTclustered | gi|507148462|ref|NR_103265.1| | 228908 | g22724 | i0 | 100 | 0.520231213872832 | 30 | 0 | 17 | 0 | 115 | 144 | 49 | 20 | Nanoarchaeum equitans Kin4-M 5S ribosomal RNA, complete sequence | blastn | 90 | 56.5 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Nanoarchaeales | Nanoarchaeaceae | Nanoarchaeum | Nanoarchaeum equitans | ||
| 6758378 | 6758378 | PRJNA315314_S_NODE_15286_length_209_cov_4.477778_g14965_i0 | PRJNA315314 | 15286 | 209 | 4.477778 | 9.35855602 | Candidatus Nitrosotenuis aquarius | 1846278 | Archaea | Archaea | 387 | 4.42e-103 | NTclustered | gi|1279207014|gb|CP024808.1| | 1846278 | g14965 | i0 | 100 | 91.5023923444976 | 209 | 0 | 100 | 0 | 1 | 209 | 292060 | 291852 | Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome | blastn | 19124 | 387 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis aquarius | |||||
| 9308754 | 9308754 | PRJNA315314_S_NODE_17368_length_197_cov_6.101190_g17047_i0 | PRJNA315314 | 17368 | 197 | 6.10119 | 12.0193443 | Candidatus Nitrosotenuis aquarius | 1846278 | Archaea | Archaea | 191 | 3.46e-44 | NTclustered | gi|1279207014|gb|CP024808.1| | 1846278 | g17047 | i0 | 100 | 42.2842639593909 | 103 | 0 | 99 | 0 | 95 | 197 | 293854 | 293752 | Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome | blastn | 8330 | 191 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis aquarius | |||||
| 9309007 | 9309007 | PRJNA315314_S_NODE_4008_length_399_cov_3.956757_g3687_i0 | PRJNA315314 | 4008 | 399 | 3.956757 | 15.78746043 | uncultured marine group II/III euryarchaeote KM3_139_C07 | 1457870 | Archaea | Archaea | 52.8 | 0.038 | NTclustered | gi|663510147|gb|KF900602.1| | 1457870 | g3687 | i0 | 100 | 0.0701754385964912 | 28 | 0 | 7 | 0 | 135 | 162 | 28594 | 28567 | Uncultured marine group II/III euryarchaeote KM3_139_C07 genomic sequence | blastn | 28 | 52.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | uncultured marine group II/III euryarchaeote KM3_139_C07 | ||||||
| 11268538 | 11268538 | PRJNA315314_S_NODE_25709_length_165_cov_4.272059_g25388_i0 | PRJNA315314 | 25709 | 165 | 4.272059 | 7.04889735 | Thermoproteati | 1783275 | Archaea | Archaea | 300 | 4.46e-77 | NTclustered | gi|29468638|gb|AY157664.1| | 29281 | g25388 | i0 | 100 | 98.3454545454545 | 162 | 0 | 98 | 0 | 4 | 165 | 612 | 451 | Uncultured crenarchaeote clone VI96h1b 16S ribosomal RNA gene, partial sequence | blastn | 16227 | 300 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 16367782 | 16367782 | PRJNA315314_S_NODE_13973_length_218_cov_4.465608_g13652_i0 | PRJNA315314 | 13973 | 218 | 4.465608 | 9.73502544 | Candidatus Nitrosotenuis | 1825023 | Archaea | Archaea | 403 | 4.62e-108 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g13652 | i0 | 100 | 103.04128440367 | 218 | 0 | 100 | 0 | 1 | 218 | 741312 | 741095 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 22463 | 403 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 16958144 | 16958144 | PRJNA315314_S_NODE_1654_length_604_cov_5.311304_g1391_i0 | PRJNA315314 | 1654 | 604 | 5.311304 | 32.08027616 | Candidatus Nitrosotenuis aquarius | 1846278 | Archaea | Archaea | 1044 | 0 | NTclustered | gi|1279207014|gb|CP024808.1| | 1846278 | g1391 | i0 | 97.848 | 74.1539735099338 | 604 | 13 | 100 | 0 | 1 | 604 | 292655 | 292052 | Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome | blastn | 44789 | 1044 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis aquarius | |||||
| 19506865 | 19506865 | PRJNA315314_S_NODE_26496_length_163_cov_3.134328_g26175_i0 | PRJNA315314 | 26496 | 163 | 3.134328 | 5.10895464 | uncultured archaeon | 115547 | Archaea | Archaea | 56.5 | 0.001 | NTclustered | gi|765560206|gb|KP308707.1| | 115547 | g26175 | i0 | 94.595 | 0.619631901840491 | 37 | 0 | 23 | 2 | 114 | 150 | 10645 | 10611 | Uncultured archaeon clone gwa2_scaffold_17898 genomic sequence | blastn | 101 | 56.5 | 1 | Archaea | uncultured archaeon | ||||||||
| 20782296 | 20782296 | PRJNA315314_S_NODE_19397_length_187_cov_5.791139_g19076_i0 | PRJNA315314 | 19397 | 187 | 5.791139 | 10.82942993 | Candidatus Nitrosotenuis aquarius | 1846278 | Archaea | Archaea | 344 | 2.36e-90 | NTclustered | gi|1279207014|gb|CP024808.1| | 1846278 | g19076 | i0 | 100 | 87.6898395721925 | 186 | 0 | 99 | 0 | 2 | 187 | 293282 | 293097 | Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome | blastn | 16398 | 344 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis aquarius | |||||
| 21467120 | 21467120 | PRJNA315314_S_NODE_30257_length_154_cov_3.424000_g29936_i0 | PRJNA315314 | 30257 | 154 | 3.424 | 5.27296 | Halococcus | 2249 | Archaea | Archaea | 285 | 1.14e-72 | NTclustered | gi|43626|emb|X05481.1| | 2250 | g29936 | i0 | 100 | 168 | 154 | 0 | 100 | 0 | 1 | 154 | 2118 | 1965 | Halococcus morrhuae 23S ribosomal RNA | blastn | 25872 | 285 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus morrhuae |
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);;