RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJEB20058" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJEB20058 · 20 ✖

analysis 1

  • blastn · 20 ✖

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
25513877 25513877 PRJEB20058_P_NODE_12521_length_1174_cov_2.795148_g10878_i0 PRJEB20058 12521 1174 2.795148 32.81503752 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 708 0   NTclustered gi|2314715370|dbj|AP024673.1| 2682145 g10878 i0 80.559 1.96678023850085 931 171 79 8 18 943 2901360 2900435 MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome blastn 2309 708 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
25517036 25517036 PRJEB20058_P_NODE_198585_length_257_cov_3.872449_g195761_i0 PRJEB20058 198585 257 3.872449 9.95219393 Armatimonadota bacterium 2033014 Bacteria Bacteria 171 6.189999999999999e-38   NTclustered gi|2621785506|emb|OY781964.1| 2033014 g195761 i0 82.09 80.1906614785992 201 34 78 2 49 248 4124904 4124705 MAG: Armatimonadota bacterium isolate 4fa1d893-657a-425b-bdcb-33dea01a3015 genome assembly, chromosome: 1 blastn 20609 171 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
25613118 25613118 PRJEB20058_P_NODE_184057_length_271_cov_6.071429_g181234_i0 PRJEB20058 184057 271 6.071429 16.45357259 Fimbriimonas 1005038 Bacteria Bacteria 294 3.74e-75   NTclustered gi|663071213|gb|CP007139.1| 661478 g181234 i0 88.843 111.10332103321 242 24 89 2 23 263 28622 28383 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 30109 294 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
25654737 25654737 PRJEB20058_P_NODE_247634_length_199_cov_8.347826_g244809_i0 PRJEB20058 247634 199 8.347826 16.61217374 uncultured Armatimonadetes bacterium 157466 Bacteria Bacteria 187 4.54e-43   NTclustered gi|2874253689|emb|OY969415.1| 157466 g244809 i0 86.517 124.195979899497 178 15 85 6 23 192 3915165 3914989 MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1 blastn 24715 187 1 Bacteria   Bacillati Armatimonadota         uncultured Armatimonadetes bacterium
25785645 25785645 PRJEB20058_P_NODE_118251_length_368_cov_1.667752_g115436_i0 PRJEB20058 118251 368 1.667752 6.13732736 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 115 4.4e-21   NTclustered gi|2314715370|dbj|AP024673.1| 2682145 g115436 i0 85.981 1.32880434782609 107 15 37 0 253 359 1334545 1334439 MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome blastn 489 115 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
25790591 25790591 PRJEB20058_P_NODE_237299_length_221_cov_5.625000_g234474_i0 PRJEB20058 237299 221 5.625 12.43125 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 180 8.61e-41   NTclustered gi|2314715370|dbj|AP024673.1| 2682145 g234474 i0 85.227 0.796380090497738 176 25 80 1 34 209 1307224 1307050 MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome blastn 176 180 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
25928892 25928892 PRJEB20058_P_NODE_56412_length_559_cov_2.538153_g53661_i0 PRJEB20058 56412 559 2.538153 14.18827527 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 606 9.369999999999996e-169   NTclustered gi|2314715370|dbj|AP024673.1| 2682145 g53661 i0 86.299 1.00536672629696 562 72 100 5 1 559 294740 295299 MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome blastn 562 606 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
25930693 25930693 PRJEB20058_P_NODE_91532_length_429_cov_2.510870_g88733_i0 PRJEB20058 91532 429 2.51087 10.7716323 uncultured Armatimonadetes bacterium 157466 Bacteria Bacteria 287 1.04e-72   NTclustered gi|2874254000|emb|OY970325.1| 157466 g88733 i0 80.101 42.965034965035 397 69 91 9 10 401 2812335 2812726 MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 blastn 18432 287 1 Bacteria   Bacillati Armatimonadota         uncultured Armatimonadetes bacterium
26060374 26060374 PRJEB20058_P_NODE_178109_length_278_cov_2.359447_g175286_i0 PRJEB20058 178109 278 2.359447 6.55926266 Fimbriimonas ginsengisoli Gsoil 348 661478 Bacteria Bacteria 215 3.08e-51   NTclustered gi|663071213|gb|CP007139.1| 661478 g175286 i0 82.47 3.40647482014389 251 38 89 6 25 272 900782 900535 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 947 215 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
26196014 26196014 PRJEB20058_P_NODE_160806_length_299_cov_1.239496_g157983_i0 PRJEB20058 160806 299 1.239496 3.70609304 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 331 3.1900000000000006e-86   NTclustered gi|2314715370|dbj|AP024673.1| 2682145 g157983 i0 89.139 0.892976588628763 267 27 89 2 17 282 868126 868391 MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome blastn 267 331 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
26329110 26329110 PRJEB20058_P_NODE_102111_length_402_cov_7.114370_g99304_i0 PRJEB20058 102111 402 7.11437 28.5997674 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 350 1.22e-91   NTclustered gi|2314715370|dbj|AP024673.1| 2682145 g99304 i0 84.314 2.89054726368159 357 56 89 0 21 377 411134 411490 MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome blastn 1162 350 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
26330148 26330148 PRJEB20058_P_NODE_124751_length_355_cov_7.329932_g121932_i0 PRJEB20058 124751 355 7.329932 26.0212586 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 320 8.34e-83   NTclustered gi|2314715370|dbj|AP024673.1| 2682145 g121932 i0 84.83 1.34084507042254 323 43 90 4 17 334 531343 531022 MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome blastn 476 320 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
26331642 26331642 PRJEB20058_P_NODE_157615_length_303_cov_2.115702_g154792_i0 PRJEB20058 157615 303 2.115702 6.41057706 Fimbriimonas ginsengisoli Gsoil 348 661478 Bacteria Bacteria 141 5.86e-29   NTclustered gi|663071213|gb|CP007139.1| 661478 g154792 i0 98.734 2.79207920792079 79 1 26 0 191 269 4676764 4676686 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 846 141 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
26333530 26333530 PRJEB20058_P_NODE_203015_length_254_cov_1.844560_g200191_i0 PRJEB20058 203015 254 1.84456 4.6851824 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 235 2.13e-57   NTclustered gi|2076449834|gb|CP075365.1| 2682144 g200191 i0 95.862 7.38582677165354 145 6 57 0 110 254 1878009 1877865 MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome blastn 1876 235 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
26336935 26336935 PRJEB20058_P_NODE_54391_length_570_cov_2.721022_g51647_i0 PRJEB20058 54391 570 2.721022 15.5098254 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 616 1.5899999999999995e-171   NTclustered gi|2314715370|dbj|AP024673.1| 2682145 g51647 i0 86.477 21.5473684210526 562 74 98 2 2 562 1613755 1613195 MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome blastn 12282 616 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
26338067 26338067 PRJEB20058_P_NODE_76111_length_476_cov_2.419277_g73333_i0 PRJEB20058 76111 476 2.419277 11.51575852 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 403 1.1099999999999996e-107   NTclustered gi|2314715370|dbj|AP024673.1| 2682145 g73333 i0 82.505 0.972689075630252 463 78 97 3 1 461 143251 143712 MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome blastn 463 403 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
26467281 26467281 PRJEB20058_P_NODE_142880_length_324_cov_4.695817_g140059_i0 PRJEB20058 142880 324 4.695817 15.21444708 Armatimonadetes bacterium Uphvl-Ar2 2004468 Bacteria Bacteria 169 2.9e-37   NTclustered gi|1199101103|gb|CP021424.1| 2004468 g140059 i0 80.631 11.5061728395062 222 39 68 4 60 280 2033212 2033430 Armatimonadetes bacterium Uphvl-Ar2 genome blastn 3728 169 1 Bacteria   Bacillati Armatimonadota         Armatimonadetes bacterium Uphvl-Ar2
26469737 26469737 PRJEB20058_P_NODE_20096_length_925_cov_13.097222_g18026_i0 PRJEB20058 20096 925 13.097222 121.1493035 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 507 1.6599999999999995e-138   NTclustered gi|2314715370|dbj|AP024673.1| 2682145 g18026 i0 81.76 0.675675675675676 625 97 67 17 275 890 174490 175106 MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome blastn 625 507 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
26473531 26473531 PRJEB20058_P_NODE_60680_length_538_cov_2.073375_g57920_i0 PRJEB20058 60680 538 2.073375 11.1547575 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 556 9.19e-154   NTclustered gi|2314715370|dbj|AP024673.1| 2682145 g57920 i0 85.475 0.99814126394052 537 74 99 4 4 538 1047720 1047186 MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome blastn 537 556 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
26565998 26565998 PRJEB20058_P_NODE_223016_length_240_cov_73.508380_g220191_i0 PRJEB20058 223016 240 73.50838 176.420112 Fimbriimonas 1005038 Bacteria Bacteria 198 2.62e-46   NTclustered gi|663071213|gb|CP007139.1| 661478 g220191 i0 83.796 5.36666666666667 216 28 88 6 1 212 29569 29781 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 1288 198 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli

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