contig_metadata
17 rows where bioproject = "PRJNA859990" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 845899 | 845899 | PRJNA859990_S_NODE_2341_length_603_cov_1.967925_g2085_i0 | PRJNA859990 | 2341 | 603 | 1.967925 | 11.86658775 | Methanobrevibacter sp. YE315 | 1609968 | Archaea | Archaea | 939 | 0 | NTclustered | gi|985614202|gb|CP010834.1| | 1609968 | g2085 | i0 | 94.868 | 69.8789386401327 | 604 | 26 | 100 | 5 | 1 | 603 | 494571 | 495170 | Methanobrevibacter sp. YE315, complete genome | blastn | 42137 | 939 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. YE315 | |
| 2511589 | 2511589 | PRJNA859990_S_NODE_15862_length_263_cov_1.531579_g15601_i0 | PRJNA859990 | 15862 | 263 | 1.531579 | 4.02805277 | Methanobrevibacter | 2172 | Archaea | Archaea | 335 | 2.129999999999999e-87 | NTclustered | gi|1294447101|gb|CP017803.1| | 2173 | g15601 | i0 | 100 | 89.106463878327 | 181 | 0 | 69 | 0 | 11 | 191 | 266547 | 266367 | Methanobrevibacter smithii strain KB11 chromosome, complete genome | blastn | 23435 | 335 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 4674298 | 4674298 | PRJNA859990_S_NODE_15724_length_264_cov_2.450262_g15463_i0 | PRJNA859990 | 15724 | 264 | 2.450262 | 6.46869168 | Methanobrevibacter sp. YE315 | 1609968 | Archaea | Archaea | 399 | 7.479999999999998e-107 | NTclustered | gi|985614202|gb|CP010834.1| | 1609968 | g15463 | i0 | 93.962 | 96.1856060606061 | 265 | 14 | 100 | 2 | 1 | 264 | 496019 | 496282 | Methanobrevibacter sp. YE315, complete genome | blastn | 25393 | 399 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. YE315 | |
| 5064139 | 5064139 | PRJNA859990_S_NODE_17304_length_253_cov_3.238889_g17043_i0 | PRJNA859990 | 17304 | 253 | 3.238889 | 8.1943891699999991 | Methanobacteriati | 3366610 | Archaea | Archaea | 307 | 4.44e-79 | NTclustered | gi|557923211|gb|KF607702.1| | 115547 | g17043 | i0 | 99.408 | 66.7588932806324 | 169 | 1 | 67 | 0 | 11 | 179 | 181 | 13 | Uncultured archaeon clone El_A021 16S ribosomal RNA gene, partial sequence | blastn | 16890 | 307 | 1 | Archaea | uncultured archaeon | ||||||||
| 6339973 | 6339973 | PRJNA859990_S_NODE_11445_length_303_cov_1.004348_g11184_i0 | PRJNA859990 | 11445 | 303 | 1.004348 | 3.04317444 | root | 1 | Root_unresolved | Root_unresolved | 560 | 3.79e-155 | NTclustered | gi|436492|gb|U00707.1|PSU00707 | 33866 | g11184 | i0 | 100 | 10.6105610561056 | 303 | 0 | 100 | 0 | 1 | 303 | 4238 | 3936 | Pyrococcus sp. Deep Vent DNA polymerase precursor gene, complete cds | blastn | 3215 | 560 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus sp. | ||
| 7224197 | 7224197 | PRJNA859990_S_NODE_7926_length_355_cov_1.411348_g7665_i0 | PRJNA859990 | 7926 | 355 | 1.411348 | 5.0102854 | Candidatus Methanoplasma termitum | 1577791 | Archaea | Archaea | 383 | 1.0499999999999998e-101 | NTclustered | gi|731480732|gb|CP010070.1| | 1577791 | g7665 | i0 | 98.611 | 319.047887323944 | 216 | 3 | 61 | 0 | 71 | 286 | 162129 | 162344 | Candidatus Methanoplasma termitum strain MpT1, complete genome | blastn | 113262 | 383 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Candidatus Methanoplasma | Candidatus Methanoplasma termitum | ||
| 12715654 | 12715654 | PRJNA859990_S_NODE_19670_length_246_cov_1.537572_g19409_i0 | PRJNA859990 | 19670 | 246 | 1.537572 | 3.78242712 | Methanobrevibacter | 2172 | Archaea | Archaea | 444 | 3.14e-120 | NTclustered | gi|968564921|gb|CP011266.1| | 230361 | g19409 | i0 | 99.187 | 161.979674796748 | 246 | 2 | 100 | 0 | 1 | 246 | 543076 | 543321 | Methanobrevibacter millerae strain SM9, complete genome | blastn | 39847 | 444 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter millerae | |
| 16148644 | 16148644 | PRJNA859990_S_NODE_22753_length_233_cov_35.343750_g22492_i0 | PRJNA859990 | 22753 | 233 | 35.34375 | 82.3509375 | uncultured archaeon | 115547 | Archaea | Archaea | 287 | 5.25e-73 | NTclustered | gi|283837256|dbj|AB541813.1| | 115547 | g22492 | i0 | 100 | 68.274678111588 | 155 | 0 | 67 | 0 | 67 | 221 | 157 | 3 | Uncultured archaeon gene for 16S rRNA, partial sequence, clone: K09_10_51 | blastn | 15908 | 287 | 1 | Archaea | uncultured archaeon | ||||||||
| 17813684 | 17813684 | PRJNA859990_S_NODE_6314_length_393_cov_1.593750_g6053_i0 | PRJNA859990 | 6314 | 393 | 1.59375 | 6.2634375 | Methanobrevibacter | 2172 | Archaea | Archaea | 704 | 0 | NTclustered | gi|968564921|gb|CP011266.1| | 230361 | g6053 | i0 | 98.982 | 144.534351145038 | 393 | 4 | 100 | 0 | 1 | 393 | 542667 | 542275 | Methanobrevibacter millerae strain SM9, complete genome | blastn | 56802 | 704 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter millerae | |
| 19972590 | 19972590 | PRJNA859990_S_NODE_8376_length_346_cov_3.098901_g8115_i0 | PRJNA859990 | 8376 | 346 | 3.098901 | 10.72219746 | uncultured Methanocorpusculum sp. | 176309 | Archaea | Archaea | 259 | 1.8e-64 | NTclustered | gi|2621786121|emb|OY782579.1| | 176309 | g8115 | i0 | 89.1 | 332.115606936416 | 211 | 19 | 60 | 3 | 65 | 272 | 98154 | 98363 | MAG: uncultured Methanocorpusculum sp. isolate 00e4b8a3-32d7-4b6d-ae68-a36d250ebca6 genome assembly, chromosome: 1 | blastn | 114912 | 259 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | uncultured Methanocorpusculum sp. | |
| 21247939 | 21247939 | PRJNA859990_S_NODE_13097_length_286_cov_17.061033_g12836_i0 | PRJNA859990 | 13097 | 286 | 17.061033 | 48.79455438 | uncultured archaeon | 115547 | Archaea | Archaea | 387 | 6.3799999999999995e-103 | NTclustered | gi|283837254|dbj|AB541811.1| | 115547 | g12836 | i0 | 100 | 74.9965034965035 | 209 | 0 | 73 | 0 | 67 | 275 | 211 | 3 | Uncultured archaeon gene for 16S rRNA, partial sequence, clone: K09_10_49 | blastn | 21449 | 387 | 1 | Archaea | uncultured archaeon | ||||||||
| 21638081 | 21638081 | PRJNA859990_S_NODE_12997_length_287_cov_9.014019_g12736_i0 | PRJNA859990 | 12997 | 287 | 9.014019 | 25.87023453 | root | 1 | Root_unresolved | Root_unresolved | 296 | 1.11e-75 | NTclustered | gi|399117610|dbj|AB739345.1| | 115547 | g12736 | i0 | 100 | 55.7491289198606 | 160 | 0 | 56 | 0 | 64 | 223 | 1244 | 1085 | Uncultured archaeon gene for 16S rRNA, partial sequence, clone: HMET47 | blastn | 16000 | 296 | 1 | Archaea | uncultured archaeon | ||||||||
| 25072152 | 25072152 | PRJNA859990_S_NODE_8300_length_348_cov_1.469091_g8039_i0 | PRJNA859990 | 8300 | 348 | 1.469091 | 5.11243668 | Methanobrevibacter sp. YE315 | 1609968 | Archaea | Archaea | 204 | 8.599999999999999e-48 | NTclustered | gi|985614202|gb|CP010834.1| | 1609968 | g8039 | i0 | 89.937 | 171.988505747126 | 159 | 15 | 46 | 1 | 124 | 282 | 1994660 | 1994503 | Methanobrevibacter sp. YE315, complete genome | blastn | 59852 | 204 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. YE315 | |
| 27118085 | 27118085 | PRJNA859990_S_NODE_17082_length_255_cov_1.252747_g16821_i0 | PRJNA859990 | 17082 | 255 | 1.252747 | 3.19450485 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 93.6 | 3.32e-21 | NR | TFG98658.1 | 2053491 | g16821 | i0 | 54.1 | 1 | 85 | 38 | 98.8 | 1 | 3 | 254 | 14 | 98 | TFG98658.1 MAG: hypothetical protein E4H12_05440 [Candidatus Thorarchaeota archaeon] | diamond | 255 | 93.6 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 29273596 | 29273596 | PRJNA859990_S_NODE_21669_length_242_cov_0.911243_g21408_i0 | PRJNA859990 | 21669 | 242 | 0.911243 | 2.20520806 | Thermoproteati | 1783275 | Archaea | Archaea | 46.2 | 0.00204 | NR | MBS7611509.1 | 2026714 | g21408 | i0 | 84.6 | 4.25206611570248 | 26 | 4 | 32.2 | 0 | 237 | 160 | 272 | 297 | MBS7611509.1 FAD-dependent oxidoreductase [Candidatus Bathyarchaeota archaeon] | diamond | 1029 | 46.2 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 30623636 | 30623636 | PRJNA859990_S_NODE_22273_length_241_cov_0.880952_g22012_i0 | PRJNA859990 | 22273 | 241 | 0.880952 | 2.12309432 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 64.3 | 1.27e-10 | NR | HUO62002.1 | 3045160 | g22012 | i0 | 44 | 1.76763485477178 | 75 | 42 | 93.4 | 0 | 14 | 238 | 79 | 153 | HUO62002.1 hypothetical protein [Candidatus Bathyarchaeia archaeon] | diamond | 426 | 64.3 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 31888285 | 31888285 | PRJNA859990_S_NODE_11177_length_306_cov_1.210300_g10916_i0 | PRJNA859990 | 11177 | 306 | 1.2103 | 3.703518 | archaeon | 1906665 | Archaea | Archaea | 97.8 | 3.129999999999999e-23 | NR | NCP98210.1 | 1906665 | g10916 | i0 | 55.3 | 0.833333333333333 | 85 | 37 | 83.3 | 1 | 52 | 306 | 1 | 84 | NCP98210.1 transcription termination/antitermination protein NusG [archaeon] | diamond | 255 | 97.8 | 1 | Archaea | archaeon |
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);;