RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB58983" 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

  • PRJEB58983 · 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
12878844 12878844 PRJEB58983_P_NODE_751_length_1501_cov_13.788515_g546_i0 PRJEB58983 751 1501 13.788515 206.96561015 Bacteria 2 Bacteria Bacteria 236 1.35e-71   NR RYD62314.1 2026800 g546 i0 71.7 0.667554963357762 166 43 32.4 1 1013 1498 1 166 RYD62314.1 MAG: hypothetical protein EOP83_14915 [Verrucomicrobiaceae bacterium] diamond 1002 236 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
28644394 28644394 PRJEB58983_P_NODE_22347_length_277_cov_2.887255_g21932_i0 PRJEB58983 22347 277 2.887255 7.99769635 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 47 0.00184   NR MDW8349389.1 2499141 g21932 i0 34.8 0.714801444043321 66 41 69.3 1 212 21 1676 1741 MDW8349389.1 putative Ig domain-containing protein [Verrucomicrobiia bacterium] diamond 198 47 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
29907400 29907400 PRJEB58983_P_NODE_9731_length_400_cov_1.311927_g9317_i0 PRJEB58983 9731 400 1.311927 5.247708 Candidatus Methylacidiphilales bacterium 2720631 Bacteria Bacteria 108 1.43e-24   NR MCE0483121.1 2720631 g9317 i0 47.3 0.9825 131 68 98.3 1 395 3 224 353 MCE0483121.1 AAA family ATPase [Candidatus Methylacidiphilales bacterium] diamond 393 108 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Methylacidiphilae Methylacidiphilales     Candidatus Methylacidiphilales bacterium
30152959 30152959 PRJEB58983_P_NODE_31512_length_244_cov_1.035088_g31097_i0 PRJEB58983 31512 244 1.035088 2.52561472 Pseudomonadati 3379134 Bacteria Bacteria 73.9 3.97e-13   NR MDA0323257.1 2026799 g31097 i0 51.2 3 82 38 99.6 2 243 1 231 311 MDA0323257.1 C25 family cysteine peptidase [Verrucomicrobiota bacterium] diamond 732 73.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30563634 30563634 PRJEB58983_P_NODE_1893_length_924_cov_2.030552_g1551_i0 PRJEB58983 1893 924 2.030552 18.76230048 Pseudomonadati 3379134 Bacteria Bacteria 247 3.42e-72   NR MFA6961216.1 2006848 g1551 i0 45.2 3.02272727272727 310 148 99.4 7 924 7 329 620 MFA6961216.1 TonB-dependent siderophore receptor [Opitutaceae bacterium] diamond 2793 247 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
30823501 30823501 PRJEB58983_P_NODE_29374_length_249_cov_1.329545_g28959_i0 PRJEB58983 29374 249 1.329545 3.31056705 Pedosphaera sp. 2024890 Bacteria Bacteria 85.9 2.67e-17   NR MSU31824.1 2024890 g28959 i0 55.7 2.85542168674699 79 35 95.2 0 237 1 549 627 MSU31824.1 type IV pilus assembly protein PilM [Pedosphaera sp.] diamond 711 85.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera sp.

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