RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA400391" and tax_phylum = "Fornicata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fornicata · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA400391 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
414027 414027 PRJNA400391_S_NODE_3641_length_211_cov_5.443182_g3580_i0 PRJNA400391 3641 211 5.443182 11.48511402 Hexamita inflata 28002 Fornicata other_Eukaryota 257 3.66e-64   NTclustered gi|459348792|gb|KC249997.1| 28002 g3580 i0 90.722 10.5781990521327 194 17 91 1 5 197 573 380 Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 2232 257 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Hexamita Hexamita inflata
414058 414058 PRJNA400391_S_NODE_4921_length_179_cov_3.277778_g4860_i0 PRJNA400391 4921 179 3.277778 5.86722262 Trepomonas sp. PPS6 460177 Fornicata other_Eukaryota 298 1.76e-76   NTclustered gi|2592099180|gb|OR670376.1| 460177 g4860 i0 96.648 98.340782122905 179 6 100 0 1 179 845 1023 Trepomonas sp. PPS6 isolate ERAWAN small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 17603 298 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Trepomonas Trepomonas sp. PPS6
1688958 1688958 PRJNA400391_S_NODE_6262_length_156_cov_2.760331_g6201_i0 PRJNA400391 6262 156 2.760331 4.30611636 Hexamita inflata 28002 Fornicata other_Eukaryota 278 1.95e-70   NTclustered gi|459348792|gb|KC249997.1| 28002 g6201 i0 98.718 37.4615384615385 156 2 100 0 1 156 2272 2117 Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 5844 278 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Hexamita Hexamita inflata
5517838 5517838 PRJNA400391_S_NODE_4065_length_200_cov_2.800000_g4004_i0 PRJNA400391 4065 200 2.8 5.6 Trepomonas steinii 460178 Fornicata other_Eukaryota 307 3.36e-79   NTclustered gi|2547715531|gb|OR291188.1| 460178 g4004 i0 94.527 100.635 201 8 100 3 1 200 666 864 Trepomonas steinii isolate GOLAKASAJ small subunit ribosomal RNA gene, partial sequence blastn 20127 307 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Trepomonas Trepomonas steinii
8067378 8067378 PRJNA400391_S_NODE_27_length_913_cov_4.906606_g17_i0 PRJNA400391 27 913 4.906606 44.79731278 Trepomonas sp. PPS6 460177 Fornicata other_Eukaryota 1262 0   NTclustered gi|2592099177|gb|OR670373.1| 460177 g17 i0 91.64 88.7196056955093 921 63 99 10 1 912 921 6 Trepomonas sp. PPS6 isolate MACHUPICCHU small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 81001 1262 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Trepomonas Trepomonas sp. PPS6
8067412 8067412 PRJNA400391_S_NODE_4527_length_188_cov_1.640523_g4466_i0 PRJNA400391 4527 188 1.640523 3.08418324 Hexamita inflata 28002 Fornicata other_Eukaryota 178 2.5499999999999998e-40   NTclustered gi|459348792|gb|KC249997.1| 28002 g4466 i0 83.957 1.15425531914894 187 28 99 2 3 188 807 622 Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 217 178 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Hexamita Hexamita inflata
9342238 9342238 PRJNA400391_S_NODE_3308_length_221_cov_2.655914_g3247_i0 PRJNA400391 3308 221 2.655914 5.86956994 Hexamita inflata 28002 Fornicata other_Eukaryota 237 5.04e-58   NTclustered gi|459348792|gb|KC249997.1| 28002 g3247 i0 91.765 17.5656108597285 170 14 77 0 5 174 573 404 Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 3882 237 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Hexamita Hexamita inflata
9342278 9342278 PRJNA400391_S_NODE_5108_length_175_cov_1.200000_g5047_i0 PRJNA400391 5108 175 1.2 2.1 Hexamita inflata 28002 Fornicata other_Eukaryota 291 2.8699999999999993e-74   NTclustered gi|459348792|gb|KC249997.1| 28002 g5047 i0 96.571 48.32 175 6 100 0 1 175 2462 2636 Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 8456 291 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Hexamita Hexamita inflata
14443012 14443012 PRJNA400391_S_NODE_3652_length_211_cov_2.198864_g3591_i0 PRJNA400391 3652 211 2.198864 4.63960304 Hexamita inflata 28002 Fornicata other_Eukaryota 211 2.89e-50   NTclustered gi|459348792|gb|KC249997.1| 28002 g3591 i0 87.234 0.890995260663507 188 20 88 3 2 187 2054 1869 Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 188 211 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Hexamita Hexamita inflata
14443052 14443052 PRJNA400391_S_NODE_5472_length_169_cov_2.126866_g5411_i0 PRJNA400391 5472 169 2.126866 3.59440354 Hexamita inflata 28002 Fornicata other_Eukaryota 213 6.12e-51   NTclustered gi|459348792|gb|KC249997.1| 28002 g5411 i0 89.349 3.58579881656805 169 18 100 0 1 169 2355 2523 Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 606 213 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Hexamita Hexamita inflata
18265631 18265631 PRJNA400391_S_NODE_1175_length_339_cov_4.559211_g1114_i0 PRJNA400391 1175 339 4.559211 15.45572529 Hexamita inflata 28002 Fornicata other_Eukaryota 318 2.86e-82   NTclustered gi|459348792|gb|KC249997.1| 28002 g1114 i0 84.923 0.958702064896755 325 37 94 11 21 339 1555 1237 Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 325 318 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Hexamita Hexamita inflata
19539828 19539828 PRJNA400391_S_NODE_2636_length_247_cov_2.674528_g2575_i0 PRJNA400391 2636 247 2.674528 6.60608416 Hexamita inflata 28002 Fornicata other_Eukaryota 267 7.32e-67   NTclustered gi|459348792|gb|KC249997.1| 28002 g2575 i0 93.333 0.728744939271255 180 12 73 0 68 247 2970 2791 Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 180 267 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Hexamita Hexamita inflata
20815726 20815726 PRJNA400391_S_NODE_3777_length_207_cov_3.860465_g3716_i0 PRJNA400391 3777 207 3.860465 7.99116255 Hexamita inflata 28002 Fornicata other_Eukaryota 255 1.29e-63   NTclustered gi|459348792|gb|KC249997.1| 28002 g3716 i0 93.103 0.840579710144927 174 12 84 0 32 205 1859 1686 Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 174 255 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Hexamita Hexamita inflata
23366140 23366140 PRJNA400391_S_NODE_2979_length_233_cov_7.833333_g2918_i0 PRJNA400391 2979 233 7.833333 18.25166589 Hexamita inflata 28002 Fornicata other_Eukaryota 289 1.46e-73   NTclustered gi|459348792|gb|KC249997.1| 28002 g2918 i0 94.18 36.4291845493562 189 11 81 0 13 201 1246 1058 Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 8488 289 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Hexamita Hexamita inflata
24032753 24032753 PRJNA400391_S_NODE_1079_length_350_cov_4.955556_g1018_i0 PRJNA400391 1079 350 4.955556 17.344446 Trepomonas 44997 Fornicata other_Eukaryota 627 4.32e-175   NTclustered gi|2592099176|gb|OR670372.1| 460177 g1018 i0 99.138 97.0228571428571 348 3 99 0 1 348 798 451 Trepomonas sp. PPS6 isolate Bot small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 33958 627 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Trepomonas Trepomonas sp. PPS6

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