contig_metadata
20 rows where bioproject = "PRJNA380660" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18253889 | 18253889 | PRJNA380660_P_NODE_3355_length_450_cov_1.983373_g2972_i0 | PRJNA380660 | 3355 | 450 | 1.983373 | 8.9251785 | archaeon | 1906665 | Archaea | Archaea | 205 | 7.61e-65 | NR | RYG67142.1 | 1906665 | g2972 | i0 | 69.5 | 0.94 | 141 | 32 | 86.7 | 2 | 391 | 2 | 2 | 142 | RYG67142.1 MAG: hypothetical protein EON64_08125, partial [archaeon] | diamond | 423 | 205 | 1 | Archaea | archaeon | ||||||||
| 20803711 | 20803711 | PRJNA380660_P_NODE_11377_length_182_cov_1.686275_g10977_i0 | PRJNA380660 | 11377 | 182 | 1.686275 | 3.0690205 | uncultured archaeon | 115547 | Archaea | Archaea | 307 | 2.99e-79 | NTclustered | gi|1032564008|gb|KX029804.1| | 115547 | g10977 | i0 | 100 | 4.82417582417582 | 166 | 0 | 91 | 0 | 17 | 182 | 76 | 241 | Uncultured archaeon clone A_OTU_328 16S ribosomal RNA gene, partial sequence | blastn | 878 | 307 | 1 | Archaea | uncultured archaeon | ||||||||
| 23354281 | 23354281 | PRJNA380660_P_NODE_299_length_1541_cov_5.557540_g210_i0 | PRJNA380660 | 299 | 1541 | 5.55754 | 85.6416914 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 405 | 4.6699999999999984e-133 | NR | MBX7076496.1 | 2099680 | g210 | i0 | 58.8 | 0.665801427644387 | 342 | 140 | 66.6 | 1 | 500 | 1525 | 27 | 367 | MBX7076496.1 F0F1 ATP synthase subunit alpha [Methanobacteriaceae archaeon] | diamond | 1026 | 405 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 27074997 | 27074997 | PRJNA380660_P_NODE_1422_length_717_cov_3.815407_g1123_i0 | PRJNA380660 | 1422 | 717 | 3.815407 | 27.35646819 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 48.5 | 0.0178 | NR | MBS3136408.1 | 2026803 | g1123 | i0 | 37.3 | 0.347280334728033 | 83 | 46 | 34.3 | 3 | 491 | 246 | 171 | 248 | MBS3136408.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 249 | 48.5 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 27548882 | 27548882 | PRJNA380660_P_NODE_9244_length_221_cov_1.177083_g8844_i0 | PRJNA380660 | 9244 | 221 | 1.177083 | 2.60135343 | archaeon | 1906665 | Archaea | Archaea | 92 | 1.57e-20 | NR | RYH14734.1 | 1906665 | g8844 | i0 | 58.9 | 0.990950226244344 | 73 | 26 | 99.1 | 1 | 2 | 220 | 135 | 203 | RYH14734.1 MAG: malate dehydrogenase [archaeon] | diamond | 219 | 92 | 1 | Archaea | archaeon | ||||||||
| 28275050 | 28275050 | PRJNA380660_P_NODE_11246_length_184_cov_3.070968_g10846_i0 | PRJNA380660 | 11246 | 184 | 3.070968 | 5.65058112 | archaeon | 1906665 | Archaea | Archaea | 108 | 5.35e-26 | NR | RYH08717.1 | 1906665 | g10846 | i0 | 88.5 | 1.98913043478261 | 61 | 7 | 99.5 | 0 | 2 | 184 | 359 | 419 | RYH08717.1 MAG: RuvB-like helicase [archaeon] | diamond | 366 | 108 | 1 | Archaea | archaeon | ||||||||
| 28906445 | 28906445 | PRJNA380660_P_NODE_11528_length_179_cov_1.440000_g11128_i0 | PRJNA380660 | 11528 | 179 | 1.44 | 2.5776 | archaeon | 1906665 | Archaea | Archaea | 43.5 | 0.00863 | NR | RYH25605.1 | 1906665 | g11128 | i0 | 40.4 | 0.787709497206704 | 47 | 28 | 78.8 | 0 | 1 | 141 | 410 | 456 | RYH25605.1 MAG: hypothetical protein EON65_15370 [archaeon] | diamond | 141 | 43.5 | 1 | Archaea | archaeon | ||||||||
| 28938330 | 28938330 | PRJNA380660_P_NODE_6808_length_284_cov_1.576471_g6408_i0 | PRJNA380660 | 6808 | 284 | 1.576471 | 4.47717764 | archaeon | 1906665 | Archaea | Archaea | 62.8 | 5.56e-9 | NR | RYH21681.1 | 1906665 | g6408 | i0 | 70.7 | 0.433098591549296 | 41 | 12 | 43.3 | 0 | 2 | 124 | 972 | 1012 | RYH21681.1 MAG: cation-translocating P-type ATPase [archaeon] | diamond | 123 | 62.8 | 1 | Archaea | archaeon | ||||||||
| 29001778 | 29001778 | PRJNA380660_P_NODE_1988_length_602_cov_2.321117_g1655_i0 | PRJNA380660 | 1988 | 602 | 2.321117 | 13.97312434 | archaeon | 1906665 | Archaea | Archaea | 171 | 1.97e-45 | NR | RYG70375.1 | 1906665 | g1655 | i0 | 48.5 | 0.996677740863787 | 200 | 66 | 99.7 | 2 | 1 | 600 | 194 | 356 | RYG70375.1 MAG: ATP-binding cassette domain-containing protein [archaeon] | diamond | 600 | 171 | 1 | Archaea | archaeon | ||||||||
| 29033155 | 29033155 | PRJNA380660_P_NODE_2808_length_500_cov_2.265393_g2439_i0 | PRJNA380660 | 2808 | 500 | 2.265393 | 11.326965 | archaeon | 1906665 | Archaea | Archaea | 191 | 1.48e-56 | NR | RYH00544.1 | 1906665 | g2439 | i0 | 80.5 | 0.678 | 113 | 22 | 67.8 | 0 | 2 | 340 | 235 | 347 | RYH00544.1 MAG: AAA family ATPase, partial [archaeon] | diamond | 339 | 191 | 1 | Archaea | archaeon | ||||||||
| 29127895 | 29127895 | PRJNA380660_P_NODE_6569_length_292_cov_1.730038_g6169_i0 | PRJNA380660 | 6569 | 292 | 1.730038 | 5.05171096 | archaeon | 1906665 | Archaea | Archaea | 46.2 | 3.64e-4 | NR | RYY86090.1 | 1906665 | g6169 | i0 | 41.9 | 1.57191780821918 | 43 | 24 | 44.2 | 1 | 164 | 292 | 20 | 61 | RYY86090.1 MAG: hypothetical protein EON63_06355 [archaeon] | diamond | 459 | 46.2 | 1 | Archaea | archaeon | ||||||||
| 29632480 | 29632480 | PRJNA380660_P_NODE_10090_length_206_cov_1.768362_g9690_i0 | PRJNA380660 | 10090 | 206 | 1.768362 | 3.64282572 | archaeon | 1906665 | Archaea | Archaea | 57.4 | 2.43e-8 | NR | RYG97486.1 | 1906665 | g9690 | i0 | 54.2 | 0.859223300970874 | 59 | 25 | 83 | 1 | 173 | 3 | 28 | 86 | RYG97486.1 MAG: helix-turn-helix domain-containing protein [archaeon] | diamond | 177 | 57.4 | 1 | Archaea | archaeon | ||||||||
| 30391453 | 30391453 | PRJNA380660_P_NODE_5933_length_315_cov_2.671329_g5533_i0 | PRJNA380660 | 5933 | 315 | 2.671329 | 8.41468635 | archaeon | 1906665 | Archaea | Archaea | 120 | 7.549999999999999e-31 | NR | RYG66691.1 | 1906665 | g5533 | i0 | 59.6 | 0.942857142857143 | 99 | 40 | 94.3 | 0 | 311 | 15 | 38 | 136 | RYG66691.1 MAG: hypothetical protein EON64_09195 [archaeon] | diamond | 297 | 120 | 1 | Archaea | archaeon | ||||||||
| 30471358 | 30471358 | PRJNA380660_P_NODE_4313_length_390_cov_2.518006_g3917_i0 | PRJNA380660 | 4313 | 390 | 2.518006 | 9.8202234 | Methanobacteriati | 3366610 | Archaea | Archaea | 198 | 9.95e-61 | NR | MBH33411.1 | 2026739 | g3917 | i0 | 79 | 2.86153846153846 | 124 | 21 | 95.4 | 1 | 373 | 2 | 139 | 257 | MBH33411.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Methanobacteriota archaeon] | diamond | 1116 | 198 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30548901 | 30548901 | PRJNA380660_P_NODE_5573_length_329_cov_2.390000_g5174_i0 | PRJNA380660 | 5573 | 329 | 2.39 | 7.8631 | archaeon | 1906665 | Archaea | Archaea | 186 | 5.63e-58 | NR | RYG68742.1 | 1906665 | g5174 | i0 | 82.6 | 0.993920972644377 | 109 | 19 | 99.4 | 0 | 327 | 1 | 22 | 130 | RYG68742.1 MAG: hypothetical protein EON64_04505 [archaeon] | diamond | 327 | 186 | 1 | Archaea | archaeon | ||||||||
| 30833304 | 30833304 | PRJNA380660_P_NODE_4614_length_373_cov_3.552326_g4217_i0 | PRJNA380660 | 4614 | 373 | 3.552326 | 13.25017598 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 45.1 | 0.0225 | NR | MCH8906695.1 | 2026747 | g4217 | i0 | 50 | 0.369973190348525 | 46 | 21 | 35.4 | 1 | 3 | 134 | 40 | 85 | MCH8906695.1 FG-GAP repeat protein [Candidatus Heimdallarchaeota archaeon] | diamond | 138 | 45.1 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 30991401 | 30991401 | PRJNA380660_P_NODE_8954_length_226_cov_2.121827_g8554_i0 | PRJNA380660 | 8954 | 226 | 2.121827 | 4.79532902 | archaeon | 1906665 | Archaea | Archaea | 48.9 | 2e-4 | NR | RYG64555.1 | 1906665 | g8554 | i0 | 45.8 | 0.63716814159292 | 48 | 23 | 63.7 | 1 | 11 | 154 | 202 | 246 | RYG64555.1 MAG: hypothetical protein EON64_13755, partial [archaeon] | diamond | 144 | 48.9 | 1 | Archaea | archaeon | ||||||||
| 31212017 | 31212017 | PRJNA380660_P_NODE_4195_length_397_cov_1.983696_g3800_i0 | PRJNA380660 | 4195 | 397 | 1.983696 | 7.87527312 | archaeon | 1906665 | Archaea | Archaea | 46.6 | 0.00815 | NR | RYH31666.1 | 1906665 | g3800 | i0 | 47.5 | 0.302267002518892 | 40 | 21 | 30.2 | 0 | 391 | 272 | 386 | 425 | RYH31666.1 MAG: hypothetical protein EON65_02130 [archaeon] | diamond | 120 | 46.6 | 1 | Archaea | archaeon | ||||||||
| 31528868 | 31528868 | PRJNA380660_P_NODE_11176_length_186_cov_1.598726_g10776_i0 | PRJNA380660 | 11176 | 186 | 1.598726 | 2.97363036 | archaeon | 1906665 | Archaea | Archaea | 56.6 | 2.16e-7 | NR | RYG70294.1 | 1906665 | g10776 | i0 | 46.7 | 0.967741935483871 | 60 | 31 | 96.8 | 1 | 184 | 5 | 306 | 364 | RYG70294.1 MAG: hypothetical protein EON64_00570 [archaeon] | diamond | 180 | 56.6 | 1 | Archaea | archaeon | ||||||||
| 31623590 | 31623590 | PRJNA380660_P_NODE_7476_length_263_cov_2.735043_g7076_i0 | PRJNA380660 | 7476 | 263 | 2.735043 | 7.19316309 | archaeon | 1906665 | Archaea | Archaea | 86.3 | 7.16e-18 | NR | RYG65852.1 | 1906665 | g7076 | i0 | 50.6 | 0.992395437262357 | 87 | 42 | 99.2 | 1 | 1 | 261 | 113 | 198 | RYG65852.1 MAG: hypothetical protein EON64_11065 [archaeon] | diamond | 261 | 86.3 | 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);;