RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA939369", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 10 ✖

tax_kingdom 1

  • Pseudomonadati · 10 ✖

bioproject 1

  • PRJNA939369 · 10 ✖

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
12393700 12393700 PRJNA939369_S_NODE_6290_length_499_cov_3.204225_g5873_i0 PRJNA939369 6290 499 3.204225 15.98908275 Desulfovibrio fairfieldensis 44742 Bacteria Bacteria 706 0   NTclustered gi|987453195|gb|CP014229.1| 44742 g5873 i0 92.354 342.563126252505 497 36 99 2 1 496 164981 165476 Desulfovibrio fairfieldensis strain CCUG 45958 chromosome, complete genome blastn 170939 706 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio fairfieldensis
17492462 17492462 PRJNA939369_S_NODE_10054_length_423_cov_2.582857_g9637_i0 PRJNA939369 10054 423 2.582857 10.92548511 Desulfovibrio fairfieldensis 44742 Bacteria Bacteria 573 7.029999999999997e-159   NTclustered gi|987453195|gb|CP014229.1| 44742 g9637 i0 91.429 436.754137115839 420 32 99 4 1 418 165110 165527 Desulfovibrio fairfieldensis strain CCUG 45958 chromosome, complete genome blastn 184747 573 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio fairfieldensis
27246223 27246223 PRJNA939369_S_NODE_32223_length_295_cov_0.801802_g31806_i0 PRJNA939369 32223 295 0.801802 2.3653159 uncultured Bilophila sp. 529385 Bacteria Bacteria 95.9 1.8199999999999994e-23   NR WP_308772421.1 529385 g31806 i0 70.3 1.30169491525424 64 19 65.1 0 3 194 29 92 WP_308772421.1 DUF3383 family protein, partial [uncultured Bilophila sp.] diamond 384 95.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Bilophila uncultured Bilophila sp.
28256612 28256612 PRJNA939369_S_NODE_70866_length_243_cov_1.358824_g70449_i0 PRJNA939369 70866 243 1.358824 3.30194232 Syntrophobacter sp. 66700 Bacteria Bacteria 69.7 3.82e-13   NR MEN6437025.1 66700 g70449 i0 63.3 0.604938271604938 49 18 60.5 0 95 241 1 49 MEN6437025.1 hypothetical protein [Syntrophobacter sp.] diamond 147 69.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Syntrophobacter Syntrophobacter sp.
28484831 28484831 PRJNA939369_S_NODE_76066_length_241_cov_0.916667_g75649_i0 PRJNA939369 76066 241 0.916667 2.20916747 Pseudomonadati 3379134 Bacteria Bacteria 45.8 0.00289   NR MBF0233920.1 2006184 g75649 i0 31.3 2.9253112033195 80 51 99.6 1 1 240 124 199 MBF0233920.1 phage portal protein [Desulfamplus sp.] diamond 705 45.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfamplus Desulfamplus sp.
29361895 29361895 PRJNA939369_S_NODE_14129_length_378_cov_0.977049_g13712_i0 PRJNA939369 14129 378 0.977049 3.69324522 Thermodesulfobacterium hydrogeniphilum 161156 Bacteria Bacteria 45.8 0.00489   NR WP_038057941.1 161156 g13712 i0 52.3 0.587301587301587 44 20 34.1 1 2 130 12 55 WP_038057941.1 transcriptional regulator NrdR [Thermodesulfobacterium hydrogeniphilum] diamond 222 45.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfobacteriaceae Thermodesulfobacterium Thermodesulfobacterium hydrogeniphilum
29551114 29551114 PRJNA939369_S_NODE_59090_length_249_cov_0.875000_g58673_i0 PRJNA939369 59090 249 0.875 2.17875 Desulfovibrio sp. ZJ2 885 Bacteria Bacteria 41.2 0.024   NR WP_165069969.1 2709792 g58673 i0 48.8 0.493975903614458 41 20 49.4 1 183 61 6 45 WP_165069969.1 hypothetical protein [Desulfovibrio sp. ZJ200] diamond 123 41.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. ZJ200
30032108 30032108 PRJNA939369_S_NODE_38831_length_279_cov_1.121359_g38414_i0 PRJNA939369 38831 279 1.121359 3.12859161 Desulfovibrio 872 Bacteria Bacteria 51.6 1.65e-5   NR MDR2077027.1 885 g38414 i0 45.7 1.44086021505376 46 25 49.5 0 142 279 5 50 MDR2077027.1 hypothetical protein [Desulfovibrio sp.] diamond 402 51.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
31320492 31320492 PRJNA939369_S_NODE_74175_length_242_cov_0.911243_g73758_i0 PRJNA939369 74175 242 0.911243 2.20520806 uncultured Desulfovibrio sp. 167968 Bacteria Bacteria 99.8 2.5600000000000003e-22   NR WP_288229577.1 167968 g73758 i0 57.5 2.93801652892562 80 34 99.2 0 1 240 317 396 WP_288229577.1 DUF3383 domain-containing protein [uncultured Desulfovibrio sp.] diamond 711 99.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
32111407 32111407 PRJNA939369_S_NODE_10998_length_411_cov_1.671598_g10581_i0 PRJNA939369 10998 411 1.671598 6.87026778 Syntrophorhabdaceae bacterium 2660714 Bacteria Bacteria 53.1 4.58e-5   NR MFA5617888.1 2660714 g10581 i0 36.5 0.54014598540146 74 47 54 0 355 134 133 206 MFA5617888.1 ParB/RepB/Spo0J family partition protein [Syntrophorhabdaceae bacterium] diamond 222 53.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophorhabdia Syntrophorhabdales Syntrophorhabdaceae   Syntrophorhabdaceae 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);;