contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax_clade = "Stenosarchaea 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14043629 | 14043629 | PRJEB11748_P_NODE_184312_length_298_cov_1.675105_g182129_i0 | PRJEB11748 | 184312 | 298 | 1.675105 | 4.9918129 | root | 1 | Root_unresolved | Root_unresolved | 166 | 2.62e-46 | NR | WP_128567077.1 | 570267 | g182129 | i0 | 74.7 | 4.87248322147651 | 99 | 25 | 99.7 | 0 | 297 | 1 | 159 | 257 | WP_128567077.1 PAS domain-containing protein [Methanocella paludicola] | diamond | 1452 | 166 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanocellales | Methanocellaceae | Methanocella | Methanocella paludicola | |
| 26937775 | 26937775 | PRJEB11748_P_NODE_213542_length_272_cov_8.767773_g211359_i0 | PRJEB11748 | 213542 | 272 | 8.767773 | 23.84834256 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 85.5 | 4.5e-17 | NR | MCZ7385823.1 | 2032688 | g211359 | i0 | 68.6 | 1.70955882352941 | 51 | 16 | 56.3 | 0 | 183 | 31 | 349 | 399 | MCZ7385823.1 ATP-binding protein [Candidatus Methanoperedens sp.] | diamond | 465 | 85.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 27254018 | 27254018 | PRJEB11748_P_NODE_293703_length_222_cov_10.838509_g291520_i0 | PRJEB11748 | 293703 | 222 | 10.838509 | 24.06148998 | Candidatus Methanofastidiosia archaeon | 2099674 | Archaea | Archaea | 52.4 | 1.02e-5 | NR | NMC58615.1 | 2099674 | g291520 | i0 | 43.9 | 0.891891891891892 | 66 | 30 | 87.8 | 2 | 198 | 4 | 224 | 283 | NMC58615.1 hypothetical protein [Candidatus Methanofastidiosia archaeon] | diamond | 198 | 52.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosia archaeon | ||||
| 27601733 | 27601733 | PRJEB11748_P_NODE_217324_length_269_cov_10.192308_g215141_i0 | PRJEB11748 | 217324 | 269 | 10.192308 | 27.41730852 | Methanosarcina sp. | 2213 | Archaea | Archaea | 71.6 | 3.52e-12 | NR | HET8686530.1 | 2213 | g215141 | i0 | 36.7 | 0.8810408921933092 | 79 | 50 | 88.1 | 0 | 262 | 26 | 785 | 863 | HET8686530.1 CHC2 zinc finger domain-containing protein [Methanosarcina sp.] | diamond | 237 | 71.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 27728282 | 27728282 | PRJEB11748_P_NODE_302724_length_218_cov_3.140127_g300541_i0 | PRJEB11748 | 302724 | 218 | 3.140127 | 6.84547686 | Methanospirillum sp. | 45200 | Archaea | Archaea | 59.7 | 2.87e-8 | NR | MEN6342654.1 | 45200 | g300541 | i0 | 65.8 | 0.522935779816514 | 38 | 13 | 52.3 | 0 | 8 | 121 | 12 | 49 | MEN6342654.1 SBBP repeat-containing protein [Methanospirillum sp.] | diamond | 114 | 59.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 28006071 | 28006071 | PRJEB11748_P_NODE_303105_length_218_cov_2.121019_g300922_i0 | PRJEB11748 | 303105 | 218 | 2.121019 | 4.62382142 | Natrialba | 63742 | Archaea | Archaea | 43.9 | 0.00749 | NR | WP_004217211.1 | 13769 | g300922 | i0 | 50 | 1.81651376146789 | 44 | 16 | 52.3 | 1 | 209 | 96 | 137 | 180 | WP_004217211.1 GNAT family N-acetyltransferase [Natrialba magadii] | diamond | 396 | 43.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrialba | Natrialba magadii | |
| 28264386 | 28264386 | PRJEB11748_P_NODE_144606_length_342_cov_4.316726_g142427_i0 | PRJEB11748 | 144606 | 342 | 4.316726 | 14.76320292 | Methanosarcina sp. | 2213 | Archaea | Archaea | 118 | 7.839999999999999e-30 | NR | HET8686534.1 | 2213 | g142427 | i0 | 53.1 | 0.859649122807018 | 98 | 44 | 84.2 | 1 | 319 | 32 | 53 | 150 | HET8686534.1 hypothetical protein [Methanosarcina sp.] | diamond | 294 | 118 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28832887 | 28832887 | PRJEB11748_P_NODE_232028_length_259_cov_1.075758_g229845_i0 | PRJEB11748 | 232028 | 259 | 1.075758 | 2.78621322 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 70.5 | 6.3e-14 | NR | WAM22632.1 | 2032688 | g229845 | i0 | 50.8 | 1.30888030888031 | 59 | 28 | 67.2 | 1 | 257 | 84 | 8 | 66 | WAM22632.1 MAG: hypothetical protein OI715_00635, partial [Candidatus Methanoperedens sp.] | diamond | 339 | 70.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 29180389 | 29180389 | PRJEB11748_P_NODE_160869_length_322_cov_4.954023_g158687_i0 | PRJEB11748 | 160869 | 322 | 4.954023 | 15.95195406 | Halococcus sp. | 29286 | Archaea | Archaea | 53.1 | 6.57e-6 | NR | HET7325469.1 | 29286 | g158687 | i0 | 57.5 | 0.698757763975155 | 40 | 17 | 37.3 | 0 | 314 | 195 | 127 | 166 | HET7325469.1 hypothetical protein [Halococcus sp.] | diamond | 225 | 53.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. | |
| 29495921 | 29495921 | PRJEB11748_P_NODE_168670_length_313_cov_12.063492_g166487_i0 | PRJEB11748 | 168670 | 313 | 12.063492 | 37.75872996 | Candidatus Methanophagales archaeon | 2056316 | Archaea | Archaea | 69.7 | 2.32e-11 | NR | MCW3128524.1 | 2056316 | g166487 | i0 | 37.8 | 1.86900958466454 | 98 | 58 | 92 | 2 | 290 | 3 | 10 | 106 | MCW3128524.1 AAA family ATPase [Candidatus Methanophagales archaeon] | diamond | 585 | 69.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagales archaeon | |||
| 29653529 | 29653529 | PRJEB11748_P_NODE_278770_length_230_cov_3.319527_g276587_i0 | PRJEB11748 | 278770 | 230 | 3.319527 | 7.6349121 | Methanosarcina sp. | 2213 | Archaea | Archaea | 72.8 | 8.07e-13 | NR | HET8686062.1 | 2213 | g276587 | i0 | 48.5 | 2.49130434782609 | 68 | 35 | 88.7 | 0 | 22 | 225 | 517 | 584 | HET8686062.1 hypothetical protein [Methanosarcina sp.] | diamond | 573 | 72.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 29843311 | 29843311 | PRJEB11748_P_NODE_248231_length_248_cov_1.882353_g246048_i0 | PRJEB11748 | 248231 | 248 | 1.882353 | 4.66823544 | Candidatus Methanoperedenaceae archaeon | 2072416 | Archaea | Archaea | 97.4 | 1.0100000000000002e-21 | NR | PWB50809.1 | 2072416 | g246048 | i0 | 62 | 5.86693548387097 | 79 | 30 | 95.6 | 0 | 248 | 12 | 30 | 108 | PWB50809.1 MAG: hypothetical protein C3F06_12005 [Candidatus Methanoperedenaceae archaeon] | diamond | 1455 | 97.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedenaceae archaeon | ||
| 29843365 | 29843365 | PRJEB11748_P_NODE_314631_length_212_cov_28.774834_g312448_i0 | PRJEB11748 | 314631 | 212 | 28.774834 | 61.00264808 | Candidatus Methanofastidiosia archaeon | 2099674 | Archaea | Archaea | 65.5 | 1.56e-10 | NR | NMC57857.1 | 2099674 | g312448 | i0 | 100 | 0.424528301886792 | 30 | 0 | 42.5 | 0 | 132 | 43 | 146 | 175 | NMC57857.1 hypothetical protein [Candidatus Methanofastidiosia archaeon] | diamond | 90 | 65.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosia archaeon | ||||
| 30311551 | 30311551 | PRJEB11748_P_NODE_97272_length_423_cov_32.693370_g95102_i0 | PRJEB11748 | 97272 | 423 | 32.69337 | 138.2929551 | Archaea | 2157 | Archaea | Archaea | 169 | 8.87e-46 | NR | OPY29367.1 | 1811677 | g95102 | i0 | 68.5 | 4.41843971631206 | 124 | 39 | 87.9 | 0 | 20 | 391 | 557 | 680 | OPY29367.1 MAG: PKD domain protein [Methanocella sp. PtaU1.Bin125] | diamond | 1869 | 169 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanocellales | Methanocellaceae | Methanocella | Methanocella sp. PtaU1.Bin125 | |
| 30406200 | 30406200 | PRJEB11748_P_NODE_258733_length_241_cov_11.822222_g256550_i0 | PRJEB11748 | 258733 | 241 | 11.822222 | 28.49155502 | root | 1 | Root_unresolved | Root_unresolved | 122 | 6.609999999999999e-31 | NR | MCA1820090.1 | 1904752 | g256550 | i0 | 80 | 4.44398340248963 | 70 | 14 | 87.1 | 0 | 211 | 2 | 164 | 233 | MCA1820090.1 transposase [Halobacteriales archaeon] | diamond | 1071 | 122 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon | |||
| 30569778 | 30569778 | PRJEB11748_P_NODE_317173_length_211_cov_14.320000_g314990_i0 | PRJEB11748 | 317173 | 211 | 14.32 | 30.2152 | Methanothrix sp. | 90426 | Archaea | Archaea | 45.8 | 0.0018600000000000001 | NR | MDD2755774.1 | 90426 | g314990 | i0 | 51.4 | 1.03791469194313 | 37 | 18 | 52.6 | 0 | 115 | 5 | 213 | 249 | MDD2755774.1 tetratricopeptide repeat protein [Methanothrix sp.] | diamond | 219 | 45.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 31106970 | 31106970 | PRJEB11748_P_NODE_244455_length_250_cov_6.544974_g242272_i0 | PRJEB11748 | 244455 | 250 | 6.544974 | 16.362435 | Candidatus Methanofastidiosia archaeon | 2099674 | Archaea | Archaea | 53.1 | 7.51e-6 | NR | NMC58615.1 | 2099674 | g242272 | i0 | 60.5 | 0.456 | 38 | 15 | 45.6 | 0 | 220 | 107 | 234 | 271 | NMC58615.1 hypothetical protein [Candidatus Methanofastidiosia archaeon] | diamond | 114 | 53.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosia archaeon | ||||
| 31265057 | 31265057 | PRJEB11748_P_NODE_112975_length_391_cov_6.557576_g110801_i0 | PRJEB11748 | 112975 | 391 | 6.557576 | 25.64012216 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 109 | 4.05e-25 | NR | MCE8425224.1 | 2032688 | g110801 | i0 | 46.2 | 0.813299232736573 | 106 | 56 | 81.3 | 1 | 369 | 52 | 391 | 495 | MCE8425224.1 DUF4157 domain-containing protein [Candidatus Methanoperedens sp.] | diamond | 318 | 109 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 31328332 | 31328332 | PRJEB11748_P_NODE_207116_length_278_cov_1.557604_g204933_i0 | PRJEB11748 | 207116 | 278 | 1.557604 | 4.33013912 | Methanosarcina sp. UBA5 | 1915593 | Archaea | Archaea | 58.9 | 1.17e-7 | NR | WP_292387814.1 | 1915593 | g204933 | i0 | 48.5 | 1.4136690647482 | 66 | 34 | 71.2 | 0 | 277 | 80 | 958 | 1023 | WP_292387814.1 chemotaxis protein CheB [Methanosarcina sp. UBA5] | diamond | 393 | 58.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. UBA5 | |
| 31486752 | 31486752 | PRJEB11748_P_NODE_207216_length_278_cov_1.069124_g205033_i0 | PRJEB11748 | 207216 | 278 | 1.069124 | 2.97216472 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 142 | 1.46e-38 | NR | MCZ7361662.1 | 2032688 | g205033 | i0 | 70 | 2.8705035971223 | 90 | 27 | 97.1 | 0 | 8 | 277 | 53 | 142 | MCZ7361662.1 hypothetical protein [Candidatus Methanoperedens sp.] | diamond | 798 | 142 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 31923134 | 31923134 | PRJEB11748_P_NODE_122877_length_374_cov_3.600639_g120701_i0 | PRJEB11748 | 122877 | 374 | 3.600639 | 13.46638986 | root | 1 | Root_unresolved | Root_unresolved | 117 | 1.28e-27 | NR | WP_256532503.1 | 1487865 | g120701 | i0 | 56.6 | 8.27005347593583 | 113 | 46 | 89 | 2 | 349 | 17 | 243 | 354 | WP_256532503.1 S8 family serine peptidase [Halovivax cerinus] | diamond | 3093 | 117 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halovivax | Halovivax cerinus | |
| 32461198 | 32461198 | PRJEB11748_P_NODE_296199_length_221_cov_4.131250_g294016_i0 | PRJEB11748 | 296199 | 221 | 4.13125 | 9.1300625 | root | 1 | Root_unresolved | Root_unresolved | 97.8 | 5e-22 | NR | MDY0386670.1 | 1874737 | g294016 | i0 | 84.9 | 1.43891402714932 | 53 | 8 | 71.9 | 0 | 58 | 216 | 3 | 55 | MDY0386670.1 IS200/IS605 family element RNA-guided endonuclease TnpB [Methanolobus sp.] | diamond | 318 | 97.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus sp. | |
| 32681702 | 32681702 | PRJEB11748_P_NODE_104960_length_407_cov_5.005780_g102788_i0 | PRJEB11748 | 104960 | 407 | 5.00578 | 20.3735246 | root | 1 | Root_unresolved | Root_unresolved | 127 | 1.12e-31 | NR | MDD1748279.1 | 90426 | g102788 | i0 | 57 | 3.94348894348894 | 107 | 46 | 78.9 | 0 | 326 | 6 | 50 | 156 | MDD1748279.1 transposase [Methanothrix sp.] | diamond | 1605 | 128 | 0.9921875 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix 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);;