RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 16 ✖

tax_clade 1

bioproject 1

  • PRJNA704949 · 16 ✖

analysis 1

  • diamond · 16 ✖

tax_kingdom 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
8347543 8347543 PRJNA704949_P_NODE_2036647_length_166_cov_0.888889_g2021308_i0 PRJNA704949 2036647 166 0.888889 1.47555574 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 101 1.67e-23   NR CEO95191.1 37360 g2021308 i0 87.3 0.993975903614458 55 7 99.4 0 2 166 340 394 CEO95191.1 hypothetical protein PBRA_003957 [Plasmodiophora brassicae] diamond 165 101 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
19813064 19813064 PRJNA704949_P_NODE_1019436_length_257_cov_1.750000_g1004101_i0 PRJNA704949 1019436 257 1.75 4.4975 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 102 2.72e-23   NR CEO97489.1 37360 g1004101 i0 57.6 0.992217898832685 85 35 99.2 1 255 1 4 87 CEO97489.1 hypothetical protein PBRA_000834 [Plasmodiophora brassicae] diamond 255 102 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
20317378 20317378 PRJNA704949_P_NODE_977876_length_264_cov_1.339535_g962541_i0 PRJNA704949 977876 264 1.339535 3.5363724 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 91.3 4.23e-19   NR CEP02346.1 37360 g962541 i0 51.2 1.94318181818182 84 40 95.5 1 7 258 260 342 CEP02346.1 hypothetical protein PBRA_008930 [Plasmodiophora brassicae] diamond 513 91.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26702956 26702956 PRJNA704949_P_NODE_1391661_length_211_cov_1.283951_g1376323_i0 PRJNA704949 1391661 211 1.283951 2.70913661 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 68.6 1.78e-11   NR CEP01776.1 37360 g1376323 i0 42.4 0.938388625592417 66 38 93.8 0 6 203 218 283 CEP01776.1 hypothetical protein PBRA_008718 [Plasmodiophora brassicae] diamond 198 68.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27915110 27915110 PRJNA704949_P_NODE_1780525_length_179_cov_1.200000_g1765186_i0 PRJNA704949 1780525 179 1.2 2.148 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 49.3 7.79e-5   NR CEO94412.1 37360 g1765186 i0 77.8 2.24581005586592 27 6 45.3 0 99 179 731 757 CEO94412.1 hypothetical protein PBRA_000197 [Plasmodiophora brassicae] diamond 402 49.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27936372 27936372 PRJNA704949_P_NODE_890225_length_279_cov_2.486957_g874891_i0 PRJNA704949 890225 279 2.486957 6.93861003 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 86.3 2.48e-17   NR CEO94506.1 37360 g874891 i0 50.7 2.35483870967742 69 34 74.2 0 1 207 367 435 CEO94506.1 hypothetical protein PBRA_000291 [Plasmodiophora brassicae] diamond 657 86.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28409883 28409883 PRJNA704949_P_NODE_66806_length_939_cov_2.078652_g55409_i0 PRJNA704949 66806 939 2.078652 19.51854228 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 110 6.539999999999999e-23   NR CEO98020.1 37360 g55409 i0 27.8 0.757188498402556 237 167 75.7 2 164 874 148 380 CEO98020.1 hypothetical protein PBRA_006134 [Plasmodiophora brassicae] diamond 711 110 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28578361 28578361 PRJNA704949_P_NODE_174247_length_621_cov_2.043706_g160444_i0 PRJNA704949 174247 621 2.043706 12.69141426 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 145 1.71e-37   NR CEO97007.1 37360 g160444 i0 43.8 5.81159420289855 192 95 88.9 4 70 621 59 245 CEO97007.1 hypothetical protein PBRA_005611 [Plasmodiophora brassicae] diamond 3609 146 0.993150684931507 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28819646 28819646 PRJNA704949_P_NODE_171488_length_625_cov_2.765625_g157731_i0 PRJNA704949 171488 625 2.765625 17.28515625 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 62 3.3e-7   NR SPQ94367.1 37360 g157731 i0 31.9 1.9584 204 115 94.6 8 624 34 1579 1765 SPQ94367.1 unnamed protein product [Plasmodiophora brassicae] diamond 1224 62 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28862360 28862360 PRJNA704949_P_NODE_2020488_length_166_cov_1.564103_g2005149_i0 PRJNA704949 2020488 166 1.564103 2.59641098 root 1 Root_unresolved Root_unresolved 44.7 0.00281   NR CEO94767.1 37360 g2005149 i0 47.8 3.21686746987952 46 20 83.1 1 139 2 378 419 CEO94767.1 hypothetical protein PBRA_003580 [Plasmodiophora brassicae] diamond 534 45.1 0.991130820399113 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29956676 29956676 PRJNA704949_P_NODE_1804631_length_177_cov_1.625000_g1789292_i0 PRJNA704949 1804631 177 1.625 2.87625 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 42 0.029   NR SPQ98830.1 37360 g1789292 i0 33.9 2.10169491525424 62 35 98.3 2 176 3 315 374 SPQ98830.1 unnamed protein product [Plasmodiophora brassicae] diamond 372 42 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30378756 30378756 PRJNA704949_P_NODE_1846232_length_174_cov_1.664000_g1830893_i0 PRJNA704949 1846232 174 1.664 2.89536 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.5 4.72e-7   NR CEP03923.1 37360 g1830893 i0 55.8 2.82758620689655 43 19 74.1 0 142 14 515 557 CEP03923.1 hypothetical protein PBRA_003530 [Plasmodiophora brassicae] diamond 492 55.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30473281 30473281 PRJNA704949_P_NODE_1612693_length_192_cov_1.034965_g1597354_i0 PRJNA704949 1612693 192 1.034965 1.9871328 root 1 Root_unresolved Root_unresolved 85.9 1.22e-17   NR CEO96988.1 37360 g1597354 i0 64.5 3.875 62 22 96.9 0 1 186 175 236 CEO96988.1 hypothetical protein PBRA_005592 [Plasmodiophora brassicae] diamond 744 85.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31062979 31062979 PRJNA704949_P_NODE_440555_length_410_cov_2.138504_g425369_i0 PRJNA704949 440555 410 2.138504 8.7678664 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 124 7.519999999999999e-31   NR SPQ96831.1 37360 g425369 i0 83.6 2.45121951219512 67 11 49 0 1 201 96 162 SPQ96831.1 unnamed protein product [Plasmodiophora brassicae] diamond 1005 124 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32275569 32275569 PRJNA704949_P_NODE_1759958_length_180_cov_1.984733_g1744619_i0 PRJNA704949 1759958 180 1.984733 3.5725194 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 72.4 5.09e-13   NR CEO99505.1 37360 g1744619 i0 70.5 5.66666666666667 44 13 73.3 0 2 133 209 252 CEO99505.1 hypothetical protein PBRA_007238 [Plasmodiophora brassicae] diamond 1020 72.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32328427 32328427 PRJNA704949_P_NODE_764539_length_306_cov_1.595331_g749208_i0 PRJNA704949 764539 306 1.595331 4.88171286 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 57 8.02e-7   NR CEO96619.1 37360 g749208 i0 35.8 0.931372549019608 95 56 91.2 2 289 11 1730 1821 CEO96619.1 hypothetical protein PBRA_005228 [Plasmodiophora brassicae] diamond 285 57 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae

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