RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA886442" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA886442 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
11445248 11445248 PRJNA886442_P_NODE_13489_length_246_cov_0.901734_g13325_i0 PRJNA886442 13489 246 0.901734 2.21826564 Corallococcus 83461 Bacteria Bacteria 427 3.16e-115   NTclustered gi|2851136330|gb|CP172866.1| 184914 g13325 i0 97.967 54.6463414634146 246 5 100 0 1 246 2475359 2475114 Corallococcus coralloides strain KYC2213 chromosome, complete genome blastn 13443 427 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus Corallococcus coralloides
12340981 12340981 PRJNA886442_P_NODE_11870_length_249_cov_1.676136_g11706_i0 PRJNA886442 11870 249 1.676136 4.17357864 Labilithrix luteola 1391654 Bacteria Bacteria 268 2.06e-67   NTclustered gi|913610804|gb|CP012333.1| 1391654 g11706 i0 86.64 0.991967871485944 247 28 98 5 1 244 5311072 5311316 Labilithrix luteola strain DSM 27648, complete genome blastn 247 268 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
19988462 19988462 PRJNA886442_P_NODE_11616_length_250_cov_0.881356_g11452_i0 PRJNA886442 11616 250 0.881356 2.20339 Sorangium cellulosum 56 Bacteria Bacteria 241 4.5e-59   NTclustered gi|161158851|emb|AM746676.1| 448385 g11452 i0 85.345 81.988 232 34 93 0 16 247 2862965 2862734 Sorangium cellulosum 'So ce 56' complete genome blastn 20497 241 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum
21263971 21263971 PRJNA886442_P_NODE_8697_length_273_cov_1.470000_g8533_i0 PRJNA886442 8697 273 1.47 4.0131 Labilithrix luteola 1391654 Bacteria Bacteria 388 1.68e-103   NTclustered gi|913610804|gb|CP012333.1| 1391654 g8533 i0 92.308 16.8241758241758 273 21 100 0 1 273 8383372 8383644 Labilithrix luteola strain DSM 27648, complete genome blastn 4593 388 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
21263973 21263973 PRJNA886442_P_NODE_877_length_736_cov_5.358974_g718_i0 PRJNA886442 877 736 5.358974 39.44204864 Corallococcus sp. EGB 1521117 Bacteria Bacteria 1269 0   NTclustered gi|2094564806|gb|CP079946.1| 1521117 g718 i0 97.829 256.445652173913 737 13 100 2 1 736 112427 113161 Corallococcus sp. EGB chromosome, complete genome blastn 188744 1269 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus Corallococcus sp. EGB
25088045 25088045 PRJNA886442_P_NODE_7100_length_296_cov_1.793722_g6936_i0 PRJNA886442 7100 296 1.793722 5.30941712 Labilithrix luteola 1391654 Bacteria Bacteria 241 5.47e-59   NTclustered gi|913610804|gb|CP012333.1| 1391654 g6936 i0 84.556 33.4189189189189 259 22 87 13 40 296 9592254 9592012 Labilithrix luteola strain DSM 27648, complete genome blastn 9892 241 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola

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