RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA438111" and tax_phylum = "Rhodothermota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rhodothermota · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA438111 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
434424 434424 PRJNA438111_P_NODE_62561_length_169_cov_4.764286_g61936_i0 PRJNA438111 62561 169 4.764286 8.05164334 Rubricoccaceae bacterium 2838334 Bacteria Bacteria 82.4 1.8e-11   NTclustered gi|2874254104|emb|OY970187.1| 2838334 g61936 i0 86.076 0.467455621301775 79 7 46 4 20 96 2364427 2364503 MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1 blastn 79 82.4 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae   Rubricoccaceae bacterium
4918868 4918868 PRJNA438111_P_NODE_62724_length_169_cov_3.842857_g62099_i0 PRJNA438111 62724 169 3.842857 6.49442833 Salinibacter 146918 Bacteria Bacteria 52.8 0.014   NTclustered gi|1419235469|gb|CP030716.1| 146919 g62099 i0 100 0.828402366863905 28 0 17 0 124 151 602763 602790 Salinibacter ruber strain P13 chromosome, complete genome blastn 140 52.8 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber
6193921 6193921 PRJNA438111_P_NODE_87905_length_152_cov_2.528455_g87280_i0 PRJNA438111 87905 152 2.528455 3.8432516 Rhodothermales 1853224 Bacteria Bacteria 167 4.2499999999999995e-37   NTclustered gi|1167574847|gb|CP020382.1| 1779382 g87280 i0 89.63 131.822368421053 135 8 88 5 15 146 2838263 2838394 Rhodothermaceae bacterium RA chromosome, complete genome blastn 20037 167 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rhodothermaceae   Rhodothermaceae bacterium RA
6811931 6811931 PRJNA438111_P_NODE_42606_length_190_cov_4.521739_g41981_i0 PRJNA438111 42606 190 4.521739 8.5913041 Rubrivirga sp. IMCC45206 3391614 Bacteria Bacteria 200 5.51e-47   NTclustered gi|2890849321|gb|CP177357.1| 3391614 g41981 i0 87.151 1.88947368421053 179 19 93 4 1 177 3170418 3170242 Rubrivirga sp. IMCC45206 chromosome, complete genome blastn 359 200 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. IMCC45206
8087880 8087880 PRJNA438111_P_NODE_77687_length_159_cov_5.392308_g77062_i0 PRJNA438111 77687 159 5.392308 8.57376972 Rubrivirga sp. IMCC43871 3391575 Bacteria Bacteria 196 5.75e-46   NTclustered gi|2890853429|gb|CP177355.1| 3391575 g77062 i0 90.196 94.503144654088 153 12 95 3 4 154 4062876 4062725 Rubrivirga sp. IMCC43871 chromosome, complete genome blastn 15026 196 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. IMCC43871
10018904 10018904 PRJNA438111_P_NODE_70188_length_164_cov_3.592593_g69563_i0 PRJNA438111 70188 164 3.592593 5.89185252 Rhodothermus 29548 Bacteria Bacteria 143 7.9e-30   NTclustered gi|262333112|gb|CP001807.1| 518766 g69563 i0 87.705 11.7439024390244 122 15 74 0 1 122 1048475 1048596 Rhodothermus marinus DSM 4252, complete genome blastn 1926 143 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rhodothermaceae Rhodothermus Rhodothermus marinus
10638309 10638309 PRJNA438111_P_NODE_59189_length_172_cov_2.881119_g58564_i0 PRJNA438111 59189 172 2.881119 4.95552468 Rubrivirga sp. IMCC45206 3391614 Bacteria Bacteria 207 2.91e-49   NTclustered gi|2890849321|gb|CP177357.1| 3391614 g58564 i0 88.372 2.97093023255814 172 20 100 0 1 172 1178812 1178983 Rubrivirga sp. IMCC45206 chromosome, complete genome blastn 511 207 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. IMCC45206
17011237 17011237 PRJNA438111_P_NODE_28354_length_210_cov_5.668508_g27729_i0 PRJNA438111 28354 210 5.668508 11.9038668 Rhodocaloribacter litoris 2558931 Bacteria Bacteria 126 1.07e-24   NTclustered gi|2076465437|gb|CP076718.1| 2558931 g27729 i0 89.796 0.466666666666667 98 10 47 0 3 100 1059954 1060051 Rhodocaloribacter litoris strain ISCAR-4553 chromosome blastn 98 126 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rhodothermaceae Rhodocaloribacter Rhodocaloribacter litoris
17011288 17011288 PRJNA438111_P_NODE_31514_length_210_cov_3.690608_g30889_i0 PRJNA438111 31514 210 3.690608 7.7502768 Rubrivirga sp. IMCC45206 3391614 Bacteria Bacteria 99 2.33e-16   NTclustered gi|2890849321|gb|CP177357.1| 3391614 g30889 i0 85.87 2.13809523809524 92 13 44 0 113 204 597403 597494 Rubrivirga sp. IMCC45206 chromosome, complete genome blastn 449 99 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. IMCC45206
18286158 18286158 PRJNA438111_P_NODE_68815_length_165_cov_2.992647_g68190_i0 PRJNA438111 68815 165 2.992647 4.93786755 Rubrivirga sp. IMCC45206 3391614 Bacteria Bacteria 178 2.18e-40   NTclustered gi|2890849321|gb|CP177357.1| 3391614 g68190 i0 86.42 1.69090909090909 162 22 98 0 1 162 3838522 3838683 Rubrivirga sp. IMCC45206 chromosome, complete genome blastn 279 178 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. IMCC45206

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