RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA429937" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA429937 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
10629977 10629977 PRJNA429937_P_NODE_1649_length_2267_cov_27.888740_g986_i0 PRJNA429937 1649 2267 27.88874 632.2377358 Longimicrobium sp. 2029185 Bacteria Bacteria 416 3.29e-137   NR HST59186.1 2029185 g986 i0 83.2 0.660344067048963 244 41 32.3 0 1368 637 1 244 HST59186.1 HD domain-containing phosphohydrolase [Longimicrobium sp.] diamond 1497 416 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
10630520 10630520 PRJNA429937_P_NODE_39369_length_575_cov_3.016484_g24819_i0 PRJNA429937 39369 575 3.016484 17.344783 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 280 1.07e-89   NR MBX3146269.1 2448054 g24819 i0 87.3 4.74782608695652 150 19 78.3 0 510 61 16 165 MBX3146269.1 restriction endonuclease subunit S [Gemmatimonadales bacterium] diamond 2730 280 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
20828505 20828505 PRJNA429937_P_NODE_47377_length_517_cov_3.608607_g30727_i0 PRJNA429937 47377 517 3.608607 18.65649819 FCB group 1783270 Bacteria Bacteria 90.9 3.37e-19   NR MDX1622694.1 2026742 g30727 i0 51.8 2.04835589941973 83 35 45.3 1 94 327 67 149 MDX1622694.1 DNA polymerase ligase N-terminal domain-containing protein [Gemmatimonadota bacterium] diamond 1059 90.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
26886072 26886072 PRJNA429937_P_NODE_38121_length_585_cov_2.210432_g23936_i0 PRJNA429937 38121 585 2.210432 12.9310272 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 47.4 0.0066   NR NJD18519.1 2026742 g23936 i0 33.8 0.41025641025641 80 47 37.9 1 39 260 32 111 NJD18519.1 type II toxin-antitoxin system VapC family toxin [Gemmatimonadota bacterium] diamond 240 47.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27138525 27138525 PRJNA429937_P_NODE_29182_length_675_cov_4.654799_g17662_i0 PRJNA429937 29182 675 4.654799 31.41989325 Gemmatimonadetes bacterium 13_1_4 1805185 Bacteria Bacteria 77.4 1.63e-14   NR OLC85640.1 1805185 g17662 i0 54.2 0.32 72 28 29.8 2 484 284 1 72 OLC85640.1 MAG: hypothetical protein AUI86_11850 [Gemmatimonadetes bacterium 13_1_40CM_3_66_12] diamond 216 77.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadetes bacterium 13_1_40CM_3_66_12
27296953 27296953 PRJNA429937_P_NODE_111603_length_270_cov_2.775934_g88981_i0 PRJNA429937 111603 270 2.775934 7.4950218 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 47.8 8.75e-4   NR MEE8551477.1 2026742 g88981 i0 56.1 0.455555555555556 41 18 45.6 0 72 194 508 548 MEE8551477.1 hypothetical protein [Gemmatimonadota bacterium] diamond 123 47.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27408544 27408544 PRJNA429937_P_NODE_13903_length_983_cov_3.435010_g8214_i0 PRJNA429937 13903 983 3.43501 33.7661483 Bacteria 2 Bacteria Bacteria 117 5.61e-28   NR WP_331125014.1 2029185 g8214 i0 47.2 4.91047812817904 123 65 37.5 0 3 371 32 154 WP_331125014.1 MarR family transcriptional regulator [Longimicrobium sp.] diamond 4827 117 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
28481864 28481864 PRJNA429937_P_NODE_82826_length_357_cov_2.088415_g60346_i0 PRJNA429937 82826 357 2.088415 7.45564155 Pseudomonadati 3379134 Bacteria Bacteria 124 9.03e-32   NR HEX7122356.1 2026741 g60346 i0 70.8 1.26050420168067 72 21 60.5 0 125 340 251 322 HEX7122356.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 450 124 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28939024 28939024 PRJNA429937_P_NODE_150968_length_178_cov_3.328859_g128341_i0 PRJNA429937 150968 178 3.328859 5.92536902 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 44.7 0.00334   NR HEX7121836.1 2026741 g128341 i0 54.5 0.926966292134832 55 21 86 1 26 178 386 440 HEX7121836.1 ABC transporter permease [Gemmatimonadaceae bacterium] diamond 165 44.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29128588 29128588 PRJNA429937_P_NODE_120469_length_247_cov_2.788991_g97843_i0 PRJNA429937 120469 247 2.788991 6.88880777 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 50.4 7.5e-5   NR MEO8448602.1 2026742 g97843 i0 84.6 0.315789473684211 26 4 31.6 0 247 170 451 476 MEO8448602.1 amidohydrolase family protein [Gemmatimonadota bacterium] diamond 78 50.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30029168 30029168 PRJNA429937_P_NODE_60251_length_446_cov_3.124700_g8214_i6 PRJNA429937 60251 446 3.1247 13.936162 Bacteria 2 Bacteria Bacteria 116 5.05e-30   NR WP_331125014.1 2029185 g8214 i6 47.2 10.2040358744395 123 65 82.7 0 75 443 32 154 WP_331125014.1 MarR family transcriptional regulator [Longimicrobium sp.] diamond 4551 117 0.991452991452991 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
30233702 30233702 PRJNA429937_P_NODE_9812_length_1153_cov_5.402135_g5771_i0 PRJNA429937 9812 1153 5.402135 62.28661655 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 486 2.239999999999999e-168   NR HEX9727007.1 2448054 g5771 i0 75.5 4.15784908933218 319 78 83 0 23 979 76 394 HEX9727007.1 Fic family protein [Gemmatimonadales bacterium] diamond 4794 486 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30755820 30755820 PRJNA429937_P_NODE_62114_length_437_cov_3.017157_g8214_i7 PRJNA429937 62114 437 3.017157 13.18497609 Bacteria 2 Bacteria Bacteria 116 6.43e-30   NR WP_331125014.1 2029185 g8214 i7 47.2 10.9221967963387 123 65 84.4 0 66 434 32 154 WP_331125014.1 MarR family transcriptional regulator [Longimicrobium sp.] diamond 4773 116 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
32652571 32652571 PRJNA429937_P_NODE_62980_length_433_cov_3.096535_g8214_i8 PRJNA429937 62980 433 3.096535 13.40799655 Bacteria 2 Bacteria Bacteria 116 6.2000000000000005e-30   NR WP_331125014.1 2029185 g8214 i8 47.2 11.0230946882217 123 65 85.2 0 62 430 32 154 WP_331125014.1 MarR family transcriptional regulator [Longimicrobium sp.] diamond 4773 116 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
32699296 32699296 PRJNA429937_P_NODE_64440_length_426_cov_4.659950_g17662_i1 PRJNA429937 64440 426 4.65995 19.851387 Gemmatimonadetes bacterium 13_1_4 1805185 Bacteria Bacteria 75.5 1.05e-14   NR OLC85640.1 1805185 g17662 i1 54.9 0.5 71 27 46.5 2 235 38 1 71 OLC85640.1 MAG: hypothetical protein AUI86_11850 [Gemmatimonadetes bacterium 13_1_40CM_3_66_12] diamond 213 75.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadetes bacterium 13_1_40CM_3_66_12

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