contig_metadata
11 rows where bioproject = "PRJNA944406", tax_phylum = "Thermoproteota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 924936 | 924936 | PRJNA944406_P_NODE_7961_length_444_cov_1.628032_g7004_i0 | PRJNA944406 | 7961 | 444 | 1.628032 | 7.22846208 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 673 | 0 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g7004 | i0 | 94.144 | 48.0833333333333 | 444 | 22 | 100 | 3 | 1 | 444 | 5937 | 6376 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 21349 | 673 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 1259275 | 1259275 | PRJNA944406_P_NODE_1041_length_1323_cov_19.168000_g613_i1 | PRJNA944406 | 1041 | 1323 | 19.168 | 253.59264 | root | 1 | Root_unresolved | Root_unresolved | 2261 | 0 | NTclustered | gi|152014600|gb|EF690623.1| | 29281 | g613 | i1 | 97.508 | 103.417233560091 | 1324 | 31 | 100 | 2 | 1 | 1323 | 1333 | 11 | Uncultured crenarchaeote clone TX4CA_68 16S ribosomal RNA gene, partial sequence | blastn | 136821 | 2283 | 0.990363556723609 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 2534985 | 2534985 | PRJNA944406_P_NODE_1022_length_1333_cov_20.376190_g613_i0 | PRJNA944406 | 1022 | 1333 | 20.37619 | 271.6146127 | Archaea | 2157 | Archaea | Archaea | 2261 | 0 | NTclustered | gi|1497996|gb|U62819.1|UAU62819 | 50857 | g613 | i0 | 97.436 | 103.756939234809 | 1326 | 34 | 99 | 0 | 1 | 1326 | 1326 | 1 | Unidentified archaeon SCA1175 16S small subunit ribosomal RNA gene, partial sequence | blastn | 138308 | 2266 | 0.997793468667255 | Archaea | Thermoproteati | Thermoproteota | unidentified archaeon SCA1175 | ||||||
| 3475481 | 3475481 | PRJNA944406_P_NODE_59023_length_255_cov_1.175824_g58064_i0 | PRJNA944406 | 59023 | 255 | 1.175824 | 2.9983512 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 438 | 1.52e-118 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g58064 | i0 | 97.647 | 115.137254901961 | 255 | 6 | 100 | 0 | 1 | 255 | 43004 | 43258 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 29360 | 438 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 4753211 | 4753211 | PRJNA944406_P_NODE_64_length_3061_cov_6.079652_g35_i0 | PRJNA944406 | 64 | 3061 | 6.079652 | 186.09814772 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 3858 | 0 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g35 | i0 | 90.379 | 96.1127082652728 | 2952 | 262 | 96 | 20 | 1 | 2943 | 40384 | 43322 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 294201 | 3858 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 11127865 | 11127865 | PRJNA944406_P_NODE_16369_length_319_cov_1.796748_g15410_i0 | PRJNA944406 | 16369 | 319 | 1.796748 | 5.73162612 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 361 | 4.38e-95 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g15410 | i0 | 87.382 | 36.6457680250784 | 317 | 37 | 99 | 3 | 1 | 316 | 7296 | 7610 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 11690 | 361 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 25151052 | 25151052 | PRJNA944406_P_NODE_69100_length_250_cov_0.870056_g68141_i0 | PRJNA944406 | 69100 | 250 | 0.870056 | 2.17514 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 99 | 2.87e-16 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g68141 | i0 | 91.549 | 1.568 | 71 | 6 | 28 | 0 | 1 | 71 | 5915 | 5845 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 392 | 99 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 28263672 | 28263672 | PRJNA944406_P_NODE_61946_length_252_cov_1.346369_g60987_i0 | PRJNA944406 | 61946 | 252 | 1.346369 | 3.39284988 | root | 1 | Root_unresolved | Root_unresolved | 50.8 | 1.7e-5 | NR | MEM0120653.1 | 2250277 | g60987 | i0 | 46.7 | 1.72619047619048 | 60 | 30 | 69 | 1 | 240 | 67 | 65 | 124 | MEM0120653.1 CBS domain-containing protein [Thermoprotei archaeon] | diamond | 435 | 50.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoprotei archaeon | |||||
| 29709087 | 29709087 | PRJNA944406_P_NODE_45650_length_267_cov_1.587629_g44691_i0 | PRJNA944406 | 45650 | 267 | 1.587629 | 4.23896943 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 160 | 2.5e-45 | NR | MDP9197000.1 | 2056631 | g44691 | i0 | 92.1 | 1 | 89 | 7 | 100 | 0 | 1 | 267 | 26 | 114 | MDP9197000.1 nickel pincer cofactor biosynthesis protein LarC [Thermoproteota archaeon] | diamond | 267 | 160 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30151440 | 30151440 | PRJNA944406_P_NODE_27512_length_284_cov_1.459716_g26553_i0 | PRJNA944406 | 27512 | 284 | 1.459716 | 4.14559344 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 45.1 | 0.00214 | NR | MDQ6862856.1 | 2056631 | g26553 | i0 | 90 | 0.422535211267606 | 20 | 2 | 21.1 | 0 | 283 | 224 | 91 | 110 | MDQ6862856.1 nuclear transport factor 2 family protein [Thermoproteota archaeon] | diamond | 120 | 45.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31352610 | 31352610 | PRJNA944406_P_NODE_92096_length_245_cov_0.895349_g91137_i0 | PRJNA944406 | 92096 | 245 | 0.895349 | 2.19360505 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 130 | 4.609999999999999e-37 | NR | MDQ4015305.1 | 2056631 | g91137 | i0 | 94.9 | 0.722448979591837 | 59 | 3 | 72.2 | 0 | 2 | 178 | 64 | 122 | MDQ4015305.1 hypothetical protein [Thermoproteota archaeon] | diamond | 177 | 130 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota 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);;