RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Candidatus Tectimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Tectimicrobiota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB20058 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
32910664 32910664 PRJEB20058_P_NODE_154009_length_308_cov_2.036437_g151186_i0 PRJEB20058 154009 308 2.036437 6.27222596 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 81.3 7.05e-17   NR HEY5871188.1 2528274 g151186 i0 100 2.63961038961039 37 0 36 0 132 22 1 37 HEY5871188.1 bacterioferritin [Candidatus Tectimicrobiota bacterium] diamond 813 81.3 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
32928213 32928213 PRJEB20058_P_NODE_222193_length_241_cov_1.777778_g219368_i0 PRJEB20058 222193 241 1.777778 4.28444498 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 162 7.579999999999998e-47   NR HEY5863953.1 2528274 g219368 i0 97.5 0.995850622406639 80 2 99.6 0 240 1 133 212 HEY5863953.1 hypothetical protein [Candidatus Tectimicrobiota bacterium] diamond 240 162 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
33098394 33098394 PRJEB20058_P_NODE_13446_length_1131_cov_5.319626_g11750_i0 PRJEB20058 13446 1131 5.319626 60.16497006 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 195 1.35e-53   NR MBI3126201.1 2528274 g11750 i0 54.3 1.48010610079576 186 85 49.3 0 571 14 243 428 MBI3126201.1 hypothetical protein [Candidatus Tectimicrobiota bacterium] diamond 1674 195 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
33098399 33098399 PRJEB20058_P_NODE_134646_length_338_cov_1.342960_g131826_i0 PRJEB20058 134646 338 1.34296 4.5392048 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 186 2.1499999999999994e-54   NR HEY7489873.1 2528274 g131826 i0 89.5 0.843195266272189 95 10 84.3 0 43 327 1 95 HEY7489873.1 hypothetical protein [Candidatus Tectimicrobiota bacterium] diamond 285 186 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
33115426 33115426 PRJEB20058_P_NODE_135559_length_336_cov_2.763636_g132739_i0 PRJEB20058 135559 336 2.763636 9.28581696 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 164 1.4299999999999999e-47   NR HEY5868178.1 2528274 g132739 i0 95.2 0.741071428571429 83 4 74.1 0 3 251 239 321 HEY5868178.1 SDR family NAD(P)-dependent oxidoreductase [Candidatus Tectimicrobiota bacterium] diamond 249 164 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
33150596 33150596 PRJEB20058_P_NODE_88568_length_437_cov_3.648936_g85773_i0 PRJEB20058 88568 437 3.648936 15.94585032 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 66.2 1.36e-9   NR MBI2880429.1 2528274 g85773 i0 41.9 0.590389016018307 86 50 59 0 24 281 244 329 MBI2880429.1 peptidylprolyl isomerase [Candidatus Tectimicrobiota bacterium] diamond 258 66.2 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium

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