RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA758088", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 18 ✖

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA758088 · 18 ✖

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
735068 735068 PRJNA758088_P_NODE_169561_length_325_cov_1.535714_g162590_i0 PRJNA758088 169561 325 1.535714 4.9910705 Chaetoceros neogracilis 240364 SAR_Eukaryotes SAR_Eukaryotes 492 1.5199999999999999e-134   NTclustered gi|2862228897|gb|PQ645531.1| 240364 g162590 i0 94.637 96.44 317 17 98 0 6 322 3527 3843 Chaetoceros neogracilis isolate AGSB0402 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 31343 492 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros neogracilis
18588893 18588893 PRJNA758088_P_NODE_305455_length_248_cov_0.880000_g298484_i0 PRJNA758088 305455 248 0.88 2.1824 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 442 1.1399999999999995e-119   NTclustered gi|219120950|ref|XM_002185671.1| 556484 g298484 i0 98.79 31.3709677419355 248 3 100 0 1 248 451 698 Phaeodactylum tricornutum CCAP 1055/1 predicted protein mRNA blastn 7780 442 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
21140461 21140461 PRJNA758088_P_NODE_358517_length_242_cov_0.911243_g351546_i0 PRJNA758088 358517 242 0.911243 2.20520806 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 93.2 5.74e-20   NR KAI2494109.1 210448 g351546 i0 52.9 2.04545454545455 85 35 99.2 1 2 241 121 205 KAI2494109.1 hypothetical protein MHU86_20422 [Fragilaria crotonensis] diamond 495 93.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26831504 26831504 PRJNA758088_P_NODE_250761_length_268_cov_1.461538_g243790_i0 PRJNA758088 250761 268 1.461538 3.91692184 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 61.6 1.05e-8   NR CAJ1900870.1 2856 g243790 i0 67.6 0.414179104477612 37 12 41.4 0 1 111 304 340 CAJ1900870.1 unnamed protein product [Cylindrotheca closterium] diamond 111 61.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27400785 27400785 PRJNA758088_P_NODE_364523_length_241_cov_0.916667_g357552_i0 PRJNA758088 364523 241 0.916667 2.20916747 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 120 1.66e-29   NR KAL3809014.1 382380 g357552 i0 72.2 0.896265560165975 72 20 89.6 0 234 19 821 892 KAL3809014.1 hypothetical protein ACHAXA_000294 [Cyclostephanos tholiformis] diamond 216 120 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28915968 28915968 PRJNA758088_P_NODE_348408_length_243_cov_0.905882_g341437_i0 PRJNA758088 348408 243 0.905882 2.20129326 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 114 2.43e-27   NR KAL3771149.1 259834 g341437 i0 56.3 0.987654320987654 80 35 98.8 0 241 2 2177 2256 KAL3771149.1 hypothetical protein ACHAWU_004772 [Discostella pseudostelligera] diamond 240 114 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
29232071 29232071 PRJNA758088_P_NODE_356469_length_242_cov_0.911243_g349498_i0 PRJNA758088 356469 242 0.911243 2.20520806 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 90.1 1.89e-19   NR KAI2498172.1 210448 g349498 i0 62.3 0.954545454545455 77 24 95.5 3 9 239 26 97 KAI2498172.1 hypothetical protein MHU86_16315 [Fragilaria crotonensis] diamond 231 90.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29326564 29326564 PRJNA758088_P_NODE_312949_length_247_cov_0.885057_g305978_i0 PRJNA758088 312949 247 0.885057 2.18609079 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 126 1.21e-33   NR KAI2493616.1 210448 g305978 i0 69.5 0.995951417004049 82 25 99.6 0 1 246 53 134 KAI2493616.1 hypothetical protein MHU86_20940 [Fragilaria crotonensis] diamond 246 126 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30062647 30062647 PRJNA758088_P_NODE_330551_length_245_cov_0.895349_g323580_i0 PRJNA758088 330551 245 0.895349 2.19360505 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 60.8 1.61e-8   NR KAI2491412.1 210448 g323580 i0 52.1 2.86530612244898 48 23 58.8 0 238 95 31 78 KAI2491412.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis] diamond 702 60.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30432517 30432517 PRJNA758088_P_NODE_298273_length_249_cov_0.875000_g291302_i0 PRJNA758088 298273 249 0.875 2.17875 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0378   NR KAL3775350.1 382360 g291302 i0 48.1 0.325301204819277 27 14 32.5 0 157 237 52 78 KAL3775350.1 hypothetical protein ACHAWO_001281 [Cyclotella atomus] diamond 81 42.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
30464150 30464150 PRJNA758088_P_NODE_313733_length_247_cov_0.885057_g306762_i0 PRJNA758088 313733 247 0.885057 2.18609079 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 146 1.62e-38   NR KAI2500502.1 210448 g306762 i0 97.6 1.97975708502024 82 2 99.6 0 246 1 703 784 KAI2500502.1 hypothetical protein MHU86_13993 [Fragilaria crotonensis] diamond 489 146 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30590024 30590024 PRJNA758088_P_NODE_313953_length_247_cov_0.885057_g306982_i0 PRJNA758088 313953 247 0.885057 2.18609079 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 57.8 1e-7   NR KAI2504849.1 210448 g306982 i0 53.2 0.959514170040486 79 35 94.7 2 235 2 15 92 KAI2504849.1 hypothetical protein MHU86_9621 [Fragilaria crotonensis] diamond 237 57.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30852617 30852617 PRJNA758088_P_NODE_237834_length_276_cov_1.211823_g230863_i0 PRJNA758088 237834 276 1.211823 3.34463148 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 55.5 1.85e-6   NR KAL3774667.1 29204 g230863 i0 39.6 1.92391304347826 91 37 98.9 1 2 274 645 717 KAL3774667.1 hypothetical protein HJC23_012281 [Cyclotella cryptica] diamond 531 55.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
31664719 31664719 PRJNA758088_P_NODE_307737_length_248_cov_0.880000_g300766_i0 PRJNA758088 307737 248 0.88 2.1824 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0189   NR KAL3805491.1 382360 g300766 i0 65.5 0.350806451612903 29 10 35.1 0 174 88 52 80 KAL3805491.1 hypothetical protein ACHAWO_003001 [Cyclotella atomus] diamond 87 43.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
31696449 31696449 PRJNA758088_P_NODE_280517_length_251_cov_0.865169_g273546_i0 PRJNA758088 280517 251 0.865169 2.17157419 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 95.9 5.57e-21   NR GFH51271.1 426638 g273546 i0 53.8 2.17529880478088 91 32 96.8 2 3 245 83 173 GFH51271.1 hypothetical protein CTEN210_07747 [Chaetoceros tenuissimus] diamond 546 95.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
32076141 32076141 PRJNA758088_P_NODE_366858_length_241_cov_0.916667_g359887_i0 PRJNA758088 366858 241 0.916667 2.20916747 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.89e-17   NR KAI2512017.1 210448 g359887 i0 89.8 0.609958506224066 49 4 59.8 1 98 241 1 49 KAI2512017.1 hypothetical protein MHU86_2305 [Fragilaria crotonensis] diamond 147 80.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32266229 32266229 PRJNA758088_P_NODE_284438_length_251_cov_0.865169_g277467_i0 PRJNA758088 284438 251 0.865169 2.17157419 Actinocyclus sp. mgcode 4 2914904 SAR_Eukaryotes SAR_Eukaryotes 50.4 6.32e-5   NR QYC61840.1 2914904 g277467 i0 40.6 2.46215139442231 69 39 80.1 1 214 14 115 183 QYC61840.1 ribosomal protein L2 [Actinocyclus sp. mgcode 4] diamond 618 50.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Hemidiscaceae Actinocyclus Actinocyclus sp. mgcode 4
32487640 32487640 PRJNA758088_P_NODE_307239_length_248_cov_0.880000_g300268_i0 PRJNA758088 307239 248 0.88 2.1824 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00246   NR KAI2492849.1 210448 g300268 i0 33.8 0.967741935483871 80 50 93.1 1 244 14 2416 2495 KAI2492849.1 hypothetical protein MHU86_21690 [Fragilaria crotonensis] diamond 240 46.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis

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