contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Perkinsozoa"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 127209 | 127209 | PRJEB64798_P_NODE_15981_length_498_cov_76.904232_g14288_i0 | PRJEB64798 | 15981 | 498 | 76.904232 | 382.98307536 | uncultured Perkinsea | 373149 | SAR_Eukaryotes | SAR_Eukaryotes | 649 | 0 | NTclustered | gi|918566078|gb|KP122543.1| | 373149 | g14288 | i0 | 95.771 | 80.6164658634538 | 402 | 17 | 81 | 0 | 5 | 406 | 122 | 523 | Uncultured Perkinsea clone G2013_T1_A7 18S ribosomal RNA gene, partial sequence | blastn | 40147 | 649 | 1 | Eukaryota | Sar | Perkinsozoa | uncultured Perkinsea | ||||||
| 128202 | 128202 | PRJEB64798_P_NODE_22881_length_413_cov_43.750000_g21139_i0 | PRJEB64798 | 22881 | 413 | 43.75 | 180.6875 | Salmoxcellia vastator | 2874172 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 6.55e-10 | NTclustered | gi|2258116978|gb|ON819178.1| | 2874172 | g21139 | i0 | 82.759 | 0.210653753026634 | 87 | 15 | 21 | 0 | 195 | 281 | 4584 | 4670 | Salmoxcellia vastator strain BC241120 internal transcribed spacer region, partial sequence | blastn | 87 | 78.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Xcellidae | Salmoxcellia | Salmoxcellia vastator | |||
| 4821111 | 4821111 | PRJEB64798_P_NODE_191204_length_170_cov_1.809917_g189438_i0 | PRJEB64798 | 191204 | 170 | 1.809917 | 3.0768589 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 2.35e-10 | NTclustered | gi|38885066|gb|AY391259.1| | 31276 | g189438 | i0 | 81.633 | 1.93529411764706 | 98 | 14 | 56 | 4 | 8 | 103 | 567 | 662 | Perkinsus marinus heat shock protein 90 gene, partial cds | blastn | 329 | 78.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 7371050 | 7371050 | PRJEB64798_P_NODE_47446_length_285_cov_3.699153_g45681_i0 | PRJEB64798 | 47446 | 285 | 3.699153 | 10.54258605 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 3.29e-26 | NTclustered | gi|22417090|gb|AF509333.1| | 32597 | g45681 | i0 | 89.423 | 5.52631578947368 | 104 | 11 | 36 | 0 | 177 | 280 | 7058 | 6955 | Perkinsus atlanticus 5S ribosomal RNA, small subunit ribosomal RNA genes, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 1575 | 132 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 20527954 | 20527954 | PRJEB64798_P_NODE_143417_length_191_cov_23.725352_g141651_i0 | PRJEB64798 | 143417 | 191 | 23.725352 | 45.31542232 | uncultured Perkinsea | 373149 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 4.289999999999999e-48 | NTclustered | gi|918566068|gb|KP122533.1| | 373149 | g141651 | i0 | 90.323 | 81.8638743455497 | 155 | 15 | 81 | 0 | 32 | 186 | 287 | 133 | Uncultured Perkinsea clone BIB6_B2 18S ribosomal RNA gene, partial sequence | blastn | 15636 | 204 | 1 | Eukaryota | Sar | Perkinsozoa | uncultured Perkinsea | ||||||
| 22669827 | 22669827 | PRJEB64798_P_NODE_155818_length_185_cov_7.205882_g154052_i0 | PRJEB64798 | 155818 | 185 | 7.205882 | 13.3308817 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 5.56e-17 | NTclustered | gi|22417090|gb|AF509333.1| | 32597 | g154052 | i0 | 77.901 | 5.39459459459459 | 181 | 26 | 94 | 12 | 13 | 185 | 5609 | 5783 | Perkinsus atlanticus 5S ribosomal RNA, small subunit ribosomal RNA genes, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 998 | 100 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 23079397 | 23079397 | PRJEB64798_P_NODE_170919_length_178_cov_5.155039_g169153_i0 | PRJEB64798 | 170919 | 178 | 5.155039 | 9.17596942 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 1.14e-18 | NTclustered | gi|22417090|gb|AF509333.1| | 32597 | g169153 | i0 | 78.212 | 40.5056179775281 | 179 | 29 | 98 | 10 | 5 | 178 | 5618 | 5791 | Perkinsus atlanticus 5S ribosomal RNA, small subunit ribosomal RNA genes, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 7210 | 106 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 23946211 | 23946211 | PRJEB64798_P_NODE_89899_length_212_cov_7.024540_g88133_i0 | PRJEB64798 | 89899 | 212 | 7.02454 | 14.8920248 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 2.38e-11 | NTclustered | gi|218526343|gb|EU919449.1| | 31276 | g88133 | i0 | 94.34 | 25.0330188679245 | 53 | 3 | 25 | 0 | 4 | 56 | 932 | 880 | Perkinsus marinus isolate EBPICv15-H6-G5 clone 3 large subunit ribosomal RNA gene, partial sequence | blastn | 5307 | 82.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 25219511 | 25219511 | PRJEB64798_P_NODE_28260_length_370_cov_86.299065_g26504_i0 | PRJEB64798 | 28260 | 370 | 86.299065 | 319.3065405 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 2.53e-53 | NTclustered | gi|22417090|gb|AF509333.1| | 32597 | g26504 | i0 | 88.172 | 49.1243243243243 | 186 | 22 | 50 | 0 | 1 | 186 | 6902 | 7087 | Perkinsus atlanticus 5S ribosomal RNA, small subunit ribosomal RNA genes, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 18176 | 222 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni |
Advanced export
JSON shape: default, array, newline-delimited
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);;