RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA1199893" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1199893 · 13 ✖

analysis 1

  • blastn · 13 ✖

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
1601437 1601437 PRJNA1199893_P_NODE_16642_length_243_cov_1.788235_g16567_i0 PRJNA1199893 16642 243 1.788235 4.34541105 uncultured Pseudomonadota bacterium 153809 Bacteria Bacteria 438 1.4399999999999996e-118   NTclustered gi|110754529|gb|DQ829216.1| 153809 g16567 i0 99.177 99.0411522633745 243 2 100 0 1 243 270 28 Uncultured proteobacterium clone DOK_NOFERT_clone243 16S ribosomal RNA gene, partial sequence blastn 24067 438 1 Bacteria   Pseudomonadati Pseudomonadota         uncultured Pseudomonadota bacterium
7980274 7980274 PRJNA1199893_P_NODE_2947_length_559_cov_2.843621_g2874_i0 PRJNA1199893 2947 559 2.843621 15.89584139 Halopseudomonas phragmitis 1931241 Bacteria Bacteria 815 0   NTclustered gi|1162906871|gb|CP020100.1| 1931241 g2874 i0 93.19 381.270125223614 558 33 99 5 1 555 377086 376531 Halopseudomonas phragmitis strain S-6-2 chromosome, complete genome blastn 213130 815 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Halopseudomonas Halopseudomonas phragmitis
8697590 8697590 PRJNA1199893_P_NODE_16887_length_243_cov_0.905882_g16812_i0 PRJNA1199893 16887 243 0.905882 2.20129326 Vibrio 662 Bacteria Bacteria 444 3.09e-120   NTclustered gi|1858855023|gb|CP053808.1| 666 g16812 i0 99.588 847.80658436214 243 1 100 0 1 243 2575352 2575110 Vibrio cholerae strain SP7G chromosome 1, complete sequence blastn 206017 444 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio cholerae
10530497 10530497 PRJNA1199893_P_NODE_14089_length_251_cov_1.387640_g14014_i0 PRJNA1199893 14089 251 1.38764 3.4829764 Vibrio metoecus 1481663 Bacteria Bacteria 453 5.34e-123   NTclustered gi|2556688018|gb|CP129421.1| 1481663 g14014 i0 99.203 4 251 2 100 0 1 251 1674412 1674162 Vibrio metoecus strain ZF102 chromosome 1, complete sequence blastn 1004 453 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio metoecus
11247929 11247929 PRJNA1199893_P_NODE_11869_length_278_cov_1.292683_g11794_i0 PRJNA1199893 11869 278 1.292683 3.59365874 Aeromonas 642 Bacteria Bacteria 508 1.26e-139   NTclustered gi|2812549515|emb|OY731314.1| 650 g11794 i0 99.64 100.320143884892 278 1 100 0 1 278 725302 725025 Aeromonas jandaei isolate KMC7K genome assembly, chromosome: 1 blastn 27889 508 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas Aeromonas jandaei
12523374 12523374 PRJNA1199893_P_NODE_6030_length_391_cov_2.314465_g5956_i0 PRJNA1199893 6030 391 2.314465 9.04955815 Pseudomonas 286 Bacteria Bacteria 712 0   NTclustered gi|2323004093|gb|CP109603.1| 303 g5956 i0 99.742 615.726342710997 388 1 100 0 1 388 4241 4628 Pseudomonas putida strain SEH01 chromosome, complete genome blastn 240749 712 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas putida
13798035 13798035 PRJNA1199893_P_NODE_7391_length_353_cov_1.650000_g7316_i0 PRJNA1199893 7391 353 1.65 5.8245 Vibrio 662 Bacteria Bacteria 647 0   NTclustered gi|2556688018|gb|CP129421.1| 1481663 g7316 i0 99.717 100.512747875354 353 1 100 0 1 353 2811450 2811098 Vibrio metoecus strain ZF102 chromosome 1, complete sequence blastn 35481 647 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio metoecus
15629527 15629527 PRJNA1199893_P_NODE_14333_length_250_cov_2.632768_g14258_i0 PRJNA1199893 14333 250 2.632768 6.58192 Vibrio metoecus 1481663 Bacteria Bacteria 451 1.91e-122   NTclustered gi|2556688018|gb|CP129421.1| 1481663 g14258 i0 99.2 883.308 250 2 100 0 1 250 146203 145954 Vibrio metoecus strain ZF102 chromosome 1, complete sequence blastn 220827 451 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio metoecus
16904009 16904009 PRJNA1199893_P_NODE_7074_length_361_cov_2.243056_g7000_i0 PRJNA1199893 7074 361 2.243056 8.09743216 Acinetobacter baumannii 470 Bacteria Bacteria 390 6.38e-104   NTclustered gi|1638218938|gb|CP040047.1| 470 g7000 i0 86.798 569.01108033241 356 20 100 15 27 361 3293293 3292944 Acinetobacter baumannii strain VB1190 chromosome, complete genome blastn 205413 390 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
17622386 17622386 PRJNA1199893_P_NODE_15654_length_246_cov_2.000000_g15579_i0 PRJNA1199893 15654 246 2 4.92 Psychrobacter 497 Bacteria Bacteria 455 1.4500000000000002e-123   NTclustered gi|307335075|gb|HM236417.1| 180588 g15579 i0 100 370.792682926829 246 0 100 0 1 246 1457 1702 Psychrobacter faecalis strain DSM 14664 23S ribosomal RNA gene, partial sequence blastn 91215 455 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Psychrobacter Psychrobacter faecalis
20170893 20170893 PRJNA1199893_P_NODE_13716_length_255_cov_2.274725_g13641_i0 PRJNA1199893 13716 255 2.274725 5.80054875 Moraxellaceae 468 Bacteria Bacteria 466 6.98e-127   NTclustered gi|1985959268|gb|CP069437.1| 34062 g13641 i0 99.608 346.796078431373 255 1 100 0 1 255 1497693 1497439 Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome blastn 88433 466 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Faucicola Faucicola osloensis
21446560 21446560 PRJNA1199893_P_NODE_17677_length_237_cov_2.250000_g17602_i0 PRJNA1199893 17677 237 2.25 5.3325 Acinetobacter 469 Bacteria Bacteria 438 1.4e-118   NTclustered gi|1751391443|gb|CP019143.2| 28090 g17602 i0 100 688.008438818565 237 0 100 0 1 237 28415 28179 Acinetobacter lwoffii strain ZS207 chromosome, complete genome blastn 163058 438 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter lwoffii
25270843 25270843 PRJNA1199893_P_NODE_13760_length_255_cov_1.252747_g13685_i0 PRJNA1199893 13760 255 1.252747 3.19450485 Acinetobacter 469 Bacteria Bacteria 472 1.5e-128   NTclustered gi|1993985272|gb|CP070518.1| 471 g13685 i0 100 604.094117647059 255 0 100 0 1 255 1258022 1257768 Acinetobacter calcoaceticus strain FDAARGOS_1218 chromosome, complete genome blastn 154044 472 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter calcoaceticus

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