RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "blastn", bioproject = "PRJNA1073183" and tax_phylum = "Haptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Haptophyta · 22 ✖

tax_clade 1

bioproject 1

  • PRJNA1073183 · 22 ✖

analysis 1

  • blastn · 22 ✖

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
187344 187344 PRJNA1073183_P_NODE_30781_length_246_cov_0.890173_g30686_i0 PRJNA1073183 30781 246 0.890173 2.18982558 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 455 1.4500000000000002e-123   NTclustered gi|551627571|ref|XM_005793710.1| 280463 g30686 i0 100 1.46747967479675 246 0 100 0 1 246 1228 983 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 361 455 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
1016036 1016036 PRJNA1073183_P_NODE_26781_length_251_cov_0.865169_g26686_i0 PRJNA1073183 26781 251 0.865169 2.17157419 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 459 1.1499999999999996e-124   NTclustered gi|2235062516|gb|OL703629.1| 2903 g26686 i0 99.602 81.0756972111554 251 1 100 0 1 251 15393 15643 Emiliania huxleyi strain Van556 mitochondrion, partial genome blastn 20350 459 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
1016067 1016067 PRJNA1073183_P_NODE_401_length_1665_cov_2.893216_g373_i0 PRJNA1073183 401 1665 2.893216 48.1720464 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 3075 0   NTclustered gi|2530650642|gb|ON844104.1| 2903 g373 i0 100 85.2882882882883 1665 0 100 0 1 1665 97716 99380 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 142005 3075 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
2291474 2291474 PRJNA1073183_P_NODE_5322_length_550_cov_1.259958_g5229_i0 PRJNA1073183 5322 550 1.259958 6.929769 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 1016 0   NTclustered gi|2530650642|gb|ON844104.1| 2903 g5229 i0 100 100.645454545455 550 0 100 0 1 550 19589 20138 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 55355 1016 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
3566704 3566704 PRJNA1073183_P_NODE_32383_length_244_cov_0.900585_g32288_i0 PRJNA1073183 32383 244 0.900585 2.1974274 Emiliania 2902 Haptophyta other_Eukaryota 446 8.639999999999999e-121   NTclustered gi|112131799|gb|DQ658247.1| 2903 g32288 i0 99.59 2 244 1 100 0 1 244 422 179 Emiliania huxleyi clone seq197.fasta.Contig5 mRNA sequence blastn 488 446 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
4013700 4013700 PRJNA1073183_P_NODE_26784_length_251_cov_0.865169_g26689_i0 PRJNA1073183 26784 251 0.865169 2.17157419 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 97.1 1.04e-15   NTclustered gi|551615762|ref|XM_005788689.1| 280463 g26689 i0 86.364 15.9721115537849 88 12 35 0 161 248 498 585 Emiliania huxleyi CCMP1516 putative histone H2B mRNA blastn 4009 97.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
6119269 6119269 PRJNA1073183_P_NODE_6145_length_511_cov_1.757991_g6052_i0 PRJNA1073183 6145 511 1.757991 8.98333401 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 944 0   NTclustered gi|2530650642|gb|ON844104.1| 2903 g6052 i0 100 109.6771037182 511 0 100 0 1 511 46684 47194 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 56045 944 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
11219522 11219522 PRJNA1073183_P_NODE_26849_length_251_cov_0.865169_g26754_i0 PRJNA1073183 26849 251 0.865169 2.17157419 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 464 2.47e-126   NTclustered gi|2530650642|gb|ON844104.1| 2903 g26754 i0 100 37.5657370517928 251 0 100 0 1 251 68872 68622 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 9429 464 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
11219560 11219560 PRJNA1073183_P_NODE_6329_length_504_cov_2.368910_g6236_i0 PRJNA1073183 6329 504 2.36891 11.9393064 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 926 0   NTclustered gi|2530650642|gb|ON844104.1| 2903 g6236 i0 99.802 101.771825396825 504 1 100 0 1 504 92849 93352 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 51293 926 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
12494862 12494862 PRJNA1073183_P_NODE_1010_length_1169_cov_12.167883_g961_i0 PRJNA1073183 1010 1169 12.167883 142.24255227 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 2159 0   NTclustered gi|2530650642|gb|ON844104.1| 2903 g961 i0 100 87.3447390932421 1169 0 100 0 1 1169 99662 100830 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 102106 2159 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
12494883 12494883 PRJNA1073183_P_NODE_17710_length_311_cov_1.294118_g17615_i0 PRJNA1073183 17710 311 1.294118 4.02470698 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 575 1.3899999999999995e-159   NTclustered gi|39753085|gb|AY391395.1| 2903 g17615 i0 100 78.4340836012862 311 0 100 0 1 311 553 863 Emiliania huxleyi strain SAG 33.90 photosystem I P700 chlorophyll a apoprotein A2 (psaB) gene, partial cds; chloroplast blastn 24393 575 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
14215754 14215754 PRJNA1073183_P_NODE_14032_length_346_cov_1.985348_g13937_i0 PRJNA1073183 14032 346 1.985348 6.86930408 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 193 1.85e-44   NTclustered gi|551548842|ref|XM_005762007.1| 280463 g13937 i0 80.632 56.7745664739884 253 45 73 2 12 262 151 401 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 19644 193 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
16764041 16764041 PRJNA1073183_P_NODE_17594_length_312_cov_1.288703_g17499_i0 PRJNA1073183 17594 312 1.288703 4.02075336 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 569 6.509999999999998e-158   NTclustered gi|551564253|ref|XM_005768650.1| 280463 g17499 i0 99.678 79.25 311 1 99 0 2 312 88 398 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 24726 569 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
16764276 16764276 PRJNA1073183_P_NODE_31394_length_245_cov_0.895349_g31299_i0 PRJNA1073183 31394 245 0.895349 2.19360505 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 436 5.229999999999999e-118   NTclustered gi|551580016|ref|XM_005775510.1| 280463 g31299 i0 98.776 5.3469387755102 245 3 100 0 1 245 515 759 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 1310 436 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
17593885 17593885 PRJNA1073183_P_NODE_4474_length_598_cov_1.173333_g4382_i0 PRJNA1073183 4474 598 1.173333 7.01653134 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 1105 0   NTclustered gi|2530650642|gb|ON844104.1| 2903 g4382 i0 100 101.408026755853 598 0 100 0 1 598 95392 94795 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 60642 1105 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
18867630 18867630 PRJNA1073183_P_NODE_1275_length_1061_cov_3.140688_g1217_i0 PRJNA1073183 1275 1061 3.140688 33.32269968 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 1960 0   NTclustered gi|2530650642|gb|ON844104.1| 2903 g1217 i0 100 99.5004712535344 1061 0 100 0 1 1061 48886 47826 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 105570 1960 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
19313121 19313121 PRJNA1073183_P_NODE_34256_length_241_cov_0.916667_g34161_i0 PRJNA1073183 34256 241 0.916667 2.20916747 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 446 8.519999999999999e-121   NTclustered gi|551580188|ref|XM_005775596.1| 280463 g34161 i0 100 2.60165975103734 241 0 100 0 1 241 17040 17280 Emiliania huxleyi CCMP1516 polyketide synthase (PKS3), partial mRNA blastn 627 446 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
21418115 21418115 PRJNA1073183_P_NODE_23397_length_270_cov_1.172589_g23302_i0 PRJNA1073183 23397 270 1.172589 3.1659903 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 499 7.349999999999998e-137   NTclustered gi|2530650642|gb|ON844104.1| 2903 g23302 i0 100 35.9 270 0 100 0 1 270 43495 43764 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 9693 499 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
22693052 22693052 PRJNA1073183_P_NODE_3698_length_654_cov_1.987952_g3609_i0 PRJNA1073183 3698 654 1.987952 13.00120608 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 1208 0   NTclustered gi|2530650642|gb|ON844104.1| 2903 g3609 i0 100 91.0107033639144 654 0 100 0 1 654 15488 16141 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 59521 1208 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
22693060 22693060 PRJNA1073183_P_NODE_7758_length_458_cov_1.155844_g7664_i0 PRJNA1073183 7758 458 1.155844 5.29376552 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 841 0   NTclustered gi|2530650642|gb|ON844104.1| 2903 g7664 i0 99.782 101.076419213974 458 1 100 0 1 458 93422 93879 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 46293 841 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
23968442 23968442 PRJNA1073183_P_NODE_16239_length_324_cov_1.649402_g16144_i0 PRJNA1073183 16239 324 1.649402 5.34406248 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 599 8.67e-167   NTclustered gi|2530650642|gb|ON844104.1| 2903 g16144 i0 100 38.5740740740741 324 0 100 0 1 324 13694 13371 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 12498 599 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
25242371 25242371 PRJNA1073183_P_NODE_26740_length_251_cov_0.865169_g26645_i0 PRJNA1073183 26740 251 0.865169 2.17157419 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 464 2.47e-126   NTclustered gi|2530650642|gb|ON844104.1| 2903 g26645 i0 100 43.4900398406375 251 0 100 0 1 251 6330 6580 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 10916 464 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi

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