contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1115053" and tax_kingdom = "Thermotogati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 223953 | 223953 | PRJNA1115053_S_NODE_169061_length_208_cov_3.200000_g167244_i0 | PRJNA1115053 | 169061 | 208 | 3.2 | 6.656 | Deinococcus soli (ex Cha et al. 2016) | 1309411 | Bacteria | Bacteria | 381 | 2.0499999999999995e-101 | NTclustered | gi|821341785|gb|CP011389.1| | 1309411 | g167244 | i0 | 100 | 206.735576923077 | 206 | 0 | 99 | 0 | 3 | 208 | 1637305 | 1637510 | 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome | blastn | 43001 | 381 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) | ||
| 224755 | 224755 | PRJNA1115053_S_NODE_20161_length_458_cov_8.971084_g18361_i0 | PRJNA1115053 | 20161 | 458 | 8.971084 | 41.08756472 | Deinococcus soli (ex Cha et al. 2016) | 1309411 | Bacteria | Bacteria | 785 | 0 | NTclustered | gi|821341785|gb|CP011389.1| | 1309411 | g18361 | i0 | 99.087 | 227.480349344978 | 438 | 3 | 95 | 1 | 22 | 458 | 1638923 | 1638486 | 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome | blastn | 104186 | 785 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) | ||
| 1024623 | 1024623 | PRJNA1115053_S_NODE_72221_length_294_cov_2.075697_g70404_i0 | PRJNA1115053 | 72221 | 294 | 2.075697 | 6.10254918 | Deinococcus | 1298 | Bacteria | Bacteria | 544 | 3.69e-150 | NTclustered | gi|1435316362|gb|CP031158.1| | 980427 | g70404 | i0 | 100 | 199.006802721088 | 294 | 0 | 100 | 0 | 1 | 294 | 2148595 | 2148302 | Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome | blastn | 58508 | 544 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus wulumuqiensis | ||
| 3574964 | 3574964 | PRJNA1115053_S_NODE_238943_length_179_cov_1.764706_g237126_i0 | PRJNA1115053 | 238943 | 179 | 1.764706 | 3.15882374 | Deinococcus | 1298 | Bacteria | Bacteria | 331 | 1.74e-86 | NTclustered | gi|1435316362|gb|CP031158.1| | 980427 | g237126 | i0 | 100 | 362.966480446927 | 179 | 0 | 100 | 0 | 1 | 179 | 1792675 | 1792497 | Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome | blastn | 64971 | 331 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus wulumuqiensis | ||
| 11703398 | 11703398 | PRJNA1115053_S_NODE_196390_length_195_cov_2.842105_g194573_i0 | PRJNA1115053 | 196390 | 195 | 2.842105 | 5.54210475 | Deinococcus geothermalis | 68909 | Bacteria | Bacteria | 361 | 2.46e-95 | NTclustered | gi|94554390|gb|CP000359.1| | 319795 | g194573 | i0 | 100 | 94.2102564102564 | 195 | 0 | 100 | 0 | 1 | 195 | 326277 | 326083 | Deinococcus geothermalis DSM 11300, complete genome | blastn | 18371 | 361 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus geothermalis | ||
| 12981259 | 12981259 | PRJNA1115053_S_NODE_316211_length_157_cov_1.631579_g314394_i0 | PRJNA1115053 | 316211 | 157 | 1.631579 | 2.56157903 | Marinitoga aeolica | 2809031 | Bacteria | Bacteria | 52.8 | 0.013 | NTclustered | gi|2498963055|gb|CP069362.1| | 2809031 | g314394 | i0 | 100 | 0.178343949044586 | 28 | 0 | 18 | 0 | 93 | 120 | 2292209 | 2292236 | Marinitoga aeolica strain BP5-C20A chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Marinitoga | Marinitoga aeolica | ||
| 13777589 | 13777589 | PRJNA1115053_S_NODE_161691_length_212_cov_3.047337_g159874_i0 | PRJNA1115053 | 161691 | 212 | 3.047337 | 6.46035444 | Deinococcus | 1298 | Bacteria | Bacteria | 377 | 2.71e-100 | NTclustered | gi|2706837832|gb|CP149782.1| | 3112952 | g159874 | i0 | 99.048 | 193.084905660377 | 210 | 2 | 99 | 0 | 1 | 210 | 1454226 | 1454017 | Deinococcus sp. VB142 chromosome 1, complete sequence | blastn | 40934 | 377 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB142 | ||
| 20150681 | 20150681 | PRJNA1115053_S_NODE_143596_length_223_cov_3.783333_g141779_i0 | PRJNA1115053 | 143596 | 223 | 3.783333 | 8.43683259 | Allomeiothermus | 2935559 | Bacteria | Bacteria | 412 | 7.88e-111 | NTclustered | gi|470486339|ref|NR_076751.1| | 52022 | g141779 | i0 | 100 | 47.9103139013453 | 223 | 0 | 100 | 0 | 1 | 223 | 1054 | 832 | Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence | blastn | 10684 | 412 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Allomeiothermus | Allomeiothermus silvanus | ||
| 25251040 | 25251040 | PRJNA1115053_S_NODE_77400_length_286_cov_3.156379_g75583_i0 | PRJNA1115053 | 77400 | 286 | 3.156379 | 9.02724394 | Deinococcus | 1298 | Bacteria | Bacteria | 486 | 6.1099999999999986e-133 | NTclustered | gi|1514756464|dbj|LC433574.1| | 47478 | g75583 | i0 | 97.535 | 104.933566433566 | 284 | 7 | 99 | 0 | 1 | 284 | 816 | 533 | Deinococcus sp. TM138 gene for 16S ribosomal RNA, partial sequence | blastn | 30011 | 486 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. |
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);;