RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA700095" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 13 ✖

bioproject 1

  • PRJNA700095 · 13 ✖

analysis 1

  • blastn · 13 ✖

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
683355 683355 PRJNA700095_P_NODE_64201_length_242_cov_0.905325_g62937_i0 PRJNA700095 64201 242 0.905325 2.1908865 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 252 2e-62   NTclustered gi|1276705688|gb|CP024698.1| 2663009 g62937 i0 94.512 8.45867768595041 164 8 67 1 80 242 1842399 1842562 Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome blastn 2047 252 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
4511194 4511194 PRJNA700095_P_NODE_29984_length_310_cov_3.839662_g28720_i0 PRJNA700095 29984 310 3.839662 11.9029522 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 113 1.31e-20   NTclustered gi|922689899|gb|CP012410.1| 712357 g28720 i0 90.588 0.274193548387097 85 8 27 0 190 274 1515128 1515212 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 85 113 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
5786599 5786599 PRJNA700095_P_NODE_18765_length_412_cov_0.876106_g17502_i0 PRJNA700095 18765 412 0.876106 3.60955672 Leptotrichia sp. oral taxon 847 1785996 Bacteria Bacteria 56.5 0.003   NTclustered gi|987458696|gb|CP014231.1| 1785996 g17502 i0 100 0.0728155339805825 30 0 7 0 195 224 1283913 1283942 Leptotrichia sp. oral taxon 847 strain F0260 chromosome, complete genome blastn 30 56.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 847
5786664 5786664 PRJNA700095_P_NODE_30045_length_310_cov_3.333333_g28781_i0 PRJNA700095 30045 310 3.333333 10.3333323 Fusobacterium nucleatum 851 Bacteria Bacteria 278 4.39e-70   NTclustered gi|2704977725|gb|CP077125.1| 851 g28781 i0 100 48.3870967741936 150 0 48 0 1 150 1024846 1024995 Fusobacterium nucleatum strain KCOM3714 chromosome, complete genome blastn 15000 278 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
7061835 7061835 PRJNA700095_P_NODE_46506_length_260_cov_2.796791_g45242_i0 PRJNA700095 46506 260 2.796791 7.2716566 Fusobacterium polymorphum 76857 Bacteria Bacteria 481 2.55e-131   NTclustered gi|2706041172|gb|CP056018.1| 76857 g45242 i0 100 99.0384615384615 260 0 100 0 1 260 1157638 1157897 Fusobacterium polymorphum strain SB006 chromosome, complete genome blastn 25750 481 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
7061992 7061992 PRJNA700095_P_NODE_9866_length_620_cov_6.466179_g8639_i0 PRJNA700095 9866 620 6.466179 40.0903098 Fusobacterium polymorphum 76857 Bacteria Bacteria 1129 0   NTclustered gi|2706435836|gb|CP077154.1| 76857 g8639 i0 99.516 481.820967741935 620 3 100 0 1 620 2497520 2496901 Fusobacterium polymorphum strain KCOM1267 chromosome, complete genome blastn 298729 1129 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
9611746 9611746 PRJNA700095_P_NODE_48868_length_255_cov_4.692308_g47604_i0 PRJNA700095 48868 255 4.692308 11.9653854 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 405 1.54e-108   NTclustered gi|922689899|gb|CP012410.1| 712357 g47604 i0 95.331 465.674509803922 257 8 100 4 1 255 52826 52572 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 118747 405 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
10887237 10887237 PRJNA700095_P_NODE_33569_length_294_cov_3.529412_g32305_i0 PRJNA700095 33569 294 3.529412 10.37647128 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 283 8.879999999999999e-72   NTclustered gi|922689899|gb|CP012410.1| 712357 g32305 i0 98.742 47.7721088435374 159 2 100 0 136 294 1859289 1859447 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 14045 283 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
13436986 13436986 PRJNA700095_P_NODE_46491_length_260_cov_3.010695_g45227_i0 PRJNA700095 46491 260 3.010695 7.827807 Fusobacterium polymorphum 76857 Bacteria Bacteria 481 2.55e-131   NTclustered gi|2706407748|gb|CP077116.1| 76857 g45227 i0 100 100.107692307692 260 0 100 0 1 260 733964 734223 Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome blastn 26028 481 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
19035988 19035988 PRJNA700095_P_NODE_35495_length_287_cov_10.009346_g34231_i0 PRJNA700095 35495 287 10.009346 28.72682302 Fusobacterium 848 Bacteria Bacteria 508 1.31e-139   NTclustered gi|2704972056|gb|CP077127.1| 851 g34231 i0 98.606 489.254355400697 287 4 100 0 1 287 648171 647885 Fusobacterium nucleatum strain KCOM3503 chromosome, complete genome blastn 140416 512 0.9921875 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
24135884 24135884 PRJNA700095_P_NODE_21059_length_382_cov_8.343042_g19795_i0 PRJNA700095 21059 382 8.343042 31.87042044 Fusobacterium 848 Bacteria Bacteria 701 0   NTclustered gi|2446175567|gb|CP117964.1| 851 g19795 i0 99.739 485.348167539267 383 0 100 1 1 382 2087322 2087704 Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome blastn 185403 704 0.995738636363636 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
24909591 24909591 PRJNA700095_P_NODE_49080_length_255_cov_1.681319_g47816_i0 PRJNA700095 49080 255 1.681319 4.28736345 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 455 1.51e-123   NTclustered gi|1276720946|gb|CP024705.1| 2663009 g47816 i0 98.824 78.9254901960784 255 3 100 0 1 255 1844858 1845112 Fusobacterium pseudoperiodonticum strain KCOM 2653 chromosome, complete genome blastn 20126 455 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
25410836 25410836 PRJNA700095_P_NODE_7940_length_703_cov_6.133333_g6780_i0 PRJNA700095 7940 703 6.133333 43.11733099 Fusobacterium 848 Bacteria Bacteria 1271 0   NTclustered gi|2445153921|gb|CP117797.1| 851 g6780 i0 99.289 498.005689900427 703 5 100 0 1 703 114314 115016 Fusobacterium nucleatum strain FNA chromosome, complete genome blastn 350098 1271 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum

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