contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26598764 | 26598764 | PRJNA168635_P_NODE_24501_length_170_cov_2.471074_g24085_i0 | PRJNA168635 | 24501 | 170 | 2.471074 | 4.2008258 | Methanosarcina sp. | 2213 | Archaea | Archaea | 50.1 | 1.84e-5 | NR | HET8688588.1 | 2213 | g24085 | i0 | 60.6 | 0.582352941176471 | 33 | 13 | 58.2 | 0 | 110 | 12 | 1 | 33 | HET8688588.1 hypothetical protein [Methanosarcina sp.] | diamond | 99 | 50.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 27597387 | 27597387 | PRJNA168635_P_NODE_17324_length_192_cov_2.545455_g16908_i0 | PRJNA168635 | 17324 | 192 | 2.545455 | 4.8872736 | root | 1 | Root_unresolved | Root_unresolved | 82 | 2.77e-16 | NR | HET8689298.1 | 2213 | g16908 | i0 | 57.4 | 1.890625 | 61 | 26 | 95.3 | 0 | 7 | 189 | 7 | 67 | HET8689298.1 hypothetical protein [Methanosarcina sp.] | diamond | 363 | 82 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 27737622 | 27737622 | PRJNA168635_P_NODE_27044_length_167_cov_1.067797_g26628_i0 | PRJNA168635 | 27044 | 167 | 1.067797 | 1.78322099 | Methanosarcina sp. | 2213 | Archaea | Archaea | 111 | 8.76e-28 | NR | HET8688246.1 | 2213 | g26628 | i0 | 87.3 | 0.988023952095808 | 55 | 7 | 98.8 | 0 | 167 | 3 | 140 | 194 | HET8688246.1 hypothetical protein [Methanosarcina sp.] | diamond | 165 | 111 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 27958332 | 27958332 | PRJNA168635_P_NODE_19045_length_185_cov_11.235294_g18629_i0 | PRJNA168635 | 19045 | 185 | 11.235294 | 20.7852939 | Methanolobus sp. | 1874737 | Archaea | Archaea | 55.5 | 2.5e-7 | NR | WP_292462491.1 | 1874737 | g18629 | i0 | 50 | 1.42702702702703 | 46 | 23 | 74.6 | 0 | 146 | 9 | 45 | 90 | WP_292462491.1 uracil-DNA glycosylase [Methanolobus sp.] | diamond | 264 | 55.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus sp. | |
| 28495239 | 28495239 | PRJNA168635_P_NODE_34967_length_153_cov_2.923077_g34551_i0 | PRJNA168635 | 34967 | 153 | 2.923077 | 4.47230781 | Methanosarcina sp. | 2213 | Archaea | Archaea | 76.3 | 1.63e-14 | NR | HET8689298.1 | 2213 | g34551 | i0 | 61.2 | 0.96078431372549 | 49 | 19 | 96.1 | 0 | 151 | 5 | 657 | 705 | HET8689298.1 hypothetical protein [Methanosarcina sp.] | diamond | 147 | 76.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28873916 | 28873916 | PRJNA168635_P_NODE_27668_length_166_cov_2.495726_g27252_i0 | PRJNA168635 | 27668 | 166 | 2.495726 | 4.14290516 | Methanolobus sp. | 1874737 | Archaea | Archaea | 50.4 | 2.48e-6 | NR | MDY0388902.1 | 1874737 | g27252 | i0 | 70 | 0.542168674698795 | 30 | 9 | 54.2 | 0 | 90 | 1 | 1 | 30 | MDY0388902.1 hypothetical protein [Methanolobus sp.] | diamond | 90 | 50.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus sp. | |
| 30010875 | 30010875 | PRJNA168635_P_NODE_10011_length_262_cov_3.436620_g9596_i0 | PRJNA168635 | 10011 | 262 | 3.43662 | 9.0039444 | Methanosarcina sp. | 2213 | Archaea | Archaea | 48.5 | 9.28e-5 | NR | HET8688784.1 | 2213 | g9596 | i0 | 47.9 | 0.549618320610687 | 48 | 25 | 55 | 0 | 177 | 34 | 1 | 48 | HET8688784.1 hypothetical protein [Methanosarcina sp.] | diamond | 144 | 48.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 30073767 | 30073767 | PRJNA168635_P_NODE_24012_length_171_cov_3.245902_g23596_i0 | PRJNA168635 | 24012 | 171 | 3.245902 | 5.55049242 | Methanosarcina sp. | 2213 | Archaea | Archaea | 87 | 1.92e-18 | NR | HET8687065.1 | 2213 | g23596 | i0 | 71.4 | 1.98245614035088 | 56 | 16 | 98.2 | 0 | 4 | 171 | 257 | 312 | HET8687065.1 hypothetical protein [Methanosarcina sp.] | diamond | 339 | 87 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 30295482 | 30295482 | PRJNA168635_P_NODE_21212_length_178_cov_4.217054_g20796_i0 | PRJNA168635 | 21212 | 178 | 4.217054 | 7.50635612 | Methanosarcina sp. | 2213 | Archaea | Archaea | 112 | 1.92e-28 | NR | HET8689236.1 | 2213 | g20796 | i0 | 89.8 | 0.99438202247191 | 59 | 6 | 99.4 | 0 | 178 | 2 | 224 | 282 | HET8689236.1 hypothetical protein [Methanosarcina sp.] | diamond | 177 | 112 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 30471044 | 30471044 | PRJNA168635_P_NODE_11213_length_245_cov_1.224490_g10798_i0 | PRJNA168635 | 11213 | 245 | 1.22449 | 3.0000005 | root | 1 | Root_unresolved | Root_unresolved | 149 | 4.85e-42 | NR | HET8689236.1 | 2213 | g10798 | i0 | 91.4 | 1.98367346938776 | 81 | 7 | 99.2 | 0 | 3 | 245 | 38 | 118 | HET8689236.1 hypothetical protein [Methanosarcina sp.] | diamond | 486 | 149 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 30484717 | 30484717 | PRJNA168635_P_NODE_31013_length_163_cov_0.912281_g30597_i0 | PRJNA168635 | 31013 | 163 | 0.912281 | 1.48701803 | Methanosarcina sp. | 2213 | Archaea | Archaea | 43.9 | 0.00497 | NR | HET8685998.1 | 2213 | g30597 | i0 | 53.7 | 0.754601226993865 | 41 | 18 | 75.5 | 1 | 127 | 5 | 1 | 40 | HET8685998.1 hypothetical protein [Methanosarcina sp.] | diamond | 123 | 43.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 31210866 | 31210866 | PRJNA168635_P_NODE_8455_length_290_cov_4.410788_g8040_i0 | PRJNA168635 | 8455 | 290 | 4.410788 | 12.7912852 | Methanosarcina sp. | 2213 | Archaea | Archaea | 122 | 1.24e-30 | NR | HET8688419.1 | 2213 | g8040 | i0 | 56.3 | 2.94827586206897 | 96 | 42 | 99.3 | 0 | 289 | 2 | 73 | 168 | HET8688419.1 nicotinate phosphoribosyltransferase [Methanosarcina sp.] | diamond | 855 | 122 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 31432707 | 31432707 | PRJNA168635_P_NODE_15336_length_205_cov_1.519231_g14920_i0 | PRJNA168635 | 15336 | 205 | 1.519231 | 3.11442355 | Methanosarcina sp. | 2213 | Archaea | Archaea | 47.8 | 3.74e-4 | NR | HET8689236.1 | 2213 | g14920 | i0 | 91.3 | 0.336585365853659 | 23 | 2 | 33.7 | 0 | 204 | 136 | 291 | 313 | HET8689236.1 hypothetical protein [Methanosarcina sp.] | diamond | 69 | 47.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 32128915 | 32128915 | PRJNA168635_P_NODE_34758_length_153_cov_34.221154_g34342_i0 | PRJNA168635 | 34758 | 153 | 34.221154 | 52.35836562 | Methanoculleus sp. | 90427 | Archaea | Archaea | 69.3 | 4.21e-12 | NR | WP_292561231.1 | 90427 | g34342 | i0 | 67.3 | 2.88235294117647 | 49 | 16 | 96.1 | 0 | 151 | 5 | 254 | 302 | WP_292561231.1 PBSX family phage terminase large subunit [Methanoculleus sp.] | diamond | 441 | 69.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 32445324 | 32445324 | PRJNA168635_P_NODE_17579_length_191_cov_1.767606_g17163_i0 | PRJNA168635 | 17579 | 191 | 1.767606 | 3.37612746 | Methanosarcina sp. | 2213 | Archaea | Archaea | 85.1 | 3.23e-19 | NR | HET8687496.1 | 2213 | g17163 | i0 | 70.5 | 0.958115183246073 | 61 | 18 | 95.8 | 0 | 7 | 189 | 42 | 102 | HET8687496.1 NUDIX domain-containing protein [Methanosarcina sp.] | diamond | 183 | 85.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina 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);;