RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA721440" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 5 ✖

bioproject 1

  • PRJNA721440 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
1193624 1193624 PRJNA721440_S_NODE_13661_length_182_cov_4.842105_g13535_i0 PRJNA721440 13661 182 4.842105 8.8126311 Deinococcus 1298 Bacteria Bacteria 324 2.97e-84   NTclustered gi|145033|gb|M21413.1|DEIRGDA 1299 g13535 i0 98.901 126.884615384615 182 1 100 1 1 182 1 181 D.radiodurans 16S ribosomal RNA gene blastn 23093 324 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiodurans
6297669 6297669 PRJNA721440_S_NODE_1505_length_436_cov_12.671835_g1379_i0 PRJNA721440 1505 436 12.671835 55.2492006 Deinococcus 1298 Bacteria Bacteria 795 0   NTclustered gi|145033|gb|M21413.1|DEIRGDA 1299 g1379 i0 99.541 133.933486238532 436 2 100 0 1 436 467 902 D.radiodurans 16S ribosomal RNA gene blastn 58395 795 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiodurans
7571449 7571449 PRJNA721440_S_NODE_15946_length_172_cov_5.682927_g15820_i0 PRJNA721440 15946 172 5.682927 9.77463444 Deinococcus 1298 Bacteria Bacteria 318 1.2899999999999999e-82   NTclustered gi|2562457319|gb|OR430766.1| 980427 g15820 i0 100 138.011627906977 172 0 100 0 1 172 1212 1041 Deinococcus wulumuqiensis strain V671 16S ribosomal RNA gene, partial sequence blastn 23738 318 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
12673247 12673247 PRJNA721440_S_NODE_5270_length_260_cov_6.412322_g5144_i0 PRJNA721440 5270 260 6.412322 16.6720372 Deinococcus 1298 Bacteria Bacteria 481 2.55e-131   NTclustered gi|1435316362|gb|CP031158.1| 980427 g5144 i0 100 221.207692307692 260 0 100 0 1 260 1792135 1791876 Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome blastn 57514 481 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
15222194 15222194 PRJNA721440_S_NODE_2472_length_356_cov_3.511401_g2346_i0 PRJNA721440 2472 356 3.511401 12.50058756 Deinococcus 1298 Bacteria Bacteria 658 0   NTclustered gi|1435316362|gb|CP031158.1| 980427 g2346 i0 100 193.719101123595 356 0 100 0 1 356 2147658 2148013 Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome blastn 68964 658 1 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);;