RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA473824" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA473824 · 10 ✖

analysis 1

  • blastn · 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
4273942 4273942 PRJNA473824_P_NODE_39544_length_193_cov_2.711538_g38906_i0 PRJNA473824 39544 193 2.711538 5.23326834 Desulfobacter sp. 2294 Bacteria Bacteria 75 3.55e-9   NTclustered gi|2447547639|gb|CP054838.1| 2294 g38906 i0 87.5 0.33160621761658 64 8 33 0 107 170 946969 947032 MAG: Desulfobacter sp. isolate Buss2-1 chromosome, complete genome blastn 64 75 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacter Desulfobacter sp.
8099626 8099626 PRJNA473824_P_NODE_164127_length_150_cov_5.053097_g163489_i0 PRJNA473824 164127 150 5.053097 7.5796455 Desulfomicrobium orale 132132 Bacteria Bacteria 141 2.53e-29   NTclustered gi|987456218|gb|CP014230.1| 888061 g163489 i0 100 1.01333333333333 76 0 100 0 1 76 113790 113865 Desulfomicrobium orale DSM 12838 chromosome, complete genome blastn 152 141 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium orale
13200791 13200791 PRJNA473824_P_NODE_60171_length_173_cov_4.830882_g59533_i0 PRJNA473824 60171 173 4.830882 8.35742586 Desulfomicrobium orale 132132 Bacteria Bacteria 237 3.74e-58   NTclustered gi|987456218|gb|CP014230.1| 888061 g59533 i0 87.356 2.7514450867052 174 21 100 1 1 173 773098 772925 Desulfomicrobium orale DSM 12838 chromosome, complete genome blastn 476 237 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium orale
13850064 13850064 PRJNA473824_P_NODE_29891_length_218_cov_1.287293_g29253_i0 PRJNA473824 29891 218 1.287293 2.80629874 Geotalea 2910589 Bacteria Bacteria 130 8.650000000000001e-26   NTclustered gi|221562406|gb|CP001390.1| 316067 g29253 i0 79.899 29.7660550458716 199 23 86 13 1 188 2115156 2115348 Geobacter daltonii FRC-32, complete genome blastn 6489 130 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geotalea Geotalea daltonii
15749452 15749452 PRJNA473824_P_NODE_29373_length_219_cov_4.500000_g28735_i0 PRJNA473824 29373 219 4.5 9.855 Desulfarculus baarsii 453230 Bacteria Bacteria 71.3 5.35e-8   NTclustered gi|301638057|gb|CP002085.1| 644282 g28735 i0 90.741 0.246575342465753 54 3 24 2 101 153 1890644 1890592 Desulfarculus baarsii DSM 2075, complete genome blastn 54 71.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfarculia Desulfarculales Desulfarculaceae Desulfarculus Desulfarculus baarsii
17024064 17024064 PRJNA473824_P_NODE_27014_length_228_cov_3.952880_g26376_i0 PRJNA473824 27014 228 3.95288 9.0125664 Oceanidesulfovibrio marinus 370038 Bacteria Bacteria 52.8 0.02   NTclustered gi|1841667704|gb|CP039543.1| 370038 g26376 i0 100 0.12280701754386 28 0 12 0 184 211 3134592 3134565 Oceanidesulfovibrio marinus strain CS1 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Oceanidesulfovibrio Oceanidesulfovibrio marinus
20847689 20847689 PRJNA473824_P_NODE_103617_length_173_cov_2.698529_g102979_i0 PRJNA473824 103617 173 2.698529 4.66845517 Geobacter sp. SVR 2495594 Bacteria Bacteria 91.6 3.08e-14   NTclustered gi|1976315905|dbj|AP024469.1| 2495594 g102979 i0 90 10.1965317919075 70 7 40 0 1 70 3156244 3156175 Geobacter sp. SVR DNA, complete genome blastn 1764 91.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp. SVR
20847765 20847765 PRJNA473824_P_NODE_114517_length_173_cov_2.301471_g113879_i0 PRJNA473824 114517 173 2.301471 3.98154483 Maridesulfovibrio sp. 2795000 Bacteria Bacteria 108 3.06e-19   NTclustered gi|2621785158|emb|OY781616.1| 2795000 g113879 i0 92.105 8.82658959537572 76 6 44 0 98 173 228032 228107 MAG: Maridesulfovibrio sp. isolate 7570950b-8a73-422e-b528-09704edcd613 genome assembly, chromosome: 1 blastn 1527 108 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Maridesulfovibrio Maridesulfovibrio sp.
23398388 23398388 PRJNA473824_P_NODE_113879_length_173_cov_2.360294_g113241_i0 PRJNA473824 113879 173 2.360294 4.08330862 Desulfomicrobium orale 132132 Bacteria Bacteria 65.8 1.87e-6   NTclustered gi|987456218|gb|CP014230.1| 888061 g113241 i0 95.122 0.445086705202312 41 2 24 0 21 61 2425695 2425735 Desulfomicrobium orale DSM 12838 chromosome, complete genome blastn 77 65.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium orale
23398642 23398642 PRJNA473824_P_NODE_141999_length_151_cov_5.035088_g141361_i0 PRJNA473824 141999 151 5.035088 7.60298288 Desulfoluna limicola 2810562 Bacteria Bacteria 54.7 0.003   NTclustered gi|2158810072|dbj|AP024488.1| 2810562 g141361 i0 100 0.19205298013245 29 0 19 0 30 58 4567007 4566979 Desulfoluna sp. ASN36 ASN36 DNA, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfolunaceae Desulfoluna Desulfoluna limicola

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