contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB83711" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3970590 | 3970590 | PRJEB83711_P_NODE_60064_length_252_cov_0.871508_g59798_i0 | PRJEB83711 | 60064 | 252 | 0.871508 | 2.19620016 | Methanobacterium sp. BRmetb2 | 2025350 | Archaea | Archaea | 139 | 1.71e-28 | NTclustered | gi|1473087786|gb|CP022705.1| | 2025350 | g59798 | i0 | 78.355 | 538.813492063492 | 231 | 39 | 98 | 11 | 18 | 242 | 478214 | 478439 | MAG: Methanobacterium sp. BRmetb2 chromosome, complete genome | blastn | 135781 | 139 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. BRmetb2 | |
| 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 | |
| 18850534 | 18850534 | PRJEB83711_P_NODE_67175_length_248_cov_0.891429_g66909_i0 | PRJEB83711 | 67175 | 248 | 0.891429 | 2.21074392 | Saccharolobus | 2100760 | Archaea | Archaea | 54.7 | 0.006 | NTclustered | gi|2440481745|gb|CP046616.1| | 43080 | g66909 | i0 | 100 | 1.08064516129032 | 29 | 0 | 12 | 0 | 139 | 167 | 1867082 | 1867054 | Saccharolobus islandicus strain HVE 10/4 chromosome, complete genome | blastn | 268 | 54.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Saccharolobus | Saccharolobus islandicus | ||
| 21821439 | 21821439 | PRJEB83711_P_NODE_72138_length_245_cov_1.279070_g71872_i0 | PRJEB83711 | 72138 | 245 | 1.27907 | 3.1337215 | Methanobacterium formicicum | 2162 | Archaea | Archaea | 442 | 1.1199999999999994e-119 | NTclustered | gi|952971377|emb|LN734822.1| | 2162 | g71872 | i0 | 99.184 | 5 | 245 | 2 | 100 | 0 | 1 | 245 | 122266 | 122022 | Methanobacterium formicicum genome assembly isolate Mb9, chromosome : I | blastn | 1225 | 442 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium formicicum | |
| 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);;