RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1166865" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1166865 · 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
2863939 2863939 PRJNA1166865_P_NODE_51543_length_307_cov_1.974359_g51302_i0 PRJNA1166865 51543 307 1.974359 6.06128213 Geomonas nitrogeniifigens 2843197 Bacteria Bacteria 60.2 1.71e-4   NTclustered gi|2056222742|gb|CP076724.1| 2847991 g51302 i0 81.013 39.5635179153094 79 11 25 4 1 77 667024 666948 Geomonas nitrogeniifigens strain RG29 chromosome, complete genome blastn 12146 60.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geomonas Geomonas nitrogeniifigens
17617379 17617379 PRJNA1166865_P_NODE_75254_length_251_cov_0.865169_g75013_i0 PRJNA1166865 75254 251 0.865169 2.17157419 Pseudomonadati 3379134 Bacteria Bacteria 52.8 0.023   NTclustered gi|2908463109|gb|CP168306.1| 81425 g75013 i0 100 0.334661354581673 28 0 11 0 221 248 1669271 1669298 MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome blastn 84 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio aminophilus
19438503 19438503 PRJNA1166865_P_NODE_29816_length_394_cov_1.919003_g29575_i0 PRJNA1166865 29816 394 1.919003 7.56087182 Desulfolutivibrio sulfoxidireducens 2773299 Bacteria Bacteria 58.4 8.1e-4   NTclustered gi|1863429635|gb|CP045508.1| 2773299 g29575 i0 100 0.548223350253807 31 0 8 0 246 276 3214337 3214307 Desulfolutivibrio sulfoxidireducens strain DSM 107105 chromosome, complete genome blastn 216 58.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfolutivibrio Desulfolutivibrio sulfoxidireducens
24538743 24538743 PRJNA1166865_P_NODE_400_length_1977_cov_3.653361_g374_i0 PRJNA1166865 400 1977 3.653361 72.22694697 Citrifermentans bremense 60035 Bacteria Bacteria 58.4 0.004   NTclustered gi|1886376207|dbj|AP023213.1| 60035 g374 i0 92.683 0.020738492665655 41 1 2 2 251 290 4358509 4358548 Geobacter bremensis R4 DNA, complete genome blastn 41 58.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Citrifermentans Citrifermentans bremense

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