RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA512103" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA512103 · 9 ✖

analysis 1

  • diamond · 9 ✖
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
26918991 26918991 PRJNA512103_P_NODE_22202_length_201_cov_1.335526_g21790_i0 PRJNA512103 22202 201 1.335526 2.68440726 Bacteroidales bacterium 2030927 Bacteria Bacteria 67 6.09e-11   NR MFO7827122.1 2030927 g21790 i0 51.6 0.955223880597015 64 31 95.5 0 1 192 577 640 MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium] diamond 192 67 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
27140002 27140002 PRJNA512103_P_NODE_20102_length_214_cov_0.963636_g19690_i0 PRJNA512103 20102 214 0.963636 2.06218104 Psychroflexus sp. 1921580 Bacteria Bacteria 59.3 3.57e-8   NR MFO7744505.1 1921580 g19690 i0 41.3 0.883177570093458 63 36 86.9 1 9 194 671 733 MFO7744505.1 reverse transcriptase family protein [Psychroflexus sp.] diamond 189 59.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Psychroflexus Psychroflexus sp.
28277152 28277152 PRJNA512103_P_NODE_23486_length_195_cov_1.150685_g23074_i0 PRJNA512103 23486 195 1.150685 2.24383575 Bacteroidales bacterium 2030927 Bacteria Bacteria 70.9 2.47e-12   NR MFO7827238.1 2030927 g23074 i0 54.2 0.907692307692308 59 27 90.8 0 186 10 839 897 MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium] diamond 177 70.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
28340435 28340435 PRJNA512103_P_NODE_13626_length_289_cov_1.225000_g13214_i0 PRJNA512103 13626 289 1.225 3.54025 Bacteroidales bacterium 2030927 Bacteria Bacteria 119 1.07e-28   NR MFO7827122.1 2030927 g13214 i0 59.1 0.913494809688581 88 36 91.3 0 12 275 511 598 MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium] diamond 264 119 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
30456673 30456673 PRJNA512103_P_NODE_33433_length_164_cov_0.904348_g33021_i0 PRJNA512103 33433 164 0.904348 1.48313072 Bacteroidales bacterium 2030927 Bacteria Bacteria 83.2 2.24e-17   NR MFO7844438.1 2030927 g33021 i0 77.1 0.878048780487805 48 11 87.8 0 154 11 103 150 MFO7844438.1 endonuclease/exonuclease/phosphatase family protein [Bacteroidales bacterium] diamond 144 83.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
31150980 31150980 PRJNA512103_P_NODE_34555_length_162_cov_0.920354_g34143_i0 PRJNA512103 34555 162 0.920354 1.49097348 Bacteroidales bacterium 2030927 Bacteria Bacteria 62 1.94e-9   NR MFO7827238.1 2030927 g34143 i0 69.4 0.666666666666667 36 11 66.7 0 154 47 872 907 MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium] diamond 108 62 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
31372938 31372938 PRJNA512103_P_NODE_22796_length_198_cov_1.221477_g22384_i0 PRJNA512103 22796 198 1.221477 2.41852446 Bacteroidales bacterium 2030927 Bacteria Bacteria 42 0.0379   NR HOY31904.1 2030927 g22384 i0 40 0.757575757575758 50 27 75.8 1 38 187 200 246 HOY31904.1 radical SAM protein [Bacteroidales bacterium] diamond 150 42 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
31546477 31546477 PRJNA512103_P_NODE_32216_length_166_cov_0.888889_g31804_i0 PRJNA512103 32216 166 0.888889 1.47555574 FCB group 1783270 Bacteria Bacteria 43.1 0.00997   NR MEI6821811.1 1898104 g31804 i0 63 3.74096385542169 27 10 48.8 0 156 76 760 786 MEI6821811.1 T9SS type A sorting domain-containing protein [Bacteroidota bacterium] diamond 621 43.1 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31847093 31847093 PRJNA512103_P_NODE_30117_length_170_cov_1.214876_g29705_i0 PRJNA512103 30117 170 1.214876 2.0652892 Bacteroidales bacterium 2030927 Bacteria Bacteria 45.4 0.00157   NR MFO7827122.1 2030927 g29705 i0 41.7 0.847058823529412 48 28 84.7 0 160 17 740 787 MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium] diamond 144 45.4 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);;