RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJEB3181", tax_kingdom = "Pararnavirae" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 5 ✖

tax_phylum 1

tax_kingdom 1

  • Pararnavirae · 5 ✖

bioproject 1

  • PRJEB3181 · 5 ✖

analysis 1

tax_clade 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
6434135 6434135 PRJEB3181_P_NODE_17466_length_198_cov_65.610778_g17202_i0 PRJEB3181 17466 198 65.610778 129.90934044 Lentivirus humimdef1 3418650 Viruses Viruses 52.8 0.017   NTclustered gi|2859928216|gb|PQ511684.1| 11676 g17202 i0 100 0.141414141414141 28 0 14 0 1 28 9493 9466 HIV-1 isolate GB1LV100191 from USA, complete genome blastn 28 52.8 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Lentivirus Lentivirus humimdef1
10258733 10258733 PRJEB3181_P_NODE_4669_length_370_cov_2.687316_g4421_i0 PRJEB3181 4669 370 2.687316 9.9430692 Lentivirus humimdef1 3418650 Viruses Viruses 54.7 0.01   NTclustered gi|82571395|gb|DQ275663.1| 11676 g4421 i0 100 1.30810810810811 29 0 8 0 240 268 8102 8130 HIV-1 isolate 03ZASK085B1 from South Africa gag protein (gag) gene, complete cds; truncated pol protein (pol) gene, partial cds; and vif protein (vif), vpr protein (vpr), tat protein (tat), rev protein (rev), vpu protein (vpu), envelope glycoprotein (env), and nef protein (nef) genes, complete cds blastn 484 54.7 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Lentivirus Lentivirus humimdef1
12467975 12467975 PRJEB3181_S_NODE_2390_length_349_cov_20461.487261_g2097_i0 PRJEB3181 2390 349 20461.487261 71410.59054089 Viruses 10239 Viruses Viruses 78.7 5.44e-10   NTclustered gi|2859928216|gb|PQ511684.1| 11676 g2097 i0 97.778 14.0171919770774 45 1 13 0 1 45 9511 9467 HIV-1 isolate GB1LV100191 from USA, complete genome blastn 4892 78.7 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Lentivirus Lentivirus humimdef1
14084475 14084475 PRJEB3181_S_NODE_8292_length_218_cov_649.836066_g7999_i0 PRJEB3181 8292 218 649.836066 1416.64262388 Lentivirus humimdef1 3418650 Viruses Viruses 75 4.11e-9   NTclustered gi|373427274|gb|JN613625.1| 11676 g7999 i0 100 17.4220183486239 40 0 18 0 153 192 296 335 HIV-1 clone 06JHS4-3552s from South Korea nonfunctional gag protein (gag) gene, partial sequence blastn 3798 75 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Lentivirus Lentivirus humimdef1
24281962 24281962 PRJEB3181_S_NODE_7080_length_234_cov_119.271357_g6787_i0 PRJEB3181 7080 234 119.271357 279.09497538 Lentivirus humimdef1 3418650 Viruses Viruses 63.9 9.68e-6   NTclustered gi|2859928216|gb|PQ511684.1| 11676 g6787 i0 100 15.7350427350427 34 0 15 0 1 34 9499 9466 HIV-1 isolate GB1LV100191 from USA, complete genome blastn 3682 63.9 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Lentivirus Lentivirus humimdef1

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