contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA429937" and tax_kingdom = "Nanobdellati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26917524 | 26917524 | PRJNA429937_P_NODE_29682_length_669_cov_8.118750_g17999_i0 | PRJNA429937 | 29682 | 669 | 8.11875 | 54.3144375 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 60.1 | 1.04e-7 | NR | MCK5625129.1 | 2026773 | g17999 | i0 | 55 | 0.269058295964126 | 60 | 27 | 26.9 | 0 | 298 | 477 | 33 | 92 | MCK5625129.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 180 | 60.1 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 28560149 | 28560149 | PRJNA429937_P_NODE_21107_length_801_cov_4.305699_g12489_i0 | PRJNA429937 | 21107 | 801 | 4.305699 | 34.48864899 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 258 | 1.03e-83 | NR | MEK6880981.1 | 2026764 | g12489 | i0 | 71.2 | 0.636704119850187 | 170 | 49 | 63.7 | 0 | 539 | 30 | 1 | 170 | MEK6880981.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 510 | 258 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29096860 | 29096860 | PRJNA429937_P_NODE_104108_length_290_cov_3.877395_g81491_i0 | PRJNA429937 | 104108 | 290 | 3.877395 | 11.2444455 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 48.9 | 4.24e-4 | NR | MCH7568436.1 | 2026764 | g81491 | i0 | 66.7 | 0.310344827586207 | 30 | 10 | 31 | 0 | 219 | 130 | 3 | 32 | MCH7568436.1 B12-binding domain-containing radical SAM protein [Nanoarchaeota archaeon] | diamond | 90 | 48.9 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29664750 | 29664750 | PRJNA429937_P_NODE_60450_length_445_cov_3.209135_g40668_i0 | PRJNA429937 | 60450 | 445 | 3.209135 | 14.28065075 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 60.8 | 3.27e-9 | NR | MEK6848982.1 | 2026764 | g40668 | i0 | 51.1 | 0.31685393258427 | 47 | 23 | 31.7 | 0 | 392 | 252 | 7 | 53 | MEK6848982.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 141 | 60.8 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 30012683 | 30012683 | PRJNA429937_P_NODE_44211_length_538_cov_7.001965_g28336_i0 | PRJNA429937 | 44211 | 538 | 7.001965 | 37.670571700000004 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 69.7 | 3.13e-10 | NR | MAH51556.1 | 2026773 | g28336 | i0 | 46.3 | 0.446096654275093 | 80 | 41 | 43.5 | 2 | 256 | 23 | 132 | 211 | MAH51556.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 240 | 69.7 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 30960481 | 30960481 | PRJNA429937_P_NODE_97294_length_310_cov_3.782918_g74689_i0 | PRJNA429937 | 97294 | 310 | 3.782918 | 11.7270458 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 94 | 1.43e-22 | NR | MDA3854950.1 | 2026803 | g74689 | i0 | 56.6 | 1.43225806451613 | 76 | 30 | 70.6 | 2 | 31 | 249 | 2 | 77 | MDA3854950.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 444 | 94 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 31592939 | 31592939 | PRJNA429937_P_NODE_9096_length_1189_cov_11.247414_g5349_i0 | PRJNA429937 | 9096 | 1189 | 11.247414 | 133.73175246 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 316 | 7.599999999999999e-100 | NR | MCK5603948.1 | 2026773 | g5349 | i0 | 70.2 | 1.13036164844407 | 225 | 67 | 56.8 | 0 | 1179 | 505 | 293 | 517 | MCK5603948.1 DEAD/DEAH box helicase [Candidatus Pacearchaeota archaeon] | diamond | 1344 | 316 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 31655770 | 31655770 | PRJNA429937_P_NODE_35957_length_604_cov_2.744348_g22384_i0 | PRJNA429937 | 35957 | 604 | 2.744348 | 16.57586192 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 90.1 | 5.98e-20 | NR | MEK6848982.1 | 2026764 | g22384 | i0 | 58.2 | 0.332781456953642 | 67 | 28 | 33.3 | 0 | 466 | 266 | 7 | 73 | MEK6848982.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 201 | 90.1 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32193892 | 32193892 | PRJNA429937_P_NODE_95518_length_315_cov_5.590909_g72921_i0 | PRJNA429937 | 95518 | 315 | 5.590909 | 17.61136335 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 60.5 | 1.45e-8 | NR | MEM1988504.1 | 2026803 | g72921 | i0 | 56.5 | 0.885714285714286 | 46 | 19 | 42.9 | 1 | 159 | 25 | 95 | 140 | MEM1988504.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 279 | 60.5 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 32415382 | 32415382 | PRJNA429937_P_NODE_10199_length_1133_cov_2.700181_g5992_i0 | PRJNA429937 | 10199 | 1133 | 2.700181 | 30.59305073 | Candidatus Altiarchaeales archaeon WOR_SM1_SCG | 1849261 | Archaea | Archaea | 52.4 | 0.00179 | NR | ODS35195.1 | 1849261 | g5992 | i0 | 36.6 | 0.217122683142101 | 82 | 37 | 18.5 | 4 | 214 | 5 | 32 | 110 | ODS35195.1 hypothetical protein BEH94_01935 [Candidatus Altiarchaeales archaeon WOR_SM1_SCG] | diamond | 246 | 52.4 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeia | Candidatus Altarchaeales | Candidatus Altiarchaeales archaeon WOR_SM1_SCG | ||||
| 32542065 | 32542065 | PRJNA429937_P_NODE_10339_length_1126_cov_2.684594_g5992_i1 | PRJNA429937 | 10339 | 1126 | 2.684594 | 30.22852844 | Candidatus Altiarchaeales archaeon WOR_SM1_SCG | 1849261 | Archaea | Archaea | 52.8 | 0.00133 | NR | ODS35195.1 | 1849261 | g5992 | i1 | 35.2 | 0.234458259325044 | 88 | 42 | 20.2 | 4 | 895 | 1122 | 26 | 110 | ODS35195.1 hypothetical protein BEH94_01935 [Candidatus Altiarchaeales archaeon WOR_SM1_SCG] | diamond | 264 | 52.8 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeia | Candidatus Altarchaeales | Candidatus Altiarchaeales archaeon WOR_SM1_SCG |
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);;