RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJEB66218" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 10 ✖

tax_clade 1

bioproject 1

  • PRJEB66218 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
2684704 2684704 PRJEB66218_P_NODE_89623_length_328_cov_2.838951_g87196_i0 PRJEB66218 89623 328 2.838951 9.31175928 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 148 3.829999999999999e-31   NTclustered gi|223997043|ref|XM_002288159.1| 296543 g87196 i0 83.03 28.3536585365854 165 26 50 2 8 171 274 111 Thalassiosira pseudonana CCMP1335 histone H2B mRNA blastn 9300 148 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
5234259 5234259 PRJEB66218_P_NODE_168585_length_228_cov_1.610778_g166155_i0 PRJEB66218 168585 228 1.610778 3.67257384 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 327 3.02e-85   NTclustered gi|146762526|gb|EF553458.1| 2850 g166155 i0 92.576 54.890350877193 229 16 100 1 1 228 4462 4234 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 12515 327 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
6512352 6512352 PRJEB66218_P_NODE_72746_length_375_cov_1.818471_g70321_i0 PRJEB66218 72746 375 1.818471 6.81926625 Pleurosigma sp. mgcode 4 2914906 SAR_Eukaryotes SAR_Eukaryotes 104 9.72e-18   NTclustered gi|2076000669|gb|MW861541.1| 2914906 g70321 i0 82.353 0.317333333333333 119 21 32 0 143 261 34902 35020 Pleurosigma sp. mgcode 4 isolate Qingdao in China mitochondrion, complete genome blastn 119 104 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pleurosigmataceae Pleurosigma Pleurosigma sp. mgcode 4
7371791 7371791 PRJEB66218_P_NODE_147446_length_243_cov_5.346154_g145017_i0 PRJEB66218 147446 243 5.346154 12.99115422 Skeletonema 2842 SAR_Eukaryotes SAR_Eukaryotes 97.1 9.98e-16   NTclustered gi|1169296928|gb|KY364698.1| 2843 g145017 i0 96.552 23.9341563786008 58 2 24 0 1 58 4365 4422 Skeletonema costatum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 5816 97.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
7787103 7787103 PRJEB66218_P_NODE_94607_length_317_cov_2.023438_g92179_i0 PRJEB66218 94607 317 2.023438 6.41429846 Cocconeiopsis kantsiensis 3082010 SAR_Eukaryotes SAR_Eukaryotes 104 8.08e-18   NTclustered gi|2692958369|ref|NC_086887.1| 3082010 g92179 i0 84.112 1.38485804416404 107 17 34 0 5 111 18668 18774 Cocconeiopsis kantsiensis isolate Huiquan Bay in China mitochondrion, complete genome blastn 439 104 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeiopsis Cocconeiopsis kantsiensis
9060756 9060756 PRJEB66218_P_NODE_44708_length_515_cov_3.200441_g42296_i0 PRJEB66218 44708 515 3.200441 16.48227115 Paralia sulcata 216927 SAR_Eukaryotes SAR_Eukaryotes 220 1.3099999999999999e-52   NTclustered gi|2074156086|gb|MW413901.1| 216927 g42296 i0 80.656 61.0349514563107 305 41 56 9 30 319 20274 19973 Paralia sulcata mitochondrion, complete genome blastn 31433 220 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Paraliales Paraliaceae Paralia Paralia sulcata
10336268 10336268 PRJEB66218_P_NODE_35289_length_603_cov_33.928044_g32909_i0 PRJEB66218 35289 603 33.928044 204.58610532 Minutocellus polymorphus 265543 SAR_Eukaryotes SAR_Eukaryotes 132 7.450000000000001e-26   NTclustered gi|2020303798|gb|MW417227.1| 265543 g32909 i0 78.404 1.97678275290216 213 38 35 7 242 450 8691 8483 Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome blastn 1192 132 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Minutocellus Minutocellus polymorphus
14162724 14162724 PRJEB66218_P_NODE_75832_length_365_cov_3.023026_g73406_i0 PRJEB66218 75832 365 3.023026 11.0340449 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 523 6.109999999999999e-144   NTclustered gi|146762526|gb|EF553458.1| 2850 g73406 i0 92.623 100.854794520548 366 24 100 3 1 365 4139 4502 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 36812 523 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
18846182 18846182 PRJEB66218_P_NODE_19695_length_889_cov_3.119565_g17648_i0 PRJEB66218 19695 889 3.119565 27.73293285 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 1295 0   NTclustered gi|1803023461|gb|MN937452.1| 2850 g17648 i0 93.107 196.955005624297 885 60 99 1 1 885 67816 68699 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 175093 1295 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
20533126 20533126 PRJEB66218_P_NODE_19657_length_890_cov_10.197829_g17613_i0 PRJEB66218 19657 890 10.197829 90.7606781 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 422 5.94e-113   NTclustered gi|657012367|gb|KF302531.1| 2850 g17613 i0 87.637 60.3539325842697 364 43 41 2 249 611 23 385 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 53715 422 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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