RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA280983" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA280983 · 6 ✖

analysis 1

  • blastn · 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
4198748 4198748 PRJNA280983_P_NODE_11064_length_162_cov_0.902655_g10949_i0 PRJNA280983 11064 162 0.902655 1.4623011 Mucilaginibacter jinjuensis 1176721 Bacteria Bacteria 176 7.67e-40   NTclustered gi|2442599841|gb|CP117167.1| 1176721 g10949 i0 86.792 1.21604938271605 159 19 98 2 5 162 589833 589676 Mucilaginibacter jinjuensis strain KACC 16571 chromosome, complete genome blastn 197 176 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Mucilaginibacter Mucilaginibacter jinjuensis
13125489 13125489 PRJNA280983_P_NODE_11571_length_151_cov_3.068627_g11456_i0 PRJNA280983 11571 151 3.068627 4.63362677 Myroides sp. JBRI-B21084 3119977 Bacteria Bacteria 152 1.18e-32   NTclustered gi|2552842630|gb|CP120653.1| 3119977 g11456 i0 84.768 13.0662251655629 151 23 100 0 1 151 1059468 1059318 Myroides sp. JBRI-B21084 chromosome, complete genome blastn 1973 152 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Myroides Myroides sp. JBRI-B21084
16361466 16361466 PRJNA280983_P_NODE_6573_length_233_cov_1.663043_g6458_i0 PRJNA280983 6573 233 1.663043 3.87489019 Flavobacterium 237 Bacteria Bacteria 226 1.1599999999999999e-54   NTclustered gi|1712897335|gb|CP042170.1| 1179672 g6458 i0 84.188 10.3519313304721 234 36 100 1 1 233 560686 560919 Flavobacterium sp. KBS0721 chromosome, complete genome blastn 2412 226 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. KBS0721
16949014 16949014 PRJNA280983_P_NODE_11094_length_162_cov_0.902655_g10979_i0 PRJNA280983 11094 162 0.902655 1.4623011 Mucilaginibacter sabulilitoris 1173583 Bacteria Bacteria 158 2.78e-34   NTclustered gi|2632603506|gb|CP139558.1| 1173583 g10979 i0 84.81 2.34567901234568 158 22 97 2 6 162 2687748 2687904 Mucilaginibacter sabulilitoris strain SNA2 chromosome, complete genome blastn 380 158 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Mucilaginibacter Mucilaginibacter sabulilitoris
18223344 18223344 PRJNA280983_P_NODE_9815_length_167_cov_0.864407_g9700_i0 PRJNA280983 9815 167 0.864407 1.44355969 Chitinophaga oryzae 2725414 Bacteria Bacteria 132 1.7500000000000002e-26   NTclustered gi|1832568489|gb|CP051205.1| 2725414 g9700 i0 81.707 10.2215568862275 164 24 96 5 1 161 7688130 7687970 Chitinophaga oryzae strain 1310 chromosome, complete genome blastn 1707 132 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Chitinophaga Chitinophaga oryzae
24597758 24597758 PRJNA280983_P_NODE_1720_length_560_cov_2.471624_g1610_i0 PRJNA280983 1720 560 2.471624 13.8410944 Seonamhaeicola sp. ML3 2937786 Bacteria Bacteria 73.1 4.24e-8   NTclustered gi|2235330891|gb|CP096884.1| 2937786 g1610 i0 82.558 0.741071428571429 86 12 15 2 391 473 1586387 1586302 Seonamhaeicola sp. ML3 chromosome, complete genome blastn 415 73.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Seonamhaeicola Seonamhaeicola sp. ML3

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