RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA939415" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA939415 · 16 ✖

analysis 1

  • blastn · 16 ✖
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
915494 915494 PRJNA939415_P_NODE_43201_length_290_cov_2.944700_g42779_i0 PRJNA939415 43201 290 2.9447 8.53963 Chthoniobacteraceae bacterium 2811408 Bacteria Bacteria 195 4.22e-45   NTclustered gi|2813917447|gb|CP170506.1| 2811408 g42779 i0 78.893 38.6310344827586 289 59 99 2 1 288 3198510 3198797 MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome blastn 11203 195 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales Chthoniobacteraceae   Chthoniobacteraceae bacterium
916014 916014 PRJNA939415_P_NODE_71621_length_262_cov_2.597884_g71199_i0 PRJNA939415 71621 262 2.597884 6.80645608 Termitidicoccus mucosus 1184151 Bacteria Bacteria 189 1.7499999999999996e-43   NTclustered gi|2724066732|gb|CP109796.1| 1184151 g71199 i0 83.333 38.8969465648855 204 34 78 0 7 210 1044123 1044326 Termitidicoccus mucosus strain TSB47 chromosome, complete genome blastn 10191 189 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Termitidicoccus Termitidicoccus mucosus
3466392 3466392 PRJNA939415_P_NODE_45303_length_288_cov_2.725581_g44881_i0 PRJNA939415 45303 288 2.725581 7.84967328 Chthoniobacteraceae bacterium 2811408 Bacteria Bacteria 231 3.19e-56   NTclustered gi|2813917447|gb|CP170506.1| 2811408 g44881 i0 82.222 89.4131944444444 270 46 93 2 20 288 3198110 3198378 MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome blastn 25751 231 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales Chthoniobacteraceae   Chthoniobacteraceae bacterium
3466876 3466876 PRJNA939415_P_NODE_71363_length_262_cov_3.582011_g70941_i0 PRJNA939415 71363 262 3.582011 9.38486882 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 222 1.72e-53   NTclustered gi|2022020957|gb|CP059069.1| 2562705 g70941 i0 85.714 40.2290076335878 210 30 80 0 4 213 915117 914908 Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome blastn 10540 222 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
7294487 7294487 PRJNA939415_P_NODE_88186_length_247_cov_1.695402_g87764_i0 PRJNA939415 88186 247 1.695402 4.18764294 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 167 7.64e-37   NTclustered gi|2874253690|emb|OY969416.1| 412056 g87764 i0 80.93 1.59514170040486 215 37 86 2 31 243 4505383 4505171 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 394 167 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
9843201 9843201 PRJNA939415_P_NODE_27728_length_310_cov_3.869198_g27306_i0 PRJNA939415 27728 310 3.869198 11.9945138 Roseimicrobium sp. ORNL1 2711231 Bacteria Bacteria 135 2.8e-27   NTclustered gi|1815841271|gb|CP049143.1| 2711231 g27306 i0 94.382 38.0806451612903 89 4 29 1 222 310 4308898 4308811 Roseimicrobium sp. ORNL1 chromosome, complete genome blastn 11805 135 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Roseimicrobium Roseimicrobium sp. ORNL1
9843568 9843568 PRJNA939415_P_NODE_45968_length_287_cov_5.584112_g45546_i0 PRJNA939415 45968 287 5.584112 16.02640144 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 65.8 3.41e-6   NTclustered gi|2874253690|emb|OY969416.1| 412056 g45546 i0 85.938 2.65853658536585 64 6 22 3 226 287 4966564 4966626 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 763 65.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
11118860 11118860 PRJNA939415_P_NODE_26749_length_310_cov_4.337553_g26327_i0 PRJNA939415 26749 310 4.337553 13.4464143 Luteolibacter sp. SL250 2995170 Bacteria Bacteria 296 1.21e-75   NTclustered gi|2381117106|gb|CP113054.1| 2995170 g26327 i0 83.601 1.00322580645161 311 44 99 4 2 310 3633669 3633974 Luteolibacter sp. SL250 chromosome blastn 311 296 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. SL250
11460097 11460097 PRJNA939415_P_NODE_18649_length_361_cov_2.250000_g18229_i0 PRJNA939415 18649 361 2.25 8.1225 Akkermansia 239934 Bacteria Bacteria 213 1.48e-50   NTclustered gi|2051350654|gb|CP072036.1| 2927224 g18229 i0 89.759 48.1135734072022 166 17 46 0 195 360 1094094 1094259 Akkermansia massiliensis strain Akk1573 chromosome, complete genome blastn 17369 213 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia massiliensis
12395639 12395639 PRJNA939415_P_NODE_97750_length_238_cov_2.642424_g97328_i0 PRJNA939415 97750 238 2.642424 6.28896912 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 65.8 2.75e-6   NTclustered gi|2874253779|emb|OY969763.1| 412056 g97328 i0 90 0.210084033613445 50 5 21 0 18 67 3741455 3741406 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 blastn 50 65.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
13668351 13668351 PRJNA939415_P_NODE_102631_length_230_cov_7.108280_g102209_i0 PRJNA939415 102631 230 7.10828 16.349044 Verrucomicrobia bacterium IMCC26134 1637999 Bacteria Bacteria 139 1.53e-28   NTclustered gi|807238858|gb|CP011265.1| 1637999 g102209 i0 89.189 0.482608695652174 111 12 48 0 118 228 233127 233017 Verrucomicrobia bacterium IMCC26134, complete genome blastn 111 139 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobia bacterium IMCC26134
17494048 17494048 PRJNA939415_P_NODE_53694_length_280_cov_1.821256_g53272_i0 PRJNA939415 53694 280 1.821256 5.0995168 Verrucomicrobium sp. GAS474 1882831 Bacteria Bacteria 67.6 9.21e-7   NTclustered gi|1085974270|emb|LT629781.1| 1882831 g53272 i0 78.302 0.532142857142857 106 21 38 2 76 180 1371569 1371465 Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I blastn 149 67.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Verrucomicrobium Verrucomicrobium sp. GAS474
17494228 17494228 PRJNA939415_P_NODE_65454_length_268_cov_2.948718_g65032_i0 PRJNA939415 65454 268 2.948718 7.90256424 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 87.9 6.73e-13   NTclustered gi|2874254019|emb|OY970344.1| 412056 g65032 i0 90.909 0.399253731343284 66 4 24 2 204 268 1337402 1337338 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 107 87.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
20042025 20042025 PRJNA939415_P_NODE_36436_length_298_cov_7.737778_g36014_i0 PRJNA939415 36436 298 7.737778 23.05857844 Horticoccus luteus 2862869 Bacteria Bacteria 60.2 1.66e-4   NTclustered gi|2077391884|gb|CP080507.1| 2862869 g36014 i0 97.143 0.11744966442953 35 1 12 0 81 115 1240300 1240334 Horticoccus luteus strain KSB-15 chromosome, complete genome blastn 35 60.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Horticoccus Horticoccus luteus
21317461 21317461 PRJNA939415_P_NODE_35637_length_304_cov_3.359307_g35215_i0 PRJNA939415 35637 304 3.359307 10.21229328 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 464 3.07e-126   NTclustered gi|2874254019|emb|OY970344.1| 412056 g35215 i0 94.137 145.858552631579 307 15 100 1 1 304 736086 736392 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 44341 464 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
25140995 25140995 PRJNA939415_P_NODE_110800_length_203_cov_4.584615_g110378_i0 PRJNA939415 110800 203 4.584615 9.30676845 Luteolibacter sp. SL250 2995170 Bacteria Bacteria 342 9.369999999999999e-90   NTclustered gi|2381117106|gb|CP113054.1| 2995170 g110378 i0 97.044 1.72413793103448 203 6 100 0 1 203 4475775 4475573 Luteolibacter sp. SL250 chromosome blastn 350 342 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. SL250

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