RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA702290" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA702290 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
3736415 3736415 PRJNA702290_P_NODE_1843_length_156_cov_14.905983_g1835_i0 PRJNA702290 1843 156 14.905983 23.25333348 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 156 9.52e-34   NTclustered gi|16751927|gb|AF169720.2| 77687 g1835 i0 84.831 63.8269230769231 178 2 98 1 1 153 411 588 Anaspides tasmaniae large subunit ribosomal RNA gene, partial sequence blastn 9957 156 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Anaspidacea Anaspididae Anaspides Anaspides tasmaniae
4511833 4511833 PRJNA702290_P_NODE_1184_length_191_cov_3.546053_g1176_i0 PRJNA702290 1184 191 3.546053 6.77296123 Gnamptogenys sp. ANH-2014 1539407 Arthropoda Arthropoda 121 4.439999999999999e-23   NTclustered gi|675276631|gb|KF612794.1| 1539407 g1176 i0 97.183 37.3246073298429 71 2 37 0 8 78 331 401 Gnamptogenys sp. ANH-2014 voucher LEEC-gn6a cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial blastn 7129 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Gnamptogenys Gnamptogenys sp. ANH-2014
4511841 4511841 PRJNA702290_P_NODE_2004_length_153_cov_30.982456_g1996_i0 PRJNA702290 2004 153 30.982456 47.40315768 Psocoptera sp. PS02 1291676 Arthropoda Arthropoda 243 6.93e-60   NTclustered gi|449084630|gb|KC513101.1| 1291676 g1996 i0 97.203 90.2091503267974 143 4 93 0 8 150 1058 1200 Psocoptera sp. PS02 28S ribosomal RNA gene, partial sequence blastn 13802 243 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea     Psocoptera sp. PS02
7562558 7562558 PRJNA702290_P_NODE_766_length_191_cov_13.690789_g758_i0 PRJNA702290 766 191 13.690789 26.14940699 root 1 Root_unresolved Root_unresolved 141 3.41e-29   NTclustered gi|78097480|gb|AC167666.4| 7176 g758 i0 98.734 245.811518324607 79 1 78 0 5 83 235 157 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940120D9, complete sequence blastn 46950 141 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
10887876 10887876 PRJNA702290_P_NODE_929_length_191_cov_9.914474_g921_i0 PRJNA702290 929 191 9.914474 18.93664534 Vespula pensylvanica 30213 Arthropoda Arthropoda 63.9 7.59e-6   NTclustered gi|2098655571|ref|XM_043809538.1| 30213 g921 i0 97.297 17.0157068062827 37 1 19 0 142 178 2886 2850 PREDICTED: Vespula pensylvanica uncharacterized protein DDB_G0271670-like (LOC122627910), transcript variant X1, mRNA blastn 3250 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula pensylvanica
17261708 17261708 PRJNA702290_P_NODE_1694_length_158_cov_8.638655_g1686_i0 PRJNA702290 1694 158 8.638655 13.6490749 Apis dorsata 7462 Arthropoda Arthropoda 69.4 1.3e-7   NTclustered gi|1772611188|ref|XM_031513972.1| 7462 g1686 i0 97.5 1.43037974683544 40 1 25 0 9 48 933 894 PREDICTED: Apis dorsata myb-like protein X (LOC102680317), mRNA blastn 226 69.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Apis Apis dorsata
17261722 17261722 PRJNA702290_P_NODE_74_length_452_cov_86.898305_g67_i0 PRJNA702290 74 452 86.898305 392.7803386 Cymothoe herminia 1210388 Arthropoda Arthropoda 544 5.93e-150   NTclustered gi|2307882115|gb|MW186585.1| 1210388 g67 i0 93.801 102.995575221239 371 8 98 3 3 373 6255 5900 Cymothoe herminia voucher 17LW02125 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence blastn 46554 544 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Cymothoe Cymothoe herminia
17762470 17762470 PRJNA702290_P_NODE_694_length_191_cov_16.019737_g686_i0 PRJNA702290 694 191 16.019737 30.59769767 Insecta 50557 Arthropoda Arthropoda 58.4 3.53e-4   NTclustered gi|2624479387|tpg|BK063615.1| 395517 g686 i0 97.059 3.61780104712042 34 1 18 0 8 41 2934 2967 TPA_asm: Bombus convexus mitochondrion, complete genome blastn 691 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus convexus

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