RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1175041" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1175041 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
21993920 21993920 PRJNA1175041_P_NODE_78038_length_300_cov_1.202643_g75170_i0 PRJNA1175041 78038 300 1.202643 3.607929 Geopseudomonas aromaticivorans 2849492 Bacteria Bacteria 171 9.6e-52   NR WP_217682444.1 2849492 g75170 i0 94.6 0.92 92 5 92 0 280 5 105 196 WP_217682444.1 hypothetical protein [Geopseudomonas aromaticivorans] diamond 276 171 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Geopseudomonas Geopseudomonas aromaticivorans
27956666 27956666 PRJNA1175041_P_NODE_91945_length_260_cov_2.213904_g89077_i0 PRJNA1175041 91945 260 2.213904 5.7561504 Oceanicella sp. SM1341 1548889 Bacteria Bacteria 43.9 0.0182   NR WP_118138491.1 1548889 g89077 i0 38.6 0.807692307692308 70 32 78.5 3 6 209 606 666 WP_118138491.1 cytochrome c oxidase subunit I [Oceanicella sp. SM1341] diamond 210 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Oceanicella Oceanicella sp. SM1341
31367999 31367999 PRJNA1175041_P_NODE_70896_length_325_cov_1.250000_g68028_i0 PRJNA1175041 70896 325 1.25 4.0625 Escherichia coli 562 Bacteria Bacteria 87.8 1.63e-19   NR HAI4532814.1 562 g68028 i0 71.6 3.23076923076923 74 21 68.3 0 325 104 69 142 HAI4532814.1 hypothetical protein [Escherichia coli] diamond 1050 87.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
31589377 31589377 PRJNA1175041_P_NODE_92596_length_259_cov_1.091398_g89728_i0 PRJNA1175041 92596 259 1.091398 2.82672082 Stenotrophomonas sp. ZAC14A_NAIMI4_1 2072412 Bacteria Bacteria 42.7 0.0444   NR WP_159095046.1 2072412 g89728 i0 46.2 0.602316602316602 52 26 57.9 1 212 63 13 64 WP_159095046.1 hypothetical protein [Stenotrophomonas sp. ZAC14A_NAIMI4_1] diamond 156 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Stenotrophomonas Stenotrophomonas sp. ZAC14A_NAIMI4_1
32285540 32285540 PRJNA1175041_P_NODE_85659_length_278_cov_0.887805_g82791_i0 PRJNA1175041 85659 278 0.887805 2.4680979 uncultured Massilia sp. 169973 Bacteria Bacteria 43.1 0.00992   NR WP_296952003.1 169973 g82791 i0 50 0.517985611510791 48 23 50.7 1 21 161 10 57 WP_296952003.1 hypothetical protein [uncultured Massilia sp.] diamond 144 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Massilia uncultured Massilia sp.
32884693 32884693 PRJNA1175041_P_NODE_94120_length_255_cov_1.049451_g91252_i0 PRJNA1175041 94120 255 1.049451 2.67610005 Trabulsiella odontotermitis 379893 Bacteria Bacteria 46.2 0.00254   NR WP_080993459.1 379893 g91252 i0 30.9 2.85882352941176 81 52 90.6 2 254 24 343 423 WP_080993459.1 type VI secretion system tip protein VgrG [Trabulsiella odontotermitis] diamond 729 46.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Trabulsiella Trabulsiella odontotermitis

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