RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJEB14175 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
25510389 25510389 PRJEB14175_P_NODE_57081_length_492_cov_4.320186_g54831_i0 PRJEB14175 57081 492 4.320186 21.25531512 uncultured crenarchaeote 29281 Archaea Archaea 852 0   NTclustered gi|42557759|emb|AJ627422.1| 29281 g54831 i0 99.362 92.760162601626 470 3 96 0 1 470 42969 42500 Uncultured crenarchaeote genomic fragment 54d9 blastn 45638 852 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
25773157 25773157 PRJEB14175_P_NODE_104747_length_347_cov_70.727273_g102481_i0 PRJEB14175 104747 347 70.727273 245.42363731 uncultured crenarchaeote 29281 Archaea Archaea 387 7.93e-103   NTclustered gi|146262968|gb|EF414271.1| 29281 g102481 i0 88.58 133.994236311239 324 30 93 6 1 324 519 203 Uncultured crenarchaeote clone BS80e2H5 putative amoA protein-like (amoA) mRNA, partial sequence blastn 46496 387 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
25775114 25775114 PRJEB14175_P_NODE_143619_length_284_cov_44.807175_g141352_i0 PRJEB14175 143619 284 44.807175 127.252377 uncultured crenarchaeote 29281 Archaea Archaea 298 3.05e-76   NTclustered gi|22797874|emb|AJ496176.1| 29281 g141352 i0 87.405 55.9401408450704 262 30 92 3 25 284 6166 6426 Uncultured crenarchaeote 34 kb genomic fragment blastn 15887 298 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
25782304 25782304 PRJEB14175_P_NODE_54411_length_504_cov_32.214447_g52165_i0 PRJEB14175 54411 504 32.214447 162.36081288 uncultured crenarchaeote 29281 Archaea Archaea 490 8.81e-134   NTclustered gi|42557759|emb|AJ627422.1| 29281 g52165 i0 85.386 79.3333333333333 479 62 95 8 1 477 40844 40372 Uncultured crenarchaeote genomic fragment 54d9 blastn 39984 490 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
25915510 25915510 PRJEB14175_P_NODE_241252_length_205_cov_6.402778_g238984_i0 PRJEB14175 241252 205 6.402778 13.1256949 uncultured crenarchaeote 29281 Archaea Archaea 329 7.39e-86   NTclustered gi|42557759|emb|AJ627422.1| 29281 g238984 i0 98.396 58.2292682926829 187 3 91 0 1 187 40548 40362 Uncultured crenarchaeote genomic fragment 54d9 blastn 11937 329 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
26189951 26189951 PRJEB14175_P_NODE_41638_length_578_cov_4.912959_g39433_i0 PRJEB14175 41638 578 4.912959 28.39690302 uncultured crenarchaeote 29281 Archaea Archaea 931 0   NTclustered gi|42557759|emb|AJ627422.1| 29281 g39433 i0 96.937 33.401384083045 555 17 96 0 24 578 40490 41044 Uncultured crenarchaeote genomic fragment 54d9 blastn 19306 931 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
26324196 26324196 PRJEB14175_P_NODE_258599_length_201_cov_1.214286_g256331_i0 PRJEB14175 258599 201 1.214286 2.44071486 uncultured crenarchaeote 29281 Archaea Archaea 335 1.5499999999999995e-87   NTclustered gi|22797874|emb|AJ496176.1| 29281 g256331 i0 98.421 20.7960199004975 190 3 95 0 1 190 8810 8621 Uncultured crenarchaeote 34 kb genomic fragment blastn 4180 335 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
26562959 26562959 PRJEB14175_P_NODE_43856_length_563_cov_11.561753_g41642_i0 PRJEB14175 43856 563 11.561753 65.09266939 Archaea 2157 Archaea Archaea 915 0   NTclustered gi|42557759|emb|AJ627422.1| 29281 g41642 i0 97.222 78.9378330373002 540 15 96 0 22 561 41488 42027 Uncultured crenarchaeote genomic fragment 54d9 blastn 44442 924 0.99025974025974 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
26563179 26563179 PRJEB14175_P_NODE_54280_length_505_cov_7.042793_g52034_i0 PRJEB14175 54280 505 7.042793 35.56610465 Thermoproteati 1783275 Archaea Archaea 678 0   NTclustered gi|22797874|emb|AJ496176.1| 29281 g52034 i0 91.054 104.556435643564 503 44 99 1 3 505 7391 6890 Uncultured crenarchaeote 34 kb genomic fragment blastn 52801 684 0.991228070175439 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);;