RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA549880" and tax_phylum = "Fornicata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fornicata · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA549880 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
3062851 3062851 PRJNA549880_P_NODE_463_length_977_cov_2.996681_g398_i0 PRJNA549880 463 977 2.996681 29.27757337 Spironucleus vortens 58336 Fornicata other_Eukaryota 1190 0   NTclustered gi|158973894|gb|EU099373.1| 58336 g398 i0 88.993 76.1780962128966 963 104 98 2 13 974 157 1118 Spironucleus vortens alpha-tubulin gene, complete cds blastn 74426 1190 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Spironucleus Spironucleus vortens
5615715 5615715 PRJNA549880_P_NODE_3025_length_421_cov_1.146552_g2932_i0 PRJNA549880 3025 421 1.146552 4.82698392 Spironucleus vortens 58336 Fornicata other_Eukaryota 492 2.02e-134   NTclustered gi|158973894|gb|EU099373.1| 58336 g2932 i0 88.945 49.6413301662708 398 44 95 0 24 421 1483 1086 Spironucleus vortens alpha-tubulin gene, complete cds blastn 20899 492 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Spironucleus Spironucleus vortens
23464237 23464237 PRJNA549880_P_NODE_6919_length_302_cov_1.340611_g6826_i0 PRJNA549880 6919 302 1.340611 4.04864522 Spironucleus salmonicida 348837 Fornicata other_Eukaryota 305 1.95e-78   NTclustered gi|2794870705|ref|XM_067904278.1| 348837 g6826 i0 86.38 3.84105960264901 279 38 92 0 3 281 127 405 Spironucleus salmonicida histone H3 (SS50377_20335), partial mRNA blastn 1160 305 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Spironucleus Spironucleus salmonicida
24737976 24737976 PRJNA549880_P_NODE_520_length_927_cov_3.104215_g452_i0 PRJNA549880 520 927 3.104215 28.77607305 Spironucleus vortens 58336 Fornicata other_Eukaryota 693 0   NTclustered gi|5566180|gb|AF159517.1|AF159517 58336 g452 i0 82.419 2.44336569579288 802 133 86 7 130 927 1 798 Spironucleus vortens enolase gene, partial cds blastn 2265 693 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Spironucleus Spironucleus vortens

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