RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA939415" and tax_clade = "delta/epsilon subdivisions"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • delta/epsilon subdivisions · 13 ✖

bioproject 1

  • PRJNA939415 · 13 ✖

analysis 1

  • diamond · 13 ✖

tax_phylum 0

tax_kingdom 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
21318085 21318085 PRJNA939415_P_NODE_68797_length_265_cov_1.885417_g68375_i0 PRJNA939415 68797 265 1.885417 4.99635505 Deltaproteobacteria bacterium HGW-Deltaproteobacteria-2 2013747 Bacteria Bacteria 79.3 5.51e-15   NR PKN46493.1 2013748 g68375 i0 48.7 0.883018867924528 78 38 88.3 1 27 260 226 301 PKN46493.1 MAG: hypothetical protein CVU63_07515, partial [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20] diamond 234 79.3 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20
26874141 26874141 PRJNA939415_P_NODE_83461_length_251_cov_0.865169_g83039_i0 PRJNA939415 83461 251 0.865169 2.17157419 Bacteria 2 Bacteria Bacteria 110 8.250000000000001e-26   NR OQB15450.1 1852869 g83039 i0 62.2 5.71314741035857 82 31 98 0 246 1 684 765 OQB15450.1 MAG: FG-GAP repeat protein [Deltaproteobacteria bacterium ADurb.Bin207] diamond 1434 110 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium ADurb.Bin207
27278041 27278041 PRJNA939415_P_NODE_39803_length_295_cov_2.725225_g39381_i0 PRJNA939415 39803 295 2.725225 8.03941375 Deltaproteobacteria bacterium GWA2_55_82 1797810 Bacteria Bacteria 47.8 0.00124   NR OGP15958.1 1797810 g39381 i0 40 0.508474576271186 50 30 50.8 0 145 294 1041 1090 OGP15958.1 MAG: hypothetical protein A2Z79_07245 [Deltaproteobacteria bacterium GWA2_55_82] diamond 150 47.8 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium GWA2_55_82
27783368 27783368 PRJNA939415_P_NODE_16944_length_378_cov_3.537705_g16524_i0 PRJNA939415 16944 378 3.537705 13.3725249 Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_65_9 1973968 Bacteria Bacteria 231 8.33e-76   NR PJB30816.1 1973968 g16524 i0 90.4 2.97619047619048 125 12 99.2 0 376 2 33 157 PJB30816.1 MAG: peroxiredoxin [Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_65_9] diamond 1125 231 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_65_9
27979623 27979623 PRJNA939415_P_NODE_112025_length_197_cov_5.709677_g111603_i0 PRJNA939415 112025 197 5.709677 11.24806369 Chloroflexota 200795 Bacteria Bacteria 103 1.41e-25   NR PIR26531.1 1973973 g111603 i0 69.2 8.90862944162436 65 20 99 0 1 195 77 141 PIR26531.1 MAG: peptidase E [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_42_23] diamond 1755 103 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_42_23
28105805 28105805 PRJNA939415_P_NODE_5265_length_873_cov_3.458750_g4877_i0 PRJNA939415 5265 873 3.45875 30.1948875 Bacteria 2 Bacteria Bacteria 305 4.479999999999999e-101   NR OGR03293.1 1797903 g4877 i0 64.8 5.53264604810997 230 81 79 0 872 183 8 237 OGR03293.1 MAG: ABC transporter ATP-binding protein [Deltaproteobacteria bacterium RIFOXYD12_FULL_53_23] diamond 4830 307 0.993485342019544 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYD12_FULL_53_23
28863617 28863617 PRJNA939415_P_NODE_67148_length_266_cov_4.621762_g66726_i0 PRJNA939415 67148 266 4.621762 12.29388692 Pseudomonadati 3379134 Bacteria Bacteria 54.3 3.97e-6   NR MEC8341679.1 2024889 g66726 i0 46.6 7.09398496240602 58 31 65.4 0 49 222 2 59 MEC8341679.1 AAA family ATPase [SAR324 cluster bacterium] diamond 1887 54.7 0.992687385740402 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       SAR324 cluster bacterium
29211171 29211171 PRJNA939415_P_NODE_12169_length_443_cov_9.624324_g11750_i0 PRJNA939415 12169 443 9.624324 42.63575532 Pseudomonadota 1224 Bacteria Bacteria 210 3.96e-62   NR OGR03277.1 1797903 g11750 i0 74.5 3.96839729119639 145 37 98.2 0 441 7 23 167 OGR03277.1 MAG: secretion system protein E [Deltaproteobacteria bacterium RIFOXYD12_FULL_53_23] diamond 1758 210 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYD12_FULL_53_23
29810787 29810787 PRJNA939415_P_NODE_111051_length_202_cov_4.170543_g110629_i0 PRJNA939415 111051 202 4.170543 8.42449686 Bacteria 2 Bacteria Bacteria 92 5.51e-20   NR OGQ91634.1 1797895 g110629 i0 69.7 3.92079207920792 66 20 98 0 3 200 331 396 OGQ91634.1 MAG: multidrug ABC transporter substrate-binding protein [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] diamond 792 92 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
29930438 29930438 PRJNA939415_P_NODE_100351_length_234_cov_3.279503_g99929_i0 PRJNA939415 100351 234 3.279503 7.67403702 Bradymonas sediminis 1548548 Bacteria Bacteria 67.4 6.61e-11   NR WP_111336193.1 1548548 g99929 i0 46.2 6.83333333333333 65 35 83.3 0 199 5 4 68 WP_111336193.1 AMP-dependent synthetase/ligase [Bradymonas sediminis] diamond 1599 67.4 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria Bradymonadales Bradymonadaceae Bradymonas Bradymonas sediminis
31004581 31004581 PRJNA939415_P_NODE_41134_length_293_cov_1.750000_g40712_i0 PRJNA939415 41134 293 1.75 5.1275 Deltaproteobacteria bacterium RIFOXYD12_FULL_53_23 1797903 Bacteria Bacteria 92.8 1.5e-20   NR OGR03272.1 1797903 g40712 i0 53 0.849829351535836 83 39 85 0 2 250 173 255 OGR03272.1 MAG: hypothetical protein A2520_04175 [Deltaproteobacteria bacterium RIFOXYD12_FULL_53_23] diamond 249 92.8 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYD12_FULL_53_23
31896887 31896887 PRJNA939415_P_NODE_84457_length_250_cov_1.361582_g84035_i0 PRJNA939415 84457 250 1.361582 3.403955 Bacteria 2 Bacteria Bacteria 63.5 1.48e-9   NR OQB09973.1 1852869 g84035 i0 39 1.968 82 49 98.4 1 3 248 146 226 OQB09973.1 MAG: hypothetical protein BWY17_04432 [Deltaproteobacteria bacterium ADurb.Bin207] diamond 492 63.5 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium ADurb.Bin207
32427997 32427997 PRJNA939415_P_NODE_79819_length_254_cov_2.331492_g79397_i0 PRJNA939415 79819 254 2.331492 5.92198968 Bradymonadales bacterium 2099667 Bacteria Bacteria 62.8 3.36e-9   NR MBN1947766.1 2099667 g79397 i0 35.4 0.968503937007874 82 52 96.9 1 5 250 105 185 MBN1947766.1 CDP-alcohol phosphatidyltransferase family protein [Bradymonadales bacterium] diamond 246 62.8 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria Bradymonadales     Bradymonadales 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);;