RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB50332" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB50332 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
29086378 29086378 PRJEB50332_P_NODE_9548_length_227_cov_1.307229_g9466_i0 PRJEB50332 9548 227 1.307229 2.96740983 Terrimicrobium sp. 1965319 Bacteria Bacteria 155 1.6e-43   NR HEY6675541.1 1965319 g9466 i0 92 0.991189427312775 75 6 99.1 0 1 225 250 324 HEY6675541.1 hypothetical protein [Terrimicrobium sp.] diamond 225 155 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Terrimicrobiia Terrimicrobiales Terrimicrobiaceae Terrimicrobium Terrimicrobium sp.
29244142 29244142 PRJEB50332_P_NODE_15869_length_205_cov_1.354167_g15787_i0 PRJEB50332 15869 205 1.354167 2.77604235 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 80.1 1.48e-15   NR HYG84357.1 2499141 g15787 i0 64.1 0.936585365853659 64 21 93.7 1 3 194 199 260 HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] diamond 192 80.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
29275513 29275513 PRJEB50332_P_NODE_1169_length_503_cov_2.416290_g1088_i0 PRJEB50332 1169 503 2.41629 12.1539387 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 58.5 6.62e-7   NR HEX3818319.1 2201154 g1088 i0 37.3 0.656063618290258 110 59 63.8 5 497 177 120 222 HEX3818319.1 CAP domain-containing protein [Chthoniobacterales bacterium] diamond 330 58.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
29521513 29521513 PRJEB50332_P_NODE_8610_length_232_cov_1.976608_g8528_i0 PRJEB50332 8610 232 1.976608 4.58573056 Prosthecobacter 48463 Bacteria Bacteria 135 7.98e-36   NR MDZ4289601.1 1965333 g8528 i0 84 4.84913793103448 75 12 97 0 227 3 40 114 MDZ4289601.1 cytochrome c peroxidase [Prosthecobacter sp.] diamond 1125 136 0.992647058823529 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
30918378 30918378 PRJEB50332_P_NODE_11314_length_217_cov_1.666667_g11232_i0 PRJEB50332 11314 217 1.666667 3.61666739 Horticoccus sp. 23ND18S-11 3391832 Bacteria Bacteria 143 1.64e-38   NR WP_414662761.1 3391832 g11232 i0 86.1 2.98617511520737 72 10 99.5 0 217 2 233 304 WP_414662761.1 NAD(P)/FAD-dependent oxidoreductase [Horticoccus sp. 23ND18S-11] diamond 648 143 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Horticoccus Horticoccus sp. 23ND18S-11
30981600 30981600 PRJEB50332_P_NODE_18414_length_192_cov_2.465649_g18332_i0 PRJEB50332 18414 192 2.465649 4.73404608 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 64.7 7.99e-12   NR HJT45844.1 2201154 g18332 i0 52.5 6.703125 59 27 92.2 1 177 1 22 79 HJT45844.1 ATP-grasp domain-containing protein [Chthoniobacterales bacterium] diamond 1287 64.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales 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);;