RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA473201", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 9 ✖

tax_kingdom 1

  • Pseudomonadati · 9 ✖

bioproject 1

  • PRJNA473201 · 9 ✖

analysis 1

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
2995200 2995200 PRJNA473201_P_NODE_78203_length_245_cov_0.895349_g77461_i0 PRJNA473201 78203 245 0.895349 2.19360505 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 121 3.74e-33   NR HJU41924.1 2910147 g77461 i0 71.6 0.991836734693878 81 23 99.2 0 245 3 12 92 HJU41924.1 DUF4383 domain-containing protein [Vicinamibacterales bacterium] diamond 243 121 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
26949510 26949510 PRJNA473201_P_NODE_44642_length_305_cov_1.396552_g43900_i0 PRJNA473201 44642 305 1.396552 4.2594836 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 85.1 1.06e-16   NR MCK6681268.1 2651171 g43900 i0 49 3.61967213114754 100 48 95.4 2 305 15 448 547 MCK6681268.1 M4 family metallopeptidase [Thermoanaerobaculia bacterium] diamond 1104 85.1 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
27012831 27012831 PRJNA473201_P_NODE_42982_length_310_cov_0.894515_g42240_i0 PRJNA473201 42982 310 0.894515 2.7729965 Acidobacteriota bacterium 1978231 Bacteria Bacteria 43.9 0.0302   NR PYY06731.1 1978231 g42240 i0 38.4 0.706451612903226 73 37 65.8 4 102 305 64 133 PYY06731.1 MAG: hypothetical protein DMG64_00660 [Acidobacteriota bacterium] diamond 219 43.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27802854 27802854 PRJNA473201_P_NODE_5604_length_857_cov_8.394133_g5002_i0 PRJNA473201 5604 857 8.394133 71.93771981 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 68.6 2.83e-9   NR HEX8565731.1 2283092 g5002 i0 26 0.752625437572929 215 145 71.1 5 65 673 6 218 HEX8565731.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 645 68.6 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27992271 27992271 PRJNA473201_P_NODE_67765_length_250_cov_0.870056_g67023_i0 PRJNA473201 67765 250 0.870056 2.17514 Acidobacteriota bacterium 1978231 Bacteria Bacteria 65.9 2.29e-10   NR MFN7971025.1 1978231 g67023 i0 46.9 0.972 81 36 97.2 1 248 6 20 93 MFN7971025.1 ornithine cyclodeaminase family protein [Acidobacteriota bacterium] diamond 243 65.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29081943 29081943 PRJNA473201_P_NODE_58608_length_270_cov_1.172589_g57866_i0 PRJNA473201 58608 270 1.172589 3.1659903 Bacteria 2 Bacteria Bacteria 54.3 4.41e-6   NR MDR3751823.1 1964191 g57866 i0 42.6 1.7 68 34 75.6 2 29 232 408 470 MDR3751823.1 choice-of-anchor D domain-containing protein [Terracidiphilus sp.] diamond 459 54.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
31877693 31877693 PRJNA473201_P_NODE_72617_length_248_cov_0.880000_g71875_i0 PRJNA473201 72617 248 0.88 2.1824 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 44.3 0.0114   NR HEY5255302.1 2052142 g71875 i0 51.3 1.39112903225806 39 19 47.2 0 29 145 269 307 HEY5255302.1 glycoside hydrolase family 36 protein [Acidobacteriaceae bacterium] diamond 345 44.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
32067582 32067582 PRJNA473201_P_NODE_81638_length_243_cov_0.905882_g80896_i0 PRJNA473201 81638 243 0.905882 2.20129326 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 45.1 0.0058   NR MEA2166533.1 2651171 g80896 i0 45 0.493827160493827 40 22 49.4 0 189 70 456 495 MEA2166533.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 120 45.1 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
32636631 32636631 PRJNA473201_P_NODE_77280_length_245_cov_0.895349_g76538_i0 PRJNA473201 77280 245 0.895349 2.19360505 Terriglobales bacterium 2282142 Bacteria Bacteria 95.9 7.580000000000001e-21   NR MCE5307638.1 2282142 g76538 i0 53.1 15.8326530612245 81 38 99.2 0 245 3 124 204 MCE5307638.1 glycosyltransferase family 4 protein [Terriglobales bacterium] diamond 3879 95.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales 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);;