contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25510389 | 25510389 | PRJEB14175_P_NODE_57081_length_492_cov_4.320186_g54831_i0 | PRJEB14175 | 57081 | 492 | 4.320186 | 21.25531512 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 852 | 0 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g54831 | i0 | 99.362 | 92.760162601626 | 470 | 3 | 96 | 0 | 1 | 470 | 42969 | 42500 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 45638 | 852 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 25607174 | 25607174 | PRJEB14175_P_NODE_112569_length_332_cov_24.560886_g110303_i0 | PRJEB14175 | 112569 | 332 | 24.560886 | 81.54214152 | Archaea | 2157 | Archaea | Archaea | 279 | 1.32e-70 | NTclustered | gi|663502579|gb|KF900394.1| | 1455910 | g110303 | i0 | 83.117 | 14.6295180722892 | 308 | 51 | 92 | 1 | 4 | 310 | 15809 | 15502 | Uncultured marine thaumarchaeote AD1000_36_B08 genomic sequence | blastn | 4857 | 281 | 0.99288256227758 | Archaea | Thermoproteati | Nitrososphaerota | uncultured marine thaumarchaeote AD1000_36_B08 | ||||||
| 25641991 | 25641991 | PRJEB14175_P_NODE_212058_length_219_cov_2.126582_g209791_i0 | PRJEB14175 | 212058 | 219 | 2.126582 | 4.65721458 | Candidatus Nitrososphaera evergladensis SR1 | 1459636 | Archaea | Archaea | 198 | 2.35e-46 | NTclustered | gi|665992324|gb|CP007174.1| | 1459636 | g209791 | i0 | 83.732 | 6.26027397260274 | 209 | 34 | 95 | 0 | 11 | 219 | 1977401 | 1977193 | Candidatus Nitrososphaera evergladensis SR1, complete genome | blastn | 1371 | 198 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Candidatus Nitrososphaera evergladensis | ||
| 25773157 | 25773157 | PRJEB14175_P_NODE_104747_length_347_cov_70.727273_g102481_i0 | PRJEB14175 | 104747 | 347 | 70.727273 | 245.42363731 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 387 | 7.93e-103 | NTclustered | gi|146262968|gb|EF414271.1| | 29281 | g102481 | i0 | 88.58 | 133.994236311239 | 324 | 30 | 93 | 6 | 1 | 324 | 519 | 203 | Uncultured crenarchaeote clone BS80e2H5 putative amoA protein-like (amoA) mRNA, partial sequence | blastn | 46496 | 387 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 25775114 | 25775114 | PRJEB14175_P_NODE_143619_length_284_cov_44.807175_g141352_i0 | PRJEB14175 | 143619 | 284 | 44.807175 | 127.252377 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 298 | 3.05e-76 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g141352 | i0 | 87.405 | 55.9401408450704 | 262 | 30 | 92 | 3 | 25 | 284 | 6166 | 6426 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 15887 | 298 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 25782304 | 25782304 | PRJEB14175_P_NODE_54411_length_504_cov_32.214447_g52165_i0 | PRJEB14175 | 54411 | 504 | 32.214447 | 162.36081288 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 490 | 8.81e-134 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g52165 | i0 | 85.386 | 79.3333333333333 | 479 | 62 | 95 | 8 | 1 | 477 | 40844 | 40372 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 39984 | 490 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 25784331 | 25784331 | PRJEB14175_P_NODE_91315_length_378_cov_3.602524_g89049_i0 | PRJEB14175 | 91315 | 378 | 3.602524 | 13.61754072 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 588 | 2.2199999999999993e-163 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g89049 | i0 | 96.61 | 0.936507936507937 | 354 | 12 | 94 | 0 | 23 | 376 | 2058511 | 2058158 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 354 | 588 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 25909738 | 25909738 | PRJEB14175_P_NODE_113324_length_331_cov_5.396296_g111058_i0 | PRJEB14175 | 113324 | 331 | 5.396296 | 17.86173976 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 566 | 9e-157 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g111058 | i0 | 99.677 | 59.9607250755287 | 310 | 0 | 93 | 1 | 1 | 309 | 848204 | 847895 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 19847 | 566 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 25913647 | 25913647 | PRJEB14175_P_NODE_196188_length_231_cov_2.482353_g193921_i0 | PRJEB14175 | 196188 | 231 | 2.482353 | 5.73423543 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 385 | 1.79e-102 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g193921 | i0 | 100 | 2.3030303030303 | 208 | 0 | 90 | 0 | 24 | 231 | 1508819 | 1508612 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 532 | 385 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 25915510 | 25915510 | PRJEB14175_P_NODE_241252_length_205_cov_6.402778_g238984_i0 | PRJEB14175 | 241252 | 205 | 6.402778 | 13.1256949 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 329 | 7.39e-86 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g238984 | i0 | 98.396 | 58.2292682926829 | 187 | 3 | 91 | 0 | 1 | 187 | 40548 | 40362 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 11937 | 329 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 26048339 | 26048339 | PRJEB14175_P_NODE_167117_length_257_cov_5.469388_g164850_i0 | PRJEB14175 | 167117 | 257 | 5.469388 | 14.05632716 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 200 | 7.89e-47 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g164850 | i0 | 97.436 | 0.455252918287938 | 117 | 3 | 46 | 0 | 2 | 118 | 255929 | 256045 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 117 | 200 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 26049655 | 26049655 | PRJEB14175_P_NODE_196213_length_231_cov_2.311765_g193946_i0 | PRJEB14175 | 196213 | 231 | 2.311765 | 5.34017715 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 244 | 3.17e-60 | NTclustered | gi|2791746555|gb|CP166960.1| | 3045160 | g193946 | i0 | 86.818 | 0.952380952380952 | 220 | 28 | 95 | 1 | 4 | 222 | 1107991 | 1107772 | MAG: Candidatus Bathyarchaeia archaeon isolate Bathy6-F28_MillB chromosome | blastn | 220 | 244 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 26051772 | 26051772 | PRJEB14175_P_NODE_24637_length_743_cov_8.856305_g22668_i0 | PRJEB14175 | 24637 | 743 | 8.856305 | 65.80234615 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 1321 | 0 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g22668 | i0 | 99.586 | 71.2099596231494 | 725 | 1 | 97 | 1 | 21 | 743 | 848664 | 849388 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 52909 | 1321 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 26056346 | 26056346 | PRJEB14175_P_NODE_88269_length_385_cov_32.046296_g86004_i0 | PRJEB14175 | 88269 | 385 | 32.046296 | 123.3782396 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 477 | 5.119999999999998e-130 | NTclustered | gi|2874253764|emb|OY969706.1| | 2026714 | g86004 | i0 | 90.385 | 26.2155844155844 | 364 | 33 | 94 | 1 | 2 | 363 | 2265882 | 2266245 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD02416.bin.c.15 genome assembly, chromosome: 1 | blastn | 10093 | 477 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 26183134 | 26183134 | PRJEB14175_P_NODE_135878_length_295_cov_5.286325_g133611_i0 | PRJEB14175 | 135878 | 295 | 5.286325 | 15.59465875 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 514 | 2.9099999999999997e-141 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g133611 | i0 | 99.296 | 2.85084745762712 | 284 | 2 | 96 | 0 | 1 | 284 | 463211 | 463494 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 841 | 514 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 26189951 | 26189951 | PRJEB14175_P_NODE_41638_length_578_cov_4.912959_g39433_i0 | PRJEB14175 | 41638 | 578 | 4.912959 | 28.39690302 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 931 | 0 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g39433 | i0 | 96.937 | 33.401384083045 | 555 | 17 | 96 | 0 | 24 | 578 | 40490 | 41044 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 19306 | 931 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 26287827 | 26287827 | PRJEB14175_P_NODE_125662_length_310_cov_5.301205_g123395_i0 | PRJEB14175 | 125662 | 310 | 5.301205 | 16.4337355 | Archaea | 2157 | Archaea | Archaea | 368 | 2.53e-97 | NTclustered | gi|2874254015|emb|OY970340.1| | 2026714 | g123395 | i0 | 96.413 | 65.3032258064516 | 223 | 8 | 72 | 0 | 16 | 238 | 1806094 | 1806316 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD04492.bin.c.5 genome assembly, chromosome: 1 | blastn | 20244 | 368 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 26317349 | 26317349 | PRJEB14175_P_NODE_105535_length_346_cov_4.042105_g103269_i0 | PRJEB14175 | 105535 | 346 | 4.042105 | 13.9856833 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 479 | 1.2699999999999996e-130 | NTclustered | gi|2874253764|emb|OY969706.1| | 2026714 | g103269 | i0 | 93.252 | 34.9450867052023 | 326 | 21 | 94 | 1 | 22 | 346 | 2266404 | 2266079 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD02416.bin.c.15 genome assembly, chromosome: 1 | blastn | 12091 | 479 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 26319239 | 26319239 | PRJEB14175_P_NODE_143807_length_284_cov_7.071749_g141540_i0 | PRJEB14175 | 143807 | 284 | 7.071749 | 20.08376716 | Nitrosopumilus cobalaminigenes | 1470066 | Archaea | Archaea | 267 | 8.599999999999999e-67 | NTclustered | gi|1869221159|gb|CP026993.1| | 1470066 | g141540 | i0 | 85.057 | 6.88732394366197 | 261 | 39 | 92 | 0 | 1 | 261 | 112025 | 112285 | Nitrosopumilus cobalaminigenes strain HCA1 chromosome, complete genome | blastn | 1956 | 267 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus cobalaminigenes | ||
| 26321248 | 26321248 | PRJEB14175_P_NODE_188447_length_237_cov_6.403409_g186180_i0 | PRJEB14175 | 188447 | 237 | 6.403409 | 15.17607933 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 399 | 6.589999999999999e-107 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g186180 | i0 | 100 | 3.42194092827004 | 216 | 0 | 91 | 0 | 22 | 237 | 886353 | 886138 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 811 | 399 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 26324196 | 26324196 | PRJEB14175_P_NODE_258599_length_201_cov_1.214286_g256331_i0 | PRJEB14175 | 258599 | 201 | 1.214286 | 2.44071486 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 335 | 1.5499999999999995e-87 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g256331 | i0 | 98.421 | 20.7960199004975 | 190 | 3 | 95 | 0 | 1 | 190 | 8810 | 8621 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 4180 | 335 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 26461739 | 26461739 | PRJEB14175_P_NODE_36768_length_615_cov_9.106498_g34602_i0 | PRJEB14175 | 36768 | 615 | 9.106498 | 56.0049627 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 1040 | 0 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g34602 | i0 | 97.997 | 0.973983739837398 | 599 | 12 | 97 | 0 | 1 | 599 | 2706478 | 2705880 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 599 | 1040 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 26562959 | 26562959 | PRJEB14175_P_NODE_43856_length_563_cov_11.561753_g41642_i0 | PRJEB14175 | 43856 | 563 | 11.561753 | 65.09266939 | Archaea | 2157 | Archaea | Archaea | 915 | 0 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g41642 | i0 | 97.222 | 78.9378330373002 | 540 | 15 | 96 | 0 | 22 | 561 | 41488 | 42027 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 44442 | 924 | 0.99025974025974 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 26563179 | 26563179 | PRJEB14175_P_NODE_54280_length_505_cov_7.042793_g52034_i0 | PRJEB14175 | 54280 | 505 | 7.042793 | 35.56610465 | Thermoproteati | 1783275 | Archaea | Archaea | 678 | 0 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g52034 | i0 | 91.054 | 104.556435643564 | 503 | 44 | 99 | 1 | 3 | 505 | 7391 | 6890 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 52801 | 684 | 0.991228070175439 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote |
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);;