contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA743294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 722088 | 722088 | PRJNA743294_P_NODE_41461_length_264_cov_9.743455_g41005_i0 | PRJNA743294 | 41461 | 264 | 9.743455 | 25.7227212 | Methanobacterium ferruginis | 710191 | Archaea | Archaea | 370 | 5.86e-98 | NTclustered | gi|2465756734|dbj|AP027738.1| | 710191 | g41005 | i0 | 92.366 | 126.011363636364 | 262 | 16 | 98 | 4 | 1 | 260 | 35426 | 35167 | Methanobacterium ferruginis NBRC 105197 DNA, complete genome | blastn | 33267 | 370 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium ferruginis | |
| 1198277 | 1198277 | PRJNA743294_P_NODE_13461_length_435_cov_4.477901_g13005_i0 | PRJNA743294 | 13461 | 435 | 4.477901 | 19.47886935 | Methanosarcina | 2207 | Archaea | Archaea | 732 | 0 | NTclustered | gi|2047643091|dbj|AP019780.1| | 2209 | g13005 | i0 | 97.011 | 223.76091954023 | 435 | 13 | 100 | 0 | 1 | 435 | 2736599 | 2737033 | Methanosarcina mazei TMA DNA, complete genome | blastn | 97336 | 732 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina mazei | |
| 1198313 | 1198313 | PRJNA743294_P_NODE_33481_length_290_cov_1.142857_g33025_i0 | PRJNA743294 | 33481 | 290 | 1.142857 | 3.3142853 | Methanosarcina | 2207 | Archaea | Archaea | 52.8 | 0.027 | NTclustered | gi|805394978|gb|CP009524.1| | 1434099 | g33025 | i0 | 91.892 | 0.255172413793103 | 37 | 3 | 13 | 0 | 104 | 140 | 3968026 | 3967990 | Methanosarcina sp. Kolksee, complete genome | blastn | 74 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. Kolksee | |
| 8851317 | 8851317 | PRJNA743294_P_NODE_18447_length_376_cov_3.029703_g17991_i0 | PRJNA743294 | 18447 | 376 | 3.029703 | 11.39168328 | Methanosarcina | 2207 | Archaea | Archaea | 628 | 1.2999999999999994e-175 | NTclustered | gi|805339246|gb|CP009504.1| | 1434102 | g17991 | i0 | 97.059 | 228.186170212766 | 374 | 10 | 99 | 1 | 3 | 376 | 43940 | 43568 | Methanosarcina sp. WH1, complete genome | blastn | 85798 | 628 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. WH1 | |
| 10126985 | 10126985 | PRJNA743294_P_NODE_13788_length_430_cov_3.546218_g13332_i0 | PRJNA743294 | 13788 | 430 | 3.546218 | 15.2487374 | Methanosarcina | 2207 | Archaea | Archaea | 580 | 4.2799999999999996e-161 | NTclustered | gi|1491786200|gb|CP032683.1| | 1715806 | g13332 | i0 | 96.839 | 185 | 348 | 10 | 100 | 1 | 83 | 430 | 464014 | 463668 | Methanosarcina flavescens strain E03.2 chromosome, complete genome | blastn | 79550 | 580 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina flavescens | |
| 12677926 | 12677926 | PRJNA743294_P_NODE_32970_length_291_cov_3.330275_g32514_i0 | PRJNA743294 | 32970 | 291 | 3.330275 | 9.69110025 | Methanosarcina | 2207 | Archaea | Archaea | 499 | 8.01e-137 | NTclustered | gi|805384997|gb|CP009517.1| | 1434107 | g32514 | i0 | 97.595 | 213.838487972509 | 291 | 7 | 100 | 0 | 1 | 291 | 56203 | 56493 | Methanosarcina barkeri 3, complete genome | blastn | 62227 | 499 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 13475753 | 13475753 | PRJNA743294_P_NODE_151_length_2415_cov_10.653715_g109_i0 | PRJNA743294 | 151 | 2415 | 10.653715 | 257.28721725 | Methanobacterium alcaliphilum | 392018 | Archaea | Archaea | 3738 | 0 | NTclustered | gi|584298067|gb|KF882006.1| | 392018 | g109 | i0 | 94.7 | 172.520082815735 | 2415 | 115 | 99 | 12 | 5 | 2407 | 2645 | 232 | Methanobacterium alcaliphilum strain WeN4 23S ribosomal RNA gene, partial sequence | blastn | 416636 | 3738 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium alcaliphilum | |
| 13475827 | 13475827 | PRJNA743294_P_NODE_2431_length_944_cov_8.580941_g2108_i0 | PRJNA743294 | 2431 | 944 | 8.580941 | 81.00408304 | Methanobacterium flexile | 490098 | Archaea | Archaea | 1735 | 0 | NTclustered | gi|1161053746|gb|KY780618.1| | 490098 | g2108 | i0 | 100 | 95.1239406779661 | 939 | 0 | 99 | 0 | 6 | 944 | 1 | 939 | Methanobacterium flexile strain Z-7215 16S ribosomal RNA gene, partial sequence | blastn | 89797 | 1735 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium flexile | |
| 13952262 | 13952262 | PRJNA743294_P_NODE_28611_length_310_cov_2.341772_g28155_i0 | PRJNA743294 | 28611 | 310 | 2.341772 | 7.2594932 | root | 1 | Root_unresolved | Root_unresolved | 573 | 4.999999999999998e-159 | NTclustered | gi|1808683266|gb|MT052672.1| | 2213 | g28155 | i0 | 100 | 100 | 310 | 0 | 100 | 0 | 1 | 310 | 344 | 653 | Methanosarcina sp. strain WLC-01 16S ribosomal RNA gene, partial sequence | blastn | 31000 | 573 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 14750987 | 14750987 | PRJNA743294_P_NODE_37752_length_275_cov_2.970297_g37296_i0 | PRJNA743294 | 37752 | 275 | 2.970297 | 8.16831675 | Methanosarcina sp. MTP4 | 1434100 | Archaea | Archaea | 243 | 1.4000000000000001e-59 | NTclustered | gi|805342629|gb|CP009505.1| | 1434100 | g37296 | i0 | 82.847 | 51.1018181818182 | 274 | 43 | 99 | 4 | 2 | 273 | 3650033 | 3650304 | Methanosarcina sp. MTP4, complete genome | blastn | 14053 | 243 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. MTP4 | |
| 19849140 | 19849140 | PRJNA743294_P_NODE_44676_length_256_cov_2.934426_g44220_i0 | PRJNA743294 | 44676 | 256 | 2.934426 | 7.51213056 | Methanosarcina siciliae | 38027 | Archaea | Archaea | 159 | 1.33e-34 | NTclustered | gi|805346097|gb|CP009506.1| | 1434120 | g44220 | i0 | 79.008 | 2.609375 | 262 | 34 | 100 | 11 | 1 | 256 | 458725 | 458971 | Methanosarcina siciliae T4/M, complete genome | blastn | 668 | 159 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina siciliae | |
| 20324798 | 20324798 | PRJNA743294_P_NODE_52996_length_245_cov_2.686047_g52540_i0 | PRJNA743294 | 52996 | 245 | 2.686047 | 6.58081515 | Methanobacterium | 2160 | Archaea | Archaea | 294 | 3.33e-75 | NTclustered | gi|2874253877|emb|OY969932.1| | 176233 | g52540 | i0 | 89.655 | 81.9102040816327 | 232 | 23 | 95 | 1 | 2 | 233 | 29474 | 29704 | MAG: uncultured Methanobacteriaceae archaeon isolate MFD09286.bin.c.5 genome assembly, chromosome: 1 | blastn | 20068 | 296 | 0.993243243243243 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | uncultured Methanobacteriaceae archaeon | ||
| 20324819 | 20324819 | PRJNA743294_P_NODE_9276_length_517_cov_7.722973_g8820_i0 | PRJNA743294 | 9276 | 517 | 7.722973 | 39.92777041 | Methanobacterium | 2160 | Archaea | Archaea | 939 | 0 | NTclustered | gi|76443580|dbj|AB236053.1| | 176233 | g8820 | i0 | 100 | 102.007736943907 | 508 | 0 | 98 | 0 | 1 | 508 | 822 | 1329 | Uncultured Methanobacteriaceae archaeon gene for 16S rRNA, partial sequence, clone:NR-H2-A | blastn | 52738 | 944 | 0.994703389830508 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | uncultured Methanobacteriaceae archaeon | ||
| 21600551 | 21600551 | PRJNA743294_P_NODE_59817_length_223_cov_4.313333_g59361_i0 | PRJNA743294 | 59817 | 223 | 4.313333 | 9.61873259 | root | 1 | Root_unresolved | Root_unresolved | 399 | 6.139999999999999e-107 | NTclustered | gi|313766567|gb|HQ591417.1| | 2208 | g59361 | i0 | 99.099 | 113.511210762332 | 222 | 2 | 99 | 0 | 2 | 223 | 1105 | 884 | Methanosarcina barkeri strain TR-Z13 16S ribosomal RNA gene, partial sequence | blastn | 25313 | 399 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri |
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);;