contig_metadata
12 rows where bioproject = "PRJEB10140", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5115691 | 5115691 | PRJEB10140_P_NODE_72905_length_503_cov_7.222467_g55742_i0 | PRJEB10140 | 72905 | 503 | 7.222467 | 36.32900901 | Acidiplasma sp. | 1872114 | Archaea | Archaea | 52.8 | 0.049 | NTclustered | gi|2573969472|gb|CP133599.1| | 1872114 | g55742 | i0 | 100 | 0.0556660039761431 | 28 | 0 | 6 | 0 | 411 | 438 | 625798 | 625825 | MAG: Acidiplasma sp. isolate BR_02 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Ferroplasmaceae | Acidiplasma | Acidiplasma sp. | ||
| 6391412 | 6391412 | PRJEB10140_P_NODE_59186_length_619_cov_3.000000_g42539_i0 | PRJEB10140 | 59186 | 619 | 3 | 18.57 | uncultured Candidatus Methanogranum sp. | 2093355 | Archaea | Archaea | 54.7 | 0.017 | NTclustered | gi|2621784480|emb|OY780938.1| | 2093355 | g42539 | i0 | 100 | 0.0936995153473344 | 29 | 0 | 5 | 0 | 79 | 107 | 1261363 | 1261391 | MAG: uncultured Candidatus Methanogranum sp. isolate 9d90576e-3f35-4afd-8682-ecdb60e67c32 genome assembly, chromosome: 1 | blastn | 58 | 54.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Candidatus Methanogranum | uncultured Candidatus Methanogranum sp. | ||
| 10214239 | 10214239 | PRJEB10140_P_NODE_115869_length_315_cov_2.533835_g98563_i0 | PRJEB10140 | 115869 | 315 | 2.533835 | 7.98158025 | Picrophilus oshimae | 46632 | Archaea | Archaea | 54.7 | 0.008 | NTclustered | gi|48429720|gb|AE017261.1| | 1122961 | g98563 | i0 | 100 | 0.0920634920634921 | 29 | 0 | 9 | 0 | 267 | 295 | 836273 | 836245 | Picrophilus torridus DSM 9790, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Picrophilaceae | Picrophilus | Picrophilus oshimae | ||
| 27089896 | 27089896 | PRJEB10140_P_NODE_186322_length_206_cov_3.197452_g169013_i0 | PRJEB10140 | 186322 | 206 | 3.197452 | 6.58675112 | root | 1 | Root_unresolved | Root_unresolved | 99 | 3.700000000000001e-22 | NR | RLF66451.1 | 1906666 | g169013 | i0 | 64.2 | 14.5485436893204 | 67 | 24 | 97.6 | 0 | 202 | 2 | 1743 | 1809 | RLF66451.1 MAG: hypothetical protein DRN30_02085 [Thermoplasmata archaeon] | diamond | 2997 | 99 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 27506758 | 27506758 | PRJEB10140_P_NODE_159563_length_234_cov_3.529730_g142255_i0 | PRJEB10140 | 159563 | 234 | 3.52973 | 8.2595682 | Candidatus Poseidoniia archaeon | 2666348 | Archaea | Archaea | 111 | 1.6500000000000002e-26 | NR | MEO2242304.1 | 2666348 | g142255 | i0 | 66.2 | 0.987179487179487 | 77 | 26 | 98.7 | 0 | 233 | 3 | 327 | 403 | MEO2242304.1 DDE-type integrase/transposase/recombinase [Candidatus Poseidoniia archaeon] | diamond | 231 | 111 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniia archaeon | |||||
| 29306174 | 29306174 | PRJEB10140_P_NODE_135149_length_272_cov_1.596413_g117842_i0 | PRJEB10140 | 135149 | 272 | 1.596413 | 4.34224336 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 133 | 6.5599999999999996e-34 | NR | RLF66451.1 | 1906666 | g117842 | i0 | 66.7 | 0.992647058823529 | 90 | 30 | 99.3 | 0 | 2 | 271 | 1662 | 1751 | RLF66451.1 MAG: hypothetical protein DRN30_02085 [Thermoplasmata archaeon] | diamond | 270 | 133 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29748108 | 29748108 | PRJEB10140_P_NODE_278771_length_164_cov_0.886957_g261462_i0 | PRJEB10140 | 278771 | 164 | 0.886957 | 1.45460948 | Candidatus Methanomethylophilaceae archaeon | 2517205 | Archaea | Archaea | 58.9 | 1.83e-8 | NR | MBR2093840.1 | 2517205 | g261462 | i0 | 70.7 | 0.75 | 41 | 12 | 75 | 0 | 160 | 38 | 1 | 41 | MBR2093840.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon] | diamond | 123 | 58.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Candidatus Methanomethylophilaceae archaeon | |||
| 29874877 | 29874877 | PRJEB10140_P_NODE_92451_length_396_cov_2.097983_g75158_i0 | PRJEB10140 | 92451 | 396 | 2.097983 | 8.30801268 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 52.4 | 6.99e-6 | NR | MEK9697629.1 | 2163009 | g75158 | i0 | 37.5 | 0.606060606060606 | 80 | 46 | 59.1 | 2 | 14 | 247 | 15 | 92 | MEK9697629.1 hypothetical protein [Candidatus Poseidoniales archaeon] | diamond | 240 | 52.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 30632738 | 30632738 | PRJEB10140_P_NODE_198073_length_197_cov_1.033784_g180764_i0 | PRJEB10140 | 198073 | 197 | 1.033784 | 2.03655448 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 45.8 | 0.00166 | NR | MCK4443788.1 | 1906666 | g180764 | i0 | 33.8 | 1.99492385786802 | 71 | 35 | 89.8 | 4 | 186 | 10 | 364 | 434 | MCK4443788.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 393 | 45.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30980673 | 30980673 | PRJEB10140_P_NODE_189874_length_203_cov_1.987013_g172565_i0 | PRJEB10140 | 189874 | 203 | 1.987013 | 4.03363639 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 45.1 | 0.00322 | NR | MEC7757032.1 | 2806419 | g172565 | i0 | 48.8 | 1.25615763546798 | 41 | 21 | 60.6 | 0 | 189 | 67 | 257 | 297 | MEC7757032.1 SAP domain-containing protein [Thermoplasmatota archaeon] | diamond | 255 | 45.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 30980793 | 30980793 | PRJEB10140_P_NODE_80614_length_455_cov_1.524631_g63361_i0 | PRJEB10140 | 80614 | 455 | 1.524631 | 6.93707105 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 52 | 1.61e-4 | NR | MFH1013195.1 | 2806419 | g63361 | i0 | 29.4 | 0.784615384615385 | 119 | 77 | 78.5 | 3 | 79 | 435 | 18 | 129 | MFH1013195.1 NosD domain-containing protein [Thermoplasmatota archaeon] | diamond | 357 | 52 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 31391584 | 31391584 | PRJEB10140_P_NODE_249876_length_168_cov_1.252101_g232567_i0 | PRJEB10140 | 249876 | 168 | 1.252101 | 2.10352968 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 57.8 | 1.4e-8 | NR | DAC06884.1 | 2163009 | g232567 | i0 | 67.4 | 4.26785714285714 | 43 | 14 | 76.8 | 0 | 39 | 167 | 12 | 54 | DAC06884.1 MAG TPA: NADP-specific glutamate dehydrogenase, partial [Candidatus Poseidoniales archaeon] | diamond | 717 | 57.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales 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);;