RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA1264536" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1264536 · 8 ✖

analysis 1

  • diamond · 8 ✖

tax_clade 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
1638726 1638726 PRJNA1264536_P_NODE_2802_length_334_cov_1.191571_g2728_i0 PRJNA1264536 2802 334 1.191571 3.97984714 Salmonella sp. s51228 3159652 Bacteria Bacteria 152 1.1599999999999999e-43   NR WP_411022868.1 3159652 g2728 i0 67.6 13.6437125748503 108 35 97 0 334 11 53 160 WP_411022868.1 GTP-binding protein [Salmonella sp. s51228] diamond 4557 152 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella sp. s51228
1638777 1638777 PRJNA1264536_P_NODE_5262_length_244_cov_0.912281_g5188_i0 PRJNA1264536 5262 244 0.912281 2.22596564 Aquabacterium sp. 1872578 Bacteria Bacteria 159 1.7599999999999998e-46   NR HET6788839.1 1872578 g5188 i0 92.5 5.9016393442623 80 6 98.4 0 242 3 48 127 HET6788839.1 D-alanyl-D-alanine carboxypeptidase family protein [Aquabacterium sp.] diamond 1440 159 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales   Aquabacterium Aquabacterium sp.
20765493 20765493 PRJNA1264536_P_NODE_4877_length_248_cov_0.891429_g4803_i0 PRJNA1264536 4877 248 0.891429 2.21074392 Rhodospirillaceae bacterium 1898112 Bacteria Bacteria 126 8.99e-33   NR MEQ9448422.1 1898112 g4803 i0 77.9 2.86693548387097 77 17 93.1 0 231 1 144 220 MEQ9448422.1 acyl-CoA dehydrogenase family protein [Rhodospirillaceae bacterium] diamond 711 126 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Rhodospirillaceae   Rhodospirillaceae bacterium
27200104 27200104 PRJNA1264536_P_NODE_5502_length_242_cov_0.923077_g5428_i0 PRJNA1264536 5502 242 0.923077 2.23384634 Roseiarcus sp. 1969460 Bacteria Bacteria 55.5 1.22e-6   NR HTR12120.1 1969460 g5428 i0 71.8 0.483471074380165 39 11 48.3 0 125 241 260 298 HTR12120.1 PAS domain S-box protein [Roseiarcus sp.] diamond 117 55.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Roseiarcaceae Roseiarcus Roseiarcus sp.
28684713 28684713 PRJNA1264536_P_NODE_5547_length_242_cov_0.923077_g5473_i0 PRJNA1264536 5547 242 0.923077 2.23384634 Pseudomonadota bacterium 1977087 Bacteria Bacteria 122 5.86e-34   NR MDE3016639.1 1977087 g5473 i0 68.4 0.979338842975207 79 25 97.9 0 3 239 32 110 MDE3016639.1 hypothetical protein [Pseudomonadota bacterium] diamond 237 122 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
28860087 28860087 PRJNA1264536_P_NODE_4788_length_249_cov_0.886364_g4714_i0 PRJNA1264536 4788 249 0.886364 2.20704636 Alphaproteobacteria 28211 Bacteria Bacteria 115 1.42e-30   NR MEA3070562.1 1913988 g4714 i0 76.9 9.39759036144578 78 18 94 0 6 239 20 97 MEA3070562.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 2340 115 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
31622450 31622450 PRJNA1264536_P_NODE_5516_length_242_cov_0.923077_g5442_i0 PRJNA1264536 5516 242 0.923077 2.23384634 Escherichia coli 562 Bacteria Bacteria 87.8 4.17e-18   NR WP_286497621.1 562 g5442 i0 73.2 0.694214876033058 56 15 69.4 0 168 1 78 133 WP_286497621.1 DDE-type integrase/transposase/recombinase [Escherichia coli] diamond 168 87.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32350378 32350378 PRJNA1264536_P_NODE_5199_length_245_cov_0.906977_g5125_i0 PRJNA1264536 5199 245 0.906977 2.22209365 Betaproteobacteria bacterium 1891241 Bacteria Bacteria 159 7.29e-48   NR MBU6304130.1 1891241 g5125 i0 93.8 0.991836734693878 81 5 99.2 0 245 3 18 98 MBU6304130.1 VOC family protein [Betaproteobacteria bacterium] diamond 243 159 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria       Betaproteobacteria 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);;