RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA564810" and tax_clade = "FCB group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • FCB group · 4 ✖

bioproject 1

  • PRJNA564810 · 4 ✖

analysis 1

  • blastn · 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
3105057 3105057 PRJNA564810_S_NODE_8083_length_211_cov_3.054795_g8061_i0 PRJNA564810 8083 211 3.054795 6.44561745 Candidatus Uzinura diaspidicola 670956 Bacteria Bacteria 60.2 1.11e-4   NTclustered gi|1271270784|gb|KY220492.1| 670956 g8061 i0 81.69 0.71563981042654 71 13 34 0 53 123 231 161 Candidatus Uzinura diaspidicola isolate D3022C 16S ribosomal RNA gene, partial sequence blastn 151 60.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales     Candidatus Uzinura diaspidicola
4381628 4381628 PRJNA564810_S_NODE_1324_length_375_cov_1.958065_g1302_i0 PRJNA564810 1324 375 1.958065 7.34274375 Porphyromonas sp. oral taxon 275 712435 Bacteria Bacteria 647 0   NTclustered gi|2028834772|gb|CP072333.1| 712435 g1302 i0 97.867 425.381333333333 375 7 100 1 1 375 443415 443042 Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome blastn 159518 647 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas sp. oral taxon 275
12612478 12612478 PRJNA564810_S_NODE_3850_length_276_cov_3.052133_g3828_i0 PRJNA564810 3850 276 3.052133 8.42388708 Porphyromonas 836 Bacteria Bacteria 231 3.04e-56   NTclustered gi|2188783050|dbj|AP025559.1| 322095 g3828 i0 85.973 410.677536231884 221 25 79 5 3 219 569635 569853 Porphyromonas somerae CE91-St14 DNA, complete genome blastn 113347 231 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas somerae
13887482 13887482 PRJNA564810_S_NODE_3811_length_277_cov_2.589623_g3789_i0 PRJNA564810 3811 277 2.589623 7.17325571 Parabacteroides 375288 Bacteria Bacteria 302 2.29e-77   NTclustered gi|2032883667|gb|CP072229.1| 46503 g3789 i0 86.525 532.599277978339 282 29 100 7 1 277 36851 37128 Parabacteroides merdae strain CL06T03C08 chromosome, complete genome blastn 147530 302 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Tannerellaceae Parabacteroides Parabacteroides merdae

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