contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJEB2368" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27949197 | 27949197 | PRJEB2368_P_NODE_10505_length_287_cov_1.184000_g10187_i0 | PRJEB2368 | 10505 | 287 | 1.184 | 3.39808 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 46.6 | 0.00199 | NR | MBS3175595.1 | 2026803 | g10187 | i0 | 31.5 | 1.1602787456446 | 111 | 53 | 92 | 1 | 285 | 22 | 106 | 216 | MBS3175595.1 glycosyltransferase [Candidatus Woesearchaeota archaeon] | diamond | 333 | 46.6 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 28037582 | 28037582 | PRJEB2368_P_NODE_8065_length_287_cov_1.748000_g7747_i0 | PRJEB2368 | 8065 | 287 | 1.748 | 5.01676 | Nanobdellati | 1783276 | Archaea | Archaea | 43.1 | 0.0125 | NR | MEK6947056.1 | 2026764 | g7747 | i0 | 80 | 0.522648083623693 | 25 | 5 | 26.1 | 0 | 2 | 76 | 52 | 76 | MEK6947056.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 150 | 43.5 | 0.990804597701149 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 28201579 | 28201579 | PRJEB2368_P_NODE_8466_length_287_cov_1.616000_g8148_i0 | PRJEB2368 | 8466 | 287 | 1.616 | 4.63792 | Candidatus Iainarchaeum archaeon | 3101447 | Archaea | Archaea | 43.5 | 0.0324 | NR | HRT03637.1 | 2026736 | g8148 | i0 | 76 | 0.261324041811847 | 25 | 6 | 26.1 | 0 | 2 | 76 | 183 | 207 | HRT03637.1 AAA family ATPase [Candidatus Iainarchaeum archaeon] | diamond | 75 | 43.5 | 1 | Archaea | Nanobdellati | Candidatus Iainarchaeota | Candidatus Iainarchaeum | Candidatus Iainarchaeum archaeon | |||||
| 28542893 | 28542893 | PRJEB2368_P_NODE_7207_length_287_cov_2.384000_g6889_i0 | PRJEB2368 | 7207 | 287 | 2.384 | 6.84208 | Archaea | 2157 | Archaea | Archaea | 47 | 0.00208 | NR | PIN94733.1 | 1974437 | g6889 | i0 | 30.5 | 4.93379790940767 | 95 | 47 | 99.3 | 1 | 287 | 3 | 451 | 526 | PIN94733.1 MAG: DNA polymerase II large subunit, partial [Candidatus Pacearchaeota archaeon CG10_big_fil_rev_8_21_14_0_10_30_48] | diamond | 1416 | 47 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon CG10_big_fil_rev_8_21_14_0_10_30_48 | ||||||
| 28675532 | 28675532 | PRJEB2368_P_NODE_8647_length_287_cov_1.556000_g8329_i0 | PRJEB2368 | 8647 | 287 | 1.556 | 4.46572 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 45.1 | 0.00933 | NR | MDP3027261.1 | 2026764 | g8329 | i0 | 31.2 | 0.97212543554007 | 93 | 17 | 97.2 | 1 | 8 | 286 | 321 | 366 | MDP3027261.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 279 | 45.1 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 30033289 | 30033289 | PRJEB2368_P_NODE_10191_length_287_cov_1.288000_g9873_i0 | PRJEB2368 | 10191 | 287 | 1.288 | 3.69656 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 50.8 | 1.87e-5 | NR | MBU0907382.1 | 2026764 | g9873 | i0 | 34.7 | 0.993031358885017 | 95 | 28 | 99.3 | 1 | 2 | 286 | 32 | 92 | MBU0907382.1 EamA/RhaT family transporter [Nanoarchaeota archaeon] | diamond | 285 | 50.8 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 31328704 | 31328704 | PRJEB2368_P_NODE_10536_length_287_cov_1.164000_g10218_i0 | PRJEB2368 | 10536 | 287 | 1.164 | 3.34068 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 49.3 | 2.94e-5 | NR | MBS3104967.1 | 2026803 | g10218 | i0 | 88 | 0.261324041811847 | 25 | 3 | 26.1 | 0 | 2 | 76 | 20 | 44 | MBS3104967.1 DNA cytosine methyltransferase [Candidatus Woesearchaeota archaeon] | diamond | 75 | 49.3 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 31487096 | 31487096 | PRJEB2368_P_NODE_7756_length_287_cov_1.880000_g7438_i0 | PRJEB2368 | 7756 | 287 | 1.88 | 5.3956 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 49.7 | 7.88e-5 | NR | MEK6915184.1 | 2026764 | g7438 | i0 | 87.5 | 0.250871080139373 | 24 | 3 | 25.1 | 0 | 285 | 214 | 95 | 118 | MEK6915184.1 glycosyltransferase [Nanoarchaeota archaeon] | diamond | 72 | 49.7 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota 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);;