RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1180292" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1180292 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1592493 1592493 PRJNA1180292_P_NODE_11642_length_245_cov_0.906977_g11510_i0 PRJNA1180292 11642 245 0.906977 2.22209365 Desulfocurvibacter africanus 873 Bacteria Bacteria 165 2.72e-36   NTclustered gi|367460290|gb|CP003221.1| 690850 g11510 i0 89.552 59.9836734693878 134 8 54 6 113 245 252042 251914 Desulfocurvibacter africanus subsp. africanus str. Walvis Bay chromosome, complete genome blastn 14696 165 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfocurvibacter Desulfocurvibacter africanus
3591734 3591734 PRJNA1180292_P_NODE_9443_length_250_cov_0.881356_g9311_i0 PRJNA1180292 9443 250 0.881356 2.20339 Pseudomonadati 3379134 Bacteria Bacteria 58.4 4.87e-4   NTclustered gi|308270651|emb|FR695865.1| 201089 g9311 i0 100 0.484 31 0 12 0 187 217 25600 25630 Uncultured Desulfobacterium sp. genomic DNA, clone contig03913 blastn 121 58.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteriaceae Desulfobacterium uncultured Desulfobacterium sp.
4144759 4144759 PRJNA1180292_P_NODE_13024_length_242_cov_0.923077_g12892_i0 PRJNA1180292 13024 242 0.923077 2.23384634 uncultured Desulfobacterium sp. 201089 Bacteria Bacteria 84.2 7.73e-12   NTclustered gi|308271113|emb|FR695867.1| 201089 g12892 i0 90.769 7.50826446280992 65 3 26 2 20 82 107449 107386 Uncultured Desulfobacterium sp. genomic DNA, clone Sel041c11.q1c blastn 1817 84.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteriaceae Desulfobacterium uncultured Desulfobacterium sp.
6695816 6695816 PRJNA1180292_P_NODE_9426_length_250_cov_0.881356_g9294_i0 PRJNA1180292 9426 250 0.881356 2.20339 Desulfosudis oleivorans 181663 Bacteria Bacteria 198 2.75e-46   NTclustered gi|158508843|gb|CP000859.1| 96561 g9294 i0 81.405 12.624 242 45 97 0 9 250 3399726 3399485 Desulfococcus oleovorans Hxd3, complete genome blastn 3156 198 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosudaceae Desulfosudis Desulfosudis oleivorans
16894929 16894929 PRJNA1180292_P_NODE_11954_length_244_cov_0.912281_g11822_i0 PRJNA1180292 11954 244 0.912281 2.22596564 Desulfobacterales bacterium 2044940 Bacteria Bacteria 241 4.38e-59   NTclustered gi|2107961690|gb|CP070789.1| 2044940 g11822 i0 84.49 2.00409836065574 245 37 100 1 1 244 3359920 3359676 MAG: Desulfobacterales bacterium isolate bin1454 chromosome blastn 489 241 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
21994610 21994610 PRJNA1180292_P_NODE_9878_length_249_cov_0.886364_g9746_i0 PRJNA1180292 9878 249 0.886364 2.20704636 Desulfovibrio aminophilus 81425 Bacteria Bacteria 254 5.76e-63   NTclustered gi|2908463109|gb|CP168306.1| 81425 g9746 i0 89.552 65.1807228915663 201 19 80 2 50 249 1635892 1635693 MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome blastn 16230 254 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio aminophilus
24543906 24543906 PRJNA1180292_P_NODE_9260_length_250_cov_0.881356_g9128_i0 PRJNA1180292 9260 250 0.881356 2.20339 Geotalea uraniireducens 351604 Bacteria Bacteria 267 7.43e-67   NTclustered gi|146395585|gb|CP000698.1| 351605 g9128 i0 87.179 4.776 234 30 94 0 1 234 3073844 3073611 Geobacter uraniireducens Rf4, complete genome blastn 1194 267 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geotalea Geotalea uraniireducens

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