contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA385073" and tax_phylum = "Candidatus Bathyarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 405611 | 405611 | PRJNA385073_P_NODE_201_length_1718_cov_9.209119_g174_i0 | PRJNA385073 | 201 | 1718 | 9.209119 | 158.21266442 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 2785 | 0 | NTclustered | gi|2874253764|emb|OY969706.1| | 2026714 | g174 | i0 | 96.136 | 24.1565774155995 | 1708 | 63 | 99 | 3 | 12 | 1718 | 2266296 | 2264591 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD02416.bin.c.15 genome assembly, chromosome: 1 | blastn | 41501 | 2785 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 6783099 | 6783099 | PRJNA385073_P_NODE_10786_length_396_cov_1.160991_g10625_i0 | PRJNA385073 | 10786 | 396 | 1.160991 | 4.59752436 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 355 | 2.58e-93 | NTclustered | gi|2810060730|gb|CP170178.1| | 3045160 | g10625 | i0 | 96.714 | 10.4343434343434 | 213 | 7 | 100 | 0 | 1 | 213 | 2863106 | 2862894 | MAG: Candidatus Bathyarchaeia archaeon isolate Bathy6-F90_cMAG_MillC chromosome, complete genome | blastn | 4132 | 355 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 6783587 | 6783587 | PRJNA385073_P_NODE_32146_length_273_cov_1.255000_g31984_i0 | PRJNA385073 | 32146 | 273 | 1.255 | 3.42615 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 333 | 7.989999999999999e-87 | NTclustered | gi|2874253955|emb|OY970280.1| | 2026714 | g31984 | i0 | 92.373 | 27.9340659340659 | 236 | 14 | 85 | 3 | 1 | 232 | 560784 | 560549 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD03726.bin.1.102 genome assembly, chromosome: 1 | blastn | 7626 | 333 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 9334783 | 9334783 | PRJNA385073_P_NODE_9528_length_414_cov_3.595308_g9367_i0 | PRJNA385073 | 9528 | 414 | 3.595308 | 14.88457512 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 346 | 1.63e-90 | NTclustered | gi|2874253764|emb|OY969706.1| | 2026714 | g9367 | i0 | 93.939 | 18.4975845410628 | 231 | 10 | 100 | 3 | 1 | 231 | 2266365 | 2266591 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD02416.bin.c.15 genome assembly, chromosome: 1 | blastn | 7658 | 346 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 13159906 | 13159906 | PRJNA385073_P_NODE_45031_length_249_cov_0.875000_g44869_i0 | PRJNA385073 | 45031 | 249 | 0.875 | 2.17875 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 285 | 2.0399999999999997e-72 | NTclustered | gi|2874253637|emb|OY968763.1| | 2026714 | g44869 | i0 | 89.13 | 5.56224899598394 | 230 | 24 | 92 | 1 | 12 | 240 | 358492 | 358721 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD01299.bin.2.105 genome assembly, chromosome: 1 | blastn | 1385 | 285 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 15709359 | 15709359 | PRJNA385073_P_NODE_7413_length_457_cov_1.953125_g7253_i0 | PRJNA385073 | 7413 | 457 | 1.953125 | 8.92578125 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 767 | 0 | NTclustered | gi|2810060730|gb|CP170178.1| | 3045160 | g7253 | i0 | 96.937 | 68.0437636761488 | 457 | 14 | 100 | 0 | 1 | 457 | 2864246 | 2863790 | MAG: Candidatus Bathyarchaeia archaeon isolate Bathy6-F90_cMAG_MillC chromosome, complete genome | blastn | 31096 | 767 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 19531528 | 19531528 | PRJNA385073_P_NODE_22636_length_306_cov_1.699571_g22474_i0 | PRJNA385073 | 22636 | 306 | 1.699571 | 5.20068726 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 403 | 6.84e-108 | NTclustered | gi|2810060730|gb|CP170178.1| | 3045160 | g22474 | i0 | 90.523 | 7.80718954248366 | 306 | 28 | 99 | 1 | 2 | 306 | 1546396 | 1546701 | MAG: Candidatus Bathyarchaeia archaeon isolate Bathy6-F90_cMAG_MillC chromosome, complete genome | blastn | 2389 | 403 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 22082053 | 22082053 | PRJNA385073_P_NODE_21098_length_312_cov_33.824268_g20936_i0 | PRJNA385073 | 21098 | 312 | 33.824267999999996 | 105.53171616 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 370 | 7.09e-98 | NTclustered | gi|2874253764|emb|OY969706.1| | 2026714 | g20936 | i0 | 88.141 | 8 | 312 | 35 | 99 | 2 | 1 | 311 | 1951091 | 1951401 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD02416.bin.c.15 genome assembly, chromosome: 1 | blastn | 2496 | 370 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 23357758 | 23357758 | PRJNA385073_P_NODE_24279_length_297_cov_3.142857_g24117_i0 | PRJNA385073 | 24279 | 297 | 3.142857 | 9.33428529 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 383 | 8.61e-102 | NTclustered | gi|2791746555|gb|CP166960.1| | 3045160 | g24117 | i0 | 89.899 | 7.84511784511785 | 297 | 30 | 100 | 0 | 1 | 297 | 833626 | 833330 | MAG: Candidatus Bathyarchaeia archaeon isolate Bathy6-F28_MillB chromosome | blastn | 2330 | 383 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 23358088 | 23358088 | PRJNA385073_P_NODE_39299_length_255_cov_2.269231_g39137_i0 | PRJNA385073 | 39299 | 255 | 2.269231 | 5.78653905 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 300 | 7.49e-77 | NTclustered | gi|2874253955|emb|OY970280.1| | 2026714 | g39137 | i0 | 87.843 | 11.9843137254902 | 255 | 31 | 100 | 0 | 1 | 255 | 561353 | 561099 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD03726.bin.1.102 genome assembly, chromosome: 1 | blastn | 3056 | 300 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 24632145 | 24632145 | PRJNA385073_P_NODE_25980_length_290_cov_5.414747_g25818_i0 | PRJNA385073 | 25980 | 290 | 5.414747 | 15.7027663 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 409 | 1.38e-109 | NTclustered | gi|2874253764|emb|OY969706.1| | 2026714 | g25818 | i0 | 92.414 | 8.01379310344828 | 290 | 16 | 99 | 4 | 2 | 290 | 1389132 | 1389416 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD02416.bin.c.15 genome assembly, chromosome: 1 | blastn | 2324 | 409 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 24632925 | 24632925 | PRJNA385073_P_NODE_6280_length_491_cov_1.454545_g6120_i0 | PRJNA385073 | 6280 | 491 | 1.454545 | 7.14181595 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 640 | 8.04e-179 | NTclustered | gi|2791746555|gb|CP166960.1| | 3045160 | g6120 | i0 | 90.224 | 11.9572301425662 | 491 | 47 | 100 | 1 | 1 | 491 | 1645022 | 1644533 | MAG: Candidatus Bathyarchaeia archaeon isolate Bathy6-F28_MillB chromosome | blastn | 5871 | 640 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia 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);;