RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", bioproject = "PRJNA675331" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA675331 · 17 ✖

analysis 1

  • blastn · 17 ✖

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
1168549 1168549 PRJNA675331_P_NODE_16181_length_263_cov_2.110526_g16009_i0 PRJNA675331 16181 263 2.110526 5.55068338 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 486 5.5499999999999986e-133   NTclustered gi|1419234739|dbj|AP018511.1| 303400 g16009 i0 100 137.684410646388 263 0 100 0 1 263 1122 860 Nitzschia palea NIES-2729 chloroplast DNA complet genome blastn 36211 486 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
1923873 1923873 PRJNA675331_P_NODE_20382_length_247_cov_0.885057_g20210_i0 PRJNA675331 20382 247 0.885057 2.18609079 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 259 1.23e-64   NTclustered gi|223998613|ref|XM_002288944.1| 296543 g20210 i0 86.957 0.931174089068826 230 30 93 0 18 247 147 376 Thalassiosira pseudonana CCMP1335 predicted protein mRNA blastn 230 259 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
3198668 3198668 PRJNA675331_P_NODE_2103_length_632_cov_4.681574_g1937_i0 PRJNA675331 2103 632 4.681574 29.58754768 Cylindrotheca fusiformis 2853 SAR_Eukaryotes SAR_Eukaryotes 532 1.84e-146   NTclustered gi|23168431|gb|AY125588.1| 2853 g1937 i0 82.862 8.71360759493671 601 96 95 6 25 623 596 1 Cylindrotheca fusiformis fucoxanthin chlorophyll a/c-binding protein precursor (cffcpB-1) mRNA, complete cds blastn 5507 532 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca fusiformis
4475819 4475819 PRJNA675331_P_NODE_9684_length_319_cov_1.048780_g9512_i0 PRJNA675331 9684 319 1.04878 3.3456082 Cylindrotheca fusiformis 2853 SAR_Eukaryotes SAR_Eukaryotes 309 1.6100000000000002e-79   NTclustered gi|23168431|gb|AY125588.1| 2853 g9512 i0 85.862 6.44200626959248 290 41 91 0 15 304 290 1 Cylindrotheca fusiformis fucoxanthin chlorophyll a/c-binding protein precursor (cffcpB-1) mRNA, complete cds blastn 2055 309 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca fusiformis
5751265 5751265 PRJNA675331_P_NODE_12745_length_286_cov_0.896714_g12573_i0 PRJNA675331 12745 286 0.896714 2.56460204 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 230 1.1399999999999998e-55   NTclustered gi|224009198|ref|XM_002293522.1| 296543 g12573 i0 81.119 1 286 54 100 0 1 286 431 146 Thalassiosira pseudonana CCMP1335 predicted protein partial mRNA blastn 286 230 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
5751297 5751297 PRJNA675331_P_NODE_15345_length_269_cov_1.372449_g15173_i0 PRJNA675331 15345 269 1.372449 3.69188781 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 303 6.16e-78   NTclustered gi|223993504|ref|XM_002286400.1| 296543 g15173 i0 87.037 7.65799256505576 270 33 100 2 1 269 182 450 Thalassiosira pseudonana CCMP1335 fucoxanthin chlorophyll a/c protein 8 (Lhcf9), mRNA blastn 2060 303 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
7026374 7026374 PRJNA675331_P_NODE_1526_length_736_cov_1.760181_g1366_i0 PRJNA675331 1526 736 1.760181 12.95493216 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 950 0   NTclustered gi|2996370|emb|AJ000967.1| 29204 g1366 i0 89.906 13.4347826086957 743 67 99 6 1 735 743 1 Cyclotella cryptica mRNA for fucoxanthin chlorophyll a/c binding protein, fcp5 blastn 9888 950 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
8301088 8301088 PRJNA675331_P_NODE_17267_length_256_cov_1.245902_g17095_i0 PRJNA675331 17267 256 1.245902 3.18950912 Cyclotella sp. L04_2 1549163 SAR_Eukaryotes SAR_Eukaryotes 468 1.95e-127   NTclustered gi|691189876|gb|KJ958480.1| 1549163 g17095 i0 99.609 198.31640625 256 1 100 0 1 256 70447 70192 Cyclotella sp. L04_2 chloroplast, complete genome blastn 50769 468 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella sp. L04_2
9576282 9576282 PRJNA675331_P_NODE_1368_length_772_cov_4.673820_g1213_i0 PRJNA675331 1368 772 4.67382 36.0818904 Nitzschia anatoliensis 2862141 SAR_Eukaryotes SAR_Eukaryotes 1277 0   NTclustered gi|2072715385|gb|MT740317.1| 2862141 g1213 i0 96.503 97.9430051813471 772 27 100 0 1 772 6088 5317 Nitzschia anatoliensis clone SZCZ E372 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 75612 1277 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia anatoliensis
10851799 10851799 PRJNA675331_P_NODE_2609_length_575_cov_1.175299_g2441_i0 PRJNA675331 2609 575 1.175299 6.75796925 Cylindrotheca fusiformis 2853 SAR_Eukaryotes SAR_Eukaryotes 411 8.13e-110   NTclustered gi|23168400|gb|AY125582.1| 2853 g2441 i0 80.952 10.4469565217391 525 94 91 5 12 533 627 106 Cylindrotheca fusiformis fucoxanthin chlorophyll a/c-binding protein precursor (cffcpA-2) mRNA, complete cds blastn 6007 411 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca fusiformis
11372081 11372081 PRJNA675331_P_NODE_2449_length_592_cov_1.206166_g2283_i0 PRJNA675331 2449 592 1.206166 7.14050272 Stephanodiscus 29206 SAR_Eukaryotes SAR_Eukaryotes 815 0   NTclustered gi|1041923295|dbj|AB831892.1| 29207 g2283 i0 92.295 97.7753378378378 584 30 96 12 23 592 2676 3258 Stephanodiscus hantzschii genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2 and 28S rRNA, partial sequence, specimen_voucher: TNS:AL-57172 blastn 57883 819 0.995115995115995 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
13922449 13922449 PRJNA675331_P_NODE_7031_length_365_cov_3.160959_g6859_i0 PRJNA675331 7031 365 3.160959 11.53750035 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 675 0   NTclustered gi|2547135572|gb|OR286793.1| 2856 g6859 i0 100 99.5972602739726 365 0 100 0 1 365 374 10 Cylindrotheca closterium strain WAP12A small subunit ribosomal RNA gene, partial sequence blastn 36353 675 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
18500069 18500069 PRJNA675331_P_NODE_6575_length_377_cov_1.424342_g6403_i0 PRJNA675331 6575 377 1.424342 5.36976934 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 250 1.19e-61   NTclustered gi|224007704|ref|XM_002292776.1| 296543 g6403 i0 87.215 1.70291777188329 219 28 58 0 1 219 1166 1384 Thalassiosira pseudonana CCMP1335 translation elongation factor alpha mRNA blastn 642 250 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
19774557 19774557 PRJNA675331_P_NODE_10956_length_304_cov_0.948052_g10784_i0 PRJNA675331 10956 304 0.948052 2.88207808 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 211 4.42e-50   NTclustered gi|224002892|ref|XM_002291082.1| 296543 g10784 i0 79.667 50.3355263157895 300 56 97 4 7 302 566 268 Thalassiosira pseudonana CCMP1335 HSP90 family member (HSP90_1), partial mRNA blastn 15302 211 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
19774627 19774627 PRJNA675331_P_NODE_21456_length_245_cov_0.895349_g21284_i0 PRJNA675331 21456 245 0.895349 2.19360505 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 248 2.6299999999999997e-61   NTclustered gi|223999666|ref|XM_002289470.1| 296543 g21284 i0 85.124 1.86530612244898 242 36 99 0 4 245 342 101 Thalassiosira pseudonana CCMP1335 predicted protein mRNA blastn 457 248 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
24873929 24873929 PRJNA675331_P_NODE_8860_length_331_cov_0.895349_g8688_i0 PRJNA675331 8860 331 0.895349 2.96360519 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 401 2.6899999999999992e-107   NTclustered gi|223999068|ref|XM_002289171.1| 296543 g8688 i0 88.52 1 331 38 100 0 1 331 2596 2266 Thalassiosira pseudonana CCMP1335 ABC cassette-containing protein partial mRNA blastn 331 401 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
25394944 25394944 PRJNA675331_P_NODE_6580_length_377_cov_1.138158_g6408_i0 PRJNA675331 6580 377 1.138158 4.29085566 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 686 0   NTclustered gi|2202538966|gb|OM891872.1| 3003 g6408 i0 99.469 100.002652519894 377 2 100 0 1 377 1138 762 Bacillaria paxillifer 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 37701 686 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer

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