contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA859990" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 845899 | 845899 | PRJNA859990_S_NODE_2341_length_603_cov_1.967925_g2085_i0 | PRJNA859990 | 2341 | 603 | 1.967925 | 11.86658775 | Methanobrevibacter sp. YE315 | 1609968 | Archaea | Archaea | 939 | 0 | NTclustered | gi|985614202|gb|CP010834.1| | 1609968 | g2085 | i0 | 94.868 | 69.8789386401327 | 604 | 26 | 100 | 5 | 1 | 603 | 494571 | 495170 | Methanobrevibacter sp. YE315, complete genome | blastn | 42137 | 939 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. YE315 | |
| 2511589 | 2511589 | PRJNA859990_S_NODE_15862_length_263_cov_1.531579_g15601_i0 | PRJNA859990 | 15862 | 263 | 1.531579 | 4.02805277 | Methanobrevibacter | 2172 | Archaea | Archaea | 335 | 2.129999999999999e-87 | NTclustered | gi|1294447101|gb|CP017803.1| | 2173 | g15601 | i0 | 100 | 89.106463878327 | 181 | 0 | 69 | 0 | 11 | 191 | 266547 | 266367 | Methanobrevibacter smithii strain KB11 chromosome, complete genome | blastn | 23435 | 335 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 4674298 | 4674298 | PRJNA859990_S_NODE_15724_length_264_cov_2.450262_g15463_i0 | PRJNA859990 | 15724 | 264 | 2.450262 | 6.46869168 | Methanobrevibacter sp. YE315 | 1609968 | Archaea | Archaea | 399 | 7.479999999999998e-107 | NTclustered | gi|985614202|gb|CP010834.1| | 1609968 | g15463 | i0 | 93.962 | 96.1856060606061 | 265 | 14 | 100 | 2 | 1 | 264 | 496019 | 496282 | Methanobrevibacter sp. YE315, complete genome | blastn | 25393 | 399 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. YE315 | |
| 6339973 | 6339973 | PRJNA859990_S_NODE_11445_length_303_cov_1.004348_g11184_i0 | PRJNA859990 | 11445 | 303 | 1.004348 | 3.04317444 | root | 1 | Root_unresolved | Root_unresolved | 560 | 3.79e-155 | NTclustered | gi|436492|gb|U00707.1|PSU00707 | 33866 | g11184 | i0 | 100 | 10.6105610561056 | 303 | 0 | 100 | 0 | 1 | 303 | 4238 | 3936 | Pyrococcus sp. Deep Vent DNA polymerase precursor gene, complete cds | blastn | 3215 | 560 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus sp. | ||
| 7224197 | 7224197 | PRJNA859990_S_NODE_7926_length_355_cov_1.411348_g7665_i0 | PRJNA859990 | 7926 | 355 | 1.411348 | 5.0102854 | Candidatus Methanoplasma termitum | 1577791 | Archaea | Archaea | 383 | 1.0499999999999998e-101 | NTclustered | gi|731480732|gb|CP010070.1| | 1577791 | g7665 | i0 | 98.611 | 319.047887323944 | 216 | 3 | 61 | 0 | 71 | 286 | 162129 | 162344 | Candidatus Methanoplasma termitum strain MpT1, complete genome | blastn | 113262 | 383 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Candidatus Methanoplasma | Candidatus Methanoplasma termitum | ||
| 12715654 | 12715654 | PRJNA859990_S_NODE_19670_length_246_cov_1.537572_g19409_i0 | PRJNA859990 | 19670 | 246 | 1.537572 | 3.78242712 | Methanobrevibacter | 2172 | Archaea | Archaea | 444 | 3.14e-120 | NTclustered | gi|968564921|gb|CP011266.1| | 230361 | g19409 | i0 | 99.187 | 161.979674796748 | 246 | 2 | 100 | 0 | 1 | 246 | 543076 | 543321 | Methanobrevibacter millerae strain SM9, complete genome | blastn | 39847 | 444 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter millerae | |
| 17813684 | 17813684 | PRJNA859990_S_NODE_6314_length_393_cov_1.593750_g6053_i0 | PRJNA859990 | 6314 | 393 | 1.59375 | 6.2634375 | Methanobrevibacter | 2172 | Archaea | Archaea | 704 | 0 | NTclustered | gi|968564921|gb|CP011266.1| | 230361 | g6053 | i0 | 98.982 | 144.534351145038 | 393 | 4 | 100 | 0 | 1 | 393 | 542667 | 542275 | Methanobrevibacter millerae strain SM9, complete genome | blastn | 56802 | 704 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter millerae | |
| 19972590 | 19972590 | PRJNA859990_S_NODE_8376_length_346_cov_3.098901_g8115_i0 | PRJNA859990 | 8376 | 346 | 3.098901 | 10.72219746 | uncultured Methanocorpusculum sp. | 176309 | Archaea | Archaea | 259 | 1.8e-64 | NTclustered | gi|2621786121|emb|OY782579.1| | 176309 | g8115 | i0 | 89.1 | 332.115606936416 | 211 | 19 | 60 | 3 | 65 | 272 | 98154 | 98363 | MAG: uncultured Methanocorpusculum sp. isolate 00e4b8a3-32d7-4b6d-ae68-a36d250ebca6 genome assembly, chromosome: 1 | blastn | 114912 | 259 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | uncultured Methanocorpusculum sp. | |
| 25072152 | 25072152 | PRJNA859990_S_NODE_8300_length_348_cov_1.469091_g8039_i0 | PRJNA859990 | 8300 | 348 | 1.469091 | 5.11243668 | Methanobrevibacter sp. YE315 | 1609968 | Archaea | Archaea | 204 | 8.599999999999999e-48 | NTclustered | gi|985614202|gb|CP010834.1| | 1609968 | g8039 | i0 | 89.937 | 171.988505747126 | 159 | 15 | 46 | 1 | 124 | 282 | 1994660 | 1994503 | Methanobrevibacter sp. YE315, complete genome | blastn | 59852 | 204 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. YE315 |
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);;