RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA902848" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 4 ✖

bioproject 1

  • PRJNA902848 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
3799117 3799117 PRJNA902848_P_NODE_6643_length_335_cov_1.259542_g6593_i0 PRJNA902848 6643 335 1.259542 4.2194657 Deinococcus 1298 Bacteria Bacteria 560 4.25e-155   NTclustered gi|2890653062|gb|CP177252.1| 367282 g6593 i0 97.554 212.850746268657 327 8 98 0 1 327 2671891 2672217 Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome blastn 71305 560 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus yunweiensis
11450893 11450893 PRJNA902848_P_NODE_9629_length_289_cov_1.444444_g9579_i0 PRJNA902848 9629 289 1.444444 4.17444316 Deinococcus 1298 Bacteria Bacteria 444 3.78e-120   NTclustered gi|1220362168|gb|CP021081.1| 317577 g9579 i0 94.464 198.539792387543 289 15 100 1 1 289 2342142 2342429 Deinococcus ficus strain CC-FR2-10, complete genome blastn 57378 444 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
16184913 16184913 PRJNA902848_P_NODE_4653_length_381_cov_1.519481_g4603_i0 PRJNA902848 4653 381 1.519481 5.78922261 Deinococcus yunweiensis 367282 Bacteria Bacteria 403 8.71e-108   NTclustered gi|2890653062|gb|CP177252.1| 367282 g4603 i0 93.68 168.732283464567 269 17 71 0 113 381 2672887 2673155 Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome blastn 64287 403 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus yunweiensis
17824395 17824395 PRJNA902848_P_NODE_10314_length_281_cov_1.153846_g10264_i0 PRJNA902848 10314 281 1.153846 3.24230726 Deinococcus 1298 Bacteria Bacteria 459 1.31e-124   NTclustered gi|1435316362|gb|CP031158.1| 980427 g10264 i0 96.099 210.722419928826 282 9 99 2 2 281 2148351 2148632 Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome blastn 59213 460 0.997826086956522 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis

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