contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB83711" and tax_clade = "Stenosarchaea group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6522289 | 6522289 | PRJEB83711_P_NODE_43366_length_281_cov_1.250000_g43100_i0 | PRJEB83711 | 43366 | 281 | 1.25 | 3.5125 | Methanosarcina sp. Kolksee | 1434099 | Archaea | Archaea | 503 | 5.95e-138 | NTclustered | gi|805394978|gb|CP009524.1| | 1434099 | g43100 | i0 | 98.932 | 6 | 281 | 3 | 100 | 0 | 1 | 281 | 443473 | 443753 | Methanosarcina sp. Kolksee, complete genome | blastn | 1686 | 503 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. Kolksee | |
| 6522841 | 6522841 | PRJEB83711_P_NODE_67646_length_248_cov_0.891429_g67380_i0 | PRJEB83711 | 67646 | 248 | 0.891429 | 2.21074392 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 385 | 1.95e-102 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g67380 | i0 | 94.737 | 1.99193548387097 | 247 | 13 | 99 | 0 | 1 | 247 | 469881 | 470127 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 494 | 385 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 11622789 | 11622789 | PRJEB83711_P_NODE_52530_length_262_cov_1.386243_g52264_i0 | PRJEB83711 | 52530 | 262 | 1.386243 | 3.63195666 | Methanosarcina vacuolata | 2215 | Archaea | Archaea | 444 | 3.38e-120 | NTclustered | gi|805391208|gb|CP009520.1| | 1434123 | g52264 | i0 | 97.328 | 7.08778625954198 | 262 | 6 | 100 | 1 | 1 | 262 | 1155291 | 1155551 | Methanosarcina vacuolata Z-761, complete genome | blastn | 1857 | 444 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina vacuolata | |
| 16721593 | 16721593 | PRJEB83711_P_NODE_78794_length_242_cov_0.923077_g78528_i0 | PRJEB83711 | 78794 | 242 | 0.923077 | 2.23384634 | Methanosarcina barkeri | 2208 | Archaea | Archaea | 387 | 5.26e-103 | NTclustered | gi|805398754|gb|CP009526.1| | 1434109 | g78528 | i0 | 95.455 | 4 | 242 | 11 | 100 | 0 | 1 | 242 | 4141494 | 4141253 | Methanosarcina barkeri str. Wiesmoor, complete genome | blastn | 968 | 387 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 17996540 | 17996540 | PRJEB83711_P_NODE_82515_length_215_cov_9.070423_g82249_i0 | PRJEB83711 | 82515 | 215 | 9.070423 | 19.50140945 | Methanosalsum zhilinae | 39669 | Archaea | Archaea | 56.5 | 0.001 | NTclustered | gi|335929340|gb|CP002101.1| | 679901 | g82249 | i0 | 100 | 0.13953488372093 | 30 | 0 | 14 | 0 | 47 | 76 | 1665167 | 1665138 | Methanosalsum zhilinae DSM 4017, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosalsum | Methanosalsum zhilinae | |
| 24370536 | 24370536 | PRJEB83711_P_NODE_73980_length_244_cov_1.473684_g73714_i0 | PRJEB83711 | 73980 | 244 | 1.473684 | 3.59578896 | Salinigranum rubrum | 755307 | Archaea | Archaea | 309 | 1.1800000000000002e-79 | NTclustered | gi|1336549475|gb|CP026309.1| | 755307 | g73714 | i0 | 89.958 | 32.6188524590164 | 239 | 24 | 98 | 0 | 3 | 241 | 1737454 | 1737692 | Salinigranum rubrum strain GX10 chromosome, complete genome | blastn | 7959 | 309 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinigranum | Salinigranum rubrum | |
| 24370543 | 24370543 | PRJEB83711_P_NODE_74300_length_244_cov_0.912281_g74034_i0 | PRJEB83711 | 74300 | 244 | 0.912281 | 2.22596564 | Natronorubrum daqingense | 588898 | Archaea | Archaea | 390 | 4.11e-104 | NTclustered | gi|1134979927|gb|CP019327.1| | 588898 | g74034 | i0 | 95.492 | 2.12704918032787 | 244 | 11 | 100 | 0 | 1 | 244 | 2319454 | 2319211 | Natronorubrum daqingense strain JX313, complete sequence | blastn | 519 | 390 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum daqingense |
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);;