contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA384462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11884025 | 11884025 | PRJNA384462_S_NODE_9170_length_190_cov_1.007092_g9054_i0 | PRJNA384462 | 9170 | 190 | 1.007092 | 1.9134748 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 114 | 7.58e-28 | NR | RYE83270.1 | 2250255 | g9054 | i0 | 90.2 | 2.92105263157895 | 61 | 6 | 96.3 | 0 | 3 | 185 | 378 | 438 | RYE83270.1 MAG: hypothetical protein EOO65_04230, partial [Methanosarcinales archaeon] | diamond | 555 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 26632005 | 26632005 | PRJNA384462_S_NODE_11581_length_174_cov_1.224000_g11465_i0 | PRJNA384462 | 11581 | 174 | 1.224 | 2.12976 | archaeon | 1906665 | Archaea | Archaea | 45.8 | 1.88e-4 | NR | RYY35050.1 | 1906665 | g11465 | i0 | 58.8 | 0.586206896551724 | 34 | 14 | 58.6 | 0 | 172 | 71 | 55 | 88 | RYY35050.1 MAG: hypothetical protein EON62_02800 [archaeon] | diamond | 102 | 45.8 | 1 | Archaea | archaeon | ||||||||
| 28211917 | 28211917 | PRJNA384462_S_NODE_11786_length_173_cov_1.177419_g11670_i0 | PRJNA384462 | 11786 | 173 | 1.177419 | 2.03693487 | archaeon | 1906665 | Archaea | Archaea | 105 | 7.09e-28 | NR | RYH28873.1 | 1906665 | g11670 | i0 | 85.7 | 0.971098265895954 | 56 | 8 | 97.1 | 0 | 1 | 168 | 26 | 81 | RYH28873.1 MAG: hypothetical protein EON65_10550 [archaeon] | diamond | 168 | 105 | 1 | Archaea | archaeon | ||||||||
| 28464901 | 28464901 | PRJNA384462_S_NODE_15506_length_161_cov_0.901786_g15390_i0 | PRJNA384462 | 15506 | 161 | 0.901786 | 1.45187546 | archaeon | 1906665 | Archaea | Archaea | 45.1 | 5.67e-4 | NR | RYY73917.1 | 1906665 | g15390 | i0 | 100 | 0.372670807453416 | 20 | 0 | 37.3 | 0 | 91 | 150 | 91 | 110 | RYY73917.1 MAG: 50S ribosomal protein P1 [archaeon] | diamond | 60 | 45.1 | 1 | Archaea | archaeon | ||||||||
| 28671216 | 28671216 | PRJNA384462_S_NODE_9647_length_186_cov_1.116788_g9531_i0 | PRJNA384462 | 9647 | 186 | 1.116788 | 2.07722568 | Thermoplasmatota | 2283796 | Archaea | Archaea | 42.4 | 0.0211 | NR | DAC54348.1 | 2163009 | g9531 | i0 | 47.9 | 5.82258064516129 | 48 | 25 | 77.4 | 0 | 158 | 15 | 1 | 48 | DAC54348.1 MAG TPA: 50S ribosomal protein L32e [Candidatus Poseidoniales archaeon] | diamond | 1083 | 42.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 28906588 | 28906588 | PRJNA384462_S_NODE_1968_length_371_cov_1.254658_g1852_i0 | PRJNA384462 | 1968 | 371 | 1.254658 | 4.65478118 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 76.3 | 2.15e-13 | NR | HVB12067.1 | 2268197 | g1852 | i0 | 53.5 | 1.14824797843666 | 71 | 32 | 56.6 | 1 | 5 | 214 | 304 | 374 | HVB12067.1 molecular chaperone DnaJ [Nitrososphaerales archaeon] | diamond | 426 | 76.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 29664196 | 29664196 | PRJNA384462_S_NODE_5670_length_228_cov_1.139665_g5554_i0 | PRJNA384462 | 5670 | 228 | 1.139665 | 2.5984362 | archaeon | 1906665 | Archaea | Archaea | 65.9 | 5.02e-12 | NR | RYY35050.1 | 1906665 | g5554 | i0 | 46.3 | 3.43421052631579 | 67 | 33 | 86.8 | 2 | 226 | 29 | 24 | 88 | RYY35050.1 MAG: hypothetical protein EON62_02800 [archaeon] | diamond | 783 | 65.9 | 1 | Archaea | archaeon | ||||||||
| 29948857 | 29948857 | PRJNA384462_S_NODE_9751_length_185_cov_1.500000_g9635_i0 | PRJNA384462 | 9751 | 185 | 1.5 | 2.775 | archaeon | 1906665 | Archaea | Archaea | 97.4 | 4.64e-25 | NR | RYY82745.1 | 1906665 | g9635 | i0 | 82.8 | 1.91351351351351 | 58 | 10 | 94.1 | 0 | 185 | 12 | 4 | 61 | RYY82745.1 MAG: hypothetical protein EON63_12740 [archaeon] | diamond | 354 | 97.4 | 1 | Archaea | archaeon | ||||||||
| 31054933 | 31054933 | PRJNA384462_S_NODE_2255_length_348_cov_1.357860_g2139_i0 | PRJNA384462 | 2255 | 348 | 1.35786 | 4.7253528 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 43.1 | 0.0433 | NR | MCK5604269.1 | 2026773 | g2139 | i0 | 30.8 | 0.78448275862069 | 91 | 49 | 78.4 | 2 | 345 | 73 | 28 | 104 | MCK5604269.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 273 | 43.1 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 31086253 | 31086253 | PRJNA384462_S_NODE_1315_length_455_cov_3.201970_g1199_i0 | PRJNA384462 | 1315 | 455 | 3.20197 | 14.5689635 | archaeon | 1906665 | Archaea | Archaea | 184 | 1.52e-54 | NR | RYG64822.1 | 1906665 | g1199 | i0 | 64.1 | 1.74065934065934 | 131 | 47 | 86.4 | 0 | 454 | 62 | 167 | 297 | RYG64822.1 MAG: 3-hydroxybutyryl-CoA dehydrogenase [archaeon] | diamond | 792 | 184 | 1 | Archaea | archaeon | ||||||||
| 31148987 | 31148987 | PRJNA384462_S_NODE_7595_length_204_cov_0.987097_g7479_i0 | PRJNA384462 | 7595 | 204 | 0.987097 | 2.01367788 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 109 | 1e-27 | NR | MAO54017.1 | 2026739 | g7479 | i0 | 76.1 | 3.73529411764706 | 67 | 16 | 98.5 | 0 | 202 | 2 | 142 | 208 | MAO54017.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Methanobacteriota archaeon] | diamond | 762 | 109 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31433942 | 31433942 | PRJNA384462_S_NODE_6916_length_211_cov_2.055556_g6800_i0 | PRJNA384462 | 6916 | 211 | 2.055556 | 4.33722316 | Methanopyrus | 2319 | Archaea | Archaea | 42.7 | 0.00273 | NR | WP_011019823.1 | 2319 | g6800 | i0 | 48 | 0.710900473933649 | 50 | 22 | 69.7 | 2 | 211 | 65 | 14 | 60 | WP_011019823.1 MULTISPECIES: 30S ribosomal protein S27ae [Methanopyrus] | diamond | 150 | 42.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanopyri | Methanopyrales | Methanopyraceae | Methanopyrus | ||
| 31845111 | 31845111 | PRJNA384462_S_NODE_9937_length_184_cov_1.133333_g9821_i0 | PRJNA384462 | 9937 | 184 | 1.133333 | 2.08533272 | archaeon | 1906665 | Archaea | Archaea | 57.8 | 6.47e-9 | NR | RYH29413.1 | 1906665 | g9821 | i0 | 71.4 | 0.570652173913043 | 35 | 10 | 57.1 | 0 | 184 | 80 | 68 | 102 | RYH29413.1 MAG: 60S ribosomal protein L22 [archaeon] | diamond | 105 | 57.8 | 1 | Archaea | archaeon | ||||||||
| 32083561 | 32083561 | PRJNA384462_S_NODE_13938_length_164_cov_1.330435_g13822_i0 | PRJNA384462 | 13938 | 164 | 1.330435 | 2.1819134 | Archaea | 2157 | Archaea | Archaea | 62 | 2.04e-9 | NR | MFL2951787.1 | 2670411 | g13822 | i0 | 56 | 2.72560975609756 | 50 | 22 | 91.5 | 0 | 160 | 11 | 2599 | 2648 | MFL2951787.1 putative Ig domain-containing protein [Candidatus Thalassarchaeaceae archaeon] | diamond | 447 | 62 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae archaeon | |||
| 32604383 | 32604383 | PRJNA384462_S_NODE_440_length_721_cov_3.142857_g361_i0 | PRJNA384462 | 440 | 721 | 3.142857 | 22.65999897 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 48.5 | 0.0182 | NR | MBS3136408.1 | 2026803 | g361 | i0 | 37.3 | 0.345353675450763 | 83 | 46 | 34.1 | 3 | 504 | 259 | 171 | 248 | MBS3136408.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 249 | 48.5 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota 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);;