contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJEB75230" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3962206 | 3962206 | PRJEB75230_P_NODE_127244_length_250_cov_0.870056_g127062_i0 | PRJEB75230 | 127244 | 250 | 0.870056 | 2.17514 | Methanococcus maripaludis | 39152 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|132662671|gb|CP000609.1| | 402880 | g127062 | i0 | 100 | 0.224 | 28 | 0 | 11 | 0 | 188 | 215 | 481881 | 481908 | Methanococcus maripaludis C5, complete genome | blastn | 56 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus maripaludis | |
| 3962828 | 3962828 | PRJEB75230_P_NODE_173624_length_242_cov_0.911243_g173442_i0 | PRJEB75230 | 173624 | 242 | 0.911243 | 2.20520806 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 99 | 2.76e-16 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g173442 | i0 | 84.314 | 0.421487603305785 | 102 | 14 | 42 | 2 | 141 | 241 | 1335935 | 1335835 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 102 | 99 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 4823788 | 4823788 | PRJEB75230_P_NODE_11064_length_455_cov_1.460733_g10882_i0 | PRJEB75230 | 11064 | 455 | 1.460733 | 6.64633515 | root | 1 | Root_unresolved | Root_unresolved | 841 | 0 | NTclustered | gi|471648006|gb|KC661715.1| | 29281 | g10882 | i0 | 100 | 100 | 455 | 0 | 100 | 0 | 1 | 455 | 117 | 571 | Uncultured crenarchaeote clone BC-M-Sd-S1-D8 16S ribosomal RNA gene, partial sequence | blastn | 45500 | 841 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 4824204 | 4824204 | PRJEB75230_P_NODE_49124_length_313_cov_1.604167_g48942_i0 | PRJEB75230 | 49124 | 313 | 1.604167 | 5.02104271 | root | 1 | Root_unresolved | Root_unresolved | 87.9 | 8.03e-13 | NTclustered | gi|2388587735|gb|CP113361.1| | 2199 | g48942 | i0 | 88.732 | 1.23003194888179 | 71 | 8 | 23 | 0 | 194 | 264 | 1189421 | 1189351 | Methanogenium organophilum strain DSM 3596 chromosome, complete genome | blastn | 385 | 87.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium organophilum | |
| 5238402 | 5238402 | PRJEB75230_P_NODE_112245_length_254_cov_1.977901_g112063_i0 | PRJEB75230 | 112245 | 254 | 1.977901 | 5.02386854 | Methanococcus voltae | 2188 | Archaea | Archaea | 54.7 | 0.006 | NTclustered | gi|2891705001|gb|CP178160.1| | 523842 | g112063 | i0 | 100 | 0.114173228346457 | 29 | 0 | 11 | 0 | 129 | 157 | 475071 | 475099 | Methanococcus voltae PS chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus voltae | |
| 11615835 | 11615835 | PRJEB75230_P_NODE_46450_length_317_cov_1.577869_g46268_i0 | PRJEB75230 | 46450 | 317 | 1.577869 | 5.00184473 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 492 | 1.48e-134 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g46268 | i0 | 94.654 | 87.3596214511041 | 318 | 15 | 100 | 2 | 1 | 317 | 42608 | 42292 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 27693 | 492 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 12474958 | 12474958 | PRJEB75230_P_NODE_24530_length_366_cov_1.385666_g24348_i0 | PRJEB75230 | 24530 | 366 | 1.385666 | 5.07153756 | Thermoproteati | 1783275 | Archaea | Archaea | 503 | 7.98e-138 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g24348 | i0 | 91.53 | 112.125683060109 | 366 | 30 | 100 | 1 | 1 | 366 | 7281 | 6917 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 41038 | 503 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 13749554 | 13749554 | PRJEB75230_P_NODE_46511_length_317_cov_1.299180_g46329_i0 | PRJEB75230 | 46511 | 317 | 1.29918 | 4.1184006 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.002 | NTclustered | gi|2324023557|gb|CP109979.1| | 2934937 | g46329 | i0 | 100 | 1.12618296529968 | 30 | 0 | 9 | 0 | 288 | 317 | 1129155 | 1129184 | Halocatena marina strain QDMS1 chromosome, complete genome | blastn | 357 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halocatena | Halocatena marina | |
| 17988837 | 17988837 | PRJEB75230_P_NODE_47275_length_316_cov_1.267490_g47093_i0 | PRJEB75230 | 47275 | 316 | 1.26749 | 4.0052684 | uncultured Methanobacteriaceae archaeon | 176233 | Archaea | Archaea | 52.8 | 0.03 | NTclustered | gi|2874253877|emb|OY969932.1| | 176233 | g47093 | i0 | 100 | 0.0886075949367089 | 28 | 0 | 9 | 0 | 93 | 120 | 1240580 | 1240553 | MAG: uncultured Methanobacteriaceae archaeon isolate MFD09286.bin.c.5 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | uncultured Methanobacteriaceae archaeon | ||
| 19262459 | 19262459 | PRJEB75230_P_NODE_23856_length_369_cov_1.040541_g23674_i0 | PRJEB75230 | 23856 | 369 | 1.040541 | 3.83959629 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 571 | 2.1799999999999993e-158 | NTclustered | gi|2221492933|gb|CP095007.1| | 179637 | g23674 | i0 | 94.595 | 148.49864498645 | 370 | 19 | 100 | 1 | 1 | 369 | 129959 | 129590 | Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence | blastn | 54796 | 571 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 20537466 | 20537466 | PRJEB75230_P_NODE_162437_length_244_cov_0.900585_g162255_i0 | PRJEB75230 | 162437 | 244 | 0.900585 | 2.1974274 | Methanosarcina barkeri | 2208 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|805403216|gb|CP009528.1| | 1434108 | g162255 | i0 | 94.286 | 0.14344262295082 | 35 | 1 | 14 | 1 | 195 | 228 | 1624588 | 1624622 | Methanosarcina barkeri MS, complete genome | blastn | 35 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 20538894 | 20538894 | PRJEB75230_P_NODE_90737_length_271_cov_1.166667_g90555_i0 | PRJEB75230 | 90737 | 271 | 1.166667 | 3.16166757 | uncultured archaeon | 115547 | Archaea | Archaea | 483 | 7.44e-132 | NTclustered | gi|440501403|gb|JX396691.1| | 115547 | g90555 | i0 | 98.889 | 99.6420664206642 | 270 | 3 | 99 | 0 | 1 | 270 | 278 | 547 | Uncultured archaeon clone NYS002507 16S ribosomal RNA gene, partial sequence | blastn | 27003 | 483 | 1 | Archaea | uncultured archaeon | ||||||||
| 24363171 | 24363171 | PRJEB75230_P_NODE_49860_length_312_cov_1.610879_g49678_i0 | PRJEB75230 | 49860 | 312 | 1.610879 | 5.02594248 | Methanobrevibacter arboriphilus | 39441 | Archaea | Archaea | 54.7 | 0.008 | NTclustered | gi|2047640843|dbj|AP019779.1| | 39441 | g49678 | i0 | 94.286 | 0.112179487179487 | 35 | 2 | 11 | 0 | 3 | 37 | 1418270 | 1418304 | Methanobrevibacter arboriphilus SA DNA, complete genome | blastn | 35 | 54.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter arboriphilus |
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);;