RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA640143", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 21 ✖

tax_kingdom 1

  • Pseudomonadati · 21 ✖

bioproject 1

  • PRJNA640143 · 21 ✖

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
609969 609969 PRJNA640143_S_NODE_27301_length_168_cov_1.190840_g27091_i0 PRJNA640143 27301 168 1.19084 2.0006112 Bacteria 2 Bacteria Bacteria 90.9 4.2e-22   NR MDQ3132555.1 1978231 g27091 i0 86.3 4.51785714285714 51 7 91.1 0 167 15 52 102 MDQ3132555.1 30S ribosomal protein S7 [Acidobacteriota bacterium] diamond 759 90.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
1886114 1886114 PRJNA640143_S_NODE_24222_length_179_cov_2.697183_g24012_i0 PRJNA640143 24222 179 2.697183 4.82795757 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 217 5.0799999999999996e-52   NTclustered gi|2874253931|emb|OY970256.1| 2283092 g24012 i0 92.715 44.854748603352 151 10 84 1 3 153 359829 359680 MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1 blastn 8029 217 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
2430650 2430650 PRJNA640143_S_NODE_27822_length_166_cov_1.046512_g27612_i0 PRJNA640143 27822 166 1.046512 1.73720992 Bacteria 2 Bacteria Bacteria 285 1.26e-72   NTclustered gi|31789363|gb|AY281352.1| 171953 g27612 i0 97.59 136.066265060241 166 4 100 0 1 166 2842 3007 Uncultured Acidobacteria bacterium clone 23k22 genomic sequence blastn 22587 285 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
8262885 8262885 PRJNA640143_S_NODE_11827_length_252_cov_1.576744_g11617_i0 PRJNA640143 11827 252 1.576744 3.97339488 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 285 2.07e-72   NTclustered gi|2874254027|emb|OY970352.1| 171953 g11617 i0 87.55 73.3968253968254 249 28 98 2 1 247 2367168 2366921 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 18496 285 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
12089180 12089180 PRJNA640143_S_NODE_17810_length_207_cov_8.370588_g17600_i0 PRJNA640143 17810 207 8.370588 17.32711716 Holophagales bacterium 2478486 Bacteria Bacteria 180 7.96e-41   NTclustered gi|1958024485|gb|CP064972.1| 2478486 g17600 i0 85.714 78.5314009661836 175 20 84 5 35 207 1452787 1452958 Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome blastn 16256 180 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales     Holophagales bacterium
13363794 13363794 PRJNA640143_S_NODE_11351_length_256_cov_88.305936_g11141_i0 PRJNA640143 11351 256 88.305936 226.06319616 Acidobacteriota bacterium 1978231 Bacteria Bacteria 298 2.71e-76   NTclustered gi|1958093598|gb|CP065003.1| 1978231 g11141 i0 90.991 38.31640625 222 19 86 1 1 221 317473 317252 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome blastn 9809 298 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
17187564 17187564 PRJNA640143_S_NODE_11154_length_258_cov_107.601810_g10944_i0 PRJNA640143 11154 258 107.60181 277.6126698 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 289 1.64e-73   NTclustered gi|76574288|gb|DQ139436.1| 171953 g10944 i0 90.135 49.593023255814 223 20 86 2 37 258 1 222 Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence blastn 12795 289 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
22287284 22287284 PRJNA640143_S_NODE_6118_length_336_cov_52.267559_g5908_i0 PRJNA640143 6118 336 52.267559 175.61899824 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 425 1.62e-114   NTclustered gi|217038899|gb|EU810989.1| 171953 g5908 i0 90.491 257.136904761905 326 26 96 5 8 331 1 323 Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence blastn 86398 425 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
23562446 23562446 PRJNA640143_S_NODE_19959_length_196_cov_44.327044_g19749_i0 PRJNA640143 19959 196 44.327044 86.88100624 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 215 2.04e-51   NTclustered gi|217038899|gb|EU810989.1| 171953 g19749 i0 90.244 334.234693877551 164 16 84 0 8 171 1 164 Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence blastn 65510 215 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
26637789 26637789 PRJNA640143_S_NODE_30921_length_155_cov_1.796610_g30711_i0 PRJNA640143 30921 155 1.79661 2.7847455 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 62.4 4.23e-11   NR MBA2736638.1 2283092 g30711 i0 60 1.93548387096774 50 19 96.8 1 4 153 1 49 MBA2736638.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 300 62.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
26681879 26681879 PRJNA640143_S_NODE_29321_length_160_cov_3.170732_g29111_i0 PRJNA640143 29321 160 3.170732 5.0731712 Bacteria 2 Bacteria Bacteria 83.6 4.75e-17   NR MDQ1353206.1 1978231 g29111 i0 82.6 7.7625 46 8 86.3 0 3 140 235 280 MDQ1353206.1 hypothetical protein [Acidobacteriota bacterium] diamond 1242 84 0.995238095238095 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26828004 26828004 PRJNA640143_S_NODE_32781_length_150_cov_1.663717_g32571_i0 PRJNA640143 32781 150 1.663717 2.4955755 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 72.4 2.91e-15   NR MBA2735665.1 2283092 g32571 i0 94.7 0.76 38 2 76 0 36 149 9 46 MBA2735665.1 50S ribosomal protein L29 [Pyrinomonadaceae bacterium] diamond 114 72.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28502222 28502222 PRJNA640143_S_NODE_14947_length_225_cov_10.377660_g14737_i0 PRJNA640143 14947 225 10.37766 23.349735 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 111 2.13e-28   NR MCK6693374.1 2651171 g14737 i0 86.2 0.866666666666667 65 9 86.7 0 196 2 16 80 MCK6693374.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 195 111 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
28565294 28565294 PRJNA640143_S_NODE_12247_length_248_cov_1.696682_g12037_i0 PRJNA640143 12247 248 1.696682 4.20777136 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 145 1.72e-39   NR HXG84575.1 2283092 g12037 i0 92.7 2.9758064516129 82 6 99.2 0 247 2 378 459 HXG84575.1 TolC family protein [Pyrinomonadaceae bacterium] diamond 738 145 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28767178 28767178 PRJNA640143_S_NODE_31787_length_153_cov_1.344828_g31577_i0 PRJNA640143 31787 153 1.344828 2.05758684 Bacteria 2 Bacteria Bacteria 84.3 2.43e-17   NR MDQ3131757.1 1978231 g31577 i0 88.9 3.52941176470588 45 5 88.2 0 150 16 625 669 MDQ3131757.1 S8 family serine peptidase [Acidobacteriota bacterium] diamond 540 84.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28861807 28861807 PRJNA640143_S_NODE_27048_length_169_cov_1.416667_g26838_i0 PRJNA640143 27048 169 1.416667 2.39416723 Bacteria 2 Bacteria Bacteria 83.6 6.62e-19   NR MDQ3132141.1 1978231 g26838 i0 95.7 5.71597633136095 46 2 81.7 0 139 2 35 80 MDQ3132141.1 hemerythrin domain-containing protein [Acidobacteriota bacterium] diamond 966 84 0.995238095238095 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29259747 29259747 PRJNA640143_S_NODE_32209_length_152_cov_1.017391_g31999_i0 PRJNA640143 32209 152 1.017391 1.54643432 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 57.8 5.3e-8   NR HXT71982.1 2910147 g31999 i0 55.3 1.85526315789474 47 21 92.8 0 11 151 157 203 HXT71982.1 alpha-L-arabinofuranosidase C-terminal domain-containing protein [Vicinamibacterales bacterium] diamond 282 57.8 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
29891636 29891636 PRJNA640143_S_NODE_31351_length_154_cov_1.461538_g31141_i0 PRJNA640143 31351 154 1.461538 2.25076852 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 82.8 1.93e-18   NR MBA2735508.1 2283092 g31141 i0 86 0.974025974025974 50 7 97.4 0 152 3 3 52 MBA2735508.1 hemerythrin domain-containing protein [Pyrinomonadaceae bacterium] diamond 150 82.8 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31073022 31073022 PRJNA640143_S_NODE_31795_length_153_cov_1.310345_g31585_i0 PRJNA640143 31795 153 1.310345 2.00482785 Bacteria 2 Bacteria Bacteria 88.6 9.86e-21   NR MBA3631548.1 1978231 g31585 i0 86.3 2 51 7 100 0 153 1 56 106 MBA3631548.1 outer membrane protein assembly factor BamD [Acidobacteriota bacterium] diamond 306 88.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31471683 31471683 PRJNA640143_S_NODE_31036_length_155_cov_1.322034_g30826_i0 PRJNA640143 31036 155 1.322034 2.0491527 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 102 4.17e-25   NR MEO7157222.1 2910147 g30826 i0 90.2 1.9741935483871 51 5 98.7 0 2 154 5 55 MEO7157222.1 50S ribosomal protein L3 [Vicinamibacterales bacterium] diamond 306 102 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
31661111 31661111 PRJNA640143_S_NODE_26497_length_171_cov_1.746269_g26287_i0 PRJNA640143 26497 171 1.746269 2.98611999 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 41.2 0.0491   NR HYO15783.1 2651171 g26287 i0 38.5 0.912280701754386 52 31 89.5 1 8 160 271 322 HYO15783.1 O-antigen ligase family protein [Thermoanaerobaculia bacterium] diamond 156 41.2 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia 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);;