RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax_phylum = "Rhodothermota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rhodothermota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB28062 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
6402371 6402371 PRJEB28062_P_NODE_18266_length_883_cov_4.530864_g16281_i0 PRJEB28062 18266 883 4.530864 40.00752912 Rubrivirga sp. IMCC45206 3391614 Bacteria Bacteria 680 0   NTclustered gi|2890849321|gb|CP177357.1| 3391614 g16281 i0 83.091 1.71913929784824 757 118 85 9 23 774 1910097 1910848 Rubrivirga sp. IMCC45206 chromosome, complete genome blastn 1518 680 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. IMCC45206
11190185 11190185 PRJEB28062_P_NODE_100649_length_313_cov_1.858333_g98286_i0 PRJEB28062 100649 313 1.858333 5.81658229 Rubrivirga 1434037 Bacteria Bacteria 137 7.86e-28   NTclustered gi|2890853429|gb|CP177355.1| 3391575 g98286 i0 100 26.7124600638978 74 0 24 0 22 95 2614979 2615052 Rubrivirga sp. IMCC43871 chromosome, complete genome blastn 8361 137 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. IMCC43871
11503440 11503440 PRJEB28062_P_NODE_72770_length_401_cov_13.057927_g70408_i0 PRJEB28062 72770 401 13.057927 52.36228727 Rubrivirga sp. IMCC45206 3391614 Bacteria Bacteria 340 7.319999999999999e-89   NTclustered gi|2890849321|gb|CP177357.1| 3391614 g70408 i0 86.392 6.7356608478803 316 37 78 4 26 338 3155422 3155110 Rubrivirga sp. IMCC45206 chromosome, complete genome blastn 2701 340 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. IMCC45206
12778822 12778822 PRJEB28062_P_NODE_66151_length_426_cov_3.677054_g63790_i0 PRJEB28062 66151 426 3.677054 15.66425004 Rubrivirga sp. IMCC45206 3391614 Bacteria Bacteria 202 3.849999999999999e-47   NTclustered gi|2890849321|gb|CP177357.1| 3391614 g63790 i0 82.278 4.36619718309859 237 38 55 4 179 413 2636111 2636345 Rubrivirga sp. IMCC45206 chromosome, complete genome blastn 1860 202 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. IMCC45206
16290192 16290192 PRJEB28062_P_NODE_46393_length_527_cov_17.396476_g44050_i0 PRJEB28062 46393 527 17.396476 91.67942852 Rhodothermales 1853224 Bacteria Bacteria 536 1.1699999999999999e-147   NTclustered gi|1167574847|gb|CP020382.1| 1779382 g44050 i0 85.91 150.84440227704 511 63 96 9 24 527 2906829 2906321 Rhodothermaceae bacterium RA chromosome, complete genome blastn 79495 536 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rhodothermaceae   Rhodothermaceae bacterium RA
21701067 21701067 PRJEB28062_P_NODE_23078_length_778_cov_1.434043_g20901_i0 PRJEB28062 23078 778 1.434043 11.15685454 Rubrivirga sp. IMCC45206 3391614 Bacteria Bacteria 832 0   NTclustered gi|2890849321|gb|CP177357.1| 3391614 g20901 i0 87.33 49.4125964010283 734 83 94 10 28 756 3266654 3265926 Rubrivirga sp. IMCC45206 chromosome, complete genome blastn 38443 832 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. IMCC45206
22976816 22976816 PRJEB28062_P_NODE_44999_length_536_cov_66.304536_g42660_i0 PRJEB28062 44999 536 66.304536 355.39231296 Rubricoccaceae bacterium 2838334 Bacteria Bacteria 676 0   NTclustered gi|2874254104|emb|OY970187.1| 2838334 g42660 i0 91.935 191.518656716418 496 21 92 7 24 515 1308870 1308390 MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1 blastn 102654 676 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae   Rubricoccaceae bacterium
22976983 22976983 PRJEB28062_P_NODE_51899_length_493_cov_7.269048_g49548_i0 PRJEB28062 51899 493 7.269048 35.83640664 Rubrivirga sp. IMCC43871 3391575 Bacteria Bacteria 342 2.5499999999999993e-89   NTclustered gi|2890853429|gb|CP177355.1| 3391575 g49548 i0 92.181 152.391480730223 243 17 94 2 231 472 806789 806548 Rubrivirga sp. IMCC43871 chromosome, complete genome blastn 75129 342 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. IMCC43871

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