contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA195897" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 365967 | 365967 | PRJNA195897_P_NODE_2261_length_336_cov_1.885017_g2228_i0 | PRJNA195897 | 2261 | 336 | 1.885017 | 6.33365712 | Halorutilales archaeon Cl-col2-1 | 3242703 | Archaea | Archaea | 54.7 | 0.009 | NTclustered | gi|2801083086|gb|CP169074.1| | 3242703 | g2228 | i0 | 100 | 0.0863095238095238 | 29 | 0 | 9 | 0 | 79 | 107 | 912384 | 912412 | Halorutilales archaeon Cl-col2-1 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halorutilales | Halorutilales archaeon Cl-col2-1 | |||
| 366029 | 366029 | PRJNA195897_P_NODE_9201_length_169_cov_0.866667_g9168_i0 | PRJNA195897 | 9201 | 169 | 0.866667 | 1.46466723 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 71.3 | 3.9e-8 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g9168 | i0 | 97.561 | 3.96449704142012 | 41 | 1 | 24 | 0 | 123 | 163 | 237439 | 237479 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 670 | 71.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 4193108 | 4193108 | PRJNA195897_P_NODE_7864_length_179_cov_0.823077_g7831_i0 | PRJNA195897 | 7864 | 179 | 0.823077 | 1.47330783 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 75 | 3.24e-9 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g7831 | i0 | 100 | 3.59776536312849 | 40 | 0 | 22 | 0 | 139 | 178 | 1623022 | 1623061 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 644 | 75 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 5469326 | 5469326 | PRJNA195897_P_NODE_3885_length_244_cov_1.558974_g3852_i0 | PRJNA195897 | 3885 | 244 | 1.558974 | 3.80389656 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 60.2 | 1.32e-4 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g3852 | i0 | 100 | 1.45901639344262 | 32 | 0 | 13 | 0 | 1 | 32 | 3027450 | 3027481 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 356 | 60.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 6743628 | 6743628 | PRJNA195897_P_NODE_12266_length_162_cov_1.592920_g12233_i0 | PRJNA195897 | 12266 | 162 | 1.59292 | 2.5805304 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 73.1 | 1.03e-8 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g12233 | i0 | 100 | 4.11111111111111 | 39 | 0 | 28 | 0 | 17 | 55 | 2837774 | 2837736 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 666 | 73.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 6743682 | 6743682 | PRJNA195897_P_NODE_7506_length_182_cov_1.458647_g7473_i0 | PRJNA195897 | 7506 | 182 | 1.458647 | 2.65473754 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 71.3 | 4.27e-8 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g7473 | i0 | 100 | 3.59340659340659 | 38 | 0 | 21 | 0 | 145 | 182 | 237480 | 237443 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 654 | 71.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 9294070 | 9294070 | PRJNA195897_P_NODE_4248_length_232_cov_1.420765_g4215_i0 | PRJNA195897 | 4248 | 232 | 1.420765 | 3.2961748 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 60.2 | 1.24e-4 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g4215 | i0 | 100 | 2.36206896551724 | 32 | 0 | 17 | 0 | 1 | 32 | 1072467 | 1072436 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 548 | 60.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 10570084 | 10570084 | PRJNA195897_P_NODE_6869_length_189_cov_1.535714_g6836_i0 | PRJNA195897 | 6869 | 189 | 1.535714 | 2.90249946 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 65.8 | 2.08e-6 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g6836 | i0 | 100 | 2.15873015873016 | 35 | 0 | 19 | 0 | 1 | 35 | 1623029 | 1623063 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 408 | 65.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 10570092 | 10570092 | PRJNA195897_P_NODE_7549_length_182_cov_1.135338_g7516_i0 | PRJNA195897 | 7549 | 182 | 1.135338 | 2.06631516 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 75 | 3.3e-9 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g7516 | i0 | 100 | 3.6043956043956 | 40 | 0 | 22 | 0 | 95 | 134 | 1072436 | 1072475 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 656 | 75 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 11844526 | 11844526 | PRJNA195897_P_NODE_1990_length_364_cov_1.260317_g1957_i0 | PRJNA195897 | 1990 | 364 | 1.260317 | 4.58755388 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 56.5 | 0.003 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g1957 | i0 | 92.683 | 0.502747252747253 | 41 | 0 | 10 | 2 | 5 | 42 | 237452 | 237492 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 183 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 11844558 | 11844558 | PRJNA195897_P_NODE_6930_length_189_cov_0.914286_g6897_i0 | PRJNA195897 | 6930 | 189 | 0.914286 | 1.72800054 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 76.8 | 9.62e-10 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g6897 | i0 | 100 | 3.49206349206349 | 41 | 0 | 22 | 0 | 30 | 70 | 1072475 | 1072435 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 660 | 76.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 13119780 | 13119780 | PRJNA195897_P_NODE_5511_length_207_cov_0.981013_g5478_i0 | PRJNA195897 | 5511 | 207 | 0.981013 | 2.03069691 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 60.2 | 1.08e-4 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g5478 | i0 | 100 | 2.58937198067633 | 32 | 0 | 16 | 0 | 8 | 39 | 237450 | 237481 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 536 | 60.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 13119801 | 13119801 | PRJNA195897_P_NODE_7651_length_181_cov_0.878788_g7618_i0 | PRJNA195897 | 7651 | 181 | 0.878788 | 1.59060628 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 52.8 | 0.015 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g7618 | i0 | 100 | 0.464088397790055 | 28 | 0 | 15 | 0 | 1 | 28 | 237468 | 237441 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 84 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 15082841 | 15082841 | PRJNA195897_P_NODE_6212_length_197_cov_1.277027_g6179_i0 | PRJNA195897 | 6212 | 197 | 1.277027 | 2.51574319 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 7.88e-6 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g6179 | i0 | 100 | 2.01522842639594 | 34 | 0 | 17 | 0 | 1 | 34 | 2837740 | 2837773 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 397 | 63.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 16943310 | 16943310 | PRJNA195897_P_NODE_8474_length_173_cov_1.217742_g8441_i0 | PRJNA195897 | 8474 | 173 | 1.217742 | 2.10669366 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 73.1 | 1.12e-8 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g8441 | i0 | 100 | 3.78034682080925 | 39 | 0 | 24 | 0 | 102 | 140 | 1072473 | 1072435 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 654 | 73.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 17632934 | 17632934 | PRJNA195897_P_NODE_4454_length_227_cov_1.117978_g4421_i0 | PRJNA195897 | 4454 | 227 | 1.117978 | 2.53781006 | root | 1 | Root_unresolved | Root_unresolved | 69.4 | 2.01e-7 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g4421 | i0 | 100 | 2.80176211453744 | 37 | 0 | 16 | 0 | 30 | 66 | 2837773 | 2837737 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 636 | 69.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 18217686 | 18217686 | PRJNA195897_P_NODE_5055_length_215_cov_0.879518_g5022_i0 | PRJNA195897 | 5055 | 215 | 0.879518 | 1.8909637 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 56.5 | 0.001 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g5022 | i0 | 100 | 0.795348837209302 | 30 | 0 | 14 | 0 | 186 | 215 | 237481 | 237452 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 171 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 19491993 | 19491993 | PRJNA195897_P_NODE_4676_length_222_cov_0.936416_g4643_i0 | PRJNA195897 | 4676 | 222 | 0.936416 | 2.07884352 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 73.1 | 1.51e-8 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g4643 | i0 | 100 | 3.03153153153153 | 39 | 0 | 20 | 0 | 32 | 70 | 1072436 | 1072474 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 673 | 73.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 20181364 | 20181364 | PRJNA195897_P_NODE_6916_length_189_cov_1.107143_g6883_i0 | PRJNA195897 | 6916 | 189 | 1.107143 | 2.09250027 | root | 1 | Root_unresolved | Root_unresolved | 75 | 3.46e-9 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g6883 | i0 | 97.674 | 3.27513227513228 | 43 | 1 | 23 | 0 | 139 | 181 | 2837733 | 2837775 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 619 | 75 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 22042585 | 22042585 | PRJNA195897_P_NODE_158_length_1206_cov_3.643907_g144_i0 | PRJNA195897 | 158 | 1206 | 3.643907 | 43.94551842 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 75 | 2.63e-8 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g144 | i0 | 100 | 0.483416252072969 | 40 | 0 | 4 | 0 | 12 | 51 | 1072474 | 1072435 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 583 | 75 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 22042657 | 22042657 | PRJNA195897_P_NODE_9198_length_169_cov_0.866667_g9165_i0 | PRJNA195897 | 9198 | 169 | 0.866667 | 1.46466723 | Methanolobus psychrophilus | 420950 | Archaea | Archaea | 62.1 | 2.34e-5 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g9165 | i0 | 100 | 3.24260355029586 | 33 | 0 | 20 | 0 | 1 | 33 | 237448 | 237480 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 548 | 62.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 22732058 | 22732058 | PRJNA195897_P_NODE_218_length_1085_cov_2.970077_g200_i0 | PRJNA195897 | 218 | 1085 | 2.970077 | 32.22533545 | root | 1 | Root_unresolved | Root_unresolved | 71.3 | 3.05e-7 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g200 | i0 | 100 | 0.532718894009217 | 38 | 0 | 4 | 0 | 712 | 749 | 1072473 | 1072436 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 578 | 71.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus |
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);;