RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA1035005" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1035005 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
1443846 1443846 PRJNA1035005_P_NODE_7962_length_392_cov_1.075235_g7560_i0 PRJNA1035005 7962 392 1.075235 4.2149212 Salidesulfovibrio onnuriiensis 2583823 Bacteria Bacteria 359 1.97e-94   NTclustered gi|1725298512|gb|CP040751.1| 2583823 g7560 i0 83.896 237.09693877551 385 52 97 9 10 388 346443 346823 Salidesulfovibrio onnuriiensis strain IOR2 chromosome, complete genome blastn 92942 359 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Salidesulfovibrio Salidesulfovibrio onnuriiensis
3995532 3995532 PRJNA1035005_P_NODE_62084_length_250_cov_0.881356_g61678_i0 PRJNA1035005 62084 250 0.881356 2.20339 Fundidesulfovibrio soli 2922716 Bacteria Bacteria 462 8.83e-126   NTclustered gi|2200496721|gb|OM850369.1| 2922716 g61678 i0 100 100.204 250 0 100 0 1 250 609 360 Fundidesulfovibrio sp. strain SG60 16S ribosomal RNA gene, partial sequence blastn 25051 462 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Fundidesulfovibrio Fundidesulfovibrio soli
10372200 10372200 PRJNA1035005_P_NODE_59049_length_251_cov_0.876404_g58643_i0 PRJNA1035005 59049 251 0.876404 2.19977404 Desulfovibrio fairfieldensis 44742 Bacteria Bacteria 451 1.92e-122   NTclustered gi|987453195|gb|CP014229.1| 44742 g58643 i0 99.2 7.41434262948207 250 2 99 0 1 250 2742994 2742745 Desulfovibrio fairfieldensis strain CCUG 45958 chromosome, complete genome blastn 1861 451 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio fairfieldensis
10372423 10372423 PRJNA1035005_P_NODE_8689_length_380_cov_2.055375_g8287_i0 PRJNA1035005 8689 380 2.055375 7.810425 Candidatus Electrothrix aestuarii 3062594 Bacteria Bacteria 56.5 0.003   NTclustered gi|2755823080|gb|CP159373.1| 3062594 g8287 i0 97.059 0.0894736842105263 34 0 9 1 339 372 874381 874413 MAG: Candidatus Electrothrix aestuarii isolate Rat1 chromosome, complete genome blastn 34 56.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix aestuarii
12922763 12922763 PRJNA1035005_P_NODE_67131_length_248_cov_1.337143_g66725_i0 PRJNA1035005 67131 248 1.337143 3.31611464 Desulfovibrio desulfuricans 876 Bacteria Bacteria 459 1.13e-124   NTclustered gi|2884834435|gb|CP176628.1| 876 g66725 i0 100 106.052419354839 248 0 100 0 1 248 3994 4241 Desulfovibrio desulfuricans strain SFAD67 chromosome, complete genome blastn 26301 459 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
18020927 18020927 PRJNA1035005_P_NODE_67355_length_248_cov_0.891429_g66949_i0 PRJNA1035005 67355 248 0.891429 2.21074392 Thermodesulfomicrobium sp. WS 3004129 Bacteria Bacteria 342 1.1899999999999999e-89   NTclustered gi|2416254156|dbj|AP027130.1| 3004129 g66949 i0 91.532 4.37096774193548 248 21 100 0 1 248 838831 839078 Thermodesulfomicrobium sp. WS DNA, complete genome blastn 1084 342 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Thermodesulfomicrobium Thermodesulfomicrobium sp. WS
21409747 21409747 PRJNA1035005_P_NODE_10097_length_363_cov_1.558621_g9692_i0 PRJNA1035005 10097 363 1.558621 5.65779423 Desulfocurvibacter 2582840 Bacteria Bacteria 390 6.42e-104   NTclustered gi|470489697|ref|NR_076945.1| 873 g9692 i0 86.686 164.787878787879 353 45 97 2 12 363 380 29 Desulfovibrio africanus strain Walvis Bay 23S ribosomal RNA gene, complete sequence blastn 59818 390 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfocurvibacter Desulfocurvibacter africanus
24395286 24395286 PRJNA1035005_P_NODE_9880_length_366_cov_0.989761_g9475_i0 PRJNA1035005 9880 366 0.989761 3.62252526 Desulfolutivibrio sulfodismutans 63561 Bacteria Bacteria 475 1.74e-129   NTclustered gi|1863422180|gb|CP045504.1| 1121464 g9475 i0 90.244 380.827868852459 369 29 100 7 1 366 1154101 1153737 Desulfolutivibrio sulfodismutans DSM 3696 chromosome, complete genome blastn 139383 475 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfolutivibrio Desulfolutivibrio sulfodismutans

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