RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA638138" and tax_phylum = "Rhodophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rhodophyta · 19 ✖

bioproject 1

  • PRJNA638138 · 19 ✖

analysis 1

  • diamond · 19 ✖

tax_kingdom 0

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
26605975 26605975 PRJNA638138_P_NODE_21721_length_250_cov_0.870056_g21506_i0 PRJNA638138 21721 250 0.870056 2.17514 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 83.6 6.46e-17   NR KAK1869382.1 2788 g21506 i0 61.2 0.804 67 26 80.4 0 214 14 230 296 KAK1869382.1 hypothetical protein I4F81_011859 [Pyropia yezoensis] diamond 201 83.6 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
26796227 26796227 PRJNA638138_P_NODE_16221_length_273_cov_0.855000_g16006_i0 PRJNA638138 16221 273 0.855 2.33415 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 65.5 1.07e-10   NR KAK1859987.1 2788 g16006 i0 84.2 0.417582417582418 38 6 41.8 0 2 115 150 187 KAK1859987.1 hypothetical protein I4F81_002579 [Pyropia yezoensis] diamond 114 65.5 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
27270603 27270603 PRJNA638138_P_NODE_20483_length_251_cov_0.780899_g20268_i0 PRJNA638138 20483 251 0.780899 1.96005649 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 59.7 4.44e-8   NR KAK1860304.1 2788 g20268 i0 43.2 0.968127490039841 81 45 96.8 1 5 247 65 144 KAK1860304.1 hypothetical protein I4F81_002893 [Pyropia yezoensis] diamond 243 59.7 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
27270608 27270608 PRJNA638138_P_NODE_2843_length_566_cov_1.111562_g2631_i0 PRJNA638138 2843 566 1.111562 6.29144092 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 171 7.76e-47   NR KAK1868637.1 2788 g2631 i0 96.6 0.46643109540636 88 3 46.6 0 141 404 475 562 KAK1868637.1 hypothetical protein I4F81_011122 [Pyropia yezoensis] diamond 264 171 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
27997104 27997104 PRJNA638138_P_NODE_27505_length_246_cov_0.890173_g27290_i0 PRJNA638138 27505 246 0.890173 2.18982558 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 132 1.58e-36   NR KAK1861470.1 2788 g27290 i0 97.5 0.963414634146341 79 2 96.3 0 238 2 1 79 KAK1861470.1 hypothetical protein I4F81_004054 [Pyropia yezoensis] diamond 237 132 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
28344261 28344261 PRJNA638138_P_NODE_30286_length_244_cov_0.900585_g30071_i0 PRJNA638138 30286 244 0.900585 2.1974274 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 81.6 7.77e-16   NR KAK1860304.1 2788 g30071 i0 50.7 0.848360655737705 69 34 84.8 0 207 1 1 69 KAK1860304.1 hypothetical protein I4F81_002893 [Pyropia yezoensis] diamond 207 81.6 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
28893361 28893361 PRJNA638138_P_NODE_13088_length_299_cov_0.911504_g12873_i0 PRJNA638138 13088 299 0.911504 2.72539696 Pyropia 1094566 Rhodophyta other_Eukaryota 84 2.46e-16   NR KAK1860304.1 2788 g12873 i0 48.8 1.54515050167224 82 42 82.3 0 50 295 203 284 KAK1860304.1 hypothetical protein I4F81_002893 [Pyropia yezoensis] diamond 462 84.7 0.991735537190083 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
29449146 29449146 PRJNA638138_P_NODE_16170_length_273_cov_1.175000_g15955_i0 PRJNA638138 16170 273 1.175 3.20775 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 97.8 2.44e-21   NR KAK1860304.1 2788 g15955 i0 44 1 91 51 100 0 273 1 766 856 KAK1860304.1 hypothetical protein I4F81_002893 [Pyropia yezoensis] diamond 273 97.8 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
29575469 29575469 PRJNA638138_P_NODE_24750_length_248_cov_0.880000_g24535_i0 PRJNA638138 24750 248 0.88 2.1824 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 73.2 5.35e-13   NR KAK1867307.1 2788 g24535 i0 47.5 3.87096774193548 80 42 96.8 0 8 247 121 200 KAK1867307.1 hypothetical protein I4F81_009814 [Pyropia yezoensis] diamond 960 73.2 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
29954661 29954661 PRJNA638138_P_NODE_21671_length_250_cov_0.870056_g21456_i0 PRJNA638138 21671 250 0.870056 2.17514 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 132 1.24e-33   NR KAK1870284.1 2788 g21456 i0 98.8 0.996 83 1 99.6 0 250 2 879 961 KAK1870284.1 hypothetical protein I4F81_012746 [Pyropia yezoensis] diamond 249 132 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
30143829 30143829 PRJNA638138_P_NODE_31332_length_244_cov_0.795322_g31117_i0 PRJNA638138 31332 244 0.795322 1.94058568 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 115 9.87e-28   NR KAK1860304.1 2788 g31117 i0 64.6 1.00819672131148 82 28 99.6 1 2 244 592 673 KAK1860304.1 hypothetical protein I4F81_002893 [Pyropia yezoensis] diamond 246 115 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
30523286 30523286 PRJNA638138_P_NODE_23873_length_248_cov_0.880000_g23658_i0 PRJNA638138 23873 248 0.88 2.1824 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 146 2.75e-39   NR KAK1868825.1 2788 g23658 i0 100 0.967741935483871 80 0 96.8 0 247 8 463 542 KAK1868825.1 hypothetical protein I4F81_011308 [Pyropia yezoensis] diamond 240 146 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
30554754 30554754 PRJNA638138_P_NODE_26533_length_247_cov_0.885057_g26318_i0 PRJNA638138 26533 247 0.885057 2.18609079 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 62.8 3.35e-9   NR KAK1867712.1 2788 g26318 i0 100 0.364372469635628 30 0 36.4 0 3 92 656 685 KAK1867712.1 hypothetical protein I4F81_010215 [Pyropia yezoensis] diamond 90 62.8 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
30870858 30870858 PRJNA638138_P_NODE_11634_length_313_cov_1.170833_g11419_i0 PRJNA638138 11634 313 1.170833 3.66470729 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 142 6.419999999999999e-37   NR KAK1860304.1 2788 g11419 i0 62.1 0.987220447284345 103 38 98.7 1 3 311 1083 1184 KAK1860304.1 hypothetical protein I4F81_002893 [Pyropia yezoensis] diamond 309 142 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
31060746 31060746 PRJNA638138_P_NODE_10295_length_328_cov_0.843137_g10080_i0 PRJNA638138 10295 328 0.843137 2.76548936 Pyropia vietnamensis 683352 Rhodophyta other_Eukaryota 72.4 1.32e-12   NR GAB0494486.1 683352 g10080 i0 39.4 0.996951219512195 109 55 92.4 4 307 5 1 106 GAB0494486.1 hypothetical protein MMPV_005780 [Pyropia vietnamensis] diamond 327 72.4 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia vietnamensis
31250008 31250008 PRJNA638138_P_NODE_24035_length_248_cov_0.880000_g23820_i0 PRJNA638138 24035 248 0.88 2.1824 Pyropia yezoensis 2788 Rhodophyta other_Eukaryota 169 9.76e-47   NR KAK1869336.1 2788 g23820 i0 97.6 3.96774193548387 82 2 99.2 0 246 1 1371 1452 KAK1869336.1 hypothetical protein I4F81_011813 [Pyropia yezoensis] diamond 984 169 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia yezoensis
32072527 32072527 PRJNA638138_P_NODE_29638_length_245_cov_0.895349_g29423_i0 PRJNA638138 29638 245 0.895349 2.19360505 Pyropia vietnamensis 683352 Rhodophyta other_Eukaryota 58.5 8.4e-8   NR GAB0498120.1 683352 g29423 i0 55.1 4.8 49 22 60 0 239 93 194 242 GAB0498120.1 hypothetical protein MMPV_009461 [Pyropia vietnamensis] diamond 1176 58.5 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia vietnamensis
32135930 32135930 PRJNA638138_P_NODE_24078_length_248_cov_0.880000_g23863_i0 PRJNA638138 24078 248 0.88 2.1824 Pyropia vietnamensis 683352 Rhodophyta other_Eukaryota 48.5 3.65e-4   NR GAB0495694.1 683352 g23863 i0 38.2 4.07661290322581 68 42 82.3 0 3 206 728 795 GAB0495694.1 hypothetical protein MMPV_006999 [Pyropia vietnamensis] diamond 1011 48.5 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia vietnamensis
32830660 32830660 PRJNA638138_P_NODE_13480_length_295_cov_1.072072_g13265_i0 PRJNA638138 13480 295 1.072072 3.1626124 Pyropia vietnamensis 683352 Rhodophyta other_Eukaryota 97.8 3.0600000000000003e-21   NR GAB0498675.1 683352 g13265 i0 56.2 3.66101694915254 89 39 90.5 0 275 9 194 282 GAB0498675.1 hypothetical protein MMPV_010022 [Pyropia vietnamensis] diamond 1080 97.8 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia vietnamensis

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