RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA966993" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 8 ✖

bioproject 1

  • PRJNA966993 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
6045101 6045101 PRJNA966993_P_NODE_100125_length_237_cov_2.792683_g99673_i0 PRJNA966993 100125 237 2.792683 6.61865871 Deinococcus sp. VB343 3385567 Bacteria Bacteria 300 6.88e-77   NTclustered gi|2905211496|gb|CP179945.1| 3385567 g99673 i0 89.54 24.1392405063291 239 21 100 3 1 237 1245697 1245461 Deinococcus sp. VB343 chromosome 1, complete sequence blastn 5721 300 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB343
6045477 6045477 PRJNA966993_P_NODE_52505_length_299_cov_1.548673_g52053_i0 PRJNA966993 52505 299 1.548673 4.63053227 Deinococcus geothermalis 68909 Bacteria Bacteria 553 6.25e-153   NTclustered gi|94554390|gb|CP000359.1| 319795 g52053 i0 100 231.755852842809 299 0 100 0 1 299 2375574 2375276 Deinococcus geothermalis DSM 11300, complete genome blastn 69295 553 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
8595487 8595487 PRJNA966993_P_NODE_81867_length_251_cov_1.730337_g81415_i0 PRJNA966993 81867 251 1.730337 4.34314587 Deinococcus sp. VB343 3385567 Bacteria Bacteria 453 5.34e-123   NTclustered gi|2905211496|gb|CP179945.1| 3385567 g81415 i0 99.203 20.5019920318725 251 2 100 0 1 251 1728247 1727997 Deinococcus sp. VB343 chromosome 1, complete sequence blastn 5146 453 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB343
12744902 12744902 PRJNA966993_P_NODE_70530_length_269_cov_2.020408_g70078_i0 PRJNA966993 70530 269 2.020408 5.43489752 Deinococcus 1298 Bacteria Bacteria 486 5.699999999999999e-133   NTclustered gi|2264081587|gb|CP094462.1| 1299 g70078 i0 99.257 15 269 2 100 0 1 269 546758 546490 Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence blastn 4035 486 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiodurans
16245253 16245253 PRJNA966993_P_NODE_72413_length_266_cov_2.787565_g71961_i0 PRJNA966993 72413 266 2.787565 7.4149229 Thermotoga caldifontis 1508419 Bacteria Bacteria 52.8 0.024   NTclustered gi|597439397|dbj|AP014509.1| 1408159 g71961 i0 100 0.105263157894737 28 0 11 0 83 110 829004 829031 Thermotoga caldifontis AZM44c09 DNA, complete genome blastn 28 52.8 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga caldifontis
17843223 17843223 PRJNA966993_P_NODE_87914_length_248_cov_0.880000_g87462_i0 PRJNA966993 87914 248 0.88 2.1824 Deinococcus 1298 Bacteria Bacteria 438 1.4699999999999995e-118   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g87462 i0 98.79 14.9193548387097 248 0 100 1 1 248 1162850 1162606 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 3700 438 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142
18794065 18794065 PRJNA966993_P_NODE_56075_length_290_cov_1.700461_g55623_i0 PRJNA966993 56075 290 1.700461 4.9313369 Deinococcus ficus 317577 Bacteria Bacteria 508 1.33e-139   NTclustered gi|1220362168|gb|CP021081.1| 317577 g55623 i0 98.276 192.572413793103 290 5 100 0 1 290 2342310 2342021 Deinococcus ficus strain CC-FR2-10, complete genome blastn 55846 508 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
25492125 25492125 PRJNA966993_P_NODE_65700_length_276_cov_2.147783_g65248_i0 PRJNA966993 65700 276 2.147783 5.92788108 Deinococcus 1298 Bacteria Bacteria 510 3.48e-140   NTclustered gi|2706840606|gb|CP149783.1| 3112952 g65248 i0 100 17.768115942029 276 0 100 0 1 276 121519 121794 Deinococcus sp. VB142 chromosome 2, complete sequence blastn 4904 510 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142

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