RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA758770" and tax_phylum = "Thermotogota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermotogota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA758770 · 20 ✖

analysis 1

  • blastn · 20 ✖

tax_clade 0

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
740609 740609 PRJNA758770_S_NODE_24381_length_252_cov_0.871508_g24255_i0 PRJNA758770 24381 252 0.871508 2.19620016 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 460 3.2e-125   NTclustered gi|762219508|emb|LN824141.1| 1006576 g24255 i0 99.603 1 252 1 100 0 1 252 1794097 1794348 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 252 460 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
1204669 1204669 PRJNA758770_S_NODE_31581_length_243_cov_0.917647_g31455_i0 PRJNA758770 31581 243 0.917647 2.22988221 Bacteria 2 Bacteria Bacteria 444 3.09e-120   NTclustered gi|383108560|gb|CP003260.1| 771875 g31455 i0 99.588 12.9753086419753 243 1 100 0 1 243 787612 787854 Fervidobacterium pennivorans DSM 9078, complete genome blastn 3153 444 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium pennivorans
2016784 2016784 PRJNA758770_S_NODE_31542_length_243_cov_0.917647_g31416_i0 PRJNA758770 31542 243 0.917647 2.22988221 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 449 6.65e-122   NTclustered gi|762219508|emb|LN824141.1| 1006576 g31416 i0 100 1 243 0 100 0 1 243 704750 704992 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 243 449 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
3291957 3291957 PRJNA758770_S_NODE_27723_length_248_cov_0.891429_g27597_i0 PRJNA758770 27723 248 0.891429 2.21074392 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 396 9e-106   NTclustered gi|762219508|emb|LN824141.1| 1006576 g27597 i0 96.639 0.959677419354839 238 8 96 0 2 239 739848 740085 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 238 396 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
8394004 8394004 PRJNA758770_S_NODE_29467_length_246_cov_0.901734_g29341_i0 PRJNA758770 29467 246 0.901734 2.21826564 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 351 1.96e-92   NTclustered gi|762219508|emb|LN824141.1| 1006576 g29341 i0 92.623 0.991869918699187 244 18 99 0 1 244 1632397 1632154 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 244 351 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
9669013 9669013 PRJNA758770_S_NODE_20868_length_266_cov_1.207254_g20742_i0 PRJNA758770 20868 266 1.207254 3.21129564 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 492 1.2099999999999999e-134   NTclustered gi|762219508|emb|LN824141.1| 1006576 g20742 i0 100 1 266 0 100 0 1 266 727226 726961 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 266 492 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
9669153 9669153 PRJNA758770_S_NODE_27028_length_249_cov_0.886364_g26902_i0 PRJNA758770 27028 249 0.886364 2.20704636 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 460 3.16e-125   NTclustered gi|762219508|emb|LN824141.1| 1006576 g26902 i0 100 1 249 0 100 0 1 249 29751 29503 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 249 460 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
10944837 10944837 PRJNA758770_S_NODE_29029_length_246_cov_0.901734_g28903_i0 PRJNA758770 29029 246 0.901734 2.21826564 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 217 7.449999999999999e-52   NTclustered gi|762219508|emb|LN824141.1| 1006576 g28903 i0 91.25 1.47967479674797 160 13 65 1 1 160 1881028 1880870 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 364 217 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
12220324 12220324 PRJNA758770_S_NODE_26930_length_249_cov_0.886364_g26804_i0 PRJNA758770 26930 249 0.886364 2.20704636 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 460 3.16e-125   NTclustered gi|762219508|emb|LN824141.1| 1006576 g26804 i0 100 1 249 0 100 0 1 249 325492 325244 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 249 460 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
12220348 12220348 PRJNA758770_S_NODE_27950_length_248_cov_0.891429_g27824_i0 PRJNA758770 27950 248 0.891429 2.21074392 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 448 2.4499999999999996e-121   NTclustered gi|762219508|emb|LN824141.1| 1006576 g27824 i0 99.197 1.00403225806452 249 1 100 1 1 248 890727 890975 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 249 448 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
13494409 13494409 PRJNA758770_S_NODE_25031_length_251_cov_0.876404_g24905_i0 PRJNA758770 25031 251 0.876404 2.19977404 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 448 2.48e-121   NTclustered gi|762219508|emb|LN824141.1| 1006576 g24905 i0 98.805 1 251 3 100 0 1 251 208969 208719 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 251 448 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
14769550 14769550 PRJNA758770_S_NODE_26692_length_249_cov_0.886364_g26566_i0 PRJNA758770 26692 249 0.886364 2.20704636 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 318 2.0099999999999998e-82   NTclustered gi|762219508|emb|LN824141.1| 1006576 g26566 i0 90.204 0.983935742971888 245 23 98 1 6 249 1438528 1438284 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 245 318 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
18592216 18592216 PRJNA758770_S_NODE_20535_length_268_cov_1.174359_g20409_i0 PRJNA758770 20535 268 1.174359 3.14728212 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 479 9.499999999999996e-131   NTclustered gi|762219508|emb|LN824141.1| 1006576 g20409 i0 98.881 22.0037313432836 268 3 100 0 1 268 1223441 1223708 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 5897 479 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
18592302 18592302 PRJNA758770_S_NODE_24355_length_252_cov_0.871508_g24229_i0 PRJNA758770 24355 252 0.871508 2.19620016 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 226 1.2699999999999999e-54   NTclustered gi|762219508|emb|LN824141.1| 1006576 g24229 i0 97.015 9.12698412698413 134 4 99 0 1 134 81482 81349 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 2300 226 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
18592351 18592351 PRJNA758770_S_NODE_26395_length_249_cov_1.346591_g26269_i0 PRJNA758770 26395 249 1.346591 3.35301159 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 438 1.4799999999999996e-118   NTclustered gi|762219508|emb|LN824141.1| 1006576 g26269 i0 98.394 30 249 4 100 0 1 249 1230143 1230391 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 7470 438 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
19867560 19867560 PRJNA758770_S_NODE_27076_length_249_cov_0.886364_g26950_i0 PRJNA758770 27076 249 0.886364 2.20704636 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 455 1.47e-123   NTclustered gi|762219508|emb|LN824141.1| 1006576 g26950 i0 99.598 1 249 1 100 0 1 249 185778 185530 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 249 455 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
19867629 19867629 PRJNA758770_S_NODE_30056_length_245_cov_0.906977_g29930_i0 PRJNA758770 30056 245 0.906977 2.22209365 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 448 2.41e-121   NTclustered gi|762219508|emb|LN824141.1| 1006576 g29930 i0 99.592 1 245 1 100 0 1 245 62971 62727 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 245 448 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
21143253 21143253 PRJNA758770_S_NODE_29097_length_246_cov_0.901734_g28971_i0 PRJNA758770 29097 246 0.901734 2.21826564 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 455 1.4500000000000002e-123   NTclustered gi|762219508|emb|LN824141.1| 1006576 g28971 i0 100 1 246 0 100 0 1 246 1354082 1354327 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 246 455 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
23693584 23693584 PRJNA758770_S_NODE_25099_length_251_cov_0.876404_g24973_i0 PRJNA758770 25099 251 0.876404 2.19977404 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 459 1.1499999999999996e-124   NTclustered gi|762219508|emb|LN824141.1| 1006576 g24973 i0 99.602 1 251 1 100 0 1 251 1771234 1771484 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 251 459 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
23693733 23693733 PRJNA758770_S_NODE_31279_length_244_cov_0.865497_g31153_i0 PRJNA758770 31279 244 0.865497 2.11181268 Defluviitoga tunisiensis 1006576 Bacteria Bacteria 451 1.86e-122   NTclustered gi|762219508|emb|LN824141.1| 1006576 g31153 i0 100 1 244 0 100 0 1 244 834694 834937 Defluviitoga tunisiensis genome assembly DTL3, chromosome : I blastn 244 451 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;