RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1054617" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1054617 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
23963686 23963686 PRJNA1054617_S_NODE_14859_length_155_cov_2.803571_g14771_i0 PRJNA1054617 14859 155 2.803571 4.34553505 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 74.3 5.32e-14   NR HNF29012.1 1869212 g14771 i0 66.7 0.987096774193548 51 17 98.7 0 154 2 208 258 HNF29012.1 NADH-quinone oxidoreductase subunit M [Chitinophagaceae bacterium] diamond 153 74.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
26718376 26718376 PRJNA1054617_S_NODE_13121_length_163_cov_1.916667_g13033_i0 PRJNA1054617 13121 163 1.916667 3.12416721 unclassified Sphingobacterium 2609468 Bacteria Bacteria 97.8 1.69e-24   NR WP_293916373.1 2609468 g13033 i0 95.5 0.809815950920245 44 2 81 0 162 31 89 132 WP_293916373.1 MULTISPECIES: hypothetical protein [unclassified Sphingobacterium] diamond 132 97.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Sphingobacterium  
27035288 27035288 PRJNA1054617_S_NODE_2002_length_347_cov_1.592105_g1914_i0 PRJNA1054617 2002 347 1.592105 5.52460435 Flavobacterium sp. UBA768 239 Bacteria Bacteria 195 3.82e-59   NR WP_291149481.1 1946559 g1914 i0 86.1 0.994236311239193 115 16 99.4 0 2 346 14 128 WP_291149481.1 helix-turn-helix domain-containing protein [Flavobacterium sp. UBA7680] diamond 345 195 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. UBA7680
27446414 27446414 PRJNA1054617_S_NODE_8583_length_195_cov_2.565789_g8495_i0 PRJNA1054617 8583 195 2.565789 5.00328855 Bacteroidota 976 Bacteria Bacteria 127 1.3899999999999998e-32   NR WP_095166073.1 976 g8495 i0 100 1 65 0 100 0 1 195 179 243 WP_095166073.1 MULTISPECIES: replicative DNA helicase [Bacteroidota] diamond 195 127 1 Bacteria FCB group Pseudomonadati Bacteroidota          
27699106 27699106 PRJNA1054617_S_NODE_13784_length_160_cov_1.179487_g13696_i0 PRJNA1054617 13784 160 1.179487 1.8871792 Bacteroidota bacterium 1898104 Bacteria Bacteria 45.8 9.92e-4   NR MBS1910472.1 1898104 g13696 i0 43.9 0.76875 41 23 76.9 0 38 160 272 312 MBS1910472.1 T9SS type A sorting domain-containing protein [Bacteroidota bacterium] diamond 123 45.8 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28258810 28258810 PRJNA1054617_S_NODE_8626_length_195_cov_1.210526_g8538_i0 PRJNA1054617 8626 195 1.210526 2.3605257 FCB group 1783270 Bacteria Bacteria 135 1.51e-36   NR MCA6362425.1 1898104 g8538 i0 95.4 10 65 3 100 0 1 195 167 231 MCA6362425.1 site-specific DNA-methyltransferase [Bacteroidota bacterium] diamond 1950 135 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28740703 28740703 PRJNA1054617_S_NODE_4747_length_248_cov_1.570732_g4659_i0 PRJNA1054617 4747 248 1.570732 3.89541536 Flavobacterium sp. 239 Bacteria Bacteria 151 4.939999999999999e-42   NR HRB72757.1 239 g4659 i0 100 1.98387096774194 82 0 99.2 0 248 3 192 273 HRB72757.1 oligosaccharide flippase family protein [Flavobacterium sp.] diamond 492 151 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
29079965 29079965 PRJNA1054617_S_NODE_11428_length_173_cov_3.184615_g11340_i0 PRJNA1054617 11428 173 3.184615 5.50938395 Bacteroidota 976 Bacteria Bacteria 93.2 2.45e-20   NR WP_052188211.1 1249972 g11340 i0 80.4 5.51445086705202 51 10 88.4 0 155 3 2039 2089 WP_052188211.1 FG-GAP-like repeat-containing protein [Cellulophaga sp. Hel_I_12] diamond 954 94 0.991489361702128 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. Hel_I_12
29245885 29245885 PRJNA1054617_S_NODE_14469_length_157_cov_1.210526_g14381_i0 PRJNA1054617 14469 157 1.210526 1.90052582 Flavobacterium sp. 239 Bacteria Bacteria 106 1.49e-26   NR WP_300492097.1 239 g14381 i0 100 0.993630573248408 52 0 99.4 0 1 156 25 76 WP_300492097.1 LytR/AlgR family response regulator transcription factor [Flavobacterium sp.] diamond 156 106 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
30785492 30785492 PRJNA1054617_S_NODE_6934_length_213_cov_1.864706_g6846_i0 PRJNA1054617 6934 213 1.864706 3.97182378 Bacteria 2 Bacteria Bacteria 108 2.9300000000000003e-26   NR OQX76388.1 1970779 g6846 i0 77.1 7.88732394366197 70 16 98.6 0 212 3 242 311 OQX76388.1 MAG: hypothetical protein B6D64_09980 [Bacteroidetes bacterium 4484_276] diamond 1680 108 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidetes bacterium 4484_276
31394303 31394303 PRJNA1054617_S_NODE_5076_length_241_cov_3.484848_g4988_i0 PRJNA1054617 5076 241 3.484848 8.39848368 Flavobacterium daemonense 1393049 Bacteria Bacteria 147 4.93e-43   NR WP_144336565.1 1393049 g4988 i0 89.9 2.97510373443983 79 8 98.3 0 5 241 25 103 WP_144336565.1 hypothetical protein [Flavobacterium daemonense] diamond 717 147 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium daemonense
31892107 31892107 PRJNA1054617_S_NODE_5277_length_238_cov_1.123077_g5189_i0 PRJNA1054617 5277 238 1.123077 2.67292326 Algoriphagus 246875 Bacteria Bacteria 127 4.31e-34   NR WP_373397230.1 226505 g5189 i0 86.1 3.98319327731092 79 11 99.6 0 2 238 42 120 WP_373397230.1 hypothetical protein [Algoriphagus halophilus] diamond 948 127 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cyclobacteriaceae Algoriphagus Algoriphagus halophilus
32658877 32658877 PRJNA1054617_S_NODE_11920_length_170_cov_1.448819_g11832_i0 PRJNA1054617 11920 170 1.448819 2.4629923 Flavobacterium sp. UBA768 239 Bacteria Bacteria 99 5.909999999999999e-23   NR WP_291149481.1 1946559 g11832 i0 78.6 0.988235294117647 56 12 98.8 0 3 170 252 307 WP_291149481.1 helix-turn-helix domain-containing protein [Flavobacterium sp. UBA7680] diamond 168 99 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. UBA7680

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);;