RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1102048" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA1102048 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
211822 211822 PRJNA1102048_P_NODE_6481_length_339_cov_1.157895_g6377_i0 PRJNA1102048 6481 339 1.157895 3.92526405 Guinardia striata 1514137 SAR_Eukaryotes SAR_Eukaryotes 267 1.05e-66   NTclustered gi|2074156236|gb|MW413904.1| 1514137 g6377 i0 83.803 82.1681415929203 284 42 83 4 3 284 1797 2078 Guinardia striata mitochondrion, complete genome blastn 27855 267 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia striata
1486436 1486436 PRJNA1102048_P_NODE_6302_length_344_cov_1.195572_g6198_i0 PRJNA1102048 6302 344 1.195572 4.11276768 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 257 6.42e-64   NTclustered gi|657012369|gb|KF302532.1| 2850 g6198 i0 88.018 0.630813953488372 217 26 63 0 102 318 10 226 Phaeodactylum tricornutum clone C80 40S ribosomal protein mRNA, complete cds blastn 217 257 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
2762465 2762465 PRJNA1102048_P_NODE_4883_length_388_cov_0.828571_g4779_i0 PRJNA1102048 4883 388 0.828571 3.21485548 Nitzschia traheaformis 1881117 SAR_Eukaryotes SAR_Eukaryotes 87.9 1.02e-12   NTclustered gi|2073953246|gb|MW849269.1| 1881117 g4779 i0 77.326 1.71134020618557 172 23 44 7 72 241 46488 46645 Nitzschia traheaformis isolate Qingdao in China mitochondrion, complete genome blastn 664 87.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia traheaformis
5314541 5314541 PRJNA1102048_P_NODE_10745_length_270_cov_1.456853_g10641_i0 PRJNA1102048 10745 270 1.456853 3.9335031 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 178 3.91e-40   NTclustered gi|224004779|ref|XM_002296005.1| 296543 g10641 i0 84.746 48.8555555555556 177 27 66 0 94 270 452 628 Thalassiosira pseudonana CCMP1335 F-type H-ATPase beta subunit mRNA blastn 13191 178 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
10415198 10415198 PRJNA1102048_P_NODE_9449_length_284_cov_2.933649_g9345_i0 PRJNA1102048 9449 284 2.933649 8.33156316 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 207 5.29e-49   NTclustered gi|657012367|gb|KF302531.1| 2850 g9345 i0 90.968 10.6549295774648 155 12 54 2 1 154 240 393 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 3026 207 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
13773359 13773359 PRJNA1102048_P_NODE_18031_length_234_cov_2.857143_g17927_i0 PRJNA1102048 18031 234 2.857143 6.68571462 Skeletonema 2842 SAR_Eukaryotes SAR_Eukaryotes 121 5.66e-23   NTclustered gi|2728403617|gb|PP777252.1| 2843 g17927 i0 98.529 46.1752136752137 68 1 50 0 167 234 4821 4754 Skeletonema costatum strain CNS00174 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 10805 121 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
14240516 14240516 PRJNA1102048_P_NODE_4592_length_398_cov_3.258462_g4488_i0 PRJNA1102048 4592 398 3.258462 12.96867876 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 289 2.67e-73   NTclustered gi|657012511|gb|KF302595.1| 2850 g4488 i0 90.09 6.49748743718593 222 22 56 0 2 223 72 293 Phaeodactylum tricornutum clone C854 ubiquitin-ribosomal protein fusion S27a mRNA, partial cds blastn 2586 289 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);;