RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB673" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJEB673 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
134868 134868 PRJEB673_P_NODE_10001_length_182_cov_3.877551_g9652_i0 PRJEB673 10001 182 3.877551 7.05714282 Myxococcus sp. 116781 422003 Bacteria Bacteria 292 8.38e-75   NTclustered gi|152956905|emb|AM489521.1| 422003 g9652 i0 95.604 114.016483516484 182 8 100 0 1 182 191 10 Myxococcus sp. 116781 partial 16S rRNA gene, strain 116781 blastn 20751 292 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus sp. 116781
1409434 1409434 PRJEB673_P_NODE_10682_length_170_cov_1.481481_g10333_i0 PRJEB673 10682 170 1.481481 2.5185177 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 99 1.8e-16   NTclustered gi|1950807334|gb|CP066680.1| 2026735 g10333 i0 82.759 0.682352941176471 116 14 66 6 58 170 309485 309373 MAG: Deltaproteobacteria bacterium isolate NC_groundwater_69_Ag_B-0.1um_32_21 chromosome blastn 116 99 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
2270418 2270418 PRJEB673_P_NODE_4262_length_467_cov_4.111111_g3919_i0 PRJEB673 4262 467 4.111111 19.19888837 Archangiaceae 39 Bacteria Bacteria 636 9.849999999999997e-178   NTclustered gi|2244675|emb|X87291.1| 41 g3919 i0 92.551 240.706638115632 443 33 95 0 10 452 1164 722 S.aurantiaca 23S rRNA gene blastn 112410 641 0.992199687987519 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Stigmatella Stigmatella aurantiaca
4823356 4823356 PRJEB673_P_NODE_1304_length_830_cov_1.938365_g1088_i0 PRJEB673 1304 830 1.938365 16.0884295 Stigmatella 40 Bacteria Bacteria 1062 0   NTclustered gi|507148216|ref|NR_103023.1| 41 g1088 i0 89.94 250.24578313253 835 68 99 12 1 828 848 23 Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence blastn 207704 1062 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Stigmatella Stigmatella aurantiaca
6098476 6098476 PRJEB673_P_NODE_2245_length_650_cov_2.276423_g1968_i0 PRJEB673 2245 650 2.276423 14.7967495 Stigmatella 40 Bacteria Bacteria 824 0   NTclustered gi|507148216|ref|NR_103023.1| 41 g1968 i0 89.124 201.524615384615 662 52 100 16 1 650 1870 1217 Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence blastn 130991 824 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Stigmatella Stigmatella aurantiaca
12474238 12474238 PRJEB673_P_NODE_5550_length_377_cov_1.216374_g5201_i0 PRJEB673 5550 377 1.216374 4.58572998 Myxococcus 32 Bacteria Bacteria 472 2.3299999999999996e-128   NTclustered gi|1691485482|gb|CP017169.1| 34 g5201 i0 89.628 253.440318302387 376 32 99 6 5 377 373664 373293 Myxococcus xanthus strain GH3.5.6c2 chromosome, complete genome blastn 95547 472 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus xanthus
25221450 25221450 PRJEB673_P_NODE_8220_length_291_cov_2.718750_g7871_i0 PRJEB673 8220 291 2.71875 7.9115625 Myxococcales 29 Bacteria Bacteria 425 1.38e-114   NTclustered gi|470488931|ref|NR_076895.1| 33 g7871 i0 93.127 279.426116838488 291 18 100 2 1 291 2953 2665 Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence blastn 81313 425 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus fulvus

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