RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA556992 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
1126030 1126030 PRJNA556992_P_NODE_3521_length_1664_cov_11.952860_g2852_i0 PRJNA556992 3521 1664 11.95286 198.8955904 Thermoproteati 1783275 Archaea Archaea 2623 0   NTclustered gi|22797874|emb|AJ496176.1| 29281 g2852 i0 98.91 88.2536057692308 1468 16 88 0 1 1468 3560 5027 Uncultured crenarchaeote 34 kb genomic fragment blastn 146854 2625 0.999238095238095 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
3081030 3081030 PRJNA556992_P_NODE_548723_length_263_cov_1.900000_g546534_i0 PRJNA556992 548723 263 1.9 4.997 uncultured crenarchaeote 29281 Archaea Archaea 339 1.65e-88   NTclustered gi|22797874|emb|AJ496176.1| 29281 g546534 i0 89.888 58.5399239543726 267 21 100 4 1 263 6183 5919 Uncultured crenarchaeote 34 kb genomic fragment blastn 15396 339 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
9454457 9454457 PRJNA556992_P_NODE_246288_length_306_cov_7.914163_g244100_i0 PRJNA556992 246288 306 7.914163 24.21733878 uncultured crenarchaeote 29281 Archaea Archaea 411 4.089999999999999e-110   NTclustered gi|22797874|emb|AJ496176.1| 29281 g244100 i0 90.85 67.3169934640523 306 28 100 0 1 306 7328 7633 Uncultured crenarchaeote 34 kb genomic fragment blastn 20599 411 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
11328088 11328088 PRJNA556992_P_NODE_13729_length_903_cov_13.113253_g12028_i0 PRJNA556992 13729 903 13.113253 118.41267459 Thermoproteati 1783275 Archaea Archaea 1596 0   NTclustered gi|22797874|emb|AJ496176.1| 29281 g12028 i0 98.668 103.857142857143 901 11 99 1 4 903 8526 7626 Uncultured crenarchaeote 34 kb genomic fragment blastn 93783 1602 0.99625468164794 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
12001974 12001974 PRJNA556992_P_NODE_1101610_length_212_cov_5.949640_g1099419_i0 PRJNA556992 1101610 212 5.94964 12.6132368 Sulfurisphaera javensis 2049879 Archaea Archaea 52.8 0.019   NTclustered gi|2747373164|dbj|AP031322.1| 2049879 g1099419 i0 100 0.132075471698113 28 0 13 0 31 58 308990 309017 Sulfurisphaera javensis KD-1 DNA, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfurisphaera Sulfurisphaera javensis
15152335 15152335 PRJNA556992_P_NODE_1029952_length_227_cov_4.175325_g1027762_i0 PRJNA556992 1029952 227 4.175325 9.47798775 Archaea 2157 Archaea Archaea 331 2.32e-86   NTclustered gi|42557759|emb|AJ627422.1| 29281 g1027762 i0 92.952 91.8193832599119 227 16 100 0 1 227 41646 41420 Uncultured crenarchaeote genomic fragment 54d9 blastn 20843 331 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
15832344 15832344 PRJNA556992_P_NODE_5033_length_1436_cov_10.793103_g4117_i0 PRJNA556992 5033 1436 10.793103 154.98895908 uncultured crenarchaeote 29281 Archaea Archaea 2327 0   NTclustered gi|22797874|emb|AJ496176.1| 29281 g4117 i0 95.964 45.7987465181059 1437 53 99 4 3 1436 7313 5879 Uncultured crenarchaeote 34 kb genomic fragment blastn 65767 2327 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
18975622 18975622 PRJNA556992_P_NODE_102475_length_402_cov_2.653495_g100291_i0 PRJNA556992 102475 402 2.653495 10.6670499 root 1 Root_unresolved Root_unresolved 743 0   NTclustered gi|471647761|gb|KC661538.1| 29281 g100291 i0 100 100 402 0 100 0 1 402 174 575 Uncultured crenarchaeote clone BC-J-R-W1-B2 16S ribosomal RNA gene, partial sequence blastn 40200 743 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
21526936 21526936 PRJNA556992_P_NODE_12197_length_956_cov_6.237826_g4117_i1 PRJNA556992 12197 956 6.237826 59.63361656 Thermoproteati 1783275 Archaea Archaea 1264 0   NTclustered gi|42557759|emb|AJ627422.1| 29281 g4117 i1 90.566 50.5407949790795 954 90 99 0 3 956 41819 40866 Uncultured crenarchaeote genomic fragment 54d9 blastn 48317 1275 0.991372549019608 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
22802844 22802844 PRJNA556992_P_NODE_287698_length_291_cov_1.775229_g285509_i0 PRJNA556992 287698 291 1.775229 5.16591639 Archaea 2157 Archaea Archaea 516 7.95e-142   NTclustered gi|944185710|emb|LN896554.1| 29281 g285509 i0 98.63 99.8659793814433 292 3 100 1 1 291 388 679 Uncultured crenarchaeote partial 16S rRNA gene, clone A709 blastn 29061 516 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
24751226 24751226 PRJNA556992_P_NODE_17640_length_803_cov_1.446575_g15798_i0 PRJNA556992 17640 803 1.446575 11.61599725 uncultured crenarchaeote 29281 Archaea Archaea 1378 0   NTclustered gi|42557759|emb|AJ627422.1| 29281 g15798 i0 97.634 54.4433374844334 803 19 100 0 1 803 40384 41186 Uncultured crenarchaeote genomic fragment 54d9 blastn 43718 1378 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote

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