RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA666695" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA666695 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
1906751 1906751 PRJNA666695_S_NODE_134102_length_189_cov_2.175676_g133008_i0 PRJNA666695 134102 189 2.175676 4.11202764 Trieres regia 1335017 SAR_Eukaryotes SAR_Eukaryotes 113 7.33e-21   NTclustered gi|2055417059|ref|NC_056371.1| 1335017 g133008 i0 78.68 9.51322751322751 197 23 97 17 1 183 35438 35247 Odontella regia mitochondrion, complete genome blastn 1798 113 1 Eukaryota Sar   Bacillariophyta Mediophyceae Eupodiscales Parodontellaceae Trieres Trieres regia
1908872 1908872 PRJNA666695_S_NODE_542_length_2031_cov_107.813568_g71_i1 PRJNA666695 542 2031 107.813568 2189.69356608 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 172 1.5399999999999998e-37   NTclustered gi|2074156200|gb|MW413905.1| 216802 g71 i1 72.804 10.8005908419498 592 129 29 26 927 1507 24220 24790 Guinardia delicatula mitochondrion, complete genome blastn 21936 172 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
3714065 3714065 PRJNA666695_S_NODE_100183_length_219_cov_3.606742_g99089_i0 PRJNA666695 100183 219 3.606742 7.89876498 root 1 Root_unresolved Root_unresolved 100 6.82e-17   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g99089 i0 89.744 3.30593607305936 78 8 36 0 37 114 2361 2438 Coscinodiscus granii mitochondrion, complete sequence blastn 724 100 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
4459393 4459393 PRJNA666695_S_NODE_17804_length_434_cov_4.119593_g16713_i0 PRJNA666695 17804 434 4.119593 17.87903362 Asterionellopsis glacialis 33640 SAR_Eukaryotes SAR_Eukaryotes 261 6.400000000000001e-65   NTclustered gi|225685848|dbj|AB461922.1| 33640 g16713 i0 79.221 34.0921658986175 385 72 88 8 27 407 223 603 Asterionellopsis glacialis MAT mRNA for methionine S-adenosyl transferase, complete cds blastn 14796 261 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionellopsis Asterionellopsis glacialis
8285209 8285209 PRJNA666695_S_NODE_2687_length_944_cov_13.042082_g2083_i0 PRJNA666695 2687 944 13.042082 123.11725408 Coscinodiscus wailesii 671091 SAR_Eukaryotes SAR_Eukaryotes 172 7.02e-38   NTclustered gi|2088246177|ref|NC_057078.1| 671091 g2083 i0 83.333 3.61758474576271 186 31 20 0 36 221 5956 5771 Coscinodiscus wailesii mitochondrion, complete genome blastn 3415 172 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus wailesii
10091498 10091498 PRJNA666695_S_NODE_26988_length_370_cov_45.407295_g25895_i0 PRJNA666695 26988 370 45.407295 168.0069915 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 126 2.0399999999999994e-24   NTclustered gi|2156401020|dbj|LC537470.1| 426638 g25895 i0 96.154 7.60540540540541 78 2 21 1 26 102 613 690 Chaetoceros tenuissimus NIES-3715 mitochondrial DNA, complete genome blastn 2814 126 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
10836621 10836621 PRJNA666695_S_NODE_45849_length_303_cov_33.064885_g44755_i0 PRJNA666695 45849 303 33.064885 100.18660155 Minutocellus polymorphus 265543 SAR_Eukaryotes SAR_Eukaryotes 132 3.5200000000000004e-26   NTclustered gi|2020303798|gb|MW417227.1| 265543 g44755 i0 78.404 3.93399339933993 213 38 69 7 59 267 8691 8483 Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome blastn 1192 132 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Minutocellus Minutocellus polymorphus
12111253 12111253 PRJNA666695_S_NODE_24930_length_381_cov_19.773529_g23837_i0 PRJNA666695 24930 381 19.773529 75.33714549 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 86.1 3.58e-12   NTclustered gi|2074156200|gb|MW413905.1| 216802 g23837 i0 88.571 4.38582677165354 70 8 18 0 3 72 15227 15296 Guinardia delicatula mitochondrion, complete genome blastn 1671 86.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
16465809 16465809 PRJNA666695_S_NODE_313_length_2818_cov_25.053295_g146_i0 PRJNA666695 313 2818 25.053295 706.0018531 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 241 5.82e-58   NTclustered gi|2088237800|ref|NC_056903.1| 59812 g146 i0 72.234 17.0039034776437 922 209 32 39 224 1133 6859 5973 Lithodesmium undulatum mitochondrion, complete genome blastn 47917 241 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmium Lithodesmium undulatum
21034814 21034814 PRJNA666695_S_NODE_3837_length_814_cov_9.776197_g3127_i0 PRJNA666695 3837 814 9.776197 79.57824358 Lithodesmium undulatum 59812 SAR_Eukaryotes SAR_Eukaryotes 254 2.09e-62   NTclustered gi|2088237800|ref|NC_056903.1| 59812 g3127 i0 84.151 18.1621621621622 265 38 32 3 104 366 2231 1969 Lithodesmium undulatum mitochondrion, complete genome blastn 14784 254 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmium Lithodesmium undulatum
23585512 23585512 PRJNA666695_S_NODE_5679_length_686_cov_29.806202_g142_i3 PRJNA666695 5679 686 29.806202 204.47054572 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 137 1.84e-27   NTclustered gi|2059418728|gb|MW971521.1| 303405 g142 i3 74.005 23.298833819242 377 80 54 15 314 685 20757 21120 Nitzschia inconspicua strain hildebrandi mitochondrion, complete genome blastn 15983 137 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua

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