RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB14803" and tax_phylum = "Nitrospinota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospinota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB14803 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
29369993 29369993 PRJEB14803_P_NODE_13069_length_342_cov_2.657980_g12604_i0 PRJEB14803 13069 342 2.65798 9.0902916 Nitrospinota bacterium 2026769 Bacteria Bacteria 113 4.520000000000001e-27   NR MBR35264.1 2026769 g12604 i0 43.4 0.991228070175439 113 64 99.1 0 339 1 97 209 MBR35264.1 hypothetical protein [Nitrospinota bacterium] diamond 339 113 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
30974708 30974708 PRJEB14803_P_NODE_14614_length_318_cov_2.286219_g14148_i0 PRJEB14803 14614 318 2.286219 7.27017642 Bacteria 2 Bacteria Bacteria 142 1.26e-38   NR MBI5748818.1 2026769 g14148 i0 67 8.74528301886792 103 34 97.2 0 2 310 138 240 MBI5748818.1 6-phosphofructokinase [Nitrospinota bacterium] diamond 2781 143 0.993006993006993 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
31581831 31581831 PRJEB14803_P_NODE_26356_length_215_cov_1.333333_g25890_i0 PRJEB14803 26356 215 1.333333 2.86666595 Nitrospinota bacterium 2026769 Bacteria Bacteria 106 1.13e-24   NR MEK6590375.1 2026769 g25890 i0 69.7 1.84186046511628 66 20 92.1 0 18 215 842 907 MEK6590375.1 phosphoribosylformylglycinamidine synthase [Nitrospinota bacterium] diamond 396 106 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
31802993 31802993 PRJEB14803_P_NODE_8457_length_453_cov_2.889952_g7996_i0 PRJEB14803 8457 453 2.889952 13.09148256 Nitrospina sp. 2024844 Bacteria Bacteria 76.6 2.3e-13   NR TDJ58492.1 2024844 g7996 i0 31.4 2.04635761589404 156 96 98 5 9 452 83 235 TDJ58492.1 MAG: hypothetical protein E2O42_08340 [Nitrospina sp.] diamond 927 76.6 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota Nitrospinia Nitrospinales Nitrospinaceae Nitrospina Nitrospina sp.

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