contig_metadata
11 rows where bioproject = "PRJNA274362" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4197440 | 4197440 | PRJNA274362_S_NODE_12744_length_249_cov_0.830000_g12624_i0 | PRJNA274362 | 12744 | 249 | 0.83 | 2.0667 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 455 | 1.47e-123 | NTclustered | gi|471647997|gb|KC661706.1| | 29281 | g12624 | i0 | 99.598 | 99.995983935743 | 249 | 1 | 100 | 0 | 1 | 249 | 408 | 656 | Uncultured crenarchaeote clone BC-M-Sd-S1-B7 16S ribosomal RNA gene, partial sequence | blastn | 24899 | 455 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 5474131 | 5474131 | PRJNA274362_S_NODE_32505_length_168_cov_1.310924_g32385_i0 | PRJNA274362 | 32505 | 168 | 1.310924 | 2.20235232 | archaeon | 1906665 | Archaea | Archaea | 99.8 | 2.07e-25 | NR | RYH29492.1 | 1906665 | g32385 | i0 | 79.6 | 0.964285714285714 | 54 | 11 | 96.4 | 0 | 6 | 167 | 64 | 117 | RYH29492.1 MAG: 50S ribosomal protein L30e [archaeon] | diamond | 162 | 99.8 | 1 | Archaea | archaeon | ||||||||
| 27232078 | 27232078 | PRJNA274362_S_NODE_8523_length_294_cov_1.657143_g8403_i0 | PRJNA274362 | 8523 | 294 | 1.657143 | 4.87200042 | archaeon | 1906665 | Archaea | Archaea | 79 | 6.4e-17 | NR | RYG59364.1 | 1906665 | g8403 | i0 | 45.9 | 2.8265306122449 | 85 | 39 | 86.7 | 2 | 293 | 39 | 1 | 78 | RYG59364.1 MAG: hypothetical protein EON64_20305, partial [archaeon] | diamond | 831 | 79 | 1 | Archaea | archaeon | ||||||||
| 27390306 | 27390306 | PRJNA274362_S_NODE_34483_length_166_cov_0.888889_g34363_i0 | PRJNA274362 | 34483 | 166 | 0.888889 | 1.47555574 | archaeon | 1906665 | Archaea | Archaea | 93.2 | 1.95e-22 | NR | RYG68310.1 | 1906665 | g34363 | i0 | 83.3 | 0.975903614457831 | 54 | 9 | 97.6 | 0 | 164 | 3 | 40 | 93 | RYG68310.1 MAG: hypothetical protein EON64_05455 [archaeon] | diamond | 162 | 93.2 | 1 | Archaea | archaeon | ||||||||
| 28653142 | 28653142 | PRJNA274362_S_NODE_31827_length_169_cov_1.300000_g31707_i0 | PRJNA274362 | 31827 | 169 | 1.3 | 2.197 | archaeon | 1906665 | Archaea | Archaea | 86.7 | 1.71e-20 | NR | MDP2434290.1 | 1906665 | g31707 | i0 | 72.2 | 1.95266272189349 | 54 | 15 | 95.9 | 0 | 7 | 168 | 5 | 58 | MDP2434290.1 acyl-CoA-binding protein [archaeon] | diamond | 330 | 86.7 | 1 | Archaea | archaeon | ||||||||
| 28828519 | 28828519 | PRJNA274362_S_NODE_25828_length_186_cov_0.788321_g25708_i0 | PRJNA274362 | 25828 | 186 | 0.788321 | 1.46627706 | Halobacteriales | 2235 | Archaea | Archaea | 41.2 | 0.0153 | NR | WP_256530515.1 | 1487865 | g25708 | i0 | 34 | 4.54838709677419 | 47 | 31 | 75.8 | 0 | 41 | 181 | 21 | 67 | WP_256530515.1 DUF5808 domain-containing protein [Halovivax cerinus] | diamond | 846 | 41.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halovivax | Halovivax cerinus | |
| 30263943 | 30263943 | PRJNA274362_S_NODE_21112_length_202_cov_0.980392_g20992_i0 | PRJNA274362 | 21112 | 202 | 0.980392 | 1.98039184 | archaeon | 1906665 | Archaea | Archaea | 61.2 | 1.32e-10 | NR | RYY85952.1 | 1906665 | g20992 | i0 | 72.5 | 0.594059405940594 | 40 | 10 | 59.4 | 1 | 202 | 83 | 25 | 63 | RYY85952.1 MAG: hypothetical protein EON63_06610 [archaeon] | diamond | 120 | 61.2 | 1 | Archaea | archaeon | ||||||||
| 30800622 | 30800622 | PRJNA274362_S_NODE_14954_length_232_cov_1.699454_g14834_i0 | PRJNA274362 | 14954 | 232 | 1.699454 | 3.94273328 | archaeon | 1906665 | Archaea | Archaea | 90.9 | 9.33e-22 | NR | RYH00022.1 | 1906665 | g14834 | i0 | 65.6 | 0.827586206896552 | 64 | 22 | 82.8 | 0 | 231 | 40 | 19 | 82 | RYH00022.1 MAG: hypothetical protein EON65_49750 [archaeon] | diamond | 192 | 90.9 | 1 | Archaea | archaeon | ||||||||
| 31369881 | 31369881 | PRJNA274362_S_NODE_11656_length_258_cov_1.473684_g11536_i0 | PRJNA274362 | 11656 | 258 | 1.473684 | 3.80210472 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 72 | 1.83e-13 | NR | HEX4921044.1 | 3045160 | g11536 | i0 | 42.9 | 3.65116279069767 | 77 | 43 | 88.4 | 1 | 11 | 238 | 27 | 103 | HEX4921044.1 DUF4397 domain-containing protein [Candidatus Bathyarchaeia archaeon] | diamond | 942 | 72 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 31907350 | 31907350 | PRJNA274362_S_NODE_37677_length_162_cov_0.911504_g37557_i0 | PRJNA274362 | 37677 | 162 | 0.911504 | 1.47663648 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 47.8 | 2.14e-5 | NR | MEJ2296750.1 | 2053489 | g37557 | i0 | 55 | 0.740740740740741 | 40 | 18 | 74.1 | 0 | 4 | 123 | 14 | 53 | MEJ2296750.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 120 | 47.8 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 32729265 | 32729265 | PRJNA274362_S_NODE_32100_length_169_cov_0.866667_g31980_i0 | PRJNA274362 | 32100 | 169 | 0.866667 | 1.46466723 | archaeon | 1906665 | Archaea | Archaea | 95.1 | 1.0499999999999999e-23 | NR | RYH18874.1 | 1906665 | g31980 | i0 | 77.8 | 0.958579881656805 | 54 | 12 | 95.9 | 0 | 164 | 3 | 27 | 80 | RYH18874.1 MAG: hypothetical protein EON65_26765 [archaeon] | diamond | 162 | 95.1 | 1 | Archaea | 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);;