RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "blastn", bioproject = "PRJNA493827" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 24 ✖

tax_clade 1

bioproject 1

  • PRJNA493827 · 24 ✖

analysis 1

  • blastn · 24 ✖

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
470368 470368 PRJNA493827_P_NODE_137041_length_291_cov_4.711009_g134843_i0 PRJNA493827 137041 291 4.711009 13.70903619 Guinardia striata 1514137 SAR_Eukaryotes SAR_Eukaryotes 143 1.56e-29   NTclustered gi|2202538957|gb|OM891863.1| 1514137 g134843 i0 81.977 4.46048109965636 172 27 58 3 122 291 6053 5884 Guinardia striata small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 1298 143 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia striata
1746517 1746517 PRJNA493827_P_NODE_198182_length_248_cov_0.880000_g195984_i0 PRJNA493827 198182 248 0.88 2.1824 Nitzschia ovalis 908985 SAR_Eukaryotes SAR_Eukaryotes 364 2.539999999999999e-96   NTclustered gi|2199203432|ref|NC_061046.1| 908985 g195984 i0 93.145 103.568548387097 248 17 100 0 1 248 51377 51624 Nitzschia ovalis chloroplast, complete genome blastn 25685 364 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia ovalis
1746875 1746875 PRJNA493827_P_NODE_215722_length_244_cov_2.163743_g213524_i0 PRJNA493827 215722 244 2.163743 5.27953292 Guinardia striata 1514137 SAR_Eukaryotes SAR_Eukaryotes 148 2.7299999999999997e-31   NTclustered gi|2074156236|gb|MW413904.1| 1514137 g213524 i0 78.689 43.5819672131148 244 36 98 15 3 242 32114 32345 Guinardia striata mitochondrion, complete genome blastn 10634 148 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia striata
1747906 1747906 PRJNA493827_P_NODE_43282_length_551_cov_0.926778_g41096_i0 PRJNA493827 43282 551 0.926778 5.10654678 Hemiaulus sinensis 1003062 SAR_Eukaryotes SAR_Eukaryotes 320 1.35e-82   NTclustered gi|2248495916|ref|NC_063458.1| 1003062 g41096 i0 79.913 139.911070780399 458 75 81 11 95 543 30511 30960 Hemiaulus sinensis isolate Qingdao in China mitochondrion, complete genome blastn 77091 320 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Hemiaulus Hemiaulus sinensis
1748373 1748373 PRJNA493827_P_NODE_61762_length_447_cov_1.203209_g59565_i0 PRJNA493827 61762 447 1.203209 5.37834423 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 327 6.42e-85   NTclustered gi|657012367|gb|KF302531.1| 2850 g59565 i0 85.266 4.92841163310962 319 45 71 2 1 318 76 393 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 2203 327 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
3023431 3023431 PRJNA493827_P_NODE_2823_length_2594_cov_6.650139_g2361_i0 PRJNA493827 2823 2594 6.650139 172.50460566 Eucampia zodiacus 444606 SAR_Eukaryotes SAR_Eukaryotes 257 5.31e-63   NTclustered gi|2026158947|ref|NC_054334.1| 444606 g2361 i0 72.025 13.674633770239 1126 231 42 59 110 1205 28314 29385 Eucampia zodiacus strain CNS00060 mitochondrion, complete genome blastn 35472 257 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Eucampia Eucampia zodiacus
3656256 3656256 PRJNA493827_P_NODE_174503_length_258_cov_3.681081_g172305_i0 PRJNA493827 174503 258 3.681081 9.49718898 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|2751573237|gb|PP962257.1| 1951536 g172305 i0 90.698 4.77131782945736 43 2 16 2 95 136 31609 31568 Halamphora sp. strain SZCZEY 2167 mitochondrion, complete genome blastn 1231 56.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora sp.
3656533 3656533 PRJNA493827_P_NODE_214503_length_245_cov_0.895349_g212305_i0 PRJNA493827 214503 245 0.895349 2.19360505 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 392 1.15e-104   NTclustered gi|2127877134|ref|NC_058783.1| 37318 g212305 i0 95.868 109.004081632653 242 10 99 0 1 242 89071 89312 Pseudo-nitzschia pungens isolate CNS00141 chloroplast, complete genome blastn 26706 392 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
4932732 4932732 PRJNA493827_P_NODE_106904_length_331_cov_1.193798_g104706_i0 PRJNA493827 106904 331 1.193798 3.95147138 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 573 5.379999999999998e-159   NTclustered gi|1803023461|gb|MN937452.1| 2850 g104706 i0 97.885 196.824773413897 331 7 100 0 1 331 68568 68898 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 65149 573 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
5575817 5575817 PRJNA493827_P_NODE_2285_length_2892_cov_14.389145_g1889_i0 PRJNA493827 2285 2892 14.389145 416.1340734 Navicula incertata 2014769 SAR_Eukaryotes SAR_Eukaryotes 182 3.67e-40   NTclustered gi|2866543349|gb|PQ722532.1| 2014769 g1889 i0 83.854 11.0968188105118 192 29 7 2 1879 2069 45611 45421 Navicula incertata mitochondrion, complete genome blastn 32092 182 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula incertata
6847159 6847159 PRJNA493827_P_NODE_105866_length_332_cov_3.436293_g103668_i0 PRJNA493827 105866 332 3.436293 11.40849276 Minutocellus polymorphus 265543 SAR_Eukaryotes SAR_Eukaryotes 126 1.82e-24   NTclustered gi|2020303798|gb|MW417227.1| 265543 g103668 i0 77.934 3.59036144578313 213 39 63 7 109 317 8483 8691 Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome blastn 1192 126 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Minutocellus Minutocellus polymorphus
6850210 6850210 PRJNA493827_P_NODE_29806_length_687_cov_1.369707_g27750_i0 PRJNA493827 29806 687 1.369707 9.40988709 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 789 0   NTclustered gi|657012562|gb|KF302618.1| 2850 g27750 i0 87.446 95.0334788937409 693 77 100 6 1 687 739 51 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 65288 789 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
6850746 6850746 PRJNA493827_P_NODE_48606_length_513_cov_2.384091_g46416_i0 PRJNA493827 48606 513 2.384091 12.23038683 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 403 1.1999999999999997e-107   NTclustered gi|657012465|gb|KF302574.1| 2850 g46416 i0 87.791 18.4678362573099 344 42 67 0 64 407 1 344 Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds blastn 9474 403 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
8127001 8127001 PRJNA493827_P_NODE_79887_length_385_cov_2.108974_g77689_i0 PRJNA493827 79887 385 2.108974 8.1195499 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 689 0   NTclustered gi|2633519340|gb|OR805654.1| 2126271 g77689 i0 98.961 199.963636363636 385 4 100 0 1 385 123085 123469 Naviculales sp. strain SZCZO2114 plastid, complete genome blastn 76986 689 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
9399251 9399251 PRJNA493827_P_NODE_179528_length_254_cov_2.060773_g177330_i0 PRJNA493827 179528 254 2.060773 5.23436342 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 75 4.92e-9   NTclustered gi|1819718724|gb|MN956530.1| 2850 g177330 i0 84.211 0.598425196850394 76 12 30 0 34 109 3500 3575 Phaeodactylum tricornutum strain ICE-H mitochondrion, complete genome blastn 152 75 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
13223622 13223622 PRJNA493827_P_NODE_116491_length_316_cov_3.267490_g114293_i0 PRJNA493827 116491 316 3.26749 10.3252684 Attheya septentrionalis 420275 SAR_Eukaryotes SAR_Eukaryotes 396 1.1899999999999997e-105   NTclustered gi|2632235279|gb|OR922661.1| 420275 g114293 i0 89.557 100.009493670886 316 28 100 4 1 316 3562 3252 Attheya septentrionalis strain AGSB0004 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 31603 396 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya septentrionalis
13858696 13858696 PRJNA493827_P_NODE_166951_length_265_cov_1.250000_g164753_i0 PRJNA493827 166951 265 1.25 3.3125 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 132 3.02e-26   NTclustered gi|9885790|gb|AF289048.1|AF289048 3005 g164753 i0 87.611 31.3132075471698 113 14 43 0 31 143 2269 2157 Rhizosolenia setigera internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 8298 132 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Sundstroemia Sundstroemia setigera
17050062 17050062 PRJNA493827_P_NODE_36134_length_614_cov_1.510166_g33973_i0 PRJNA493827 36134 614 1.510166 9.27241924 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 451 5.14e-122   NTclustered gi|657012367|gb|KF302531.1| 2850 g33973 i0 90.407 55.200325732899 344 31 56 2 272 614 390 48 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 33893 451 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
19598244 19598244 PRJNA493827_P_NODE_233196_length_241_cov_0.916667_g230998_i0 PRJNA493827 233196 241 0.916667 2.20916747 Eunotia naegelii 1458866 SAR_Eukaryotes SAR_Eukaryotes 374 4.079999999999998e-99   NTclustered gi|699008555|ref|NC_024928.1| 1458866 g230998 i0 94.606 126.51867219917 241 13 100 0 1 241 89673 89433 Eunotia naegelii chloroplast, complete genome blastn 30491 374 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii
20871307 20871307 PRJNA493827_P_NODE_103697_length_336_cov_1.574144_g101499_i0 PRJNA493827 103697 336 1.574144 5.28912384 Nitzschia traheaformis 1881117 SAR_Eukaryotes SAR_Eukaryotes 134 1.1e-26   NTclustered gi|2073953246|gb|MW849269.1| 1881117 g101499 i0 79.5 5.23809523809524 200 31 58 9 95 289 45929 46123 Nitzschia traheaformis isolate Qingdao in China mitochondrion, complete genome blastn 1760 134 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia traheaformis
22150468 22150468 PRJNA493827_P_NODE_79658_length_386_cov_1.316294_g77460_i0 PRJNA493827 79658 386 1.316294 5.08089484 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 296 1.54e-75   NTclustered gi|219112330|ref|XM_002177881.1| 556484 g77460 i0 82.022 56.8575129533679 356 56 90 4 1 349 797 443 Phaeodactylum tricornutum CCAP 1055/1 predicted protein (atpB), mRNA blastn 21947 296 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
22781859 22781859 PRJNA493827_P_NODE_125618_length_305_cov_1.267241_g123420_i0 PRJNA493827 125618 305 1.267241 3.86508505 root 1 Root_unresolved Root_unresolved 529 1.0799999999999996e-145   NTclustered gi|197359040|gb|FJ002189.1| 29204 g123420 i0 98.658 110.983606557377 298 4 98 0 7 304 438 735 Cyclotella cryptica isolate C114 16S ribosomal RNA gene, partial sequence; chloroplast blastn 33850 529 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
23421934 23421934 PRJNA493827_P_NODE_103219_length_337_cov_1.174242_g101021_i0 PRJNA493827 103219 337 1.174242 3.95719554 Eunotia naegelii 1458866 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.032   NTclustered gi|699008555|ref|NC_024928.1| 1458866 g101021 i0 100 0.166172106824926 28 0 8 0 19 46 81126 81099 Eunotia naegelii chloroplast, complete genome blastn 56 52.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii
23423545 23423545 PRJNA493827_P_NODE_175239_length_258_cov_1.356757_g173041_i0 PRJNA493827 175239 258 1.356757 3.50043306 Craticula sp. RGastineau-2025a 3393937 SAR_Eukaryotes SAR_Eukaryotes 279 9.9e-71   NTclustered gi|2906190882|gb|PV031684.1| 3393937 g173041 i0 86.312 12.1550387596899 263 29 100 7 1 258 61942 62202 Craticula sp. RGastineau-2025a strain SZCZEY2171 mitochondrion, complete genome blastn 3136 279 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Craticula Craticula sp. RGastineau-2025a

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