RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA902848" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 4 ✖

tax_kingdom 1

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
882021 882021 PRJNA902848_P_NODE_17481_length_246_cov_0.901734_g17431_i0 PRJNA902848 17481 246 0.901734 2.21826564 Sorangium cellulosum 56 Bacteria Bacteria 294 3.34e-75   NTclustered gi|520999024|gb|CP003969.1| 1254432 g17431 i0 89.61 16.1260162601626 231 24 94 0 1 231 951494 951724 Sorangium cellulosum So0157-2, complete genome blastn 3967 294 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum
6351055 6351055 PRJNA902848_P_NODE_19465_length_243_cov_0.917647_g19415_i0 PRJNA902848 19465 243 0.917647 2.22988221 Sorangium 39643 Bacteria Bacteria 198 2.6599999999999998e-46   NTclustered gi|1566478966|gb|CP012672.1| 56 g19415 i0 82.553 54.0123456790123 235 31 95 8 14 243 7556250 7556021 Sorangium cellulosum strain So ce836 chromosome, complete genome blastn 13125 198 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum
16184807 16184807 PRJNA902848_P_NODE_18393_length_245_cov_0.906977_g18343_i0 PRJNA902848 18393 245 0.906977 2.22209365 Anaeromyxobacter paludicola 2918171 Bacteria Bacteria 398 2.47e-106   NTclustered gi|2199271117|dbj|AP025592.1| 2918171 g18343 i0 95.918 225.722448979592 245 10 100 0 1 245 1383991 1383747 Anaeromyxobacter paludicola DNA, complete genome blastn 55302 398 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter paludicola
18733420 18733420 PRJNA902848_P_NODE_15835_length_249_cov_0.886364_g15785_i0 PRJNA902848 15835 249 0.886364 2.20704636 Vulgatibacter incomptus 1391653 Bacteria Bacteria 348 2.57e-91   NTclustered gi|913607065|gb|CP012332.1| 1391653 g15785 i0 92.245 238.807228915663 245 19 98 0 1 245 180391 180147 Vulgatibacter incomptus strain DSM 27710, complete genome blastn 59463 348 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Vulgatibacteraceae Vulgatibacter Vulgatibacter incomptus

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