RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA493632", tax_clade = "FCB group" and tax_phylum = "Chlorobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Chlorobiota · 6 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 6 ✖

bioproject 1

  • PRJNA493632 · 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
3013244 3013244 PRJNA493632_P_NODE_357883_length_281_cov_1.774038_g354444_i0 PRJNA493632 357883 281 1.774038 4.98504678 Chlorobiota bacterium 2268192 Bacteria Bacteria 52.8 0.026   NTclustered gi|1958119998|gb|CP065014.1| 2268192 g354444 i0 96.774 0.110320284697509 31 1 11 0 163 193 1981055 1981085 MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome blastn 31 52.8 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium
5568734 5568734 PRJNA493632_P_NODE_508525_length_251_cov_0.865169_g505086_i0 PRJNA493632 508525 251 0.865169 2.17157419 Chlorobiota bacterium 2268192 Bacteria Bacteria 160 5.03e-46   NR KAA0265727.1 2268192 g505086 i0 100 0.944223107569721 79 0 94.4 0 250 14 281 359 KAA0265727.1 MAG: twin-arginine translocation signal domain-containing protein, partial [Chlorobiota bacterium] diamond 237 160 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium
29887168 29887168 PRJNA493632_P_NODE_424271_length_267_cov_1.587629_g420832_i0 PRJNA493632 424271 267 1.587629 4.23896943 Chlorobiota bacterium 2268192 Bacteria Bacteria 43.9 0.0192   NR NOX18656.1 2268192 g420832 i0 48.8 0.921348314606742 41 21 46.1 0 11 133 433 473 NOX18656.1 T9SS type A sorting domain-containing protein [Chlorobiota bacterium] diamond 246 43.9 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium
29934669 29934669 PRJNA493632_P_NODE_509891_length_251_cov_0.865169_g506452_i0 PRJNA493632 509891 251 0.865169 2.17157419 Chlorobiaceae 191412 Bacteria Bacteria 48.1 5.15e-4   NR NTV08952.1 1092 g506452 i0 63.9 4.30278884462151 36 13 43 0 141 34 572 607 NTV08952.1 HAD-IC family P-type ATPase [Chlorobium limicola] diamond 1080 48.5 0.991752577319588 Bacteria FCB group Pseudomonadati Chlorobiota Chlorobiia Chlorobiales Chlorobiaceae Chlorobium Chlorobium limicola
30645175 30645175 PRJNA493632_P_NODE_597933_length_245_cov_0.895349_g594492_i0 PRJNA493632 597933 245 0.895349 2.19360505 Chlorobiota bacterium 2268192 Bacteria Bacteria 156 8.76e-46   NR MBL7989103.1 2268192 g594492 i0 100 0.991836734693878 81 0 99.2 0 243 1 137 217 MBL7989103.1 hypothetical protein [Chlorobiota bacterium] diamond 243 156 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium
31846561 31846561 PRJNA493632_P_NODE_502977_length_251_cov_2.561798_g499538_i0 PRJNA493632 502977 251 2.561798 6.43011298 Chlorobiaceae bacterium 2067991 Bacteria Bacteria 139 3.3999999999999996e-36   NR NMW22485.1 2067991 g499538 i0 74.7 0.99203187250996006 83 21 99.2 0 1 249 530 612 NMW22485.1 acyltransferase family protein [Chlorobiaceae bacterium] diamond 249 139 1 Bacteria FCB group Pseudomonadati Chlorobiota Chlorobiia Chlorobiales Chlorobiaceae   Chlorobiaceae 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);;