RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB2368" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 7 ✖

bioproject 1

  • PRJEB2368 · 7 ✖

analysis 1

  • blastn · 7 ✖

tax_clade 0

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
1297098 1297098 PRJEB2368_P_NODE_10862_length_286_cov_1.650602_g10544_i0 PRJEB2368 10862 286 1.650602 4.72072172 Leptotrichia sp. oral taxon 221 712362 Bacteria Bacteria 128 4.27e-25   NTclustered gi|2028889048|gb|CP072378.1| 712362 g10544 i0 97.333 0.262237762237762 75 2 26 0 212 286 1552536 1552610 Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome blastn 75 128 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 221
3849093 3849093 PRJEB2368_P_NODE_10984_length_286_cov_1.457831_g10666_i0 PRJEB2368 10984 286 1.457831 4.16939666 Leptotrichia sp. SK-5 3075818 Bacteria Bacteria 52.8 0.026   NTclustered gi|2899356158|dbj|AP028931.1| 3075818 g10666 i0 94.118 0.118881118881119 34 2 12 0 239 272 1247371 1247404 Leptotrichia sp. SK-5 DNA, complete genome blastn 34 52.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. SK-5
10225696 10225696 PRJEB2368_P_NODE_8369_length_287_cov_1.644000_g8051_i0 PRJEB2368 8369 287 1.644 4.71828 Fusobacterium polymorphum 76857 Bacteria Bacteria 134 9.21e-27   NTclustered gi|2673502234|gb|CP144257.1| 76857 g8051 i0 98.667 2.09407665505226 75 1 53 0 213 287 1355756 1355682 Fusobacterium polymorphum strain IOOS_98 chromosome blastn 601 134 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
12776471 12776471 PRJEB2368_P_NODE_10611_length_287_cov_1.068000_g10293_i0 PRJEB2368 10611 287 1.068 3.06516 Leptotrichia wadei 157687 Bacteria Bacteria 141 5.510000000000001e-29   NTclustered gi|1708575239|dbj|AP019834.1| 157687 g10293 i0 100 2.63763066202091 76 0 53 0 212 287 1915914 1915839 Leptotrichia wadei JMUB3933 DNA, complete genome blastn 757 141 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
15014267 15014267 PRJEB2368_P_NODE_7552_length_287_cov_1.988000_g7234_i0 PRJEB2368 7552 287 1.988 5.70556 Cetobacterium 180162 Bacteria Bacteria 102 2.6e-17   NTclustered gi|2666488225|gb|CP143319.1| 188913 g7234 i0 90.789 1.32404181184669 76 7 26 0 212 287 869185 869110 Cetobacterium somerae strain ceto chromosome, complete genome blastn 380 102 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
19148401 19148401 PRJEB2368_P_NODE_7156_length_287_cov_2.560000_g6838_i0 PRJEB2368 7156 287 2.56 7.3472 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 130 1.19e-25   NTclustered gi|2705022034|gb|CP084128.1| 2663009 g6838 i0 97.368 4.62369337979094 76 2 26 0 1 76 1569328 1569403 Fusobacterium pseudoperiodonticum strain KCOM1322 chromosome, complete genome blastn 1327 130 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
20112919 20112919 PRJEB2368_P_NODE_7516_length_287_cov_2.012000_g7198_i0 PRJEB2368 7516 287 2.012 5.77444 Fusobacterium 848 Bacteria Bacteria 137 7.12e-28   NTclustered gi|2269773925|gb|CP100429.1| 76857 g7198 i0 100 15.0766550522648 74 0 52 0 1 74 973559 973486 Fusobacterium polymorphum strain SSMR1 chromosome, complete genome blastn 4327 137 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum

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