contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA385073" and tax_phylum = "Thermoplasmatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1680679 | 1680679 | PRJNA385073_P_NODE_29902_length_279_cov_1.888350_g29740_i0 | PRJNA385073 | 29902 | 279 | 1.88835 | 5.2684965 | Methanomassiliicoccaceae archaeon | 2052168 | Archaea | Archaea | 455 | 1.68e-123 | NTclustered | gi|2621703346|emb|OY760646.1| | 2052168 | g29740 | i0 | 96.057 | 1.36559139784946 | 279 | 11 | 100 | 0 | 1 | 279 | 447915 | 447637 | MAG: Methanomassiliicoccaceae archaeon isolate 2dded12f-1c8b-4e4a-b374-f87b1937d54c genome assembly, chromosome: 1 | blastn | 381 | 455 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Methanomassiliicoccaceae archaeon | |||
| 4233349 | 4233349 | PRJNA385073_P_NODE_49484_length_246_cov_1.531792_g49322_i0 | PRJNA385073 | 49484 | 246 | 1.531792 | 3.76820832 | Methanomassiliicoccaceae archaeon | 2052168 | Archaea | Archaea | 263 | 9.430000000000001e-66 | NTclustered | gi|2621703346|emb|OY760646.1| | 2052168 | g49322 | i0 | 86.235 | 2.60569105691057 | 247 | 29 | 99 | 5 | 3 | 246 | 447656 | 447900 | MAG: Methanomassiliicoccaceae archaeon isolate 2dded12f-1c8b-4e4a-b374-f87b1937d54c genome assembly, chromosome: 1 | blastn | 641 | 263 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Methanomassiliicoccaceae archaeon | |||
| 18257630 | 18257630 | PRJNA385073_P_NODE_41835_length_251_cov_0.865169_g41673_i0 | PRJNA385073 | 41835 | 251 | 0.865169 | 2.17157419 | uncultured Methanomassiliicoccales archaeon | 1235852 | Archaea | Archaea | 267 | 7.459999999999999e-67 | NTclustered | gi|2874253643|emb|OY968769.1| | 1235852 | g41673 | i0 | 86.166 | 2.96414342629482 | 253 | 27 | 99 | 6 | 1 | 250 | 62691 | 62938 | MAG: uncultured Methanomassiliicoccales archaeon isolate MFD00905.bin.2.112 genome assembly, chromosome: 1 | blastn | 744 | 267 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | uncultured Methanomassiliicoccales archaeon | ||||
| 22753125 | 22753125 | PRJNA385073_P_NODE_39018_length_256_cov_1.524590_g38856_i0 | PRJNA385073 | 39018 | 256 | 1.52459 | 3.9029504 | Candidatus Methanogranum | 1577789 | Archaea | Archaea | 217 | 7.8e-52 | NTclustered | gi|2621784480|emb|OY780938.1| | 2093355 | g38856 | i0 | 82.031 | 3 | 256 | 45 | 100 | 1 | 1 | 256 | 1493228 | 1493482 | MAG: uncultured Candidatus Methanogranum sp. isolate 9d90576e-3f35-4afd-8682-ecdb60e67c32 genome assembly, chromosome: 1 | blastn | 768 | 217 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Candidatus Methanogranum | uncultured Candidatus Methanogranum sp. | ||
| 23357762 | 23357762 | PRJNA385073_P_NODE_24399_length_297_cov_1.370536_g24237_i0 | PRJNA385073 | 24399 | 297 | 1.370536 | 4.07049192 | Methanomassiliicoccales archaeon | 1906667 | Archaea | Archaea | 383 | 8.61e-102 | NTclustered | gi|1870051182|gb|CP058896.1| | 1906667 | g24237 | i0 | 89.899 | 59.8148148148148 | 297 | 30 | 100 | 0 | 1 | 297 | 1627396 | 1627692 | MAG: Methanomassiliicoccales archaeon isolate Ch47 chromosome | blastn | 17765 | 383 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccales archaeon | ||||
| 23358372 | 23358372 | PRJNA385073_P_NODE_5259_length_524_cov_3.545455_g5100_i0 | PRJNA385073 | 5259 | 524 | 3.545455 | 18.5781842 | Methanomassiliicoccales archaeon | 1906667 | Archaea | Archaea | 616 | 1.4499999999999995e-171 | NTclustered | gi|1870051182|gb|CP058896.1| | 1906667 | g5100 | i0 | 88.123 | 15.7958015267176 | 522 | 57 | 99 | 4 | 6 | 524 | 1629228 | 1629747 | MAG: Methanomassiliicoccales archaeon isolate Ch47 chromosome | blastn | 8277 | 616 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccales archaeon |
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);;