RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJEB12237" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJEB12237 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
26868674 26868674 PRJEB12237_P_NODE_2661_length_430_cov_1.716456_g2465_i0 PRJEB12237 2661 430 1.716456 7.3807608 Pseudomonadati 3379134 Bacteria Bacteria 59.3 4.29e-7   NR MBX3265733.1 1978231 g2465 i0 34.8 1.3046511627907 89 52 59.3 4 354 100 146 232 MBX3265733.1 hypothetical protein [Acidobacteriota bacterium] diamond 561 59.7 0.993299832495812 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27032932 27032932 PRJEB12237_P_NODE_9682_length_172_cov_1.459854_g9486_i0 PRJEB12237 9682 172 1.459854 2.51094888 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 47 4.62e-4   NR NNF01029.1 2283092 g9486 i0 48.7 1.90116279069767 39 20 68 0 171 55 366 404 NNF01029.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 327 47 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27949034 27949034 PRJEB12237_P_NODE_3085_length_387_cov_4.221591_g2889_i0 PRJEB12237 3085 387 4.221591 16.33755717 Acidobacteriota bacterium 1978231 Bacteria Bacteria 125 1.42e-34   NR MDQ7008653.1 1978231 g2889 i0 83.8 0.62015503875969 80 13 62 0 146 385 24 103 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 240 125 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29085838 29085838 PRJEB12237_P_NODE_6008_length_239_cov_1.568627_g5812_i0 PRJEB12237 6008 239 1.568627 3.74901853 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 70.9 4.43e-13   NR HSE24404.1 2283092 g5812 i0 52.9 0.853556485355649 68 32 85.4 0 237 34 103 170 HSE24404.1 globin family protein [Pyrinomonadaceae bacterium] diamond 204 70.9 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29338331 29338331 PRJEB12237_P_NODE_10349_length_165_cov_1.230769_g10153_i0 PRJEB12237 10349 165 1.230769 2.03076885 Blastocatellia bacterium 2052146 Bacteria Bacteria 53.9 7.63e-7   NR HQR39838.1 2052146 g10153 i0 52.3 0.8 44 21 80 0 163 32 73 116 HQR39838.1 hypothetical protein [Blastocatellia bacterium] diamond 132 53.9 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
29748462 29748462 PRJEB12237_P_NODE_9111_length_179_cov_1.666667_g8915_i0 PRJEB12237 9111 179 1.666667 2.98333393 Terriglobia bacterium 2081523 Bacteria Bacteria 54.3 1.29e-6   NR MBV8732832.1 2081523 g8915 i0 42.4 0.988826815642458 59 31 98.9 2 3 179 125 180 MBV8732832.1 hypothetical protein [Terriglobia bacterium] diamond 177 54.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
29780295 29780295 PRJEB12237_P_NODE_2011_length_504_cov_2.400853_g1823_i0 PRJEB12237 2011 504 2.400853 12.10029912 Acidobacteriota bacterium 1978231 Bacteria Bacteria 107 1.13e-26   NR MDQ7008654.1 1978231 g1823 i0 86.8 0.404761904761905 68 8 40.5 1 504 301 45 111 MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium] diamond 204 107 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30089772 30089772 PRJEB12237_P_NODE_9452_length_175_cov_1.300000_g9256_i0 PRJEB12237 9452 175 1.3 2.275 Pseudomonadati 3379134 Bacteria Bacteria 47.4 3.55e-4   NR HKQ62042.1 2910585 g9256 i0 59.5 3.41142857142857 37 15 63.4 0 111 1 600 636 HKQ62042.1 metallophosphoesterase [Candidatus Polarisedimenticolaceae bacterium] diamond 597 47.4 1 Bacteria   Pseudomonadati Acidobacteriota Candidatus Polarisedimenticolia Candidatus Polarisedimenticolales Candidatus Polarisedimenticolaceae   Candidatus Polarisedimenticolaceae bacterium
30886062 30886062 PRJEB12237_P_NODE_3094_length_387_cov_1.715909_g2898_i0 PRJEB12237 3094 387 1.715909 6.64056783 Acidobacteriota bacterium 1978231 Bacteria Bacteria 101 5.38e-25   NR MDQ7008653.1 1978231 g2898 i0 83.1 0.503875968992248 65 11 50.4 0 222 28 45 109 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 195 101 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31992808 31992808 PRJEB12237_P_NODE_5078_length_272_cov_1.518987_g4882_i0 PRJEB12237 5078 272 1.518987 4.13164464 Blastocatellia bacterium 2052146 Bacteria Bacteria 69.7 9.02e-12   NR MFN7928494.1 2052146 g4882 i0 45.1 2.00735294117647 91 36 99.3 3 3 272 173 250 MFN7928494.1 pirin family protein [Blastocatellia bacterium] diamond 546 69.7 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
32246285 32246285 PRJEB12237_P_NODE_12158_length_150_cov_1.391304_g11962_i0 PRJEB12237 12158 150 1.391304 2.086956 Acidobacteriota bacterium 1978231 Bacteria Bacteria 95.1 3.6100000000000005e-21   NR MCB1042508.1 1978231 g11962 i0 75.5 4.9 49 12 98 0 149 3 291 339 MCB1042508.1 acetate--CoA ligase [Acidobacteriota bacterium] diamond 735 95.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32782593 32782593 PRJEB12237_P_NODE_3200_length_376_cov_1.768328_g3004_i0 PRJEB12237 3200 376 1.768328 6.64891328 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 89.4 2.57e-18   NR MDR3737318.1 2052142 g3004 i0 44.8 0.997340425531915 125 61 95.7 4 362 3 186 307 MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] diamond 375 89.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae 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);;