contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA315399" and tax_clade = "Methanomada 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1065678 | 1065678 | PRJNA315399_P_NODE_206041_length_184_cov_7.074830_g205593_i0 | PRJNA315399 | 206041 | 184 | 7.07483 | 13.0176872 | Methanobacterium | 2160 | Archaea | Archaea | 78.7 | 2.59e-10 | NTclustered | gi|952971377|emb|LN734822.1| | 2162 | g205593 | i0 | 90.164 | 1.66304347826087 | 61 | 5 | 33 | 1 | 109 | 168 | 2401971 | 2402031 | Methanobacterium formicicum genome assembly isolate Mb9, chromosome : I | blastn | 306 | 78.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium formicicum | |
| 1656794 | 1656794 | PRJNA315399_P_NODE_231222_length_183_cov_2.945205_g230774_i0 | PRJNA315399 | 231222 | 183 | 2.945205 | 5.38972515 | Methanobacterium sp. ERen5 | 2977359 | Archaea | Archaea | 87.9 | 4.27e-13 | NTclustered | gi|2264313079|gb|CP099988.1| | 2977359 | g230774 | i0 | 87.013 | 0.420765027322404 | 77 | 10 | 42 | 0 | 102 | 178 | 151033 | 150957 | MAG: Methanobacterium sp. ERen5 chromosome, complete genome | blastn | 77 | 87.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. ERen5 | |
| 2341958 | 2341958 | PRJNA315399_S_NODE_164822_length_157_cov_2.950000_g164621_i0 | PRJNA315399 | 164822 | 157 | 2.95 | 4.6315 | Methanobrevibacter | 2172 | Archaea | Archaea | 259 | 7.11e-65 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g164621 | i0 | 99.301 | 6.37579617834395 | 143 | 1 | 91 | 0 | 1 | 143 | 1775153 | 1775295 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 1001 | 259 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 2932539 | 2932539 | PRJNA315399_P_NODE_218543_length_184_cov_1.836735_g218095_i0 | PRJNA315399 | 218543 | 184 | 1.836735 | 3.3795924 | Methanobacterium congolense | 118062 | Archaea | Archaea | 135 | 1.51e-27 | NTclustered | gi|1063149921|emb|LT607756.1| | 118062 | g218095 | i0 | 98.684 | 0.41304347826087 | 76 | 1 | 41 | 0 | 101 | 176 | 1972079 | 1972004 | Methanobacterium congolense isolate Buetzberg genome assembly, chromosome: I | blastn | 76 | 135 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium congolense | |
| 2932617 | 2932617 | PRJNA315399_P_NODE_230343_length_183_cov_3.171233_g229895_i0 | PRJNA315399 | 230343 | 183 | 3.171233 | 5.80335639 | Methanobacterium sp. ACI-7 | 3240853 | Archaea | Archaea | 122 | 1.1699999999999997e-23 | NTclustered | gi|2904246484|gb|CP166866.1| | 3240853 | g229895 | i0 | 97.222 | 2.6775956284153 | 72 | 2 | 39 | 0 | 14 | 85 | 938434 | 938505 | Methanobacterium sp. ACI-7 chromosome, complete genome | blastn | 490 | 122 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. ACI-7 | |
| 4210857 | 4210857 | PRJNA315399_P_NODE_494884_length_151_cov_13.114035_g494436_i0 | PRJNA315399 | 494884 | 151 | 13.114035 | 19.80219285 | Methanobrevibacter arboriphilus | 39441 | Archaea | Archaea | 52.8 | 0.012 | NTclustered | gi|2047640843|dbj|AP019779.1| | 39441 | g494436 | i0 | 100 | 0.185430463576159 | 28 | 0 | 19 | 0 | 15 | 42 | 1151854 | 1151827 | Methanobrevibacter arboriphilus SA DNA, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter arboriphilus | |
| 4212809 | 4212809 | PRJNA315399_S_NODE_6224_length_409_cov_192.032258_g2588_i1 | PRJNA315399 | 6224 | 409 | 192.032258 | 785.41193522 | Methanobacterium palustre | 2171 | Archaea | Archaea | 78.7 | 6.48e-10 | NTclustered | gi|584298062|gb|KF882001.1| | 2171 | g2588 | i1 | 95.833 | 2.73349633251834 | 48 | 2 | 12 | 0 | 21 | 68 | 145 | 98 | Methanobacterium palustre strain F 23S ribosomal RNA gene, partial sequence | blastn | 1118 | 78.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium palustre | |
| 6760755 | 6760755 | PRJNA315399_P_NODE_408006_length_160_cov_13.333333_g407558_i0 | PRJNA315399 | 408006 | 160 | 13.333333 | 21.3333328 | Methanobacterium sp. BRmetb2 | 2025350 | Archaea | Archaea | 95.3 | 2.17e-15 | NTclustered | gi|1473087786|gb|CP022705.1| | 2025350 | g407558 | i0 | 88.462 | 0.4875 | 78 | 9 | 49 | 0 | 73 | 150 | 936093 | 936170 | MAG: Methanobacterium sp. BRmetb2 chromosome, complete genome | blastn | 78 | 95.3 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. BRmetb2 | |
| 11859978 | 11859978 | PRJNA315399_P_NODE_126510_length_192_cov_13.858065_g126062_i0 | PRJNA315399 | 126510 | 192 | 13.858065 | 26.6074848 | Methanobacterium petrolearium | 710190 | Archaea | Archaea | 54.7 | 0.005 | NTclustered | gi|2465759960|dbj|AP027739.1| | 710190 | g126062 | i0 | 100 | 0.151041666666667 | 29 | 0 | 15 | 0 | 162 | 190 | 850036 | 850064 | Methanobacterium petrolearium NBRC 105198 DNA, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium petrolearium | |
| 11864306 | 11864306 | PRJNA315399_S_NODE_76090_length_192_cov_1.658065_g75889_i0 | PRJNA315399 | 76090 | 192 | 1.658065 | 3.1834848 | Methanobacterium petrolearium | 710190 | Archaea | Archaea | 239 | 1.18e-58 | NTclustered | gi|2465759960|dbj|AP027739.1| | 710190 | g75889 | i0 | 89.119 | 1.765625 | 193 | 19 | 100 | 2 | 1 | 192 | 655318 | 655127 | Methanobacterium petrolearium NBRC 105198 DNA, complete genome | blastn | 339 | 239 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium petrolearium | |
| 13136900 | 13136900 | PRJNA315399_P_NODE_420951_length_159_cov_5.180328_g420503_i0 | PRJNA315399 | 420951 | 159 | 5.180328 | 8.23672152 | Methanobacterium congolense | 118062 | Archaea | Archaea | 124 | 2.75e-24 | NTclustered | gi|1063149921|emb|LT607756.1| | 118062 | g420503 | i0 | 93.902 | 0.515723270440252 | 82 | 5 | 52 | 0 | 62 | 143 | 2178961 | 2179042 | Methanobacterium congolense isolate Buetzberg genome assembly, chromosome: I | blastn | 82 | 124 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium congolense | |
| 13138058 | 13138058 | PRJNA315399_S_NODE_121851_length_169_cov_9.833333_g121650_i0 | PRJNA315399 | 121851 | 169 | 9.833333 | 16.61833277 | Methanobacterium congolense | 118062 | Archaea | Archaea | 132 | 1.7600000000000002e-26 | NTclustered | gi|1063149921|emb|LT607756.1| | 118062 | g121650 | i0 | 100 | 0.420118343195266 | 71 | 0 | 42 | 0 | 10 | 80 | 690983 | 690913 | Methanobacterium congolense isolate Buetzberg genome assembly, chromosome: I | blastn | 71 | 132 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium congolense | |
| 15093919 | 15093919 | PRJNA315399_P_NODE_452172_length_156_cov_3.000000_g451724_i0 | PRJNA315399 | 452172 | 156 | 3 | 4.68 | Methanobrevibacter | 2172 | Archaea | Archaea | 268 | 1.1699999999999997e-67 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g451724 | i0 | 100 | 5.57692307692308 | 145 | 0 | 93 | 0 | 2 | 146 | 698191 | 698047 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 870 | 268 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 15685815 | 15685815 | PRJNA315399_P_NODE_421813_length_159_cov_4.500000_g421365_i0 | PRJNA315399 | 421813 | 159 | 4.5 | 7.155 | Methanobacterium paludis | 868131 | Archaea | Archaea | 180 | 5.79e-41 | NTclustered | gi|333824386|gb|CP002772.1| | 868131 | g421365 | i0 | 91.538 | 0.817610062893082 | 130 | 11 | 82 | 0 | 19 | 148 | 1473062 | 1473191 | Methanobacterium paludis strain SWAN1, complete genome | blastn | 130 | 180 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium paludis | |
| 16958542 | 16958542 | PRJNA315399_P_NODE_102654_length_200_cov_5.233129_g102206_i0 | PRJNA315399 | 102654 | 200 | 5.233129 | 10.466258 | Methanobacterium petrolearium | 710190 | Archaea | Archaea | 171 | 4.599999999999999e-38 | NTclustered | gi|2465759960|dbj|AP027739.1| | 710190 | g102206 | i0 | 81.215 | 0.905 | 181 | 32 | 90 | 1 | 12 | 190 | 239800 | 239980 | Methanobacterium petrolearium NBRC 105198 DNA, complete genome | blastn | 181 | 171 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium petrolearium | |
| 19509537 | 19509537 | PRJNA315399_P_NODE_485376_length_152_cov_7.139130_g484928_i0 | PRJNA315399 | 485376 | 152 | 7.13913 | 10.8514776 | Methanobacterium congolense | 118062 | Archaea | Archaea | 200 | 4.1899999999999997e-47 | NTclustered | gi|1063149921|emb|LT607756.1| | 118062 | g484928 | i0 | 95.238 | 0.828947368421053 | 126 | 6 | 83 | 0 | 8 | 133 | 2446143 | 2446268 | Methanobacterium congolense isolate Buetzberg genome assembly, chromosome: I | blastn | 126 | 200 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium congolense | |
| 19509831 | 19509831 | PRJNA315399_P_NODE_65476_length_221_cov_16.086957_g65028_i0 | PRJNA315399 | 65476 | 221 | 16.086957 | 35.55217497 | Methanobacterium palustre | 2171 | Archaea | Archaea | 78.7 | 3.23e-10 | NTclustered | gi|584298062|gb|KF882001.1| | 2171 | g65028 | i0 | 95.833 | 5.05882352941176 | 48 | 2 | 22 | 0 | 15 | 62 | 145 | 98 | Methanobacterium palustre strain F 23S ribosomal RNA gene, partial sequence | blastn | 1118 | 78.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium palustre | |
| 21467944 | 21467944 | PRJNA315399_P_NODE_435757_length_158_cov_1.710744_g435309_i0 | PRJNA315399 | 435757 | 158 | 1.710744 | 2.70297552 | Methanobacterium | 2160 | Archaea | Archaea | 239 | 9.34e-59 | NTclustered | gi|1297867845|gb|CP017766.1| | 59277 | g435309 | i0 | 97.163 | 7.2025316455696196 | 141 | 4 | 89 | 0 | 18 | 158 | 1025489 | 1025629 | Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome | blastn | 1138 | 239 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium subterraneum | |
| 22059571 | 22059571 | PRJNA315399_P_NODE_41138_length_250_cov_5.356808_g40691_i0 | PRJNA315399 | 41138 | 250 | 5.356808 | 13.39202 | Methanobacterium congolense | 118062 | Archaea | Archaea | 270 | 5.74e-68 | NTclustered | gi|1063149921|emb|LT607756.1| | 118062 | g40691 | i0 | 96.341 | 0.656 | 164 | 6 | 66 | 0 | 87 | 250 | 53714 | 53551 | Methanobacterium congolense isolate Buetzberg genome assembly, chromosome: I | blastn | 164 | 270 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium congolense |
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);;