RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA702290" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA702290 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
7562538 7562538 PRJNA702290_P_NODE_1206_length_191_cov_3.032895_g1198_i0 PRJNA702290 1206 191 3.032895 5.79282945 Deinococcus 1298 Bacteria Bacteria 141 3.41e-29   NTclustered gi|1435316362|gb|CP031158.1| 980427 g1198 i0 100 45.5968586387435 76 0 79 0 112 187 2148533 2148458 Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome blastn 8709 141 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
8837534 8837534 PRJNA702290_P_NODE_1407_length_170_cov_18.000000_g1399_i0 PRJNA702290 1407 170 18 30.6 Deinococcus 1298 Bacteria Bacteria 294 2.14e-75   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g1399 i0 100 161.111764705882 159 0 94 0 6 164 1455241 1455399 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 27389 294 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142
9612251 9612251 PRJNA702290_P_NODE_1048_length_191_cov_7.230263_g1040_i0 PRJNA702290 1048 191 7.230263 13.80980233 Deinococcus ficus 317577 Bacteria Bacteria 128 2.65e-25   NTclustered gi|1220362168|gb|CP021081.1| 317577 g1040 i0 96.203 10.4031413612565 79 2 80 1 2 79 540301 540223 Deinococcus ficus strain CC-FR2-10, complete genome blastn 1987 128 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
10887863 10887863 PRJNA702290_P_NODE_1929_length_155_cov_14.405172_g1921_i0 PRJNA702290 1929 155 14.405172 22.3280166 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 272 8.99e-69   NTclustered gi|821341785|gb|CP011389.1| 1309411 g1921 i0 100 137.083870967742 147 0 95 0 3 149 1637377 1637523 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 21248 272 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
12664155 12664155 PRJNA702290_P_NODE_950_length_191_cov_9.414474_g942_i0 PRJNA702290 950 191 9.414474 17.98164534 Deinococcus 1298 Bacteria Bacteria 134 5.7e-27   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g942 i0 98.667 13.9528795811518 75 1 79 0 6 80 1045570 1045496 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 2665 134 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142
13938567 13938567 PRJNA702290_P_NODE_1051_length_191_cov_7.184211_g1043_i0 PRJNA702290 1051 191 7.184211 13.72184301 Deinococcus 1298 Bacteria Bacteria 143 9.479999999999999e-30   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g1043 i0 100 111.596858638743 77 0 79 0 112 188 1454901 1454825 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 21315 143 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142
16487593 16487593 PRJNA702290_P_NODE_1073_length_191_cov_6.578947_g1065_i0 PRJNA702290 1073 191 6.578947 12.56578877 Deinococcus 1298 Bacteria Bacteria 130 7.38e-26   NTclustered gi|2264081587|gb|CP094462.1| 1299 g1065 i0 96.203 9.45549738219895 79 3 41 0 2 80 2460417 2460339 Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence blastn 1806 130 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiodurans
21586891 21586891 PRJNA702290_P_NODE_1837_length_156_cov_18.273504_g1829_i0 PRJNA702290 1837 156 18.273504 28.50666624 Deinococcus 1298 Bacteria Bacteria 122 9.66e-24   NTclustered gi|470478007|ref|NR_076423.1| 68909 g1829 i0 96 75.9230769230769 75 3 79 0 79 153 382 456 Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence blastn 11844 122 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis

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