contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJEB75230" and tax_kingdom = "Methanobacteriati"
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 | |
| 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 | |
| 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 | |
| 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);;