contig_metadata
7 rows where bioproject = "PRJEB6054" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26203554 | 26203554 | PRJEB6054_S_NODE_1918_length_309_cov_996.821168_g1829_i0 | PRJEB6054 | 1918 | 309 | 996.821168 | 3080.17740912 | archaeon | 1906665 | Archaea | Archaea | 118 | 7.329999999999999e-31 | NR | RYH25290.1 | 1906665 | g1829 | i0 | 88.1 | 0.572815533980582 | 59 | 7 | 57.3 | 0 | 309 | 133 | 148 | 206 | RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon] | diamond | 177 | 118 | 1 | Archaea | archaeon | ||||||||
| 26475538 | 26475538 | PRJEB6054_S_NODE_11632_length_167_cov_1.371212_g11543_i0 | PRJEB6054 | 11632 | 167 | 1.371212 | 2.28992404 | Methanosphaera sp. ISO3-F5 | 1452353 | Archaea | Archaea | 52.8 | 0.014 | NTclustered | gi|2695672541|gb|CP118754.2| | 1452353 | g11543 | i0 | 100 | 0.167664670658683 | 28 | 0 | 17 | 0 | 34 | 61 | 141713 | 141740 | Methanosphaera sp. ISO3-F5 plasmid pNP174, complete sequence | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. ISO3-F5 | |
| 32911625 | 32911625 | PRJEB6054_S_NODE_10961_length_171_cov_1.801471_g10872_i0 | PRJEB6054 | 10961 | 171 | 1.801471 | 3.08051541 | archaeon | 1906665 | Archaea | Archaea | 47.8 | 1.07e-4 | NR | RYH03712.1 | 1906665 | g10872 | i0 | 95.5 | 0.385964912280702 | 22 | 1 | 38.6 | 0 | 2 | 67 | 137 | 158 | RYH03712.1 MAG: hypothetical protein EON65_47145 [archaeon] | diamond | 66 | 47.8 | 1 | Archaea | archaeon | ||||||||
| 32997172 | 32997172 | PRJEB6054_S_NODE_4211_length_234_cov_4.311558_g4122_i0 | PRJEB6054 | 4211 | 234 | 4.311558 | 10.08904572 | archaeon | 1906665 | Archaea | Archaea | 73.9 | 4.54e-15 | NR | RYH00022.1 | 1906665 | g4122 | i0 | 75.4 | 0.782051282051282 | 61 | 15 | 78.2 | 0 | 232 | 50 | 38 | 98 | RYH00022.1 MAG: hypothetical protein EON65_49750 [archaeon] | diamond | 183 | 73.9 | 1 | Archaea | archaeon | ||||||||
| 33065351 | 33065351 | PRJEB6054_S_NODE_11589_length_167_cov_2.651515_g11500_i0 | PRJEB6054 | 11589 | 167 | 2.651515 | 4.42803005 | archaeon | 1906665 | Archaea | Archaea | 80.5 | 2.82e-16 | NR | RYG65852.1 | 1906665 | g11500 | i0 | 79.1 | 0.772455089820359 | 43 | 9 | 77.2 | 0 | 162 | 34 | 268 | 310 | RYG65852.1 MAG: hypothetical protein EON64_11065 [archaeon] | diamond | 129 | 80.5 | 1 | Archaea | archaeon | ||||||||
| 33133768 | 33133768 | PRJEB6054_S_NODE_8815_length_183_cov_3.398649_g8726_i0 | PRJEB6054 | 8815 | 183 | 3.398649 | 6.21952767 | archaeon | 1906665 | Archaea | Archaea | 47.8 | 1.14e-5 | NR | RYG69863.1 | 1906665 | g8726 | i0 | 95 | 0.639344262295082 | 20 | 1 | 32.8 | 0 | 3 | 62 | 13 | 32 | RYG69863.1 MAG: hypothetical protein EON64_01665 [archaeon] | diamond | 117 | 47.8 | 1 | Archaea | archaeon | ||||||||
| 33150744 | 33150744 | PRJEB6054_S_NODE_8016_length_189_cov_1.876623_g7927_i0 | PRJEB6054 | 8016 | 189 | 1.876623 | 3.54681747 | archaeon | 1906665 | Archaea | Archaea | 46.2 | 3.01e-4 | NR | RYY73917.1 | 1906665 | g7927 | i0 | 100 | 0.444444444444444 | 28 | 0 | 44.4 | 0 | 43 | 126 | 91 | 118 | RYY73917.1 MAG: 50S ribosomal protein P1 [archaeon] | diamond | 84 | 46.2 | 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);;