RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA451191" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA451191 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
26600943 26600943 PRJNA451191_P_NODE_10041_length_477_cov_1.923077_g9770_i0 PRJNA451191 10041 477 1.923077 9.17307729 Bacteroidales bacterium 2030927 Bacteria Bacteria 118 2.1900000000000003e-27   NR MFO7827238.1 2030927 g9770 i0 41.8 0.993710691823899 158 92 99.4 0 3 476 773 930 MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium] diamond 474 118 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
27676570 27676570 PRJNA451191_P_NODE_19244_length_328_cov_1.880150_g18973_i0 PRJNA451191 19244 328 1.88015 6.166892 Bacteroidales bacterium 2030927 Bacteria Bacteria 85.9 7.57e-17   NR MFO7827238.1 2030927 g18973 i0 55 0.731707317073171 80 28 73.2 2 1 240 356 427 MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium] diamond 240 85.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
27708345 27708345 PRJNA451191_P_NODE_48844_length_208_cov_0.884354_g48573_i0 PRJNA451191 48844 208 0.884354 1.83945632 Riemerella sp. 2382126 Bacteria Bacteria 136 1.96e-35   NR MBF1097526.1 2382126 g48573 i0 98.5 1.96153846153846 68 1 98.1 0 3 206 127 194 MBF1097526.1 type I restriction-modification system endonuclease [Riemerella sp.] diamond 408 136 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Riemerella Riemerella sp.
27708346 27708346 PRJNA451191_P_NODE_49464_length_207_cov_0.890411_g49193_i0 PRJNA451191 49464 207 0.890411 1.84315077 Bacteroidales bacterium 2030927 Bacteria Bacteria 48.1 2.89e-4   NR MFO7827238.1 2030927 g49193 i0 42.9 0.91304347826087 63 34 88.4 1 2 184 861 923 MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium] diamond 189 48.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
27771250 27771250 PRJNA451191_P_NODE_52804_length_204_cov_0.909091_g52533_i0 PRJNA451191 52804 204 0.909091 1.85454564 Rufibacter latericius 2487040 Bacteria Bacteria 113 3.520000000000001e-27   NR WP_123124899.1 2487040 g52533 i0 80.6 1.97058823529412 67 13 98.5 0 2 202 266 332 WP_123124899.1 TAT-variant-translocated molybdopterin oxidoreductase [Rufibacter latericius] diamond 402 113 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Rufibacter Rufibacter latericius
28655188 28655188 PRJNA451191_P_NODE_44727_length_212_cov_2.403974_g44456_i0 PRJNA451191 44727 212 2.403974 5.09642488 Bacteroidota bacterium 1898104 Bacteria Bacteria 63.9 8.23e-10   NR MEL6988110.1 1898104 g44456 i0 54.7 2.19339622641509 53 24 75 0 210 52 64 116 MEL6988110.1 reverse transcriptase family protein [Bacteroidota bacterium] diamond 465 63.9 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28655192 28655192 PRJNA451191_P_NODE_50507_length_206_cov_0.896552_g50236_i0 PRJNA451191 50507 206 0.896552 1.84689712 Bacteroidales bacterium 2030927 Bacteria Bacteria 43.5 0.0125   NR MFO7827122.1 2030927 g50236 i0 45.9 0.538834951456311 37 20 53.9 0 8 118 815 851 MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium] diamond 111 43.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
28686967 28686967 PRJNA451191_P_NODE_51427_length_205_cov_1.201389_g51156_i0 PRJNA451191 51427 205 1.201389 2.46284745 Bacteroidales bacterium 2030927 Bacteria Bacteria 87.8 3.08e-18   NR MFO7827238.1 2030927 g51156 i0 64.5 0.907317073170732 62 22 90.7 0 204 19 561 622 MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium] diamond 186 87.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
29254768 29254768 PRJNA451191_P_NODE_19789_length_323_cov_1.793893_g19518_i0 PRJNA451191 19789 323 1.793893 5.79427439 Bacteroidales bacterium 2030927 Bacteria Bacteria 78.6 2.58e-14   NR MFO7827122.1 2030927 g19518 i0 51.9 0.715170278637771 77 37 71.5 0 79 309 591 667 MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium] diamond 231 78.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
29949767 29949767 PRJNA451191_P_NODE_54051_length_203_cov_0.915493_g53780_i0 PRJNA451191 54051 203 0.915493 1.85845079 Bacteroidales bacterium 2030927 Bacteria Bacteria 63.5 1.01e-9   NR MFO7827122.1 2030927 g53780 i0 43.1 0.960591133004926 65 37 96.1 0 2 196 768 832 MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium] diamond 195 63.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
31339998 31339998 PRJNA451191_P_NODE_44936_length_212_cov_1.549669_g44665_i0 PRJNA451191 44936 212 1.549669 3.28529828 Bacteroidales bacterium 2030927 Bacteria Bacteria 45.1 0.00386   NR MFO7827122.1 2030927 g44665 i0 48.8 0.608490566037736 43 22 60.8 0 50 178 613 655 MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium] diamond 129 45.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
31814481 31814481 PRJNA451191_P_NODE_25877_length_279_cov_3.472477_g25606_i0 PRJNA451191 25877 279 3.472477 9.68821083 Bacteroidales bacterium 2030927 Bacteria Bacteria 96.3 1.22e-21   NR MFO7844437.1 2030927 g25606 i0 51.2 0.903225806451613 84 41 90.3 0 278 27 201 284 MFO7844437.1 hypothetical protein [Bacteroidales bacterium] diamond 252 96.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
31877586 31877586 PRJNA451191_P_NODE_20037_length_321_cov_1.426923_g19766_i0 PRJNA451191 20037 321 1.426923 4.58042283 Psychroflexus sp. 1921580 Bacteria Bacteria 49.3 4.64e-4   NR MFO7744505.1 1921580 g19766 i0 58.3 0.336448598130841 36 15 33.6 0 213 320 709 744 MFO7744505.1 reverse transcriptase family protein [Psychroflexus sp.] diamond 108 49.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Psychroflexus Psychroflexus sp.
31909405 31909405 PRJNA451191_P_NODE_28157_length_268_cov_1.256039_g27886_i0 PRJNA451191 28157 268 1.256039 3.36618452 Bacteroidota bacterium 1898104 Bacteria Bacteria 43.1 0.0343   NR MFC2110995.1 1898104 g27886 i0 33.3 0.705223880597015 63 36 69.4 2 226 41 77 134 MFC2110995.1 diacylglycerol/lipid kinase family protein [Bacteroidota bacterium] diamond 189 43.1 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
32067498 32067498 PRJNA451191_P_NODE_32798_length_248_cov_3.128342_g32527_i0 PRJNA451191 32798 248 3.128342 7.75828816 Bacteroidales bacterium 2030927 Bacteria Bacteria 49.7 1.44e-4   NR MFO7827122.1 2030927 g32527 i0 30.4 0.955645161290323 79 55 95.6 0 239 3 747 825 MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium] diamond 237 49.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
32099189 32099189 PRJNA451191_P_NODE_30578_length_257_cov_1.326531_g30307_i0 PRJNA451191 30578 257 1.326531 3.40918467 Psychroflexus sp. 1921580 Bacteria Bacteria 48.5 4.11e-4   NR MFO7744505.1 1921580 g30307 i0 47.1 0.595330739299611 51 27 59.5 0 102 254 285 335 MFO7744505.1 reverse transcriptase family protein [Psychroflexus sp.] diamond 153 48.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Psychroflexus Psychroflexus sp.
32099191 32099191 PRJNA451191_P_NODE_33218_length_247_cov_1.419355_g32947_i0 PRJNA451191 33218 247 1.419355 3.50580685 Bacteroidales bacterium 2030927 Bacteria Bacteria 44.7 0.00812   NR MFO7827122.1 2030927 g32947 i0 36 0.898785425101215 50 32 60.7 0 6 155 453 502 MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium] diamond 222 44.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
32225963 32225963 PRJNA451191_P_NODE_13858_length_396_cov_1.232836_g13587_i0 PRJNA451191 13858 396 1.232836 4.88203056 Bacteroidales bacterium 2030927 Bacteria Bacteria 71.2 2.23e-11   NR MFO7827238.1 2030927 g13587 i0 35.8 0.803030303030303 106 62 77.3 3 5 310 918 1021 MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium] diamond 318 71.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales 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);;