RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1174770" and tax_clade = "FCB group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • FCB group · 20 ✖

bioproject 1

  • PRJNA1174770 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
26933202 26933202 PRJNA1174770_P_NODE_10042_length_165_cov_0.896552_g9953_i0 PRJNA1174770 10042 165 0.896552 1.4793108 Porphyromonas 836 Bacteria Bacteria 107 1.44e-25   NR WP_287336950.1 1924944 g9953 i0 92.7 2 55 4 100 0 1 165 10 64 WP_287336950.1 IMP dehydrogenase [Porphyromonas sp.] diamond 330 107 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas sp.
27388438 27388438 PRJNA1174770_P_NODE_8323_length_168_cov_0.873950_g8234_i0 PRJNA1174770 8323 168 0.87395 1.468236 Candidatus Brachybacter algidus 2982024 Bacteria Bacteria 47.4 3.77e-5   NR MBK8748818.1 2982024 g8234 i0 50 0.571428571428571 32 16 57.1 0 70 165 8 39 MBK8748818.1 hypothetical protein [Candidatus Brachybacter algidus] diamond 96 47.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae Candidatus Brachybacter Candidatus Brachybacter algidus
27849285 27849285 PRJNA1174770_P_NODE_9564_length_166_cov_0.888889_g9475_i0 PRJNA1174770 9564 166 0.888889 1.47555574 Pseudomonadati 3379134 Bacteria Bacteria 92.8 3.02e-20   NR MBI4559844.1 2030809 g9475 i0 83.6 2.98192771084337 55 9 99.4 0 2 166 8 62 MBI4559844.1 N-6 DNA methylase [Candidatus Hydrogenedentota bacterium] diamond 495 92.8 1 Bacteria FCB group Pseudomonadati Candidatus Hydrogenedentota         Candidatus Hydrogenedentota bacterium
27861757 27861757 PRJNA1174770_P_NODE_10085_length_165_cov_0.896552_g9996_i0 PRJNA1174770 10085 165 0.896552 1.4793108 Prevotella intermedia 28131 Bacteria Bacteria 93.2 2.24e-20   NR WP_097550220.1 28131 g9996 i0 100 1.8 50 0 90.9 0 16 165 4031 4080 WP_097550220.1 LPD38 domain-containing protein [Prevotella intermedia] diamond 297 93.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella Prevotella intermedia
28177372 28177372 PRJNA1174770_P_NODE_7606_length_171_cov_1.704918_g7517_i0 PRJNA1174770 7606 171 1.704918 2.91540978 Porphyromonas sp. HMSC 1924944 Bacteria Bacteria 78.6 3.04e-15   NR WP_148130711.1 1739394 g7517 i0 86.4 0.771929824561403 44 6 77.2 0 40 171 1 44 WP_148130711.1 hypothetical protein [Porphyromonas sp. HMSC065F10] diamond 132 78.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas sp. HMSC065F10
28209026 28209026 PRJNA1174770_P_NODE_11986_length_162_cov_0.920354_g11897_i0 PRJNA1174770 11986 162 0.920354 1.49097348 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 80.1 3.61e-16   NR HEX3024296.1 1869212 g11897 i0 70.4 1 54 16 100 0 162 1 93 146 HEX3024296.1 substrate-binding domain-containing protein [Chitinophagaceae bacterium] diamond 162 80.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
29459421 29459421 PRJNA1174770_P_NODE_11130_length_163_cov_1.789474_g11041_i0 PRJNA1174770 11130 163 1.789474 2.91684262 Prevotellaceae 171552 Bacteria Bacteria 110 2.39e-26   NR WP_009752068.1 712469 g11041 i0 98.1 2.98159509202454 54 1 99.4 0 2 163 2 55 WP_009752068.1 DNA primase [Alloprevotella sp. oral taxon 473] diamond 486 111 0.990990990990991 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Alloprevotella Alloprevotella sp. oral taxon 473
29787726 29787726 PRJNA1174770_P_NODE_8391_length_168_cov_0.873950_g8302_i0 PRJNA1174770 8391 168 0.87395 1.468236 Apibacter adventoris 1679466 Bacteria Bacteria 89 4.79e-19   NR WP_105247188.1 1679466 g8302 i0 66.7 2.92857142857143 54 18 96.4 0 166 5 358 411 WP_105247188.1 mechanosensitive ion channel family protein [Apibacter adventoris] diamond 492 89 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Apibacter Apibacter adventoris
29945924 29945924 PRJNA1174770_P_NODE_8771_length_167_cov_0.881356_g8682_i0 PRJNA1174770 8771 167 0.881356 1.47186452 Hoylesella pleuritidis 407975 Bacteria Bacteria 117 6.8e-29   NR WP_024992004.1 407975 g8682 i0 100 0.988023952095808 55 0 98.8 0 3 167 232 286 WP_024992004.1 ABC transporter permease [Hoylesella pleuritidis] diamond 165 117 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Hoylesella Hoylesella pleuritidis
30103640 30103640 PRJNA1174770_P_NODE_12092_length_162_cov_0.920354_g12003_i0 PRJNA1174770 12092 162 0.920354 1.49097348 Cyclobacteriaceae bacterium 2099675 Bacteria Bacteria 111 1.9599999999999997e-30   NR MBY0434382.1 2099675 g12003 i0 100 1 54 0 100 0 162 1 25 78 MBY0434382.1 hypothetical protein [Cyclobacteriaceae bacterium] diamond 162 111 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cyclobacteriaceae   Cyclobacteriaceae bacterium
30344700 30344700 PRJNA1174770_P_NODE_10112_length_165_cov_0.896552_g10023_i0 PRJNA1174770 10112 165 0.896552 1.4793108 Alloprevotella 1283313 Bacteria Bacteria 102 5.33e-25   NR WP_009436353.1 712469 g10023 i0 92.6 1.96363636363636 54 4 98.2 0 163 2 30 83 WP_009436353.1 AMP nucleosidase [Alloprevotella sp. oral taxon 473] diamond 324 103 0.990291262135922 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Alloprevotella Alloprevotella sp. oral taxon 473
30660056 30660056 PRJNA1174770_P_NODE_5173_length_204_cov_1.316129_g5084_i0 PRJNA1174770 5173 204 1.316129 2.68490316 Bacteroidota 976 Bacteria Bacteria 96.3 2.9e-21   NR WP_160341687.1 238 g5084 i0 65.7 1.97058823529412 67 23 98.5 0 3 203 386 452 WP_160341687.1 ATP-dependent nuclease [Elizabethkingia meningoseptica] diamond 402 97.1 0.991761071060762 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Elizabethkingia Elizabethkingia meningoseptica
30830426 30830426 PRJNA1174770_P_NODE_8234_length_168_cov_0.873950_g8145_i0 PRJNA1174770 8234 168 0.87395 1.468236 Chryseobacterium sp. 1871047 Bacteria Bacteria 102 6.399999999999998e-25   NR WP_147756048.1 1871047 g8145 i0 89.1 0.982142857142857 55 6 98.2 0 166 2 79 133 WP_147756048.1 glycosyltransferase family 2 protein [Chryseobacterium sp.] diamond 165 102 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium sp.
30862056 30862056 PRJNA1174770_P_NODE_12174_length_162_cov_0.911504_g12085_i0 PRJNA1174770 12174 162 0.911504 1.47663648 Tannerella sp. oral taxon 8 2382127 Bacteria Bacteria 102 9.56e-25   NR PNE25233.1 712711 g12085 i0 96.2 0.981481481481482 53 2 98.1 0 161 3 187 239 PNE25233.1 hypothetical protein BHU16_02780 [Tannerella sp. oral taxon 808] diamond 159 102 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Tannerellaceae Tannerella Tannerella sp. oral taxon 808
31545223 31545223 PRJNA1174770_P_NODE_6576_length_183_cov_1.268657_g6487_i0 PRJNA1174770 6576 183 1.268657 2.32164231 Alloprevotella 1283313 Bacteria Bacteria 124 2.3099999999999997e-31   NR WP_009437284.1 712469 g6487 i0 98.3 1.9672131147541 60 1 98.4 0 3 182 1264 1323 WP_009437284.1 cell surface protein SprA [Alloprevotella sp. oral taxon 473] diamond 360 124 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Alloprevotella Alloprevotella sp. oral taxon 473
31652258 31652258 PRJNA1174770_P_NODE_7917_length_169_cov_0.866667_g7828_i0 PRJNA1174770 7917 169 0.866667 1.46466723 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 107 1.3800000000000002e-27   NR HRE39561.1 1869212 g7828 i0 96.4 0.976331360946746 55 2 97.6 0 3 167 125 179 HRE39561.1 TetR/AcrR family transcriptional regulator [Chitinophagaceae bacterium] diamond 165 107 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
31829589 31829589 PRJNA1174770_P_NODE_8817_length_167_cov_0.881356_g8728_i0 PRJNA1174770 8817 167 0.881356 1.47186452 Bacteria 2 Bacteria Bacteria 93.2 1.3100000000000002e-21   NR ODT01418.1 1660163 g8728 i0 94.4 7.76047904191617 54 3 97 0 1 162 175 228 ODT01418.1 MAG: hypothetical protein ABS52_16880 [Gemmatimonadetes bacterium SCN 70-22] diamond 1296 93.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadetes bacterium SCN 70-22
31892995 31892995 PRJNA1174770_P_NODE_10637_length_164_cov_0.904348_g10548_i0 PRJNA1174770 10637 164 0.904348 1.48313072 Flavisolibacter 398041 Bacteria Bacteria 99 1.97e-22   NR MEI9944377.1 1869212 g10548 i0 90.7 5.92682926829268 54 5 98.8 0 3 164 401 454 MEI9944377.1 DUF5916 domain-containing protein [Chitinophagaceae bacterium] diamond 972 100 0.99 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
31937000 31937000 PRJNA1174770_P_NODE_12597_length_156_cov_2.065421_g12508_i0 PRJNA1174770 12597 156 2.065421 3.22205676 Bacteroidota bacterium 1898104 Bacteria Bacteria 40.8 0.0219   NR MCH8276136.1 1898104 g12508 i0 34.1 0.788461538461538 41 27 78.8 0 27 149 2 42 MCH8276136.1 hypothetical protein [Bacteroidota bacterium] diamond 123 40.8 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
32032129 32032129 PRJNA1174770_P_NODE_8518_length_168_cov_0.865546_g8429_i0 PRJNA1174770 8518 168 0.865546 1.45411728 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 114 1.47e-28   NR HRE37978.1 1869212 g8429 i0 98.2 2.94642857142857 55 1 98.2 0 3 167 241 295 HRE37978.1 M20 family metallopeptidase [Chitinophagaceae bacterium] diamond 495 114 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae 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);;