RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA453111" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA453111 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
2992025 2992025 PRJNA453111_P_NODE_10683_length_249_cov_0.875000_g10591_i0 PRJNA453111 10683 249 0.875 2.17875 Terribium terrae 2725666 Bacteria Bacteria 460 3.16e-125   NTclustered gi|1752754875|gb|CP044218.1| 2725666 g10591 i0 100 64.6706827309237 249 0 100 0 1 249 3572184 3571936 Mesorhizobium terrae strain NIBRBAC000500504 chromosome, complete genome blastn 16103 460 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Terribium Terribium terrae
4268436 4268436 PRJNA453111_P_NODE_13024_length_241_cov_0.916667_g12932_i0 PRJNA453111 13024 241 0.916667 2.20916747 Bradyrhizobium sp. PSBB068 2715960 Bacteria Bacteria 446 8.519999999999999e-121   NTclustered gi|1979381481|gb|CP069300.1| 2715960 g12932 i0 100 42.7966804979253 241 0 100 0 1 241 4027655 4027415 Bradyrhizobium sp. PSBB068 chromosome, complete genome blastn 10314 446 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. PSBB068
5545095 5545095 PRJNA453111_P_NODE_10285_length_250_cov_0.870056_g10193_i0 PRJNA453111 10285 250 0.870056 2.17514 Bradyrhizobium sp. PSBB068 2715960 Bacteria Bacteria 462 8.83e-126   NTclustered gi|1979381481|gb|CP069300.1| 2715960 g10193 i0 100 97.756 250 0 100 0 1 250 5136916 5136667 Bradyrhizobium sp. PSBB068 chromosome, complete genome blastn 24439 462 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. PSBB068
9369277 9369277 PRJNA453111_P_NODE_12448_length_243_cov_0.905882_g12356_i0 PRJNA453111 12448 243 0.905882 2.20129326 Ralstonia insidiosa 190721 Bacteria Bacteria 449 6.65e-122   NTclustered gi|1036241154|gb|CP016023.1| 190721 g12356 i0 100 83.8600823045268 243 0 100 0 1 243 339164 338922 Ralstonia insidiosa strain ATCC 49129 chromosome 2, complete sequence blastn 20378 449 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Ralstonia Ralstonia insidiosa
11920257 11920257 PRJNA453111_P_NODE_9050_length_267_cov_1.190722_g8958_i0 PRJNA453111 9050 267 1.190722 3.17922774 Kosakonia arachidis 551989 Bacteria Bacteria 56.5 0.002   NTclustered gi|1769903668|gb|CP045299.1| 551989 g8958 i0 96.97 0.123595505617978 33 1 12 0 203 235 25488 25456 Kosakonia arachidis strain KACC 18508 plasmid unnamed1, complete sequence blastn 33 56.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Kosakonia Kosakonia arachidis
13194969 13194969 PRJNA453111_P_NODE_10151_length_251_cov_0.865169_g10059_i0 PRJNA453111 10151 251 0.865169 2.17157419 Methyloversatilis sp. RAC08 1842540 Bacteria Bacteria 414 2.52e-111   NTclustered gi|1059487190|gb|CP016448.1| 1842540 g10059 i0 96.414 224.486055776892 251 9 100 0 1 251 844965 844715 Methyloversatilis sp. RAC08 chromosome, complete genome blastn 56346 414 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Sterolibacteriaceae Methyloversatilis Methyloversatilis sp. RAC08
15120687 15120687 PRJNA453111_P_NODE_7952_length_287_cov_1.065421_g7860_i0 PRJNA453111 7952 287 1.065421 3.05775827 Comamonas 283 Bacteria Bacteria 486 6.139999999999999e-133   NTclustered gi|507148303|ref|NR_103106.1| 285 g7860 i0 97.213 420.620209059233 287 8 100 0 1 287 1145 1431 Comamonas testosteroni strain CNB-1 23S ribosomal RNA gene, complete sequence blastn 120718 486 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Comamonas Comamonas testosteroni
18293023 18293023 PRJNA453111_P_NODE_11675_length_246_cov_0.890173_g11583_i0 PRJNA453111 11675 246 0.890173 2.18982558 Mixta calida 665913 Bacteria Bacteria 52.8 0.022   NTclustered gi|1907656030|gb|CP061511.1| 665913 g11583 i0 100 0.227642276422764 28 0 11 0 14 41 3529897 3529870 Mixta calida strain 5098PV chromosome, complete genome blastn 56 52.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Erwiniaceae Mixta Mixta calida
23393647 23393647 PRJNA453111_P_NODE_4719_length_372_cov_1.190635_g4627_i0 PRJNA453111 4719 372 1.190635 4.4291622 Mesorhizobium loti 381 Bacteria Bacteria 54.7 0.01   NTclustered gi|1050758791|dbj|AP017605.1| 381 g4627 i0 96.875 0.161290322580645 32 1 9 0 154 185 2839721 2839752 Mesorhizobium loti DNA, nearly complete genome, strain: TONO blastn 60 54.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Mesorhizobium Mesorhizobium loti
24044772 24044772 PRJNA453111_P_NODE_9199_length_264_cov_1.905759_g9107_i0 PRJNA453111 9199 264 1.905759 5.03120376 Burkholderia 32008 Bacteria Bacteria 82.4 3.08e-11   NTclustered gi|2304481520|gb|CP104215.1| 28095 g9107 i0 94.34 35.9090909090909 53 3 20 0 17 69 1071718 1071666 Burkholderia gladioli strain ZN-S4 chromosome 2, complete sequence blastn 9480 82.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Burkholderia Burkholderia gladioli
24667579 24667579 PRJNA453111_P_NODE_12500_length_243_cov_0.905882_g12408_i0 PRJNA453111 12500 243 0.905882 2.20129326 Aquipseudomonas campi 2731681 Bacteria Bacteria 54.7 0.006   NTclustered gi|1876483579|gb|CP053697.2| 2731681 g12408 i0 96.875 0.131687242798354 32 1 13 0 38 69 2709033 2709002 Aquipseudomonas campi strain S1-A32-2 chromosome, complete genome blastn 32 54.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Aquipseudomonas Aquipseudomonas campi

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