contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA966993" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2541321 | 2541321 | PRJNA966993_P_NODE_76862_length_259_cov_2.284946_g76410_i0 | PRJNA966993 | 76862 | 259 | 2.284946 | 5.91801014 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 147 | 5.08e-39 | NR | MFB5612793.1 | 2026886 | g76410 | i0 | 87.2 | 0.996138996138996 | 86 | 11 | 99.6 | 0 | 2 | 259 | 475 | 560 | MFB5612793.1 molecular chaperone DnaK [Nitrosarchaeum sp.] | diamond | 258 | 147 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 26804237 | 26804237 | PRJNA966993_P_NODE_43421_length_327_cov_2.944882_g42969_i0 | PRJNA966993 | 43421 | 327 | 2.9448820000000002 | 9.62976414 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 52 | 3.46e-5 | NR | MCJ7636760.1 | 2169593 | g42969 | i0 | 39.2 | 2.20183486238532 | 74 | 43 | 67.9 | 1 | 101 | 322 | 4 | 75 | MCJ7636760.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 720 | 52 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 27247157 | 27247157 | PRJNA966993_P_NODE_73783_length_264_cov_2.026178_g73331_i0 | PRJNA966993 | 73783 | 264 | 2.026178 | 5.34910992 | Caldisphaera sp. | 2060322 | Archaea | Archaea | 63.9 | 1.31e-9 | NR | MFP3144362.1 | 2060322 | g73331 | i0 | 41.1 | 1.02272727272727 | 90 | 43 | 97.7 | 3 | 258 | 1 | 186 | 269 | MFP3144362.1 ABC transporter ATP-binding protein [Caldisphaera sp.] | diamond | 270 | 63.9 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Acidilobales | Caldisphaeraceae | Caldisphaera | Caldisphaera sp. | ||
| 28263783 | 28263783 | PRJNA966993_P_NODE_12726_length_589_cov_1.992248_g12293_i0 | PRJNA966993 | 12726 | 589 | 1.992248 | 11.73434072 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 167 | 2.12e-47 | NR | MBM3896303.1 | 2026795 | g12293 | i0 | 49.4 | 9.48387096774194 | 170 | 82 | 85.1 | 2 | 586 | 86 | 134 | 302 | MBM3896303.1 pirin family protein [Nitrososphaerota archaeon] | diamond | 5586 | 167 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 28573333 | 28573333 | PRJNA966993_P_NODE_56187_length_290_cov_1.419355_g55735_i0 | PRJNA966993 | 56187 | 290 | 1.419355 | 4.1161295 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 57 | 6.15e-7 | NR | MDE1816823.1 | 2026795 | g55735 | i0 | 50 | 0.558620689655172 | 54 | 27 | 55.9 | 0 | 29 | 190 | 444 | 497 | MDE1816823.1 reverse transcriptase family protein [Nitrososphaerota archaeon] | diamond | 162 | 57 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 29931321 | 29931321 | PRJNA966993_P_NODE_73331_length_265_cov_1.604167_g72879_i0 | PRJNA966993 | 73331 | 265 | 1.604167 | 4.25104255 | Nitrososphaeria archaeon | 2268198 | Archaea | Archaea | 42 | 0.0333 | NR | MEM2741679.1 | 2268198 | g72879 | i0 | 34.9 | 0.713207547169811 | 63 | 41 | 71.3 | 0 | 45 | 233 | 46 | 108 | MEM2741679.1 methionine adenosyltransferase [Nitrososphaeria archaeon] | diamond | 189 | 42 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaeria archaeon | |||||
| 30120541 | 30120541 | PRJNA966993_P_NODE_35552_length_359_cov_1.937063_g35100_i0 | PRJNA966993 | 35552 | 359 | 1.937063 | 6.95405617 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 55.5 | 3.7e-7 | NR | MCX6647851.1 | 2026714 | g35100 | i0 | 51 | 0.818941504178273 | 49 | 24 | 40.9 | 0 | 211 | 357 | 1 | 49 | MCX6647851.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 294 | 55.5 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32334034 | 32334034 | PRJNA966993_P_NODE_62939_length_280_cov_2.202899_g62487_i0 | PRJNA966993 | 62939 | 280 | 2.202899 | 6.1681172 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 47.8 | 4.55e-4 | NR | MDQ2684781.1 | 2056631 | g62487 | i0 | 32.6 | 0.953571428571429 | 89 | 50 | 85.7 | 3 | 1 | 240 | 74 | 161 | MDQ2684781.1 CHRD domain-containing protein [Thermoproteota archaeon] | diamond | 267 | 47.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32365612 | 32365612 | PRJNA966993_P_NODE_39079_length_344_cov_1.243542_g38627_i0 | PRJNA966993 | 39079 | 344 | 1.243542 | 4.27778448 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 69.7 | 4.09e-11 | NR | MEO9277753.1 | 1971748 | g38627 | i0 | 34.2 | 0.994186046511628 | 114 | 63 | 98.5 | 2 | 1 | 339 | 265 | 367 | MEO9277753.1 serpin family protein [Nitrososphaera sp.] | diamond | 342 | 69.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera 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);;