contig_metadata
20 rows where bioproject = "PRJNA900028" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1244622 | 1244622 | PRJNA900028_P_NODE_114721_length_169_cov_1.241667_g113972_i0 | PRJNA900028 | 114721 | 169 | 1.241667 | 2.09841723 | Methanothrix | 2222 | Archaea | Archaea | 313 | 5.859999999999999e-81 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g113972 | i0 | 100 | 16.6449704142012 | 169 | 0 | 100 | 0 | 1 | 169 | 310 | 142 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 2813 | 313 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 20001915 | 20001915 | PRJNA900028_P_NODE_2436_length_709_cov_1.093939_g1766_i0 | PRJNA900028 | 2436 | 709 | 1.093939 | 7.75602751 | Salinigranum rubrum | 755307 | Archaea | Archaea | 56.5 | 0.005 | NTclustered | gi|1336549475|gb|CP026309.1| | 755307 | g1766 | i0 | 89.362 | 0.0662905500705219 | 47 | 2 | 7 | 3 | 242 | 288 | 2303461 | 2303418 | Salinigranum rubrum strain GX10 chromosome, complete genome | blastn | 47 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinigranum | Salinigranum rubrum | |
| 25100935 | 25100935 | PRJNA900028_P_NODE_168280_length_163_cov_0.894737_g167531_i0 | PRJNA900028 | 168280 | 163 | 0.894737 | 1.45842131 | Methanobrevibacter acididurans | 120963 | Archaea | Archaea | 110 | 7.95e-20 | NTclustered | gi|2871247231|gb|CP166991.1| | 120963 | g167531 | i0 | 83.333 | 4.07361963190184 | 120 | 18 | 73 | 2 | 37 | 155 | 857234 | 857352 | Methanobrevibacter acididurans strain DSM 15163 chromosome, complete genome | blastn | 664 | 110 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter acididurans | |
| 26968438 | 26968438 | PRJNA900028_P_NODE_195962_length_161_cov_0.910714_g195213_i0 | PRJNA900028 | 195962 | 161 | 0.910714 | 1.46624954 | Halobacteriales | 2235 | Archaea | Archaea | 81.6 | 1.91e-17 | NR | WP_121744904.1 | 1702106 | g195213 | i0 | 78.8 | 2.92546583850932 | 52 | 11 | 96.9 | 0 | 159 | 4 | 6 | 57 | WP_121744904.1 recombinase family protein [Natronorubrum halophilum] | diamond | 471 | 82.4 | 0.990291262135922 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum halophilum | |
| 28231714 | 28231714 | PRJNA900028_P_NODE_155186_length_164_cov_0.886957_g154437_i0 | PRJNA900028 | 155186 | 164 | 0.886957 | 1.45460948 | Methanobacterium | 2160 | Archaea | Archaea | 103 | 6.73e-25 | NR | WP_286475775.1 | 2584467 | g154437 | i0 | 96.3 | 9.87804878048781 | 54 | 2 | 98.8 | 0 | 2 | 163 | 138 | 191 | WP_286475775.1 hydroxymethylglutaryl-CoA synthase [Methanobacterium aridiramus] | diamond | 1620 | 104 | 0.990384615384615 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium aridiramus | |
| 28326577 | 28326577 | PRJNA900028_P_NODE_148206_length_165_cov_0.879310_g147457_i0 | PRJNA900028 | 148206 | 165 | 0.87931 | 1.4508615 | root | 1 | Root_unresolved | Root_unresolved | 51.2 | 1.3e-5 | NR | RQW80199.1 | 90426 | g147457 | i0 | 52.5 | 6.58181818181818 | 40 | 19 | 72.7 | 0 | 161 | 42 | 368 | 407 | RQW80199.1 MAG: DNA helicase RecQ [Methanothrix sp.] | diamond | 1086 | 51.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 28389826 | 28389826 | PRJNA900028_P_NODE_178846_length_162_cov_0.902655_g178097_i0 | PRJNA900028 | 178846 | 162 | 0.902655 | 1.4623011 | Natronomonas | 63743 | Archaea | Archaea | 43.1 | 0.00905 | NR | WP_410321013.1 | 2184060 | g178097 | i0 | 88 | 1.38888888888889 | 25 | 3 | 46.3 | 0 | 11 | 85 | 1 | 25 | WP_410321013.1 DUF2298 domain-containing protein [Natronomonas sp.] | diamond | 225 | 43.5 | 0.990804597701149 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. | |
| 28413897 | 28413897 | PRJNA900028_P_NODE_132526_length_166_cov_0.871795_g131777_i0 | PRJNA900028 | 132526 | 166 | 0.871795 | 1.4471797 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 99.8 | 9.14e-23 | NR | MBS3761550.1 | 1980530 | g131777 | i0 | 92.5 | 0.957831325301205 | 53 | 4 | 95.8 | 0 | 159 | 1 | 434 | 486 | MBS3761550.1 molybdopterin-dependent oxidoreductase [Halodesulfurarchaeum sp.] | diamond | 159 | 99.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 28484658 | 28484658 | PRJNA900028_P_NODE_56926_length_200_cov_1.350993_g56177_i0 | PRJNA900028 | 56926 | 200 | 1.350993 | 2.701986 | root | 1 | Root_unresolved | Root_unresolved | 94.7 | 5.22e-21 | NR | MDD1724742.1 | 45200 | g56177 | i0 | 63.6 | 38.535 | 66 | 24 | 99 | 0 | 2 | 199 | 148 | 213 | MDD1724742.1 cysteine desulfurase NifS [Methanospirillum sp.] | diamond | 7707 | 94.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 29589356 | 29589356 | PRJNA900028_P_NODE_185330_length_162_cov_0.902655_g184581_i0 | PRJNA900028 | 185330 | 162 | 0.902655 | 1.4623011 | Halobacteriales | 2235 | Archaea | Archaea | 89.4 | 4.62e-19 | NR | MFB6202471.1 | 1961697 | g184581 | i0 | 77.4 | 1.96296296296296 | 53 | 12 | 98.1 | 0 | 3 | 161 | 506 | 558 | MFB6202471.1 winged helix-turn-helix domain-containing protein [Halorhabdus sp.] | diamond | 318 | 89.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorhabdus | Halorhabdus sp. | |
| 29960977 | 29960977 | PRJNA900028_P_NODE_32151_length_235_cov_1.096774_g31402_i0 | PRJNA900028 | 32151 | 235 | 1.096774 | 2.5774189 | Methanomethylophilus sp. | 2774294 | Archaea | Archaea | 104 | 4.37e-25 | NR | MDD2626962.1 | 2774294 | g31402 | i0 | 67.1 | 1.00851063829787 | 79 | 25 | 99.6 | 1 | 234 | 1 | 122 | 200 | MDD2626962.1 ATPase, T2SS/T4P/T4SS family [Methanomethylophilus sp.] | diamond | 237 | 104 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Methanomethylophilus | Methanomethylophilus sp. | ||
| 30245573 | 30245573 | PRJNA900028_P_NODE_67852_length_190_cov_1.446809_g67103_i0 | PRJNA900028 | 67852 | 190 | 1.446809 | 2.7489371 | Methanogenium sp. | 2196 | Archaea | Archaea | 58.2 | 6.13e-8 | NR | MFA5395000.1 | 2196 | g67103 | i0 | 41.3 | 1.98947368421053 | 63 | 37 | 99.5 | 0 | 1 | 189 | 46 | 108 | MFA5395000.1 HAD family acid phosphatase [Methanogenium sp.] | diamond | 378 | 58.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium sp. | |
| 30403772 | 30403772 | PRJNA900028_P_NODE_174273_length_163_cov_0.894737_g173524_i0 | PRJNA900028 | 174273 | 163 | 0.894737 | 1.45842131 | Methanobacterium | 2160 | Archaea | Archaea | 103 | 6.4999999999999985e-24 | NR | WP_100906157.1 | 2160 | g173524 | i0 | 88.9 | 0.993865030674847 | 54 | 6 | 99.4 | 0 | 2 | 163 | 498 | 551 | WP_100906157.1 MULTISPECIES: thioredoxin domain-containing protein [Methanobacterium] | diamond | 162 | 103 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | ||
| 30687572 | 30687572 | PRJNA900028_P_NODE_161433_length_164_cov_0.886957_g160684_i0 | PRJNA900028 | 161433 | 164 | 0.886957 | 1.45460948 | Haloplanus sp. GCM1 | 1961696 | Archaea | Archaea | 77.8 | 1.73e-16 | NR | WP_379798203.1 | 3252679 | g160684 | i0 | 82.6 | 0.841463414634146 | 46 | 8 | 84.1 | 0 | 26 | 163 | 1 | 46 | WP_379798203.1 hypothetical protein [Haloplanus sp. GCM10025708] | diamond | 138 | 77.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus sp. GCM10025708 | |
| 30750936 | 30750936 | PRJNA900028_P_NODE_143414_length_165_cov_0.879310_g142665_i0 | PRJNA900028 | 143414 | 165 | 0.87931 | 1.4508615 | Halorubrum miltondacostae | 3076378 | Archaea | Archaea | 114 | 6.03e-29 | NR | WP_371163206.1 | 3076378 | g142665 | i0 | 94.4 | 0.981818181818182 | 54 | 3 | 98.2 | 0 | 163 | 2 | 104 | 157 | WP_371163206.1 dipeptidase [Halorubrum miltondacostae] | diamond | 162 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum miltondacostae | |
| 30972186 | 30972186 | PRJNA900028_P_NODE_55434_length_202_cov_1.000000_g54685_i0 | PRJNA900028 | 55434 | 202 | 1 | 2.02 | Methanoregula sp. | 2052170 | Archaea | Archaea | 63.5 | 7.78e-10 | NR | HSQ94427.1 | 2052170 | g54685 | i0 | 50.8 | 2.62871287128713 | 63 | 31 | 93.6 | 0 | 202 | 14 | 144 | 206 | HSQ94427.1 PP2C family serine/threonine-protein phosphatase [Methanoregula sp.] | diamond | 531 | 63.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 30972194 | 30972194 | PRJNA900028_P_NODE_72134_length_188_cov_1.467626_g71385_i0 | PRJNA900028 | 72134 | 188 | 1.467626 | 2.75913688 | Halobellus ruber | 2761102 | Archaea | Archaea | 93.2 | 2.44e-21 | NR | WP_185193430.1 | 2761102 | g71385 | i0 | 66.7 | 0.957446808510638 | 60 | 20 | 95.7 | 0 | 3 | 182 | 158 | 217 | WP_185193430.1 DUF547 domain-containing protein [Halobellus ruber] | diamond | 180 | 93.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus ruber | |
| 31383084 | 31383084 | PRJNA900028_P_NODE_103956_length_174_cov_1.224000_g103207_i0 | PRJNA900028 | 103956 | 174 | 1.224 | 2.12976 | Methanomethylophilus sp. | 2774294 | Archaea | Archaea | 54.7 | 8.17e-7 | NR | MDD2626961.1 | 2774294 | g103207 | i0 | 41.4 | 1 | 58 | 34 | 100 | 0 | 1 | 174 | 45 | 102 | MDD2626961.1 type II secretion system F family protein [Methanomethylophilus sp.] | diamond | 174 | 54.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Methanomethylophilus | Methanomethylophilus sp. | ||
| 31572945 | 31572945 | PRJNA900028_P_NODE_166976_length_163_cov_0.894737_g166227_i0 | PRJNA900028 | 166976 | 163 | 0.894737 | 1.45842131 | Methanobacterium sp. MZD13 | 2164 | Archaea | Archaea | 87.8 | 1.27e-19 | NR | WP_416113749.1 | 3394378 | g166227 | i0 | 88.9 | 0.993865030674847 | 54 | 6 | 99.4 | 0 | 162 | 1 | 99 | 152 | WP_416113749.1 triose-phosphate isomerase [Methanobacterium sp. MZD130B] | diamond | 162 | 87.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. MZD130B | |
| 32742675 | 32742675 | PRJNA900028_P_NODE_90340_length_180_cov_1.557252_g89591_i0 | PRJNA900028 | 90340 | 180 | 1.557252 | 2.8030536 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 82 | 2.46e-17 | NR | MBR2557691.1 | 66852 | g89591 | i0 | 73.2 | 0.933333333333333 | 56 | 15 | 93.3 | 0 | 9 | 176 | 75 | 130 | MBR2557691.1 IS607 family transposase [Methanobrevibacter sp.] | diamond | 168 | 82 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. |
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);;