RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA975724" 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

  • PRJNA975724 · 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
6370974 6370974 PRJNA975724_S_NODE_79585_length_250_cov_1.305085_g79404_i0 PRJNA975724 79585 250 1.305085 3.2627125 Deinococcus 1298 Bacteria Bacteria 462 8.83e-126   NTclustered gi|730601855|gb|CP010028.1| 57497 g79404 i0 100 164.02 250 0 100 0 1 250 70509 70260 Deinococcus swuensis strain DY59, complete genome blastn 41005 462 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiopugnans
8599621 8599621 PRJNA975724_S_NODE_62687_length_274_cov_1.532338_g62506_i0 PRJNA975724 62687 274 1.532338 4.19860612 Trueperaceae bacterium 2026798 Bacteria Bacteria 422 1.67e-113   NTclustered gi|2108366028|gb|CP070651.1| 2026798 g62506 i0 95.131 462.452554744526 267 13 97 0 8 274 7477 7211 MAG: Trueperaceae bacterium isolate bin86 chromosome blastn 126712 422 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
16250034 16250034 PRJNA975724_S_NODE_79173_length_250_cov_2.237288_g78992_i0 PRJNA975724 79173 250 2.237288 5.59322 Deinococcus radiophilus 32062 Bacteria Bacteria 54.7 0.006   NTclustered gi|2152125425|gb|CP086381.1| 32062 g78992 i0 100 0.116 29 0 12 0 222 250 71369 71341 Deinococcus radiophilus strain ATCC 27603 plasmid pRadio1, complete sequence blastn 29 54.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiophilus
22623113 22623113 PRJNA975724_S_NODE_36778_length_328_cov_1.454902_g36597_i0 PRJNA975724 36778 328 1.454902 4.77207856 Trueperaceae bacterium 2026798 Bacteria Bacteria 418 2.6399999999999992e-112   NTclustered gi|2108366028|gb|CP070651.1| 2026798 g36597 i0 89.666 79.655487804878 329 32 100 2 1 328 7858 8185 MAG: Trueperaceae bacterium isolate bin86 chromosome blastn 26127 418 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
23899445 23899445 PRJNA975724_S_NODE_72619_length_259_cov_1.241935_g72438_i0 PRJNA975724 72619 259 1.241935 3.21661165 Trueperaceae bacterium 2026798 Bacteria Bacteria 370 5.73e-98   NTclustered gi|2108366028|gb|CP070651.1| 2026798 g72438 i0 92.941 589.521235521236 255 17 98 1 4 257 6781 6527 MAG: Trueperaceae bacterium isolate bin86 chromosome blastn 152686 370 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium

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